help me debug

[menyki]

help 'e debug
--------------------------------------------------------------------------------

I wrote the below code to input new data from name and address textbox of a form to microsoft access but there are alot of error. the name of the table in the access is Hotel and the the fields are HotelName and HotelAddress . Please can somebody help me and debug. i used vb.net

Note: almost all the line is underlined with red line indicating incorrect declaration and so on. please help me debuge. i know is also possible you set OleDb connection and OleDbAdapter and then write a few line code to input data into database. how do i write the code. please help me

Private Sub submitButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
 
 
        Dim Objconn As New SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector  y|\ECBInvoicing.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")
        Objconn.Open()
 
        ObjCmd = New SqlCommand("INSERT INTO hotel (HotelName, HotelAddress) VALUES (@HotelName, @HotelAddress)", Objconn)
 
 
        ObjCmd.Parameters.Add("@HotelName", Data.SqlDbType.VarChar).Value = txtHotelname.Text
        ObjCmd.Parameters.Add("@HotelAddress", Data.SqlDbType.VarChar).Value = txtHotelAddress.Text
 
 
        ObjCmd.ExecuteNonQuery()
 
 
        Objconn.Close 
    End Sub

[vanc]

To query access database you should use System.Data.Ole Db namespace
and create connection
OleDbConnection connection = new OleDbConnection (@"Provider=Mic rosoft.Jet.OLED B.4.0;" +
" User Id=; Password=; Data Source="mdb file name")

Create command
OleDbCommand command = connection.Crea teCommand()
command.Command Text = ""

Create DataReader
OleDbDataReader reader = command.Execute Reader();

cheers.