protected void Button1_click(object sender, EventArgs e)
{
try
{
SqlConnection con = new SqlConnection(strcon);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("INSERT INTO member_master_tbl(" +
"full_name,dob,tel,email,salary,username,password) values(" +
"
@full_name,@dob,@tel,
@email,
@salary,
@username,
@password)", con);
cmd.Parameters.AddWithValue("
@full_name", Textbox_1.Text.Trim());
cmd.Parameters.AddWithValue("@dob", Textbox2.Text.Trim());
cmd.Parameters.AddWithValue("@tel", Textbox3.Text.Trim());
cmd.Parameters.AddWithValue("
@email", Textbox4.Text.Trim());
cmd.Parameters.AddWithValue("
@salary", Textbox5.Text.Trim());
cmd.Parameters.AddWithValue("
@username", Textbox_6.Text.Trim());
cmd.Parameters.AddWithValue("
@password", Textbox7.Text.Trim());
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('Тіркелу сәтті өтті кіру парақшасына өтіңіз');</script>");
}
catch(Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "');</script>");
}