向sql数据库中添家数据.txt

来自「学习积累的代码段」· 文本 代码 · 共 31 行

 SqlConnection con = db.creatcon();
        con.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = (SqlConnection)con;
     cmd.CommandText= "insert into [client](cid,cname,caddress,ctel,cemal,caccount,ctex)values(@cid,@cname,@caddress,@ctel,@cemal,@caccount,@ctex)";
       
        cmd.Parameters.Add("@cid",SqlDbType.VarChar);
        cmd.Parameters.Add("@cname", SqlDbType.VarChar);
        cmd.Parameters.Add("@caddress", SqlDbType.VarChar);
        cmd.Parameters.Add("@ctel", SqlDbType.VarChar);
        cmd.Parameters.Add("@cemal", SqlDbType.VarChar);
        cmd.Parameters.Add("@caccount", SqlDbType.VarChar);
        cmd.Parameters.Add("@ctex", SqlDbType.VarChar);


        cmd.Parameters["@cid"].Value = this.TextBox1.Text;
        cmd.Parameters["@cname"].Value = this.TextBox2.Text;
        cmd.Parameters["@caddress"].Value = this.TextBox3.Text;
        cmd.Parameters["@ctel"].Value = this.TextBox4.Text;
        cmd.Parameters["@cemal"].Value = this.TextBox5.Text;
        cmd.Parameters["@caccount"].Value = this.TextBox6.Text;
        cmd.Parameters["@ctex"].Value = this.TextBox7.Text;
        cmd.ExecuteNonQuery();

 
     

   con.Close();

   Response.Write("添加成功");
   Response.Redirect("client.aspx");