I am wondering if its possibl to change the DataField value of the asp:BoundField in the code behind.aspx page:
[Code]....
I would like to change DataField="From" to DataField="To" before I call the GridView.DataBind.Please let me know if this is possible and if so how can I do it.
I'm using a DataSet to fill my gridview. The dataset contains several columns, like: direction - fromNumber - toNumberThe column direction can contain the values "incoming" or "outgoing". In my gridview, I would like to show only 2 columns, direction and from/to. If direction = "incoming", the values from fromNumber has to be inserted in "from/to". If direction = "outgoing", the values from toNumber has to be inserted in "from/to".I know I can use a TemplateField to show different text values in a column...But I have no idea how to do this when I want to show the values from a column...
<asp:BoundField DataField="direction" HeaderText="direction" HtmlEncode="false" />
[Code]....
Such as in the where clause of an update statement in code behind?
View 7 RepliesI was hoping this is simple but i have problems.
Basically i was only able to set the string color with itemstyle-Forecolor.
But how do i set the background of a column and also set height,width.Ok height may not work because i have an itemtemplate with predefined height.
Can this be done in a simple boundfield or must i have all my datafields in itemtemplates?
What i do for one column:
[Code]....
I would like to find the Datafield Value in boundfield and set it to visible - false. I want to find the "ReceivPrice" DataField and it to visible after any conditions.
<asp:BoundField DataField="ReceivPrice" HeaderText="Price" SortExpression="ReceivPrice" ReadOnly="True" DataFormatString="{0:N4}" HtmlEncode="False">
<HeaderStyle Width="12%" HorizontalAlign="Right"/>
<ItemStyle HorizontalAlign="Right" />
</asp:BoundField>
In my asp.net+vb we+access DB. i have a field named DOB which is date of birth. i displays the data in grid view whose DOB+90 is less than ot equl to current date
DOB+90<=now()
and it works currect. but when i try to used vb code to change the row colour as per data it works for this one.
Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
If e.Row.RowType = DataControlRowType.DataRow Then
If (e.Row.DataItem("DOR") <= Now()) Then
e.Row.ForeColor = Drawing.Color.Red
End If
But i want three diffrent conditions
1. whose DOB=current month
2. whose DOB comes in next month
3. whose DOB comes in month after next month
The font colour should be diffrent
I want to access the header text of bound fields programatically. suppose i have GridView1 with following bound fields:
<asp:BoundField Visible="false" DataField="ID" HeaderText="ID" /> <asp:BoundField DataField="Title" HeaderText="Title" /> <asp:BoundField Visible="false" DataField="Description" HeaderText="Description" />
how can I access their header text programmatically ( display it(either using response.write or any label)
I have a gridview where I have TemplateField and I have bind with Coulmn Name. In Run time I would like to change the coulmn name but I am getting error.
[Code]....
I am using item template and eval function in the gridview to display the records. Can I add a coulmn which is not in the table?
I have to add some columns which is not in the table and assign the values from code behind to that particular column
I have Gridview with boundfield and one of the fields is weblink in data likewww.yahoo.comI want in Gridview display it shows up as hyperlinks in row.How should I modify the code for the Gridview boundfield for this field ?
View 5 RepliesI want to bind the datafields of the gridview to the linkbuttons.
In a column i want to display the links.
I have created gridview dynamicaly.
Probably a Q more suited for a SQL forum, but I guess it comes up a fair bit in ASP.net web site design?
View 5 RepliesI am using Templates in GridView, but now I have to change the "HeaderText" of each column from code behind. I don't have <HeaderTemplate> so therefore I cannot use FndControl() in header row.
Is there a way to change the HeaderText of each colum without using <HeaderTemplate>
Here are the templates of the GridView which I am using
[Code]....
I want to display the value to different text in particular column.
I want to change Status column text.
The column will be shown three char values; O, P, C
However, I want to display three of status; On Order, Partly, Complete
I am trying to use code behind, but still I am finding solution.
Code behind:
[code]....
I'm trying to change one section in code from DataGrid format to GridView format. The reasoning is that the sample application that was displayed was using a DataGrid even though it should have been using a Gridview for 2.0 and above. Most of it shows up without an error except one line in 3 lines which are pretty much the same. I bolded them and just want to know how do I re-write them for the Gridview?
Protected Sub NewsGrid_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles NewsGrid.RowCommand
Dim connection As SqlConnection = CreateConnection()
If e.CommandName = "Delete" Then
Dim com As New SqlCommand("DELETE FROM ElectPageEditor WHERE NewsID = @NewsID", connection)
com.Parameters.AddWithValue("@NewsID", e.Item.Cells(0).Text)
Try
connection.Open()
com.ExecuteNonQuery()
Catch generatedExceptionName As SqlException
Finally
connection.Close()
End Try
ElseIf e.CommandName = "Edit" Then
Dim command As New SqlCommand("SELECT NewsText FROM ElectPageEditor WHERE NewsID = @NewsID", connection)
command.Parameters.AddWithValue("@NewsID", e.Row.Cells(0).Text)
Try
connection.Open()
Dim record As SqlDataReader = command.ExecuteReader(CommandBehavior.CloseConnection)
If record.Read() Then
NewsEditor.Content = record.GetString(0)
EditedNews.Value = e.Item.Cells(0).Text
lse
NewsEditor.Content = ""
EditedNews.Value = ""
End If
' Will close the connection as well
record.Close()
Catch generatedExceptionName As SqlException
Finally
connection.Close()
End Try
End If
' Add code to delete row from data source.
ReadAllRecords()
End Sub
I have the code below, it all works if the BoundField is set to Visible = "true", but if i change it to "false" then my conditions are not being met and page logic doesnt work.
What am i doing wrong?
[Code]....
In vb.net how can I get the value of a gridview's boundfield value? I'm basically putting a value in that boundfield that I need to access in the RowDeleting event so I can pass that into a stored procedure. I'd be open to also trying to get the value of a control from a template column too if that's a better method?
View 4 RepliesI'm trying to programaticaly change the 'headerText' property of a GridView boundfield.
[Code]....
Apparently all goes weel, because i ca see, in a a debug session, the control initial value, and after i change it, the value changes.
I have a gridview that loads with a new datasource on button click event. On the gridview (which is located in a table columm incidentally) are 2 columns, a descriptor and a checkbox. The problem is that after postback, the column widths change, the checkbox column expands and the other column contracts. Is there a way to keep the gridview column sizes the same after postback?
View 2 RepliesDLRepository is a class with method getDLandRules. I am binding the gridview with the list that is returned by method. Now I would like to iterate through the list and add 1 more column to each row that is returned. currently, I am getting an error
GridView1.Rows[row].Cells[7].Text 'GridView1.Rows[row].Cells[7]' threw an exception of type 'System.ArgumentOutOfRangeException' strin
I need to set the HeaderText of GridView BoundField in codebehind file based on a flag at runtime.
I tried setting the column name as
e.Row.Cells[0].Text = "XXXX";
It is worked out but not able to sort that column.
here my requirement is to set the HeaderText programmatically in codebehind and able to sort the column.
I have one two GridViews on a page. One Gridview uses BoundFields inside of the GridView and the Update statement works just fine. The other GridView utilizes TemplateFields due to the fact that Validation Expressions have to be used. I also want This GridView to be able to update the vlues when the user clicks on the Update link on the right side of the GridView. The GridView that uses the BoundFields updates just fine, but the GridView that uses TemplateFields will not update. I have checked and everything is correct other than this difference of BoundField and TemplateField.
View 2 RepliesI I have a GridView attached to a SqlDataSource and all is working well. I also have and edit and delete icon attached to each record in the GridView, and again, all is working well.My problem is when I add a BoundField named 'statusCode', the delete stored procedure fails with:"Procedure or function 'up_delReference' expects parameter '@statusCode', which was not supplied."When I remove the BoundField named 'statusCode' from the GridView list, the delete works fine. I need to show the status in the GridView as the user can chose to see Avtive, Inavtive or Both records and they need to see the status when in Both.Here is the Code:
[Code]....
I have one gridview with two columns.. I am fetching data which is like invno, invno, invno, invno, invno, invno, invno, invno,.......... in one column.. but problem is when ifetch more data its Growing Across Gridview and Table.. i used following code
<td align="left" width="100%">
<asp:GridView ID="GridView1" runat="server" Width="100%"
AutoGenerateColumns="False" BackColor="White" >
<Columns>
<asp:BoundField DataField="lblInvoice" HeaderText="Invoice(s)" />
<asp:BoundField DataField="lblTotal" HeaderText="Total" />
[Code] ...
how to create calculated column using boundfield in gridview?
i want to create a new column using the existing records?