supplier/supplier_Add.aspx.cs

（完整代码） 2KB 

 using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Text;
using System.Data.SqlClient;

public partial class supplier_Add : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
        
        }
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        
        StringBuilder strSql = new StringBuilder();
         strSql.Append(@"insert into Supplier ( sname,tel,fax,people,ptel,bank,bankno,address,postno ) ");
        strSql.Append(@" values (@sname,@tel,@fax,@people,@ptel,@bank,@bankno,@address,@postno)");

        //设置参数
        SqlParameter[] parameters = new SqlParameter[] {
            new SqlParameter("@sname", SqlDbType.VarChar,100),
            new SqlParameter("@tel", SqlDbType.VarChar,50),
            new SqlParameter("@fax", SqlDbType.VarChar,50),
            new SqlParameter("@people", SqlDbType.VarChar,50),
            new SqlParameter("@ptel", SqlDbType.VarChar,50),
            new SqlParameter("@bank", SqlDbType.VarChar,50),
            new SqlParameter("@bankno", SqlDbType.VarChar,50),
            new SqlParameter("@address", SqlDbType.VarChar,100),
            new SqlParameter("@postno", SqlDbType.VarChar,20)        };

        parameters[0].Value =txt_sname.Text;
        parameters[1].Value =txt_tel.Text;
        parameters[2].Value =txt_fax.Text;
        parameters[3].Value =txt_people.Text;
        parameters[4].Value =txt_ptel.Text;
        parameters[5].Value =txt_bank.Text;
        parameters[6].Value =txt_bankno.Text;
        parameters[7].Value =txt_address.Text;
        parameters[8].Value =txt_postno.Text;

        SqlHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters);
        MessageBox.ShowAndRedirect(this, "保存成功！", "supplier_Add.aspx");

    }
}

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。