Friday, March 23, 2012

How to use SQLDataSource

Hello guys i am a bit confused, because i cannot do a simple select using the SQLDataSource from ASP.NET 2.0

here is how was doing after droping the SQLDatAdapter using the VS2003

Example

SqlDataAdapter1.SelectCommand="select * from users"

SQLDataAdapter1.Fill(Datasource1,"users")

TextBox1.DataBind()

my question is how to do it in VS2005 since that i dont see theDataAdapter anywhere, do i have to do by hand like declaring everything??

thank you in advance!!

Hi,

Because we are no longer have MSTray in the webform designer, we won't support SQLDataAdapter/DataSet on the designer. However, you can still use the old binding syntax with sqlDataAdapter/DataSet in the code.
For more information about new feature SQLDataSource, please seehttp://www.asp.net/Tutorials/quickstart.aspx

Hope that helps,

Lan

sql

No comments:

Post a Comment