protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack)
{
string UName2 = Request.Form["username"];
string Pass2 = Request.Form["password"];
string FName2 = Request.Form["firstname"];
string LName2 = Request.Form["lastname"];
string sex2 = Request.Form["sex"];
string Area2 = Request.Form["area"];
string City2 = Request.Form["add_city"];
string Street2 = Request.Form["add_street"];
string SNum2 = Request.Form["add_num"];
string Mail2 = Request.Form["mail"];
string HomeNum2 = Request.Form["homenum"];
string CellNum2 = Request.Form["cellnum"];
string sql1 = string.Format("UPDATE tUsers SET username ='******', pass ='******', firstname ='{2}', lastname ='{3}', sex ='{4}', area ='{5}', add_city ='{6}', add_street ='{7}', add_num ='{8}', mail ='{9}', homenum ='{10}',cellnum = '{11}' WHERE (username ='******')", UName2, Pass2, FName2, LName2, sex2, Area2, City2, Street2, SNum2, Mail2, HomeNum2, CellNum2, UName2);
MyDbase.ChangeTable(sql1, "tUsers.accdb");
Response.Redirect("ShowUsersTable.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
Response.Write("<body dir='rtl'>");
string user_name = Request.Form["text1"];
string lest_name = Request.Form["text2"];
string pass_word = Request.Form["password"];
string age = Request.Form["text3"];
string gender = Request.Form["radio"];
string hoby = Request.Form["DDL"];
string sql1 = "SELECT * FROM AcsessTeble WHERE FN=" + "'" + user_name + "'";
System.Data.DataTable dt = MyDbase.SelectFromTable(sql1, "AccessFile.accdb");
if (dt.Rows.Count == 0)
{
//string sql = "INSERT INTO AcsessTeble(FN,LN)" +"values(" + "'" + user_name + "','" + lest_name + "')";
//MyDbase.ChangeTable(sql, "AccessFile.accdb");
//string sql = "INSERT INTO AcsessTeble(FN)" +
// "values(" + "'" + user_name + "')";
string sql = "INSERT INTO AcsessTeble(FN,LN,PW,Age_fild,gender,hoby)" +
"values(" + "'" + user_name + "','" + lest_name + "','" + pass_word + "','" + age + "','" + gender + "','" + hoby + "')";
MyDbase.ChangeTable(sql, "AccessFile.accdb");
Session["login"] = user_name; // יצירת סשן עם שם משתמש
Response.Redirect("Success.aspx");
}
else
{
Response.Redirect("Erorr.aspx");
}
}
}