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...
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?
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
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:
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?
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 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.
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
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.
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?
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 !
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.
I 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 ( )
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.