Last post Jan 31, 2013 05:32 PM by gogginl
Oct 25, 2012 02:48 PM|gogginl|LINK
I am using a gridview to display user data. Its datasource is configured using the GUI. I know the GUI "Where" clause can be setup to compare with controls to query/populate the data. This is very simple. However is it possible to use a querystring from
codebehind to populate the data? I have to build and configure the gridview using the GUI to setup special cell control template so the gridview cannot be built using codebehind. I only want to have the gridview use the querystring from codebehind.
Basically setup and connect the gridview using the GUI then populate the data using a querystring built in codebehind?
I cannot use a dummy dataset to populate the gridview I need the actual values from the SQl datastore. The reason is the user wil be editing the gridview and making changes to the data.
Basically the user will select a series of controls in top half of the page. Once they hit submit button the control data will be inserted into SQL table. Now I want to display the data in the botton half of the page using a gridview. The gridview should
only display the new inserted data rows. Once the gridview is visible the user will have the option to edit the row cells and make changes or add data to some blank cells.
I know all this can be done using codebehind to build a query and populate the gridview. The problem I have is that I do not know how I can setup the gridview with the edit options and dropdown cells I need using codebehind. I know how to set this up using
gridview GUI options and column templates but I do not know how this can be done without first configuring the gridview to a datasource using the GUI
Dec 24, 2012 12:47 PM|Pbalan.in|LINK
Only possible solution is using the template field inside the gridview and using for each loop to find the controls inside the gridview for manipulating the operation which you required.
Jan 31, 2013 05:32 PM|gogginl|LINK
Solved - I realize the querystring can be used in SQL statement using a defined variable in codebehind. Using is and workd great@