Custom Validation

Question

I am using custom validation. my problem is on save button data is inserted in table. e.isvalid=false in this case also data is inserted and in other case also. how can i use custom validation. so that if validation occurs data should not enter database.

.aspx
<asp:CustomValidator ID="cv_login" runat="server" ValidationGroup="add" Enabled="true" ControlToValidate="txt_username" OnServerValidate="cv_login_validate"></asp:CustomValidator>

.cs
protected void cv_login_validate(object sender, ServerValidateEventArgs e)
{
............
........
if (temp > 0)
{
e.IsValid = false;
}
else
{
e.IsValid = true;
}
}

button code
<asp:Button ID="btn_save" runat="server" Font-Bold="true" Text="Save"
onclick="btn_save_Click" ValidationGroup="add" style="height: 26px" CausesValidation="true"/>

nishant ranjan · Answer

i have commented custom validation tag. uncomment it and chk and in cs uncomment protected void cv_login_validate(object sender ServerValidateEventArgs e) and comment protected int cv_login_validate()

Pravin Ghadge · Answer

Hi can u attach that page.

nishant ranjan · Answer

still data is inserted into database

nishant ranjan · Answer

no  this is also not working.

Pravin Ghadge · Answer

Hi Is ur thread has been resolved.

Pravin Ghadge · Answer

Hi Niranjan On Save button click event u have to use. Page.Validate(add); if(Page.IsValid) { ....... }

nishant ranjan · Answer

protected void btn_save_Click(object sender EventArgs e) { string pwd = txt_patpass.Text; string re_pwd = txt_repatpass.Text; string password = Encrypt(pwd); string re_password = Encrypt(re_pwd); login_name = txt_username.Text.ToLower(); try { if (password == re_password) { con.Close(); cmd = new SqlCommand(select id from login_detail where loginname=' + txt_pname.Text + ' con); con.Open(); SqlDataReader rd = cmd.ExecuteReader(); rd.Read(); if (!rd.HasRows) { con.Close(); cmd = new SqlCommand(select value from main_master where description='patient' con); con.Open(); string roleid = cmd.ExecuteScalar().ToString(); con.Close(); cmd = new SqlCommand(proc_patient_detail con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@login_name login_name); cmd.Parameters.AddWithValue(@password password); cmd.Parameters.AddWithValue(@roleid roleid); cmd.Parameters.AddWithValue(@user_sts 1); cmd.Parameters.AddWithValue(@login_sts 0); cmd.Parameters.AddWithValue(@patient_name txt_pname.Text); cmd.Parameters.AddWithValue(@address txt_paddress.Text); cmd.Parameters.AddWithValue(@mobile_no txt_pmobile.Text); cmd.Parameters.AddWithValue(@emailid txt_pemail.Text); cmd.Parameters.AddWithValue(@streamid login_name); cmd.Parameters.AddWithValue(@amount txt_amount.Text); con.Close(); con.Open(); cmd.ExecuteNonQuery(); con.Close(); sendmail(); ClientScript.RegisterClientScriptBlock(this.GetType() success alert('Submitted Successfully');window.location.href='editpatient.aspx'; true); //Response.Redirect(addpatient.aspx); } else { lbl_loginmsg.Text = User Already Exist; lbl_loginmsg.Visible = true; } } } catch (Exception ex) { } }

Pravin Ghadge · Answer

Nishant Show me ur btn_save_Click code.

nishant ranjan · Answer

i have written the code part. in cs part protected void cv_login_validate(object sender ServerValidateEventArgs e) { int temp = 0; con.Close(); string qry = string.Format(select count(*) from login_detail where loginname='{0}' (txt_username.Text)); cmd = new SqlCommand(qry con); con.Open(); temp = Convert.ToInt32(cmd.ExecuteScalar()); if (temp > 0) { e.IsValid = false; } else { e.IsValid = true; } } in aspx page Width=250px AutoPostBack=True OnTextChanged=txt_username_TextChanged > on button click asp:Button ID=btn_save runat=server Font-Bold=true Text=Save onclick=btn_save_Click ValidationGroup=add style=height: 26px CausesValidation=true/>

Pravin Ghadge · Answer

Hi Nishant Can u provide me ur code sniffet.