→ O2000: 單純Insert用SqlCommand.ExecuteNonQuery吧 02/21 16:56
→ wezmag: 記得用using包起來 02/21 19:53
→ nickerChen: 在SqlCommand scmd = new 這行前面用using(){}包起來 02/22 11:26
推 Litfal: 剛學嗎? 你要不要早點跳MVC 02/22 16:31
以下是我的程式碼，剛學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);
}
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 175.97.37.124
※ 文章網址: https://www.ptt.cc/bbs/C_Sharp/M.1550736312.A.D69.html
※ 編輯: falink (175.97.37.124), 02/21/2019 16:05:49