SQLDatasource with multiple controlparameters for select command
-
I would like to introduce myself as ASP.Net 2.0 beginner. I face a problem when using gridview and sqldatasource. Problem: Initially I tried using the SQLDatasource control and Gridview with one parameter in the select query. I made that parameter as a control parameter and set the autopostback of the control. Everything worked fine. Now I want to have multiple control parameters set for one SQLDatasource and GridView combination (It is basically a kind of search screen and the procedure for select command has so many parameters). I have created all the properties for these controls. But getting stuck with how to trigger the retrieval process. If it is one control, I used the autopostback and ASP.Net did the rest. Now that I have to manually trigger the retrieval of data and the binding on a search button click, am getting stuck. This is an urgent requirement and Could you please help??? Thanks Geetha
-
I would like to introduce myself as ASP.Net 2.0 beginner. I face a problem when using gridview and sqldatasource. Problem: Initially I tried using the SQLDatasource control and Gridview with one parameter in the select query. I made that parameter as a control parameter and set the autopostback of the control. Everything worked fine. Now I want to have multiple control parameters set for one SQLDatasource and GridView combination (It is basically a kind of search screen and the procedure for select command has so many parameters). I have created all the properties for these controls. But getting stuck with how to trigger the retrieval process. If it is one control, I used the autopostback and ASP.Net did the rest. Now that I have to manually trigger the retrieval of data and the binding on a search button click, am getting stuck. This is an urgent requirement and Could you please help??? Thanks Geetha
all you have to is put datagrid.databind(); in the code that handles the event for your search button.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things --thedailywtf 3/21/06