Database Commands?

[antonio622]

I am quite new to ASP.net but I no stranger to the SQL and .net database design process.

I know that ASP.net has numerous wizards as does Visual Studio.net has.

I actually enjoy and like to access my database through code only. (using datatables)

Including: (Declarations)
Private ADONetConnection As New SqlClient.SqlConnection()Private DataAdapter As SqlClient.SqlDataAdapter
Private CommandBuilder As SqlClient.SqlCommandBuilder
Private dtContacts As New DataTable

Then in code:
ADONetConnection.ConnectionString = "whatever"
ADONetConnection.Open()
DataAdapter = New SqlClient.SqlDataAdapter("Select * From Employees", ADONetConnection)
CommandBuilder = New SqlClient.SqlCommandBuilder(DataAdapter)
DataAdapter.Fill(dtContacts)

My question is:

Can I do this in ASP.net because I cant seem to find these commands. (Im using VB)

 

[ca8msm]

Yes, you can use the objects and methods you mentioned. Have a look in the help files for those objects for more information.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[antonio622]

I wasnt using the correct syntax:

System.Data.SqlClient

Thanks Anyhow