project problem

[aartinair]

hii everybdy.Act now i have removed the data source and added this code,still the data is noty getting inserted

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim myOleDbConnection As OleDb.OleDbConnection
        Dim insertcommand As String
        Dim connString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Documents and Settings\Radhakrishnan\My Documents\Visual Studio 2008\Projects\BHARATH MATRIMONY\BHARATH MATRIMONY\My Project\REGISTRATIONGROOM.accdb;Persist Security Info=False"
        insertcommand = "INSERT INTO GROOM(MATCH,NAME1,MARITAL STATUS,HEIGHT,AGE,COUNTRY,STATE,CITY,QUALIFICATION,CASTE,RELIGION,MOTHER TONGUE,MOBILE NO,RESIDENCE NO,PHOTO)VALUES (trim(cmbMatch.value),trim(txtName.text),trim(RadioButton.selected.value),trim(txtHeight.text),trim(txtAge.text),trim(cmbCountry.value),trim(cmbState.value),trim(cmbCity.value),trim(txtQualification.text),trim(cmbCaste.value),trim(cmbReligion.value),trim(cmbMotherTongue.value),trim(txtMobile.text),trim(txtResidence.text),picGroom.image)"
        myOleDbConnection = New OleDb.OleDbConnection(connString)
        Dim myOleDbCommand As New OleDb.OleDbCommand(insertcommand, myOleDbConnection)
        myOleDbConnection.Open()
        myOleDbCommand.ExecuteNonQuery()
        myOleDbConnection.Close()
    End Sub

plz some1 do reply

[tlhintoq]

TIP: When you are writing your question, there is a button on the tool bar that wraps the [code] tags around your copy/pasted code. It helps a bunch. Its the button with a '#' on it. More on tags. They're cool. Check'em out.

[tlhintoq]

Database How two parts 1 and 2
http://bytes.com/topic/net/insights/...e-your-program
http://bytes.com/topic/net/insights/...rogram-part-ii

[Frinavale]

Your SQL statement is not right.
Your values, if they are Strings in the database, have to be enclosed in quotes ('').
A better way to do this is to use parameters (this is demonstrated in part 1 of the "How to use a database in your program" articles)

-Frinny