insert statement using AddParams

tunde Mattieu

Please I am trying out how to use dataAdapter.InsertCommand to insert into the DB. It says AddParams does not exist in my current context..Please is there something i am missing out. below is the code:

adapter.InsertCommand = myConn.CreateCommand();

adapter.InsertCommand.CommandText =

"INSERT INTO Article " +

"(artId, title, topic, authorId, lines, dateOfPublishing) " +

"VALUES(@artId, @title, @topic, @authorId, @lines, @dateOfPublishing) ";

AddParams(adapter.InsertCommand, "artId", "title", "topic", "authorId", "lines", "dateOfPublishing");

I am using visual studio 2012. Anyone with helpful hint.

Thanks.

3 Replies

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

Iftikar Hussain13y ago
Hi,
You can try like this

SqlDataAdapter adapter = new SqlDataAdapter();
adapter.InsertCommand = myConn.CreateCommand();
adapter.InsertCommand.CommandText = "INSERT INTO Article (artId, title, topic, authorId, lines, dateOfPublishing) " +
"VALUES(@artId, @title, @topic, @authorId, @lines, @dateOfPublishing)";
adapter.InsertCommand.Parameters.AddWithValue("@artId", 1);
adapter.InsertCommand.Parameters.AddWithValue("@title", "title");
adapter.InsertCommand.Parameters.AddWithValue("@topic", "topic");
adapter.InsertCommand.Parameters.AddWithValue("@authorId", 1);
adapter.InsertCommand.Parameters.AddWithValue("@lines", "lines");
adapter.InsertCommand.Parameters.AddWithValue("@dateOfPublishing", DateTime.Now);
adapter.InsertCommand.ExecuteNonQuery();

Regards,
Iftikar
0
Jignesh Trivedi13y ago
hi,
As per my knowledge there is no AddParams method in ADO.net
To add parameter you have to write your own code.
Please refer
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters.aspx
hope this will help you.
0
Riyaz Akhtar13y ago
Try the below code, you give proper SqlDbType and value based on input column

adapter.InsertCommand.CommandText =
"INSERT INTO Article " +
"(artId, title, topic, authorId, lines, dateOfPublishing) " +
"VALUES(@artId, @title, @topic, @authorId, @lines, @dateOfPublishing) ";

adapter.InsertCommand.Parameters.Add("@artId", SqlDbType.Int, 4, "[artId value]");
adapter.InsertCommand.Parameters.Add("@title", SqlDbType.VarChar, 50, "title");
adapter.InsertCommand.Parameters.Add("@topic", SqlDbType.VarChar, 50, "topic");
adapter.InsertCommand.Parameters.Add("@authorId", SqlDbType.Int, 4, "authorId");
adapter.InsertCommand.Parameters.Add("@lines", SqlDbType.Int, 4, "lines");
adapter.InsertCommand.Parameters.Add("@dateOfPublishing", SqlDbType.Date, 4, "dateOfPublishing");
0