Using the selected items in Sqldatasource

Question

How can I use the results of the select method in SqlDatasource like assign the returned id to a variable ?

i would not use SqlDataSource unless you are doing a quick&dirty tool or a throw-away-prototype. — gsharp
– gsharp, Commented Feb 22, 2011 at 20:20

Dustin Hodges · Accepted Answer · 2011-02-22 20:15:39Z

1

By default the SqlDataSource returns a System.Data.DataView object from its select method:

System.Web.UI.WebControls.SqlDataSource source = new System.Web.UI.WebControls.SqlDataSource("Connection String", "Select Query");
System.Data.DataView view = (System.Data.DataView)source.Select(System.Web.UI.DataSourceSelectArguments.Empty);

The System.Data.DataView object is a collection of System.Data.DataRowView so if you wanted to get the value of "pk" column for the first object you do this:

int itemIndex = 0;
String ColumnName = "pk";
int ID = view[itemIndex][ColumnName];

answered Feb 22, 2011 at 20:15

Dustin Hodges

4,1933 gold badges28 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using the selected items in Sqldatasource

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related