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.

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)

And don't forget to add
Imports System.Data.OleDb
Above your public class(On the top of the page

^^

hi every one,hop your fine and thanks for the above mentioned lessons i really need that,so could you plz make the books of these web devoloping with this lesson it will be very usefull .
thank bashirrafi from afghanistan on of the most the fan of your site