Using jquery in the client side(textbox validation) it is work,but the server(save and update code) is not working.
when i click save btn, if the textbox is empty it will show the msgbox.But i provide all value there is no response..
What can i do..
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script type="text/javascript">
$(function validation() {
$("#btnsave").click(function () {
if ($("#txtzonal").val() == "" ){
alert("Zonal shouldn't be empty!")
}
else if($("#txtname").val() == "" ){
alert("Name shouldn't be empty!")
}
else if($("#txtusername").val() == "" ){
alert("Username shouldn't be empty!")
}
else if($("#txtpassword").val() == "" ){
alert("Password shouldn't be empty!")
}
else if($("#txtphoneno").val() == "" ){
alert("Phoneno shouldn't be empty!")
}
else if($("#txtgmail").val() == "" ){
alert("Gmail shouldn't be empty!")
}
else if ($("[id*=ddlcertificate]").val() == "") {
alert("Certificate is Empty")
}
else if ($("[id*=ddlcategory]").val() == "") {
alert("Category is Empty")
}
else if ($("[id*=ddlqualification]").val() == "") {
alert("Qualification is Empty")
}
else if ($("[id*=ddlexperience]").val() == "") {
alert("Experience is Empty")
}
else {
var radio = $("#ddlgender").find("input");
var isChecked = false;
for (var i = 0; i < radio.length; i++) {
if (radio[i].checked) {
isChecked = true;
break;
}
}
if (!isChecked) {
alert("Please select an option from gender!");
}
}
return false;
});
});
</script>
client side jquery
protected void btnsave_Click(object sender, EventArgs e)
{
if (btnsave.Text == "Save")
{
sqlCon.ConnectionString = objsqlHelpingClass.strSqlConnection;
SqlCommand SqlCmd = new SqlCommand("sp_zonal_insertupdate", sqlCon);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.Add("@zonalid", SqlDbType.Int).Value = 0;
SqlCmd.Parameters.Add("@name", SqlDbType.VarChar).Value = txtname.Text;
SqlCmd.Parameters.Add("@username", SqlDbType.VarChar).Value = txtusername.Text;
SqlCmd.Parameters.Add("@password", SqlDbType.VarChar).Value = txtpassword.Text;
SqlCmd.Parameters.Add("@gender", SqlDbType.VarChar).Value = ddlgender.Text;
SqlCmd.Parameters.Add("@phoneno", SqlDbType.VarChar).Value = txtphoneno.Text;
SqlCmd.Parameters.Add("@experience", SqlDbType.VarChar).Value = ddlexperience.Text;
SqlCmd.Parameters.Add("@qualification", SqlDbType.VarChar).Value = ddlqualification.Text;
SqlCmd.Parameters.Add("@certificate", SqlDbType.VarChar).Value = ddlcertificate.Text;
SqlCmd.Parameters.Add("@category", SqlDbType.VarChar).Value = ddlcategory.Text;
SqlCmd.Parameters.Add("@gmail", SqlDbType.VarChar).Value = txtgmail.Text;
SqlCmd.Parameters.Add("@zonal", SqlDbType.VarChar).Value = txtzonal.Text;
SqlCmd.Parameters.Add("@type", SqlDbType.Int).Value = 1;
sqlCon.Open();
int intRowAffected = SqlCmd.ExecuteNonQuery();
sqlCon.Close();
if (intRowAffected > 0)
{
//lblWarning.Text = "Zonal Manager Added Successfully!...";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Zonal Manager Added Successfully');</script>");
clearcontrol();
}
}
else if (btnsave.Text == "Update")
{
sqlCon.ConnectionString = objsqlHelpingClass.strSqlConnection;
SqlCommand SqlCmd = new SqlCommand("sp_zonal_insertupdate", sqlCon);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.Add("@zonalid", SqlDbType.Int).Value = Convert.ToInt32(hidzonalID.Value);
SqlCmd.Parameters.Add("@name", SqlDbType.VarChar).Value = txtname.Text;
SqlCmd.Parameters.Add("@username", SqlDbType.VarChar).Value = txtusername.Text;
SqlCmd.Parameters.Add("@password", SqlDbType.VarChar).Value = txtpassword.Text;
SqlCmd.Parameters.Add("@gender", SqlDbType.VarChar).Value = ddlgender.Text;
SqlCmd.Parameters.Add("@gmail", SqlDbType.VarChar).Value = txtgmail.Text;
SqlCmd.Parameters.Add("@phoneno", SqlDbType.VarChar).Value = txtphoneno.Text;
SqlCmd.Parameters.Add("@qualification", SqlDbType.VarChar).Value = ddlqualification.Text;
SqlCmd.Parameters.Add("@certificate", SqlDbType.VarChar).Value = ddlcertificate.Text;
SqlCmd.Parameters.Add("@experience", SqlDbType.VarChar).Value = ddlexperience.Text;
SqlCmd.Parameters.Add("@category", SqlDbType.VarChar).Value = ddlcategory.Text;
SqlCmd.Parameters.Add("@zonal", SqlDbType.VarChar).Value = txtzonal.Text;
SqlCmd.Parameters.Add("@type", SqlDbType.Int).Value = 2;
sqlCon.Open();
int intRowAffected = SqlCmd.ExecuteNonQuery();
sqlCon.Close();
if (intRowAffected > 0)
{
//lblWarning.Text = "Zonal Manager Updated Successfully";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Zonal Manager Updated Successfully');</script>");
clearcontrol();
}
}
}
server side save and update funtion..