المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Data not insert



C# Programming
01-30-2010, 01:00 AM
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