Following are the SqlDataAdapter Command Properties:-
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 select query
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("select * from employee_master");
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 |