01.
02.MySqlConnection objConn;
03.MySqlCommand objCmd;
04.string strConnString = null;
05.string strSQL = null;
06.
07.strConnString = "Server=localhost;User Id=root; Password=123456; Database=database; Pooling=false";
08.objConn = new MySqlConnection(strConnString);
09.objConn.Open();
10.
11. int intNumRows = 0;
12. strSQL = "SELECT COUNT(*) FROM member WHERE User = '" + Request.QueryString["User"] + "'";
13. objCmd = new MySqlCommand(strSQL, objConn);
14. intNumRows = Convert.ToInt32(objCmd.ExecuteScalar());
15. if (intNumRows > 0)
16. {
17. objCmd = new MySqlCommand("insert into member(namethai,tel) value (?snamethai,?stel)", objConn);
18. objCmd.Parameters.Add(new MySqlParameter("?snamethai", textbox1.Text));
19. objCmd.Parameters.Add(new MySqlParameter("?stel", textbox2.Text));
20. objCmd.ExecuteNonQuery();
21. }
22.objConn.Close();
23.objConn = null;
