Data not insert

[mjawadkhatri]

hi, i need your help when i insert data in my table show error Error is ERROR [42S02] [Microsoft][SQL Native Client][SQL Server]Invalid object name 'test' and i use this coding string MyString = "Select * from test"; OdbcConnection cn = new OdbcConnection("Driver={SQL Native Client};Server=localhost;UID=sa;PWD=java;"); OdbcCommand cmd = new OdbcCommand(MyString, cn); cn.Open(); MessageBox.Show("Connected"); cmd.CommandText = "insert into test values ('" + textBox1.Text + "','" + textBox2.Text + "')"; MessageBox.Show(cmd.CommandText); cmd.ExecuteNonQuery(); cn.Close(); Thanks In Advance jawad khatri

[loyal ginger]

Did you verify that you have a table named "test"?

[kevinnicol]

You also didn't supply which database or catalogue you wish to connect to, so you are probably just connnected to the master database which I very much doubt has a table called test. Add a Database=[dbname]; section to your query string.

[rockracker]

cmd.CommandText = "insert into test values ('" + textBox1.Text + "','" + textBox2.Text + "')"; --------------------------------------------------------------------------------------- try this one.... cmd.CommandText = "insert into test values ('" textBox1.Text + "','" + textBox2.Text + "')"; :doh: :doh: :doh: :doh: :doh: :doh: :doh:

[mjawadkhatri]

yes i have test table