GridView binding - how to stop initial binding

[Amit]

Hello,
I have a simple search screen, with two drop-downs and a text box. There's
also a GridView control that is using a SqlDataSource control to show the
matching results. The SqlDataSource uses the control values in its query as
parameters. Two questions:

1. When the Find button is clicked, how do I tell the GridView to load the
data?
2. How do I stop the GridView from data binding when the page first loads? I
don't want to pre-populate the grid, it should only show the data after the
Find button is clicked

Thanks
Amit

 

[Eliyahu Goldin]

Call myGrid.DataBind (); in the Find button OnClick event handler. This will
solve both problems.

Eliyahu

 

[Amit]

I tried that but it didn't load the grid. I kept the SQL Profiler running
and it didn't even send a database query.
-Amit

 

[Otis Mukinfus]

I tried that but it didn't load the grid. I kept the SQL Profiler running
and it didn't even send a database query.
-Amit

Amit,

If you want to populate the grid using the criteria from the drop downs you must
do it the way Eliyahu told you, but now you will have to call your
DatatAdapter's Fill method in the click event.

To prevent the grid from filling the first time you load the page, move the
DataAdapter's Fill method to the click event. That will keep it from loading on
the page load.

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com

 

[Amit]

Otis,
Thanks for your reply. I was using the SqlDataSource object bound to a
stored procedure to do the binding. But now it looks like I have to do the
binding myself, without using the SqlDataSource object.
Thanks
Amit

 

[jurev]

You can prevent initial GridView binding by setting GridView.Visible to
false by default, and setting to true in button OnClick event.

When GridView.Visible is set to false the DataSource select command
will not be executed.

 

[Assimalyst]

You can bind on button click using the VS controls with the following code:

SqlDataSource1.DataBind();
GridView1.DataBind();

This rebinds your source first, then your gridview.

HTH