Database

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
        Dim strconn As String<br />
        strconn = "Provider=Microsoft.Jet.OleDb.4.0;data source = C:\Inetpub\wwwroot\IED416\ied416lp3_19\db\handel.mdb"<br />
        Dim dbconn As OleDbConnection = New OleDbConnection(strconn)<br />
        Dim dbinsert As OleDbCommand<br />
        dbconn.Open()<br />
        dbinsert.Connection = dbconn<br />
        dbinsert.CommandText = "INSERT INTO Kunder (Namn,Ort) VALUES ('Christian','Sweden')"<br />
        dbinsert.ExecuteNonQuery()<br />
        MsgBox("Weee")<br />
        dbconn.Close()<br />
<br />
    End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
Dim strconn As String<br />
        strconn = "Provider=Microsoft.Jet.OleDb.4.0;data source = C:\Inetpub\wwwroot\IED416\ied416lp3_19\db\handel.mdb"<br />
        Dim dbconn As OleDbConnection = New OleDbConnection(strconn) <br />
        dbconn.Open()<br />
        Dim dbinsert As OleDbCommand = New OleDbCommand("INSERT INTO Kunder (Namn,Ort) VALUES ('Christian','Sweden')", dbconn)<br />
        dbinsert.ExecuteNonQuery()<br />
        MsgBox("Weee")<br />
        dbconn.Close()<br />
<br />
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
<br />
Dim strconn As String ' here declare string variable for instance of OleDbConnection<br />
strconn = "Provider=Microsoft.Jet.OleDb.4.0;data source = C:\Inetpub\wwwroot\IED416\ied416lp3_19\db\handel.mdb" ' here initialize  string  variable  by  givin  string  of  conenction<br />
Dim dbconn As OleDbConnection = New OleDbConnection(strconn) 'here  initialize OleDbConnection  with string  variable<br />
dbconn.Open() 'Here open OleDb connection string<br />
Dim dbinsert As OleDbCommand = New OleDbCommand("INSERT INTO Kunder (Namn,Ort)  VALUES ('Christian','Sweden')", dbconn)  'Here is initialize  of OleDbCommand  and  here you  get  your  error but if  you  use  this  code  you  should  not  get  any  error<br />
dbinsert.ExecuteNonQuery() 'Here  executed  OleDbCommand <br />
MsgBox("Weee") 'Here Display MessageBox with string Weee<br />
dbconn.Close() ' Here Closed  your  connection string<br />
<br />
End Sub

Amit R wrote:

Is it possible to create form at Runtime and when I click on a button create on the new form the data should get stored in database

rahsi wrote:

where A means alias of Server

rahsi wrote:

This code is working at my office and not at my home. whats the difference in this case.

rahsi wrote:

USER ID=sa; PASSWORD=password

MikeUPMC wrote:

I noticed that when I load in data onto my form it takes a very long time to load, I'm only talking about 91K records.

MikeUPMC wrote:

Is this normal or is it inherit in Sql Server & or Vb.net?