高分，各位来帮我看看这是怎么回事?使用存储过程,前台我直接付值了，就点一下按钮就可以了，但是数据库没有反应，也不报错．

[bolome]

protected void button_a_Click(object sender, EventArgs e)
    {   
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["NetdbConnectionString"].ConnectionString);
        try
        {
            con.Open();
            SqlCommand cmd = con.CreateCommand();
            cmd.CommandText = "product_add_HbxzTB";
            cmd.CommandType = CommandType.StoredProcedure;
            SqlParameter param;
            string ID ="123";
            param = cmd.Parameters.AddWithValue("@Iproduct_ID", ID);
            param.Direction = ParameterDirection.Input;
            param.DbType = DbType.String;

            string gcxz ="456";
            param = cmd.Parameters.AddWithValue("@qcxz", gcxz);
            param.Direction = ParameterDirection.Input;
            param.DbType = DbType.String;

            string hcxz ="789";
            param = cmd.Parameters.AddWithValue("@hcxz", hcxz);
            param.Direction = ParameterDirection.Input;
            param.DbType = DbType.String;


        }
        finally
        {
            con.Close();
        }

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER proc [dbo].[product_add_HbxzTB]
 @Iproduct_ID nchar(32), 
 @qcxz nchar(10),
 @hcxz nchar(10)
as  
insert into HbxzTB (Iproduct_ID,qcxz,hcxz) values(@Iproduct_ID,@qcxz,@hcxz)

高分，各位来帮我看看这是怎么回事?使用存储过程,前台我直接付值了，就点一下按钮就可以了，但是数据库没有反应，也不报错．

[fmzwyfmzwy]

肯定会错你的value没有赋值撒
param.Value=“sm”

[yangpeiyu]

这句
cmd.ExecuteNonQuery();

[yb1124]

不报错？

try{
}
catch(Exception ex)
{
   Response.Write(ex.Message);
}
finally
{
   con.close();
}

看看是否有异常

[yangpeiyu]

都没有执行。当然没反应了。我接分啦。。哈。

[gjfizx]

[Quote=引用 2 楼 yangpeiyu 的回复:]
这句
cmd.ExecuteNonQuery();
[/Quote]

[amandag]

    protected void button_a_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["NetdbConnectionString"].ConnectionString);
        try
        {
            con.Open();
            SqlCommand cmd = con.CreateCommand();
            cmd.CommandText = "product_add_HbxzTB";
            cmd.CommandType = CommandType.StoredProcedure;
            SqlParameter param;
            string ID = "123";
            param = cmd.Parameters.AddWithValue("@Iproduct_ID", ID);
            param.Direction = ParameterDirection.Input;
            param.DbType = DbType.String;

            string gcxz = "456";
            param = cmd.Parameters.AddWithValue("@qcxz", gcxz);
            param.Direction = ParameterDirection.Input;
            param.DbType = DbType.String;

            string hcxz = "789";
            param = cmd.Parameters.AddWithValue("@hcxz", hcxz);
            param.Direction = ParameterDirection.Input;
            param.DbType = DbType.String;

            cmd.EndExecuteNonQuery();
        }
        finally
        {
            con.Close();
        }
    }

[bolome]

低级错误！！！

[yangpeiyu]

。哈哈，楼主不小心吧。那就来吧。我准备接分啦。向两星星个冲。。

[bolome]

谢谢各位了！！！结帐

[GT7466]

//你不执行他，要他怎么反应？

			using( SqlDataAdapter da = new SqlDataAdapter(cmd) )
			{
				DataSet ds = new DataSet();

				da.Fill(ds);

				cmd.Parameters.Clear();

				return ds;
			}