创建存储过程
Create PROCEDURE Getstudentname(
@studentid INT
)
AS
BEGIN
SELECT Firstname+' '+Lastname FROM tbl_Students WHERE studentid=@studentid
END
执行存储过程(有疑问加群:480888314 技术交流 干货分享)
/// <summary>
/// </summary>
/// <param name="procedureName">存储过程名称</param>
/// <param name="para">参数 放在Hashtable</param>
/// <returns></returns>
public DataSet ExecProcedure(string procedureName, Hashtable hs)
{
DataSet ds = new DataSet();
try
{
using (SqlConnection conn = new SqlConnection(GetConnString()))
{
SqlCommand com = new SqlCommand(procedureName, conn);
com.CommandType = CommandType.StoredProcedure;//采用存储过程
foreach (DictionaryEntry dic in hs)
{
com.Parameters.Add("@" + dic.Key.ToString(), dic.Value);
}
SqlDataAdapter adapter = new SqlDataAdapter(com);
adapter.Fill(ds);
}
}
catch (Exception ex)
{
ExecptionRecord.WriteExecptionToFile(ex.ToString(), " ");
}
return ds;
}