First, create a stored procedure in SQL Server, which is divided into parameters and no arguments, and briefly introduces the simple absence of parameters:
Suppose the stored procedure is as follows:
Copy Code code as follows:
create proc SelectAll
as
Select * from Stude Ntinf
The call to this SP is as follows:
SqlCommand selectcmd = new SqlCommand ("SelectAll", conn);
//conn is sqlconnection
Selectcmd.commandtype = CommandType.StoredProcedure;
If you need to add a result set to a DataAdapter, you can do the following:
SqlDataAdapter studa = new SqlDataAdapter ();
Studa.selectcommand = selectcmd;
If there are parameters: Create proc andselect
@studentid varchar (a),
@studentname varchar (a),
as
Sel ECT * from studentinf where StudentID = @studentid and studentname = @studentname
The parameter can be added as follows:
Selectcmd.par Ameters.add ("@studentid", SqlDbType.NVarChar, 10);
Selectcmd.parameters.add ("@studentname", SqlDbType.NVarChar, 10);
If there is only one parameter, you can also assign this value:
sqlparameters Onepara = Selectcmd.parameters.add ("@studentid", SqlDbType.NVarChar, 10);
Onepara.value = "A string"