Command object property settings to execute stored procedure - ADO.NET
Q. What are the Command object property settings to execute a stored procedure?
1. CommandType = Text, CommandText = stored procedure name
2. CommandType= Text, CommandText = SQL syntax to execute the stored
procedure
3. CommandType = StoredProcedure, CommandText = SQL syntax to execute the
stored procedure
4. CommandType = StoredProcedure, CommandText = stored procedure name
- Published on 19 Oct 15a. 1, 2
b. 1, 2, 3
c. 2, 4
d. 1, 4
ANSWER: 2, 4
You can execute stored procedure by using Command object.
SqlCommandcmd = new SqlCommand();
cmd.Connection = ConnectionString;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "stored procedure name ";
