Member Avatar for suemaina

i am new with SQL server 2005 and visual studio 2008 please help me..how do i connect the forms and the tables in the database

  • 3 Contributors
  • 4 Replies
  • 302 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Netcode
Member Avatar for NetJunkie

This may not be what you are looking for but this should point you in the right direction:

Dim Connect 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 SQLCMD As String = "Your SQL Command"
Dim myConnection As New OleDbConnection(Connect)
Dim myCommand As New OleDbDataAdapter(strsql, myConnection)

Also, make sure to import the following code above your class:

Imports System.Data.OleDb
Edited by NetJunkie because: n/a
Member Avatar for suemaina

Thanx the thread has guided me

Member Avatar for Netcode

nice one.

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.