Forms Data Controls :: Add Column To A Gridview Dynamically?
Jun 27, 2010
So I take all my current query and through it into my gridview and it works great. What I need to do is grab some data from antoher query and add on columns if anything exists in the data. How can i create columns dynamically and add them onto my existing gridview if data exists.
Sql = Select intMetricId, strBenchmarkName, intBenchmark from tblbenchmark.
myDataTable = New DataTable
myDatatable = GetData(sql)
mygridview.Datasource = mydatatable
mygridview.databind
So strBenchmarkName would be the new column heading name and then all the 12 rows of data would be the inbenchmark if any exists.
How can i new columns on an existing gridview if anything exists in the datasource.
I populate a gridview dynamically which has differen column numbers depend on requirements. My goal is to adjust column width dynamically. I have tried several methods and events, then RowCreated event of GridView looks best one to do. My code is as below. When i check result at the ViewSource on the browser, i can see that width of <td> successfully adjusted. BUT nothing changes on the browser, column width always as wide as text?
I have a auto column generated GridView in a page, I have a dynamically binded column in that gridview, when page loads then sorting option is available on all other columns except that dynamically created column.
My issue is that , need to change the column name(following some format) of the gridview (which is binded with XMLTextReader). Without changing directly XML file, Required to change the column name dynamically at runtime .
am binding a gridview to datatable ...and now i want to add a linkbutton/hyperlink as one of the columns in gridview (similar to checkbox field) ...am adding the Lbtn inside a template field ,but i want that column to come as last column ..but its coming as first column,,,how to acheive that??
moreover ,whn i clk on eack linkbutton a pop-up window has to come with submit and save and close buttons and functionality(is it better to use linkbutton or hyperlink??)...am using vs 2005
HyperLinkColum hlc = new HyperLinkColum(); hlc.Datatext.DataTextField = "PK"; myGridView.Colums.Add(hlc);
I wanted to call a page say "test.aspx" and to send the primary key of the relevant row to the "test.aspx" page and then how to retrieve this values in the "test.aspx" page
I've already searched to no avail for an answer to this question:is it possible to dynamically alter the page size in a paged gridview based on data in a particular column?In other words,let's say I get data from a table that lists students enrolled in a particular course.If there are 10 students in Course "A," then I want page 1 in my gridview to show 10 records.
If there are 15 students in Course "B," then I want page 2 in my gridview to show those 15 records,and so on.I imagine that this could probably be done with a master-detail kind of set up,but let's say for the sake of argument that I don't want to go that route.
I am trying to dynamically create radio buttons based on one of the grid column. If the grid  has four rows, it means that there are 4 time slots in the time column and I need to display 4 radio buttons after click of a button on the page. I am able to display radio buttons but dont know how to display dynamically based on grid
i have made a gridview which contains three fields, two textboxes and one combo box. ComboBox fetchs data from table(SQL) and when a combox box triggers, data related to combo must be added in two boxes. i did this throw another button, but i want this to be trigger directly when it clicks.
I want to display gridview column heading when mouse over to the particular column in the gridview.I am working in VisualStudio 2005 with MS.Net2.0 framework.I don't want to use ajax.
I have a gridview which is binded to a Sqldatasource. I would like to replace a column data field value to 'Not Applicable' if that column has got a value of 2 in database.
I am using GridView ,I want to do a validation like if i edit any one of the Cell in that column, it will through the validation when the sum of column value is more than 100. How can i do this validation?
I have an asp:Table. Its with is 100%. This table has only one row but 6 columns. The width of first 5 column is fixed at 150px. The last one does not have its Width specified and so it takes up the rest. The whole row has a background. If any of the first 5 column is clicked, the background of that cell is changed to white.In my development computer, the last column has about 250px. Yet in user computer, as the monitor has a smaller resolution, the last column has only 30px or so. User complains it is ugly and wish to merge the last column with the previous one. How to do so?
i want to to replace the hyperlinkfield with a template field that contains a hyperlink WITH ID where hyperlinkfield does not have ID and be bound to the same datasource above because i want to make the abililty to set the navigate url attribute using rowdatabound
I just wanted to know if there is any way to dynamically set the width of a column inside a table within a datalist based on the length of the text fetched from the database.I am inserting my code.