sqldatasource control

Is the sqldatasource control no longer available?
I am using ASP.NET and the Microsoft Visual Studio 2010
------------
Version 10.0.40219.1 SP1Rel
Microsoft .NET Framework
Version 4.0.30319 SP1Rel

Installed Version: WD Express
-------------

I cannot find a way to connect to an externally hosted sql server 2008 database.

Regards
Michael

 

Do you just need help with the connection string?

 

hi
No, not the connection string. None of the methods suggested for database access seem to be available.
Until a week ago I hadn't used NET ASP at all. I did a website for a large UK postage stamps business many years ago in classic ASP and a hosted SQL Server database.
I need to rewrite! the site so it works on IIS7 hosting.
The sqldatasource source control does seem to be available on the 2010 express software!
It also looked like I could use the GridView control for displaying product lists and in the shopping cart but that is hidden somewhere.
The main problem seems to be that I cannot find these controls in order to see if they are suitable to use!
Thanks

 

OK, much more clear now. ;-)

1) View Toolbox (Ctrl+Alt+X)
2) Look in the section named "Data".
3) The SqlDataSource, Gridview and Listview are all there in that section.

Tips: Some of the functions work best in Design view.
It's often very helpful to switch to Design view, use the Wizards, then change back to Code view.
Your remote DASP SQL Server can work as a Server in the Data Connections in the Server Explorer. (Ctrl+Alt+S)

Hope that helps a bit. ;-)