Please Help
I want to Validate Drop Down List and Submit Form but it doesn't doing
The form gets submitted with out validating the form
and please select state and please select city gets stored in database
New Employee Registeration Form.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPageHeaderFooter.master" AutoEventWireup="true" CodeFile="New Employee Registeration Form.aspx.cs" Inherits="_Default" %>
New Employee Registeration Form. | ||
Your Full Name : | ||
Gender : | ||
Email Address : | ||
Mobile Number : | ||
Address : | ||
State : | ||
City of Resident : | ||
Pin Code : | ||
Upload Your Image : | ||
Upload Your Resume : | ||
| | ||
New Employee Registeration Form.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DropDownListNewEmployeeRegisterationFormStates.DataSource = GetData("spAllStatesDetails", null);
DropDownListNewEmployeeRegisterationFormStates.DataBind();
ListItem StateSelectPrompt = new ListItem("Please Select State", "-1");
StateSelectPrompt.Selected = true;
DropDownListNewEmployeeRegisterationFormStates.Items.Insert(0, StateSelectPrompt);
ListItem CitySelectPrompt = new ListItem("Please Select City", "-1");
CitySelectPrompt.Selected = true;
DropDownListNewEmployeeRegisterationFormCity.Items.Insert(0, CitySelectPrompt);
DropDownListNewEmployeeRegisterationFormCity.Enabled = false;
}
LabelNewEmployeeRegisterationFormGender.Text = string.Empty;
RadioButtonNewEmployeeRegisterationFormTermsandCondition.Checked = true;
LabelNewEmployeeRegisterationFormImageUploadMessage1.Text = string.Empty;
LabelNewEmployeeRegisterationFormImageUploadMessage2.Text = string.Empty;
LabelNewEmployeeRegisterationFormResumeUploadMessage1.Text = string.Empty;
LabelNewEmployeeRegisterationFormResumeUploadMessage2.Text = string.Empty;
}
private DataSet GetData(string ParameterStates,SqlParameter ParameterCity)
{
string CSCity = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection Con = new SqlConnection(CSCity);
SqlDataAdapter DA = new SqlDataAdapter(ParameterStates, Con);
DA.SelectCommand.CommandType = CommandType.StoredProcedure;
if (ParameterCity != null)
{
DA.SelectCommand.Parameters.Add(ParameterCity);
}
DataSet DS = new DataSet();
DA.Fill(DS);
return DS;
}
protected void ButtonNewEmployeeRegisterationFormSubmit_Click(object sender, EventArgs e)
{
String InsertData = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection Con = new SqlConnection(InsertData))
{
SqlCommand Cmd = new SqlCommand("spNewEmployeeDataInsertion", Con);
Cmd.CommandType = System.Data.CommandType.StoredProcedure;
Cmd.Parameters.AddWithValue("@NewEmployeeFirstName", TextBoxNewEmployeeRegisterationFormFirstName.Text);
Cmd.Parameters.AddWithValue("@NewEmployeeMiddleName", TextBoxNewEmployeeRegisterationFormMiddleName.Text);
Cmd.Parameters.AddWithValue("@NewEmployeeLastName", TextBoxNewEmployeeRegisterationFormLastName.Text);
Cmd.Parameters.AddWithValue("@NewEmployeeGender", DropDownListNewEmployeeGender.SelectedValue);
Cmd.Parameters.AddWithValue("@NewEmployeeEmailAddress", TextBoxNewEmployeeRegisterationFormEmailAddress.Text);
Cmd.Parameters.AddWithValue("@NewEmployeeMobileNumber", Convert.ToInt64(TextBoxNewEmployeeRegisterationFormMobileNumber.Text));
Cmd.Parameters.AddWithValue("@NewEmployeeAddress", TextBoxNewEmployeeRegisterationFormAddress.Text);
Cmd.Parameters.AddWithValue("@NewEmployeeState", DropDownListNewEmployeeRegisterationFormStates.SelectedItem.Text);
Cmd.Parameters.AddWithValue("@NewEmployeeCity", DropDownListNewEmployeeRegisterationFormCity.SelectedItem.Text);
Cmd.Parameters.AddWithValue("@NewEmployeePinCode", TextBoxNewEmployeeRegisterationFormPinCode.Text);
SqlParameter EmployeeIDParameter = new SqlParameter();
EmployeeIDParameter.ParameterName = "@EmployeeID";
EmployeeIDParameter.SqlDbType = System.Data.SqlDbType.Int;
EmployeeIDParameter.Direction = System.Data.ParameterDirection.Output;
Cmd.Parameters.Add(EmployeeIDParameter);
Con.Open();
Cmd.ExecuteNonQuery();
}
}
protected void RadioButtonNewEmployeeRegisterationFormTermsandCondition_CheckedChanged(object sender, EventArgs e)
{
if (RadioButtonNewEmployeeRegisterationFormTermsandCondition.Checked==false)
{
LabelNewEmployeeRegisterationFormTermsandCondition.Text = "Please Select the Terms and Conditions.";
}
}
protected void ButtonNewEmployeeRegisterationFormImageUpload_Click(object sender, EventArgs e)
{
if (FileUploadNewEmployeeRegisterationFormImageUpload.HasFile)
{
String ImageExtension = System.IO.Path.GetExtension(FileUploadNewEmployeeRegisterationFormImageUpload.FileName);
if (ImageExtension.ToLower() != ".png" && ImageExtension.ToLower() != ".jpg" && ImageExtension.ToLower() != ".jpeg")
{
LabelNewEmployeeRegisterationFormImageUploadMessage1.Text = "Only .png or .jpg or .jpeg Files are Accepted.";
LabelNewEmployeeRegisterationFormImageUploadMessage1.ForeColor = System.Drawing.Color.Red;
}
else
{
int ImageSize = FileUploadNewEmployeeRegisterationFormImageUpload.PostedFile.ContentLength;
if (ImageSize > 2097152)
{
LabelNewEmployeeRegisterationFormImageUploadMessage1.Text = "ImageFile Size Should bee less Than 512 KB.";
LabelNewEmployeeRegisterationFormImageUploadMessage1.ForeColor = System.Drawing.Color.Red;
}
else
{
FileUploadNewEmployeeRegisterationFormImageUpload.SaveAs(Server.MapPath("~/New Employee/Upload/Images/" + FileUploadNewEmployeeRegisterationFormImageUpload.FileName));
LabelNewEmployeeRegisterationFormImageUploadMessage2.Text = "Image File Uploaded";
LabelNewEmployeeRegisterationFormImageUploadMessage2.ForeColor = System.Drawing.Color.Green;
}
}
}
else
{
LabelNewEmployeeRegisterationFormImageUploadMessage1.Text = "Please Select Image File to Upload";
LabelNewEmployeeRegisterationFormImageUploadMessage1.ForeColor = System.Drawing.Color.Red;
}
}
protected void ButtonNewEmployeeRegisterationFormResumeUpload_Click(object sender, EventArgs e)
{
if (FileUploadNewEmployeeRegisterationFormResumeUpload.HasFile)
{
String ResumeExtension = System.IO.Path.GetExtension(FileUploadNewEmployeeRegisterationFormResumeUpload.FileName);
if (ResumeExtension.ToLower() != ".doc" && ResumeExtension.ToLower() != ".docx" )
{
LabelNewEmployeeRegisterationFormResumeUploadMessage1.Text = "Only .doc or .docx or .jpeg Files are Accepted.";
LabelNewEmployeeRegisterationFormResumeUploadMessage1.ForeColor = System.Drawing.Color.Red;
}
else
{
int ResumeSize = FileUploadNewEmployeeRegisterationFormResumeUpload.PostedFile.ContentLength;
if (ResumeSize > 2097152)
{
LabelNewEmployeeRegisterationFormResumeUploadMessage1.Text = "Resume File Size Should bee less Than 2 MB.";
LabelNewEmployeeRegisterationFormResumeUploadMessage1.ForeColor = System.Drawing.Color.Red;
}
else
{
FileUploadNewEmployeeRegisterationFormResumeUpload.SaveAs(Server.MapPath("~/New Employee/Upload/Resumes/" + FileUploadNewEmployeeRegisterationFormResumeUpload.FileName));
LabelNewEmployeeRegisterationFormResumeUploadMessage2.Text = "Resume File Uploaded";
LabelNewEmployeeRegisterationFormResumeUploadMessage2.ForeColor = System.Drawing.Color.Green;
}
}
}
else
{
LabelNewEmployeeRegisterationFormResumeUploadMessage1.Text = "Please Select Resume File to Upload";
LabelNewEmployeeRegisterationFormResumeUploadMessage1.ForeColor = System.Drawing.Color.Red;
}
}
protected void DropDownListNewEmployeeRegisterationFormStates_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownListNewEmployeeRegisterationFormStates.SelectedIndex==0)
{
ListItem CitySelectPrompt = new ListItem("Please Select City", "-1");
DropDownListNewEmployeeRegisterationFormCity.Items.Insert(0, CitySelectPrompt);
DropDownListNewEmployeeRegisterationFormCity.Enabled = false;
}
else
{
DropDownListNewEmployeeRegisterationFormCity.Enabled = true;
SqlParameter GetParameter = new SqlParameter("@StateID",DropDownListNewEmployeeRegisterationFormStates.SelectedValue);
DataSet DSCity = GetData("spAllCityDetails", GetParameter);
DropDownListNewEmployeeRegisterationFormCity.DataSource = DSCity;
DropDownListNewEmployeeRegisterationFormCity.DataBind();
ListItem CitySelectPrompt = new ListItem("Please Select City...", "-1");
DropDownListNewEmployeeRegisterationFormCity.Items.Insert(0, CitySelectPrompt);
}
}
protected void DropDownListNewEmployeeRegisterationFormCity_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
}
}
Joginder BangerPosted Mar 24, 2014, 7:38 AM
use the validation control. try this type
when you are press the form submit button then message show select your state plz.
Note in Button coding add the same validation group other wise same error you will show.
for any query hit to reply
jsb