ASP.NET学习基础十三：数据添加的另一种方式

//引用using System.Data.SqlClient;

string constr = "server=localhost;uid=sa;pwd=sa;database=dianxinkapin";

String insertCmd = "insert into comeout (出库编号,卡类) values (@id,@type)";

SqlConnection cn = new SqlConnection(constr);

SqlCommand cmd = new SqlCommand(insertCmd,cn );

cmd.Parameters.Add("@id", SqlDbType.Int,8).Value= TextBox3.Text;

cmd.Parameters.Add("@type", SqlDbType.VarChar ,20).Value= TextBox4.Text;

cn.Open();

cmd.ExecuteNonQuery();

cn.Close();