i am new to programing help me out

[naveens]

I want to insert values from vb textbox in sql table named [home] and my code is


Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim result As Integer
Dim conn As New OleDb.OleDbConnection("provider=SQLOLEDB;User ID=sa;password=xxxxxx;Initial Catalog=first;data source=NAVEEN;")
conn.Open()
Dim insert1 As New OleDb.OleDbCommand
insert1 = New OleDb.OleDbCommand("insert into home values('" + TextBox1.Text + "','" + TextBox2.Text + "'),conn")
insert1.CommandType = CommandType.Text
result = insert1.ExecuteNonQuery()
conn.Close()

error message that i get is

ExecuteNonQuery: Connection property has not been initialized.


please help out

thanks

[jamesd0142]

Imports System.Data.OleDb

Try
            Dim StrConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Users\Users.mdb"
            Dim oConn As New System.Data.OleDb.OleDbConnection(StrConn)
            Dim con As New System.Data.OleDb.OleDbCommand
            con.Connection = oConn
            con.CommandType = CommandType.Text
            con.CommandText = ""            
            oConn.Open()
            con.ExecuteNonQuery()
            oConn.Close()
        Catch
        End Try
 

[Curtis Rutland]

Part of your problem seems to be that you have a quote after conn. But let me show you an easier way to build your command string:

Dim cmdStr As String
cmdStr = String.Format("insert into homes values('{0}','{1}')", TextBox1.Text, TextBox2.Text)
Dim insert1 As New OleDb.OleDbCommand
insert1 = New OleDb.OleDbCommand(cmdStr,conn)
 

String.Format will replace the {#} with the parameters that follow in order, so {0} will have the value of TextBox1.Text, and {1} will have the value of TextBox2.Text.

Also, I'd suggest that instead of OleDb, you use SqlClient. SqlClient is the native .NET data provider for MS SQL Server. So OleDbConnection becomes SqlConnection (get your connection string here) and OleDbCommand becomes SqlCommand.