01.using System;
02.using System.Data;
03.using System.Configuration;
04.using System.Web;
05.using System.Web.Security;
06.using System.Web.UI;
07.using System.Web.UI.WebControls;
08.using System.Web.UI.WebControls.WebParts;
09.using System.Web.UI.HtmlControls;
10.using System.Web.Configuration;
11.using System.Data.SqlClient;
12.
13.public partial class _Default : System.Web.UI.Page
14.{
15. private string strConn, strSql;
16. SqlCommand cmd;
17. SqlConnection conn;
18.
19. protected void Page_Load(object sender, EventArgs e)
20. {
21.
22. }
23.
24. protected void bt_ok_Click(object sender, EventArgs e)
25. {
26. strConn = WebConfigurationManager.ConnectionStrings["System sales CCTV online area in Bangkok"].ConnectionString;
27. conn = new SqlConnection(strConn);
28. conn.Open();
29. cmd = new SqlCommand();
30.
31. strSql = "INSERT INTO [member]([Mem_usename],[Mem_password],[Mem_question],[Mem_answer],[Mem_fname],[Mem_lname],[Mem_card],[Mem_birthday],[Mem_address],[Mem_District],[Mem_province],[Mem_zipcode],[Mem_tel],[Mem_email]) VALUES(@Mem_usename,@Mem_password,@Mem_question,@Mem_answer,@Mem_fname,@Mem_lname,@Mem_card,@Mem_birthday,@Mem_sex,@Mem_address,@Mem_District,@Mem_province,@Mem_zipcode,@Mem_tel,@Mem_email)";
32.
33. cmd.Parameters.Add("@Mem_usename", SqlDbType.VarChar).Value = TextBox3.Text.Trim();
34. cmd.Parameters.Add("@Mem_password", SqlDbType.VarChar).Value = TextBox4.Text.Trim();
35. cmd.Parameters.Add("@Mem_email", SqlDbType.VarChar).Value = TextBox6.Text.Trim();
36. cmd.Parameters.Add("@Mem_question", SqlDbType.VarChar).Value = TextBox7.Text.Trim();
37. cmd.Parameters.Add("@Mem_answer", SqlDbType.VarChar).Value = TextBox8.Text.Trim();
38. cmd.Parameters.Add("@Mem_fname", SqlDbType.VarChar).Value = TextBox9.Text.Trim();
39. cmd.Parameters.Add("@Mem_lname", SqlDbType.VarChar).Value = TextBox10.Text.Trim();
40. cmd.Parameters.Add("@Mem_birthday", SqlDbType.VarChar).Value = TextBox11.Text.Trim();
41. cmd.Parameters.Add("@Mem_card", SqlDbType.VarChar).Value = TextBox12.Text.Trim();
42. cmd.Parameters.Add("@Mem_address", SqlDbType.VarChar).Value = TextBox13.Text.Trim();
43. cmd.Parameters.Add("@Mem_District", SqlDbType.VarChar).Value = TextBox14.Text.Trim();
44. cmd.Parameters.Add("@Mem_province", SqlDbType.VarChar).Value = TextBox15.Text.Trim();
45. cmd.Parameters.Add("@Mem_zipcode", SqlDbType.VarChar).Value = TextBox16.Text.Trim();
46. cmd.Parameters.Add("@Mem_tel", SqlDbType.VarChar).Value = TextBox17.Text.Trim();
47.
48. cmd.CommandText = strSql;
49. cmd.CommandType = CommandType.Text;
50. cmd.Connection = conn;
51.
52.
53.
54.
55.
56. }
57. protected void RadioButton1_CheckedChanged(object sender, EventArgs e)
58. {
59.
60. }
61. protected void TextBox3_TextChanged(object sender, EventArgs e)
62. {
63.
64. }
65.}
