1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| string sqlCmd = "INSERT INTO users (last_name, first_name, email, password, registered_date, registered_hour) VALUES (@LAST_NAME, @FIRST_NAME, @EMAIL, @PASSWORD, @REGISTERED_DATE, @REGISTERED_HOUR);";
using (conn)
{
SqlCommand cmd = new SqlCommand(sqlCmd, conn);
cmd.Parameters.AddWithValue("@LAST_NAME", txtBxLastName.Text.ToString());
cmd.Parameters.AddWithValue("@FIRST_NAME", txtBxFirstName.ToString());
cmd.Parameters.AddWithValue("@EMAIL", txtBxEmail.ToString());
cmd.Parameters.AddWithValue("@PASSWORD", txtBxPasswordRegister.ToString());
cmd.Parameters.AddWithValue("@REGISTERED_DATE", System.DateTime.Now.Date.ToShortDateString());
cmd.Parameters.AddWithValue("@REGISTERED_HOUR", System.DateTime.Now.TimeOfDay.ToString());
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
}
catch (Exception exc)
{
}
} |
Partager