How to connect queries from SQL Server 2005 to VB.Net Windows application

Be sure you use parameterized queries when building your applications! Often people vary the queries' command text with user input. Here is an example of using the Sql* classes and parameterized SQL:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    'Insert an image
    Using conn As New System.Data.SqlClient.SqlConnection("Data Source=apex2006sql;Initial Catalog=Scott;Integrated Security=True;")
      conn.Open()
      Using cmd As New SqlClient.SqlCommand("Insert Into Picture (Name, CreateDate, Picture) Values (@Name, @CreateDate, @Picture)", conn)
        cmd.Parameters.Add(New SqlClient.SqlParameter("@Name", SqlDbType.VarChar)).Value = "Picture 1"
        cmd.Parameters.Add(New SqlClient.SqlParameter("@CreateDate", SqlDbType.VarChar)).Value = DateTime.Today
        cmd.Parameters.Add(New SqlClient.SqlParameter("@Picture", SqlDbType.Image)).Value = IO.File.ReadAllBytes("C:\picture.bmp")
        cmd.ExecuteNonQuery()
      End Using
    End Using
  End Sub

Here is a good site for finding out what connections you need to use to connect a datasource (e.g. SQL Server, Excel, Oracle etc) to your code.

www.connectionstrings.com

How to connect queries from SQL Server 2005 to VB.Net Windows application

Dim conn as new sqlclient.sqlconnection
                   Dim command as new sqlclient.sqlcommand
                   Dim dataadapter as new sqlclient.sqldataadapter 
                   Dim dt as new Datatable
                   Dim sql as string
                   conn.connectionstring("put your data source here")                           
                   sql= "your sql statement here"
                   conn.open()
                   command.connection=conn
                   command.commandtext=sql
                   command.executenonquery

this is for an insert or update statement.
if u want a select query replace the command.executenonquery with this

adapter.selectcommand= command
            adapter.fill(dt)

Hope this is helpful.
Let me know if you have any questions.

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.