insert value into database using ms access 2007

[EDN Admin]

i have a textbox in that number should be entered and stored in database .sometimes textbox will be blank .the problem is if number is not entered then insertion is not taking place .Dim constring As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UsersnandhiniDocumentsAccount.accdb"
Dim insertcmd As System.Data.OleDb.OleDbCommand = New System.Data.OleDb.OleDbCommand
Dim con As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection
con.ConnectionString = constring
insertcmd.CommandType = CommandType.Text
insertcmd.CommandText = String.Format("INSERT INTO {0} VALUES ({1}, {2},{3},{4},{5},{6},{7},{8},{9})", "Account", TextBox8.Text, TextBox1.Text, TextBox3.Text, TextBox2.Text, TextBox6.Text, TextBox7.Text, cd1.Text, crs1.Text, cg1.Text)
insertcmd.Connection = con
con.Open()
Try
insertcmd.ExecuteNonQuery()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try


con.Close()
this is the code which i used ..please help me to solve problem

View the full article