asp.net 调用存储过程

(1)执行一个没有参数的存储过程的代码如下： SqlConnection conn=new SqlConnection(“connectionString”); SqlDataAdapter da = new SqlDataAdapter(); da.selectCommand = new SqlCommand(); da.selectCommand.Connection = conn; da.selectCommand.CommandText = "NameOfProcedure"; da.selectCommand.CommandType = CommandType.StoredProcedure; (2)执行一个有参数的存储过程的代码如下 SqlConnection conn=new SqlConnection(“connectionString”); SqlDataAdapter da = new SqlDataAdapter(); da.selectCommand = new SqlCommand(); da.selectCommand.Connection = conn; da.selectCommand.CommandText = "NameOfProcedure"; da.selectCommand.CommandType = CommandType.StoredProcedure; param = new SqlParameter("@ParameterName", SqlDbType.DateTime); param.Direction = ParameterDirection.Input; param.Value = Convert.ToDateTime(inputdate); da.selectCommand.Parameters.Add(param); 若需要添加输出参数： param = new SqlParameter("@ParameterName", SqlDbType.DateTime); param.Direction = ParameterDirection.Output; param.Value = Convert.ToDateTime(inputdate); da.selectCommand.Parameters.Add(param); 若要获得参储过程的返回值： param = new SqlParameter("@ParameterName", SqlDbType.DateTime); param.Direction = ParameterDirection.ReturnValue; param.Value = Convert.ToDateTime(inputdate); da.selectCommand.Parameters.Add(param);

转载于:https://www.cnblogs.com/neoe1984/archive/2007/06/22/793415.html