get sqldatasource field values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ganesh - 15 Jul 2007 10:36 GMT

Hi There,

I've a page with with sqldatasource and detailsview, detailview was assinged
to sqldatasource on design time. Now i would like to display a some fileds
value in text box.

How can i get the values from sqldatasource. Sqldatasource always returns
one row only.

I expect something like ths

string StockName = SqlDatasource.FieldByName("StockName").AsString in my
pageload.

Thanks

Reply to this Message

nahid - 15 Jul 2007 12:54 GMT

> Hi There,
>
[quoted text clipped - 11 lines]
>
> Thanks

hi,
think this way...

DataView oDataView=new DataView();
oDataView =
SqlDataSource1.Select(_DataSourceSelectArguments.Empty);
DataRowView dr = oDataView[0];
string userName = dr("username") as string;

hope help

nahid
http://nahidulkibria.blogspot.com/
http://www.kaz.com.bd

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...