Change Gridview Datasource or Select statement ijn code?

K B · Jun 8, 2006

Hi. I have a gridview with sqldatasource, etc. For the grid, I also have
a search textbox. If the user needs to filter the records, I want to
dynamically adjust the SELECT statement for the SqlDataSource. I like
all the automatic capabilities for paging, sorting, etc., so I don't
want to just bind the old way.

Any clues?

thanks,
KB

PeterKellner · Jun 8, 2006

Hi. I have a gridview with sqldatasource, etc. For the grid, I also have
a search textbox. If the user needs to filter the records, I want to
dynamically adjust the SELECT statement for the SqlDataSource. I like
all the automatic capabilities for paging, sorting, etc., so I don't
want to just bind the old way.

Any clues?

thanks,
KB

The QuickStart's are a great resource for things like this. To change
your sql statement in a sqldatasource, use the SelectCommand
attribute. You can set it in code by doing something like:

SqlDataSource1.SelectCommand = "select * from table";

http://www.asp.net/QuickStart/util/srcview.aspx?path=~/aspnet/samples/data/GridViewSimple.src

<%@ Page Language="C#" %>
<html>
<head runat="server">
<title>GridView Bound to SqlDataSource</title>
</head>
<body>
<form id="form1" runat="server">
<asp:GridView ID="GridView1" DataSourceID="SqlDataSource1"
runat="server" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
SelectCommand="SELECT [au_id], [au_lname], [au_fname], [phone],
[address], [city], [state], [zip], [contract] FROM [authors]"
ConnectionString="<%$ ConnectionStrings

ubs %>" />
</form>
</body>
</html>
Peter Kellner
http://peterkellner.net

Filter datasource/gridvw w/ 2 or more multi-select listboxes	0	Aug 21, 2009
Binding Gridview with Sqldatasource control	0	Aug 26, 2008
Problem with binding Gridview to sqldatasource control	1	Aug 27, 2008
Dynamically change the select method of a object datasource	1	May 10, 2007
DataSource problem (Whidbey)	0	Jun 28, 2004
How to show an empty GridView when DataSet is datasource?	0	Sep 21, 2009
Datatable as Gridview datasource	1	Dec 27, 2005
Setting DropDown datasource	2	Jun 19, 2008

Change Gridview Datasource or Select statement ijn code?

K B

PeterKellner

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads