 |
|
นี่คือโค้ดที่เขียนไว้ค่ะ
protected void bt_submit_Click(object sender, EventArgs e)
{
string connect = "Data Source=.\\SQLEXPRESS;Initial Catalog=furniture;user=sa;password=123456;";
SqlConnection con = new SqlConnection(connect);
con.Open();
System.Text.StringBuilder str = new System.Text.StringBuilder();
str.AppendLine("insert in to customers(customerID, customerFName, customerLName, username, password, address, phone, mail)");
str.AppendLine("values(@customerID, @customerFName, @customerLName, @username, @password, @address, @phone, @mail)");
SqlCommand comm = new SqlCommand(str.ToString(), con);
//comm.Parameters.AddWithValue("@userID", );
comm.Parameters.AddWithValue("@customerFName", tb_fname.Text);
comm.Parameters.AddWithValue("@customerLName", tb_lname.Text);
comm.Parameters.AddWithValue("@username", tb_username.Text);
comm.Parameters.AddWithValue("@password", tb_pass.Text);
comm.Parameters.AddWithValue("@address", tb_address.Text);
comm.Parameters.AddWithValue("@phone", tb_phone.Text);
comm.Parameters.AddWithValue("@mail", tb_mail.Text);
comm.ExecuteNonQuery();
con.Dispose();
}
รบกวนด้วยน่ะค่ะ
Tag : .NET, Ms SQL Server 2008, HTML/CSS, Ajax, Web (ASP.NET), C#
|
|
|
 |
 |
 |
 |
| Date :
2011-01-01 15:02:48 |
By :
ling-keaw |
View :
1139 |
Reply :
6 |
|
 |
 |
 |
 |
|
|
|
|
 |
