You Just Try This Code
protected void cmdLogin_Click(object sender, EventArgs e)
{
Class1.con = CreateConnection();
string str = "SELECT Ad_Regid from Admin_Profile WHERE Ad_Regid LIKE @TempPasscode";
cmd = new SqlCommand(str, Class1.con);
con.Open();
cmd.Parameters.AddWithValue("@TempPasscode", txtcurrentpwd.Text.Trim());
cmd.CommandType = CommandType.Text;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
if (dr[4].ToString() == txtcurrentpwd.Text)
{
cmd = new SqlCommand("_insertAdminLogin", Class1.con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@AdminType", ddltype.SelectedItem.Text);
cmd.Parameters.AddWithValue("@AdminUsrname", txtuname.Text);
cmd.Parameters.AddWithValue("@AdminPwd", txtconfirmpwd.Text);
cmd.ExecuteNonQuery();
con.Close();
}
else
{
ClientScript.RegisterStartupScript(GetType(), "Warning", "javascript:alert('Temporary Password Does not Match!');", true);
}
}
)
AS BEGIN
INSERT INTO dbo.AdminLogin (AdminType, AdminUsrname, AdminPwd)
VALUES (@AdminType, @AdUsrname, @AdminPwd)
END
}