insert statement using AddParams

Question

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.

Iftikar Hussain · Answer

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

Jignesh Trivedi · Answer

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.

Riyaz Akhtar · Answer

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);