UC知道调用存储过程失败
来源：百度知道 编辑：UC知道 时间：2024/06/07 06:33:20
页面后台：
if (con.excuPro1("addfenxi", new string[]{ Session["teaname"].ToString(), TextBox1.Text, DropDownList1.SelectedValue }) == true)
{
this.Label1.Text = "提交成功!";
}
else
{
this.Label1.Text = "对不起!提交失败!";
}
对应函数如下：
public bool excuPro1(string procudureName, string[] proParameter)
{
SqlCommand cmd = new SqlCommand();
SqlConnection con = getcon();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = procudureName;
for (int i = 0; i < proParameter.Length; i++)
{
cmd.Parameters.Add(new SqlParameter(proParameter[i], SqlDbType.VarChar));
}
cmd.Connection = con;
if (con.State == System.Data.ConnectionState.Closed)
if (con.excuPro1("addfenxi", new string[]{ Session["teaname"].ToString(), TextBox1.Text, DropDownList1.SelectedValue }) == true)
{
this.Label1.Text = "提交成功!";
}
else
{
this.Label1.Text = "对不起!提交失败!";
}
对应函数如下：
public bool excuPro1(string procudureName, string[] proParameter)
{
SqlCommand cmd = new SqlCommand();
SqlConnection con = getcon();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = procudureName;
for (int i = 0; i < proParameter.Length; i++)
{
cmd.Parameters.Add(new SqlParameter(proParameter[i], SqlDbType.VarChar));
}
cmd.Connection = con;
if (con.State == System.Data.ConnectionState.Closed)
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);