I have many users in my system and i want all users to change their passwords respectively.
protected void Button1_Click(object sender, EventArgs e)
{
try
{
if (Label2.Text.Contains("@iumw.edu.my"))
{
if (TextBox1.Text == SqlDataSource1.SelectCommand)
{
if (TextBox2.Text == TextBox3.Text)
{
Label3.Visible = true;
Label3.Text = "";
con.Open();
SqlCommand cmd = new SqlCommand("Update [Programme Leader] set Password='" + TextBox3.Text + "'where Username='" + Session["username"].ToString() + "'", con);
cmd.ExecuteNonQuery();
con.Close();
Label3.ForeColor = System.Drawing.Color.Red;
Label3.Text = "Password Changed Successfully";
}
}
}
if (Label2.Text != "")
{
if (TextBox1.Text == SqlDataSource2.SelectCommand)
{
if (TextBox2.Text == TextBox3.Text)
{
Label3.Visible = true;
Label3.Text = "";
con.Open();
SqlCommand cmd = new SqlCommand("Update Student set Password='" + TextBox3.Text + "'where Username='" + Session["username"].ToString() + "'", con);
cmd.ExecuteNonQuery();
con.Close();
Label3.ForeColor = System.Drawing.Color.Red;
Label3.Text = "Password Changed Successfully";
}
}
}
if(TextBox2.Text != TextBox3.Text)
{
Label3.Visible=true;
Label3.Text = "";
Label3.ForeColor = System.Drawing.Color.Red;
Label3.Text = "The Passwords Do Not Match";
}
}
catch
{
}
}
}
}
I think i need a stored procedure to do this, but i dont know how to do it. please help me
Thanks