SqlException was unhandled ,Invalid object name 'Mobil'.

mevada kamlesh

8y794Visual Basic .NET

SqlException was unhandled ,Invalid object name 'Mobil'.error found Runtime

Our Code is:-

private void button2_Click(object sender, EventArgs e)

{

con.Open();

SqlCommand cmd = new SqlCommand(@"INSERT INTO Mobil

(First, Last, Mobile, Email, Category)

VALUES ('"+textBox1.Text+"','"+textBox2.Text+"','"+textBox3.Text+"','"+textBox4.Text+"','"+comboBox1.Text+"')",con);

cmd.ExecuteNonQuery();

con.Close();

}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manav Pandya8y ago
Accepted answer
Hello

You can store query in string varable like :
String myQuery = "INSERT INTO Mobil
(First, Last, Mobile, Email, Category)
VALUES ('"+textBox1.Text+"','"+textBox2.Text+"','"+textBox3.Text+"','"+textBox4.Text+"','"+comboBox1.Text+"')";
And you can pass to SqlCommand parameter like :
SqlCommand cmd=new SqlCommand(myQuery,con);
Sill you face this issue than debug that line that table is exist or not and check the name of table properly
Thanks
mevada kamlesh8y ago
Problem Resolved
Manav Pandya8y ago
Hello

Make sure that you are providing correct value as per data type defined to mobile column

Like :

Mobile is int , and you should parse to int like

Int.TryParse(textbox3.text);

Thanks
mevada kamlesh8y ago
this time Different error show sqlException was unhandled "Invalid column name 'Mobile'.

Table is Already created and table name and column name different use but problem found
mobile column datatype in valid format
Nitin Sontakke8y ago
What is happening to the validation. What happens if the user is Genelia d'Souza?
Nitin Sontakke8y ago
I think the error is quite self explanatory if you just care to read it.

Obviously either there is no 'Mobil' table in your database or you misspelled it.

Also, if you do have a table called 'Mobile' there is also a column called 'Mobile' in it. Not a very good practise.

Please be bit more imaginative and come up with more descriptive names, for example, tblMobile.

Always enclose your column names within square brackets.

Do not directly call data access code in your UI layer. I am seeing lot of this lately. Create several different classess to perform several different tasks. Do not do everything in the UI page itself.