Nodals
website problem: update and permmisson
this is the update page :
protected void Page_Load(object sender, EventArgs e)
{
string filname = "MyDB.mdf";
string select = "SELECT * FROM users WHERE usern ='" + Session["status"].ToString() + "'";
DataTable table = MyAdoHelper.ExecuteDataTable(filname, select);
int len = table.Rows.Count;
if (len > 0)
{
globalusername = table.Rows[0]["usern"].ToString();
globalpassword = table.Rows[0]["userpass"].ToString();
}
if (Request.Form["updateuser"] != null)//did you update?
{
string umameupdate = Request.Form["uname"].ToString();
string passwordupdate = Request.Form["upass"].ToString();
string updateq = "UPDATE users SET ";
updateq += "usern='" + umameupdate + "'";
updateq += ",userpass='" + passwordupdate + "'";
updateq += "WHERE usern='" + Session["status"].ToString() + "'";
MyAdoHelper.DoQuery(filname, updateq);
Response.Write("Update!");
Response.Redirect("HomePage.aspx");
}
}
31 replies