What are the SqlDataAdapter command properties?

 Posted by vishalneeraj-24503 on 12/6/2013 | Category: ADO.NET Interview questions | Views: 2177 | Points: 40
Answer:

Following are the SqlDataAdapter Command Properties:-

1). InsertCommand
2). DeleteCommand
3). UpdateCommand
4). SelectCommand

InsertCommand is used for writing Insert statement.
DeleteCommand is used for writing Delete statement.
UpdateCommand is used for writing Update statement.
SelectCommand is used for writing Select statement.

For Ex:-
//For select query
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("select * from employee_master");
da.Fill(ds);

we can write queries for Insert,delete and update command also.

where did i post the same content.I have just change from objective to subjective. above is my previous post that is not approving.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response