62,244
社区成员




param = cmd.Parameters.Add("@out", SqlDbType.Char, 22);
param.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
Button1.Text = cmd.Parameters["@out"].Value.ToString();
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
cmd.CommandText = "EXEC Inter_xd(@ID,@stat,@out)";
cmd.CommandType = CommandType.Text;
param = cmd.Parameters.Add("@out", SqlDbType.Char, 22);
param.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
Button1.Text = cmd.Parameters["@out"].Value.ToString();
cmd.CommandText = "Inter";
ALTER proc [dbo].[Inter_xd]
--输入信息
@ID nchar(32),
@stat nchar(10),
@out char(17) output
as
set @out=@ID
param.Direction = ParameterDirection.ReturnValue;