Member Avatar for sathiya

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.

  • 3 Contributors
  • 2 Replies
  • 283 Views
  • 4 Years Discussion Span
  • Latest Post Latest Post by bashirrafi
Member Avatar for mojio 
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

^^

Member Avatar for bashirrafi

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.