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>
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]....
I'm currently analyzing the code behind for a web application. The Default page contains a GridView with several bound DataFields that are supposed to be populated, when the page loads and reloads, with data based on a URL parameter that's passed on initial load. The way it works in summary is this:
-I have a GridView1_Init method that is called when the page loads, this retrieves data using an OldDbConnection and a URL parameter appended as part of the OleDbCommand SQL statement.
-The data is read and stored in the Web.config file. At this point, when debugging, I can see and verify the there is data being retrieved.
-Now I'm calling a GridView1_RowDataBound method to populate each row. I have it in the Default.aspx page within the GirdView parameters as OnRowDataBound="GridView1_RowDataBound"
My problem is that this method never gets called for one of the URL parameters I'm passing and as a result the Databound rows in the GridView don't get populated and the page displays nothing. I have another URL parameter I use to test and it works perfectly with that one, i.e. the page loads with the Gridview displaying all the data as expected. I'm not sure why the method GridView1_RowDataBound is getting called for one URL parameter, but not for the other. I've debugged using both and also ran the query in SQL Server Management Studio and I am getting data back for both.
My code below has a drawback. The scenario is this, i have two user roles - Approvers and Encoders. The encoders are not allowed to view the price only the approvers. Using the code below, i can now hide the Price column. but the problem is, when the encoder modified the quantity column, the Total Amount (Quantity * Price ) is zero. Giving zero value for price. When the approvers view the transaction,the Total Amount is zero. Is that really the possible thing to happen when hiding a datafield?
HTML Code:
For Each colField As DataControlField In colFields
If TypeOf colField Is BoundField Then
Dim bField As BoundField
bField = CType(colField, BoundField)
If bField.DataField = "ReceivPrice" Then
bField.Visible = False ' Hide Price Column
End If
End If
Next
Let's say I have a DataGrid that looks something like:
<asp:DataGrid ID="SomeDataGrid"
runat="server">
<Columns>
<asp:BoundColumn HeaderText="A Header" SortExpression="Sort" DataField="Data"></asp:BoundColumn>
</Columns>
</asp:DataGrid>
In this Grid, I set the datasource to some collection that contains a public property called "Data" and do a databind(). Every works as expected.Now let's say I want to set the DataField attribute of the column to a public member, or a property, or some other thing I've computed. What is the easiest way to go about this without creating intermediate objects or adding public properties to the objects in the collection?So what I want to do is something like:
<asp:BoundColumn HeaderText="A Header" SortExpression="Sort" DataField="someMethod()"></asp:BoundColumn
search for a item, display the results in a datagrid, have a LinkButton (per item in the datagrid) to show a popup modal and insert this data to a new table. I have the search, the datagrid, and popup modal all working. I need help with the add button in the popup modal (which insert into a new table in the db). In my datagrid im using DataFields - how would I get access to this in the codebehind so I dont have to re-query the db again for the ID that i'm trying to insert?
View 5 RepliesI have a textbox which displays the date as 01-May-2011 but the database coumis in format of datetime ... how to enter date in date time column of database. ..how to wite the sqlquery for this ?
View 5 RepliesSuch as in the where clause of an update statement in code behind?
View 7 RepliesI have a dropdown list with hard coded values:
<asp:ListItem Text="One Day Shoots" Value="1" />
<asp:ListItem Text="Multi-day Shoots" Value="2" />
I want to use this to insert and edit values from a db. For example when adding a record the user selects 'One Day Shoots' and 1 gets inserted into the database. Then if the user goes to edit the page since the value in the db is 1 then the 'One Day Shoots' is selected.
One way I considered accomplishing this was by using a hidden feild - when the user selects something in the dropdown list the field is updated with the value, then when the user actually adds the record the value in the feild is submitted. I'm pretty sure this would work but is there a better way?
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 have a bound field in a DetailsView that I want updated with the contents of TextBox2.Text when I update. I have TextBox2 set AutoPostBack True. Cannot remember how to move the contents on update. I tried converting the "Description_Update" to a template field without success.
I can copy and paste the contents of TextBox2 into the DetailsView and it does update as do the other DataFields.
<asp:TextBox
ID="TextBox2"
runat="server"
Height="80px"
TextMode="MultiLine" Width="360px"
Font-Size="Small"
MaxLength="120"
Text=""
Font-Names="Calibri" AutoPostBack="True"></asp:TextBox>
<asp:BoundField
DataField="Description_Update"
HeaderText="Descrip"
SortExpression="Description_Update"
/>
Do I need to use adn Eval or DataBind function or both. I have triued several combinations and do nothing but continue to butcher the database tables.
I 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.
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] ...
I want to add a class name to some of my BoundFields in the GridView control; so that once the GridView is data-bound and rendered I can obtain something like:
<td class="Tag1">Some data came from data source </td>
The purpose of doing such a thing is to be able to find all the elements that are "Tag1" in this way:
var allTag1td = $('td.Tag1');
So, how can I add this class to the BoundField so that it is rendered in this way?
protected void Button1_Click(object sender, EventArgs e)
{
System.Collections.ArrayList list = new System.Collections.ArrayList();
list.Add("abc");
list.Add("xyz");
list.Add("pqr");
list.Add("efg");
GridView1.DataSource = list;
GridView1.DataBind();
}
Now when data is bound to the gridview the column name is by default "Items" but I want to change the header text of this column.
I am binding a GridView using a DataSource in asp.net, and i would like to have some hidden BoundFields so I can access those values in my RowDataBound Function. However, when I set Visible="False" on these BoundFields the values do not get set and are always blank in the RowDataBound function.
I've seen some suggestions of setting the style on the BoundField to hidden but this did not work for me either. Ideally I don't even want a column created in the gridview, I just want these values to be hidden so I can access them.
I have a GridView like this
<asp:GridView ID="gv_FilesList" runat="server" AutoGenerateColumns="false" onrowcommand="gv_FilesList_RowCommand">
<Columns>
<asp:BoundField DataField="f_Id" Visible="false" HeaderText="File Name" />
</Columns>
<Columns>
<asp:BoundField DataField="f_Name" HeaderText="File Name" />
</Columns>
<Columns>
<asp:ButtonField ButtonType="Link" Text="Download" CommandName="DownloadFile" HeaderText="Download" />
</Columns>
</asp:GridView>
Now when I click on the download Button, how can I get the corresponding f_Id in order to get the related data from Database.
Is it possible to add a property to the existing asp:BoundField control without creating a brand new instance to which I'd have to declare <tst:BoundField></tst:BoundField>? If so, can someone provide an example?
View 1 RepliesI have a grid view control having some bound and template fields as follows
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False"
ReadOnly="True" SortExpression="ID" Visible="False" />
<asp:TemplateField HeaderText="Question">
<ItemTemplate>
<asp:LinkButton ID="btnques" runat="server" onclick="btnques_Click"
Text='<%# bind("Question") %>'></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
Now what I want to do is that on the click event of a buttom btnques, I want to access its corressponding boundfield ID's value and to store it in a label.
I have a webform with a a couple of boundfields in an edit window as follows:
<asp:BoundField DataField="TS_TITLE" HeaderText="Title" SortExpression="TS_TITLE" HeaderStyle-VerticalAlign="Top" HtmlEncode="True" >
<ControlStyle Width="500px" />
[code]...
I'm using dynamic columns boundfield and templatefield in gridview, the GV embeded in a panel (autoscroll:auto;width:fixe), I fixed 3 columns to fit the panel's width , when I add exceed the 3 columns the width changes !
View 15 RepliesCan I do something like this:
<asp:BoundField DataField="Field1"
HeaderText='<% IF(Eval("Field2").ToString().SubString(3,4).Equals("Text3"),"Text1","Text2") %>'
SortExpression="Field1" />
With the goal of having the header of Field1 be Text1 when the 4th-7th characters of Field2 = Text3 and Text2 otherwise?
I tried it and it just put "'<%IF(Eval("Field2").ToString().SubString(3,4).Equals("Text3"),"Text1","Text2") %>'" as the actual header string!
i am having a boundfield column and in that column if i entered a string(without spaces) of length 15, there is no problem. But if the string is more than 15, the text is not wrapped. I gave the command column.ItemStyle.Wrap=true; But its not working. I have fixed the width of the column. How to wrap the text in the boundfield if a string more 15 characters.
View 3 RepliesI have a gridview that I am populating with data for the folks in accounting and they want me to format currency values so that they display without $'s, with commas separating digits and with negative numbers surrounded by ( )
e.g.:
12345.67 = 12,345.67
-12345.67 = (12,345.67)
I have found lots of examples around the interwebs that get me close but there is either no ( ) around negatives or there is a $ included.