Asked By Chinnarasu Chinnarasu.M
21-Jun-11 07:25 AM
hi can anyone help me here what is going on..my dropdown list for caste and subcaste column loading as more than one duplicate value..
string strMid = "";
string id = "";
string body = "";
int i1;
string strComplexion = "";
string strname = "";
string strage = "";
string strdob = "";
string strgender = "";
string hr = "";
string min = "";
string am = "";
string strtimeofbirth = "";
string strplaceofbirth = "";
string strreligion = "";
string strmothertongue = "";
string strmaritalstatus = "";
string strnativity = "";
// string strhouse = "";
// string strstatusproperty = "";
string strfathername = "";
string strmothername = "";
string strfatherjob = "";
string strmotherjob = "";
string strfather = "";
string strmother = "";
string strmelderbrother = "";
string strmyoungerbrother = "";
string strmeldersister = "";
string strmyoungersister = "";
string strunelderbrother = "";
string strunyoungerbrother = "";
string struneldersister = "";
string strunyoungersister = "";
string strotherdetails = "";
string strqualification = "";
string strjob = "";
string strplaceofjob = "";
string strincome = "";
string strheight = "";
string strweight = "";
string strbloodgroup = "";
string strphysicalstatus = "";
string strdiet = "";
string strcaste = "";
string strsubcaste = "";
string strstar = "";
string strraasi = "";
string strpadam = "";
string strlaknam = "";
string strgothram = "";
string Dasa = "";
string Day = "";
string Month = "";
string Year = "";
string Rasi1 = "";
string Rasi2 = "";
string Rasi3 = "";
string Rasi4 = "";
string Rasi5 = "";
string Rasi6 = "";
string Rasi7 = "";
string Rasi8 = "";
string Rasi9 = "";
string Rasi10 = "";
string Rasi11 = "";
string Rasi12 = "";
string Amsam1 = "";
string Amsam2 = "";
string Amsam3 = "";
string Amsam4 = "";
string Amsam5 = "";
string Amsam6 = "";
string Amsam7 = "";
string Amsam8 = "";
string Amsam9 = "";
string Amsam10 = "";
string Amsam11 = "";
string Amsam12 = "";
string strpermanentaddress = "";
string strpresentaddress = "";
string strmobileno = "";
string strlandline = "";
string emailid = "";
string qualification = "";
string placeofjob = "";
string job = "";
string income = "";
string prefferedage1 = "";
string prefferedage2 = "";
string maritalstatus = "";
string caste = "";
string subcaste = "";
string star = "";
string raasi = "";
string comments = "";
string scheme = "";
string strcontactperson = "";
string diet = "";
string strminor = "";
string strPhoto1;
string strPhoto2;
string strphoto3;
string regmonth = "";
string expmonth = "";
string status = "";
int stAge;
string ephysicalstatus = "";
ArrayList acaste = new ArrayList();
ArrayList asubcaste = new ArrayList();
ArrayList amother = new ArrayList();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//System.Web.UI.HtmlControls.HtmlGenericControl meta = new System.Web.UI.HtmlControls.HtmlGenericControl("meta");
//meta.Attributes.Add("http-equiv", "Cache-Control");
//meta.Attributes.Add("content", "no-cache");
//// this.Page.Header.Controls.Add(meta);
//System.Web.UI.HtmlControls.HtmlGenericControl meta1 = new System.Web.UI.HtmlControls.HtmlGenericControl("meta");
//meta1.Attributes.Add("http-equiv", "Cache-Control");
//meta1.Attributes.Add("content", "must-revalidate");
// this.Page.Header.Controls.Add(meta1);
if (Session["username"] == null || Session["id"] == null)
{
Response.Redirect("login_public.aspx");
}
else if (Session["username"] != null || Session["id"] != null)
{
Btn_Go.Attributes.Add("OnClientClick", "javascript:return ValidateForm()");
string config = ConfigurationManager.ConnectionStrings["myDbCon"].ConnectionString;
SqlConnection conn = new SqlConnection(config);
conn.Open();
ArrayList RetrievedList1 = (ArrayList)Session["List"];
strMid = RetrievedList1[0].ToString();
if (!Page.IsPostBack)
{
acaste.Clear();
SqlCommand cmdedu = new SqlCommand("select distinct caste from tbl_mastercaste", conn);
SqlDataReader dredu = cmdedu.ExecuteReader();
while (dredu.Read())
{
for (int i = 0; dredu.VisibleFieldCount != i; i++)
{
acaste.Add(dredu[i].ToString());
}
}
dredu.Close();
asubcaste.Clear();
SqlCommand sub = new SqlCommand("select distinct subcaste from tbl_SubCasteMaster", conn);
SqlDataReader subrd = sub.ExecuteReader();
while (subrd.Read())
{
for (int i = 0; subrd.VisibleFieldCount != i; i++)
{
asubcaste.Add(subrd[i].ToString());
}
}
subrd.Close();
amother.Clear();
SqlCommand moth = new SqlCommand("select distinct mothertongue from tbl_mothertongue", conn);
SqlDataReader mothdr = moth.ExecuteReader();
while (mothdr.Read())
{
for (int i = 0; mothdr.VisibleFieldCount != i; i++)
{
amother.Add(mothdr[i].ToString());
}
}
mothdr.Close();
SqlCommand v = new SqlCommand("select mothertongue from tbl_mothertongue", conn);
SqlDataReader g1 = v.ExecuteReader();
// ddlcaste.Items.Add("select");
while (g1.Read())
{
ddlmothertongue.Items.Add(g1["mothertongue"].ToString());
}
g1.Close();
txtuname.Text = Session["username"].ToString();
txtuname.Text = Session["id"].ToString();
SqlCommand cmd = new SqlCommand("sp_EditView1", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlCommand c = new SqlCommand("select username from tbl_registration1 where id='" + txtuname.Text + "' or username='" + txtuname.Text + "'", conn);
SqlDataReader d = c.ExecuteReader();
while (d.Read())
{
strMid = d["username"].ToString();
}
d.Close();
cmd.Parameters.Add("username", strMid);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
txtName.Text = dr["name"].ToString();
if (dr[3].ToString() == "Male")
{
Radiomale.Checked = true;
}
else
{
Radiofemale.Checked = true;
}
if (dr["id"].ToString() != "")
{
Label51.Text = dr["id"].ToString();
}
if (dr["mothertongue"].ToString() != "")
{
string d1 = dr["mothertongue"].ToString();
if (amother.Contains(d1))
{
ddlmothertongue.SelectedValue = d1;
}
else
{
ddlmothertongue.SelectedValue = "Others";
txtmothertongue.Visible = true;
txtmothertongue.Text = d1;
}
}
txtplaceofbirth.Text = dr["placeofbirth"].ToString();
txtnativity.Text = dr["nativity"].ToString();
if (dr["maritalstatus"].ToString() == "UnMarried")
{
Radiomaritial1.Checked = true;
}
else if (dr["maritalstatus"].ToString() == "Married")
{
Radiomaritalmarried.Checked = true;
}
else if (dr["maritalstatus"].ToString() == "Widow/Widower")
{
Radiomaritial3.Checked = true;
}
else
{
Radiomaritaldivoce.Checked = true;
}
if (dr["physicalstatus"].ToString() != "" && dr["physicalstatus"].ToString() != "")
{
string value = dr["physicalstatus"].ToString();
char[] delimiters = new char[] { ' ' };
//char[] delimiters = new char[] {' ','(',')' };
string[] parts = value.Split(delimiters, StringSplitOptions.RemoveEmptyEntries);
string ss = dr["ephysicalstatus"].ToString();
if (dr["ephysicalstatus"].ToString() == "Physically challenged")
{
RadioPhysicallyChallenged.Checked = true;
txtphysicalstatus.Visible = true;
int cnt = parts.Length;
if (cnt > 1)
{
for (int i2 = 1; i2 < cnt; i2++)
{
txtphysicalstatus.Text += parts[i2].ToString() + " ";
}
//txtphysicalstatus.Text = parts[1].ToString();
}
}
}
if (dr["complexion"].ToString() != "")
{
if (dr["complexion"].ToString() == "Veryfair")
{
RadioVeryFair.Checked = true;
}
else if (dr["complexion"].ToString() == "Fair")
{
RadioFair.Checked = true;
}
else if (dr["complexion"].ToString() == "Wheatish")
{
RadioWheatish.Checked = true;
}
else if (dr["complexion"].ToString() == "wheatishBrown")
{
RadioWheatishbrown.Checked = true;
}
else if (dr["complexion"].ToString() == "dark")
{
RadioDark.Checked = true;
}
}
if (dr["timeofbirth"].ToString() != "")
{
string value = dr["timeofbirth"].ToString();
char[] delimiters = new char[] { ':' };
string[] parts = value.Split(delimiters, StringSplitOptions.RemoveEmptyEntries);
//for (int i = 0; i < parts.Length; i++)
//{
if (parts[0].ToString() != "")
{
DropDownList6.SelectedValue = parts[0].ToString();
}
if (parts[1].ToString() != "")
{
DropDownList7.SelectedValue = parts[1].ToString();
}
if (parts[2].ToString() != "")
{
DropDownList8.SelectedValue = parts[2].ToString();
}
//}
}
// txtstatusproperty.Text = dr[10].ToString();
txtfathername.Text = dr["fathername"].ToString();
txtmothername.Text = dr["mothername"].ToString();
if (dr["father"].ToString() == "Yes")
{
radiofatheralive.Checked = true;
}
if (dr["father"].ToString() == "No")
{
radiofathernotalive.Checked = true;
}
if (dr["mother"].ToString() == "Yes")
{
radiomotheralive.Checked = true;
}
else if (dr["mother"].ToString() == "No")
{
radiomothernotalive.Checked = true;
}
txtfatherjob.Text = dr["fatherjob"].ToString();
txtmotherjob.Text = dr["motherjob"].ToString();
if (dr["melderbrother"].ToString() != "")
{
string d2 = dr["melderbrother"].ToString();
ddlmelderbrother.Items.FindByText(d2).Selected = true;
}
if (dr["myoungerbrother"].ToString() != "")
{
string d3 = dr["myoungerbrother"].ToString();
ddlmyoungerbrother.Items.FindByText(d3).Selected = true;
}
if (dr["meldersister"].ToString() != "")
{
string d4 = dr["meldersister"].ToString();
ddlmeldersister.Items.FindByText(d4).Selected = true;
}
if (dr["myoungersister"].ToString() != "")
{
string d5 = dr["myoungersister"].ToString();
ddlmyoungersister.Items.FindByText(d5).Selected = true;
}
if (dr["unelderbrother"].ToString() != "")
{
string d6 = dr["unelderbrother"].ToString();
ddlunelderbrother.Items.FindByText(d6).Selected = true;
}
if (dr["unyoungerbrother"].ToString() != "")
{
string d7 = dr["unyoungerbrother"].ToString();
ddlunyoungerbrother.Items.FindByText(d7).Selected = true;
}
if (dr["uneldersister"].ToString() != "")
{
string d8 = dr["uneldersister"].ToString();
ddluneldersister.Items.FindByText(d8).Selected = true;
}
if (dr["unyoungersister"].ToString() != "")
{
string d9 = dr["unyoungersister"].ToString();
ddlunyoungersister.Items.FindByText(d9).Selected = true;
}
txtotherdetails.Text = dr["otherdetails"].ToString();
if (dr["height"].ToString() != "")
{
string d10 = dr["height"].ToString();
ddlheight.Items.FindByText(d10).Selected = true;
}
if (dr["weight"].ToString() != "")
{
string d11 = dr["weight"].ToString();
ddlweight.Items.FindByText(d11).Selected = true;
}
if (dr["bloodgroup"].ToString() != "")
{
string d12 = dr["bloodgroup"].ToString();
ddlbloodgroup.Items.FindByText(d12).Selected = true;
}
if (dr["diet"].ToString() == "Vegetarian")
{
RadioVegetarian.Checked = true;
}
else if (dr["diet"].ToString() == "Non-Vegetarian")
{
RadioNonVeg.Checked = true;
}
else if (dr["diet"].ToString() == "Eggetarian")
{
RadioEggetarian.Checked = true;
}
if (dr["photo2"].ToString() != "")
{
}
if (dr["ephysicalstatus"].ToString() != "")
{
if (dr["ephysicalstatus"].ToString() == "Normal")
{
RadioNormal.Checked = true;
}
else if (dr["ephysicalstatus"].ToString() == "Physically challenged")
{
RadioPhysicallyChallenged.Checked = true;
}
}
txtqualification.Text = dr["qualification"].ToString();
txtjob.Text = dr["job"].ToString();
txtplaceofjob.Text = dr["placeofjob"].ToString();
txtincome.Text = dr["income"].ToString();
if (dr["caste"].ToString() != "")
{
string d14 = dr["caste"].ToString();
if (acaste.Contains(d14))
{
ddlcaste.SelectedValue = d14;
// ddlcaste.Items.FindByText(d14).Selected = true;
}
else
{
//ddlcaste.SelectedValue = "Others";
//string cs = "Others";
//ddlcaste.Items.FindByValue(cs).Selected = true;
ddlcaste.SelectedValue = "Others";
txtcaste.Visible = true;
txtcaste.Text = d14;
}
}
if (dr["subcaste"].ToString() != "")
{
string d15 = dr["subcaste"].ToString();
if (asubcaste.Contains(d15))
{
ddlsubcaste.SelectedValue = d15;
}
else
{
ddlsubcaste.SelectedValue = "Others";
txtsubcaste.Visible = true;
txtsubcaste.Text = d15;
}
}
txtgothram.Text = dr["gothram"].ToString();
if (dr["star"].ToString() != "")
{
string d16 = dr["star"].ToString();
ddlStar.Items.FindByText(d16).Selected = true;
}
if (dr["raasi"].ToString() != "")
{
string d17 = dr["raasi"].ToString();
ddlRaasiSign.Items.FindByText(d17).Selected = true;
}
if (dr["padam"].ToString() != "")
{
string d18 = dr["padam"].ToString();
ddlLaknamNO.Items.FindByText(d18).Selected = true;
}
if (dr["laknam"].ToString() != "")
{
string d19 = dr["laknam"].ToString();
ddlLaknam.Items.FindByText(d19).Selected = true;
}
if (dr["p_job"].ToString() == "Must")
{
Radiomust.Checked = true;
}
else if (dr["p_job"].ToString() == "Optional")
{
Radiooptional.Checked = true;
}
else if (dr["p_job"].ToString() == "Not Required")
{
Radionotrequired.Checked = true;
}
txtincome1.Text = dr["p_income"].ToString();
if (dr["p_age1"].ToString() != "")
{
string d21 = dr["p_age1"].ToString();
ddlPreferredAgeFrom.Items.FindByText(d21).Selected = true;
}
if (dr["p_age2"].ToString() != "")
{
string d22 = dr["p_age2"].ToString();
ddlPreferredAgeTo.Items.FindByText(d22).Selected = true;
}
if (dr["p_maritalstatus"].ToString() == "UnMarried,Married,Divoce,Widow/Widower")
{
chkUnmarried.Checked = true;
chkmarried.Checked = true;
chkDivorced.Checked = true;
chkWidow.Checked = true;
}
if (dr["p_maritalstatus"].ToString() == "UnMarried,Divoce,Widow/Widower")
{
chkUnmarried.Checked = true;
chkDivorced.Checked = true;
chkWidow.Checked = true;
}
else if (dr["p_maritalstatus"].ToString() == "UnMarried,Divoce")
{
chkUnmarried.Checked = true;
chkDivorced.Checked = true;
}
else if (dr["p_maritalstatus"].ToString() == "UnMarried,Widow/Widower")
{
chkUnmarried.Checked = true;
chkWidow.Checked = true;
}
else if (dr["p_maritalstatus"].ToString() == "Married,Divoce")
{
chkmarried.Checked = true;
chkDivorced.Checked = true;
}
else if (dr["p_maritalstatus"].ToString() == "Married,Widow/Widower")
{
chkmarried.Checked = true;
chkWidow.Checked = true;
}
else if (dr["p_maritalstatus"].ToString() == "Divoce,Widow/Widower")
{
chkDivorced.Checked = true;
chkWidow.Checked = true;
}
else if (dr["p_maritalstatus"].ToString() == "Divoce,Married")
{
chkDivorced.Checked = true;
chkmarried.Checked = true;
}
else if (dr["p_maritalstatus"].ToString() == "UnMarried")
{
chkUnmarried.Checked = true;
}
else if (dr["p_maritalstatus"].ToString() == "Married")
{
chkmarried.Checked = true;
}
else if (dr["p_maritalstatus"].ToString() == "Divoce")
{
chkDivorced.Checked = true;
}
else if (dr["p_maritalstatus"].ToString() == "Widow/Widower")
{
chkWidow.Checked = true;
}
else if (dr["p_maritalstatus"].ToString() == "Doesn't Matter")
{
chkdoesntmatter.Checked = true;
}
if (dr["p_diet"].ToString() == "Vegetarian,Non vegetarian,Eggetarian")
{
chkvegetarian.Checked = true;
chknonveg.Checked = true;
chkeggetarian.Checked = true;
}
else
if (dr["p_diet"].ToString() == "Vegetarian")
{
chkvegetarian.Checked = true;
}
else if (dr["p_diet"].ToString() == "Vegetarian,Non vegetarian")
{
chkvegetarian.Checked = true;
chknonveg.Checked = true;
}
else if (dr["p_diet"].ToString() == "Vegetarian,Eggetarian")
{
chkvegetarian.Checked = true;
chkeggetarian.Checked = true;
}
else if (dr["p_diet"].ToString() == "Non vegetarian,Eggetarian")
{
chknonveg.Checked = true;
chkeggetarian.Checked = true;
}
else if (dr["p_diet"].ToString() == "Eggetarian")
{
chkeggetarian.Checked = true;
}
else if (dr["p_diet"].ToString() == "Non vegetarian")
{
chknonveg.Checked = true;
}
else if (dr[81].ToString() == "Eggetarian")
{
chkeggetarian.Checked = true;
}
else if (dr["p_diet"].ToString() == "Doesn't Matter")
{
chkdoes.Checked = true;
}
if (dr["p_minordisability"].ToString() == "Yes")
{
radiominoryes.Checked = true;
}
else if (dr["p_minordisability"].ToString() == "No")
{
radiominorno.Checked = true;
}
if (dr["p_caste"].ToString() != "")
{
string d23 = dr["p_caste"].ToString();
if (acaste.Contains(d23))
{
DropDownList18.SelectedValue = d23;
}
else
{
DropDownList18.SelectedValue = "Others";
txtpcaste.Visible = true;
txtpcaste.Text = d23;
}
}
if (dr["p_subcaste"].ToString() != "")
{
string d24 = dr["p_subcaste"].ToString();
if (asubcaste.Contains(d24))
{
DropDownList19.SelectedValue = d24;
}
else
{
DropDownList19.SelectedValue = "Others";
txtpsubcaste.Visible = true;
txtpsubcaste.Text = d24;
}
}
if (dr["p_star"].ToString() != "")
{
string d25 = dr["p_star"].ToString();
//DropDownList1.Items.FindByText(d25).Selected = true;
}
if (dr["p_raasi"].ToString() != "")
{
string d26 = dr["p_raasi"].ToString();
//DropDownList2.Items.FindByText(d26).Selected = true;
}
TextBox15.Text = dr["otherexceptations"].ToString();
if (dr["scheme"].ToString() != "")
{
// DropDownList20.SelectedItem.Text = dr["scheme"].ToString();
string d24 = dr["scheme"].ToString();
DropDownList20.Items.FindByText(d24).Selected = true;
scem.Text = dr["scheme"].ToString();
}
if (dr["status"].ToString() != "")
{
string d19 = dr["status"].ToString();
DropDownList21.Items.FindByText(d19).Selected = true;
}
strPhoto1 = dr["photo"].ToString();
strphoto3 = dr["photo2"].ToString();
//FileUpload3.
calendar1_container.Text = dr["dob"].ToString();
calendar2_container.Text = dr["regmonth"].ToString();
calendar3_container.Text = dr["expmonth"].ToString();
Label47.Text = dr["username"].ToString();
Label48.Text = dr["password"].ToString();
string img1;
string img2;
img1 = dr["photo"].ToString();
img2 = dr["photo2"].ToString();
if (img1.ToString() != "")
{
//prevImage.ImageUrl = "~/photos/" + dr["photo"].ToString();
prevImage.ImageUrl = "~/photos/" + dr["photo"].ToString() + "?t=" + DateTime.Now.Ticks.ToString();
Image1.ImageUrl = "~/photos/" + dr["photo"].ToString() + "?t=" + DateTime.Now.Ticks.ToString();
}
if (img2.ToString() != "")
{
//ImageButton2.ImageUrl = "~/photos/" + dr["photo2"].ToString();
ImageButton2.ImageUrl = "~/photos/" + dr["photo2"].ToString() + "?t=" + DateTime.Now.Ticks.ToString();
Image2.ImageUrl = "~/photos/" + dr["photo2"].ToString() + "?t=" + DateTime.Now.Ticks.ToString();
}