以下是我的程式码，刚学asp.net
希望大家多多指导
DataTable customersData = new DataTable();
SqlConnection conn = new SqlConnection(ConfigurationManager.Conne
ctionStrings["TSQL2012"].ToString());
string cmdst = "INSERT INTO [TSQL2012].[Sales].[Custmoers] (comp
anyname,contactname,contacttitle,address,city,region,postalcode,country,phon
e,fax) VALUES (@cname,@conname,@contitle,@add,@city,@region,@postal,@country
,@phone,@fax)";
SqlCommand scmd = new SqlCommand(cmdst, conn);
SqlParameter param1 = new SqlParameter("@cname", TextBox1.Text);
SqlParameter param2 = new SqlParameter("@conname", TextBox2.Text);
SqlParameter param3= new SqlParameter("@contitle", TextBox3.Text);
SqlParameter param4= new SqlParameter("@add", TextBox4.Text);
SqlParameter param5= new SqlParameter("@city", TextBox5.Text);
SqlParameter param6= new SqlParameter("@region", TextBox6.Text);
SqlParameter param7= new SqlParameter("@postal", TextBox7.Text);
SqlParameter param8= new SqlParameter("@country", TextBox8.Text);
SqlParameter param9= new SqlParameter("@phone", TextBox9.Text);
SqlParameter param10= new SqlParameter("@fax", TextBox10.Text);
scmd.Parameters.Add(param1);
scmd.Parameters.Add(param2);
scmd.Parameters.Add(param3);
scmd.Parameters.Add(param4);
scmd.Parameters.Add(param5);
scmd.Parameters.Add(param6);
scmd.Parameters.Add(param7);
scmd.Parameters.Add(param8);
scmd.Parameters.Add(param9);
scmd.Parameters.Add(param10);
using (SqlDataAdapter adapter = new SqlDataAdapter(selCmd))
{
adapter.Fill(customersData);
}