How to insert the data to sql table?

Dinesh Santhalingam

I have some values .I want to insert the values into the Sql table .Here is my code.There were no error populating.But i can't able to insert the data to sql table.

using (SqlConnection Connection = new SqlConnection((@"Data Source")))
{
using (SqlCommand myCommand = new SqlCommand("INSERT INTO table1(Nameofbike,Totalbike,
Inuse)", Connection))
{
Connection.Open();
myCommand.Parameters.Add(new SqlParameter("Nameofbike", "Hero"));
myCommand.Parameters.Add(new SqlParameter("Totalbike", "15"))
myCommand.Parameters.Add(new SqlParameter("Inuse", "10"));
}
Connection.Close();
}

4 Replies

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

Rajeesh Menoth9y ago
Accepted answer
Hi,

Your code is containing wrong syntax.

Check this code :

using (SqlCommand cmd = new SqlCommand("INSERT INTO table1(Nameofbike,Totalbike,Inuse) VALUES (@Nameofbike,@Totalbike,@Inuse)"))

Code :
using (SqlConnection Connection = new SqlConnection((@"Data Source")))
{
using (SqlCommand myCommand = new SqlCommand("INSERT INTO table1(Nameofbike,Totalbike,
Inuse) values (@Nameofbike,@Totalbike,@Inuse)", Connection))
{
Connection.Open();
myCommand.Parameters.Add(new SqlParameter("@Nameofbike", "Hero"));
myCommand.Parameters.Add(new SqlParameter("@Totalbike", "15"))
myCommand.Parameters.Add(new SqlParameter("@Inuse", "10"));
}
Connection.Close();
}
Reference :

http://www.aspsnippets.com/Articles/Insert-data-into-database-using-Web-Service-in-ASPNet-using-C-and-VBNet.aspx
Dinesh Santhalingam9y ago
Is it working?@
Mangesh Gaherwar
Mangesh G9y ago
Dinesh

make sure u are using the proccedures approach to do any sort of db operations.

Thanks
Mangesh G9y ago
Hey Dinesh ,

Little Bi modification therer in code

using (SqlConnection Connection = new SqlConnection((@"Data Source")))
{
using (SqlCommand myCommand = new SqlCommand("INSERT INTO table1(Nameofbike,Totalbike,
Inuse) values (@Nameofbike,@Totalbike,@Inuse)", Connection))
{
Connection.Open();
myCommand.Parameters.Add(new SqlParameter("@Nameofbike", "Hero"));
myCommand.Parameters.Add(new SqlParameter("@Totalbike", "15"))
myCommand.Parameters.Add(new SqlParameter("@Inuse", "10"));

}
Connection.Close();
}

Hope it solves ur issue

mark approved if it does !!!!