存储过程没错 问题可能出在cmd.ExecuteNonQuery() 这个方法是返回受影响的行数.
我在我这里测试通过 不过是返回一个结果集!
protected void Button1_Click(object sender, EventArgs e)
{
SqlParameter[] paraList = new SqlParameter[2];
paraList[0] = new SqlParameter("@ID", SqlDbType.VarChar,20);
paraList[0].Value = "hoid";
paraList[1] = new SqlParameter("@out", SqlDbType.VarChar,20);
paraList[1].Direction = ParameterDirection.Output;
SelectCmd("Inter_xd", "ds", paraList);
Button1.Text = paraList[1].Value.ToString();
}
#region
/// <summary>
/// 执行查询命令 用于查询类操作
/// </summary>
/// <param name="strProcName">存储过程名</param>
/// <param name="strTabName">返回的表名</param>
/// <param name="paraList">参数列表</param>
/// <returns>返回一个结果集</returns>
public static DataSet SelectCmd(string strProcName, string strTabName, SqlParameter[] paraList)
{
DataSet ds = null;
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(strProcName, conn);
cmd.CommandType = CommandType.StoredProcedure;
if (paraList != null)
{
foreach (SqlParameter para in paraList)
{
cmd.Parameters.Add(para);
}
}
SqlDataAdapter sa = new SqlDataAdapter(cmd);
ds = new DataSet();
sa.Fill(ds, strTabName);
return ds;
}
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
