ASP.NET

ASP.NET RSS

How to connect sql database in asp.net using VB?

Please support our ASP.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!

•

Join Date: May 2006

Posts: 6

Reputation: sathiya is an unknown quantity at this point

Solved Threads: 0

sathiya

Offline

Newbie Poster

How to connect sql database in asp.net using VB?

May 6th, 2006

Hi all,

I would like to seek for some help from you on how to create a connection to a sql server database from an asp.net application using VB codes. I appreciate if you could provide me the relevant information about that with some sample codes.

Thank you.

•

Join Date: Apr 2006

Posts: 9

Reputation: mojio is an unknown quantity at this point

Solved Threads: 0

mojio

Offline

Newbie Poster

Re: How to connect sql database in asp.net using VB?

May 9th, 2006

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
            Dim strConn As String = "Provider=SQLOLEDB.1;Password=xxxx;Persist Security Info=True;User ID=xxx;Initial Catalog=Your database name;Data Source=Your server Name"
            Dim strsql As String = "Your SQL Command"
            Dim myconn As New OleDbConnection(strConn)
            Dim myCommand As New OleDbDataAdapter(strsql, myconn)
            Dim strConn As String = "Provider=SQLOLEDB.1;Password=xxxx;Persist Security Info=True;User ID=xxx;Initial Catalog=Your database name;Data Source=Your server Name"
            Dim strsql As String = "Your SQL Command"
            Dim myconn As New OleDbConnection(strConn)
            Dim myCommand As New OleDbDataAdapter(strsql, myconn)