how do i bring backend to front end
-
how do i make the backend database in sqlserver2000 appear on the frontend visual basic form plz show me the connection code thank u
The simplest way would be to add an Adodc Control from your toolbox to your form, and build the ConnectionString using the wizard.
"if you vote me down, I shall become more powerful than you can possibly imagine" - Michael P. Butler. Support Bone It's a weird Life
-
how do i make the backend database in sqlserver2000 appear on the frontend visual basic form plz show me the connection code thank u
In order to retrevie data from backend SQL server.... You need to follow this step 1)first go to Project-References-select "Microsoft ActiveX data objects 2.1 library 2)then declare this value Option Explicit Dim con As New ADODB.Connection Dim Rs As New ADODB.Recordset Dim Com As New ADODB.Command Private Sub Form_Load() con = New ADODB.Connection ConString = "provider=sqloledb;uid=;pwd=;Initial Catalog=;Data Source=" con.open Then you can write code for retreiving data.. make sure that you close connection each time when you open the connection. End Sub