string connectionString1 = "server=(local); user=sa;password=sa;
database=sonic";
System.Data.SqlClient.SqlConnection dbConnection1 = new
System.Data.SqlClient.SqlConnection(connectionStri ng1);
System.Data.SqlClient.SqlCommand dbCommand1 = new
System.Data.SqlClient.SqlCommand();
string sql="Select * From Student_SDS Where SSN='" + Session["SSN"] +
"'";
dbCommand1 = new SqlCommand (sql, dbConnection1);
dbConnection1.Open();
SqlDataReader dr = dbCommand1.ExecuteReader();
dr.Read();
LName.Text = Convert.ToString(dr["LName"]);
FName.Text= Convert.ToString(dr["FName"]);
MName.Text= Convert.ToString(dr["MName"]);
LocalAddress.Text= Convert.ToString(dr["LocalAddress"]);
Lcity.Text=Convert.ToString(dr["Lcity"]);
Lzip.Text=Convert.ToString(dr["Lzip"]);
BirthDate.Text=Convert.ToString(dr["BirthDate"]);
SchoolName.Text=Convert.ToString(dr["SchoolName"]);
SchoolOrigin.Text=Convert.ToString(dr["SchoolOrigin"]);
AGraduationDate.Text=Convert.ToString(dr["AGraduationDate"]);
Lstate.DataSource=dr;
Lstate.DataTextField="Lstate";
Lstate.DataBind();
USCitizen.DataSource=dr;
USCitizen.DataTextField="USCitizen";
USCitizen.DataBind();
SClassification.DataSource=dr;
SClassification.DataTextField="SClassification";
SClassification.DataBind();
SchoolState.DataSource=dr;
SchoolState.DataTextField="SchoolState";
SchoolState.DataBind();
SDSApplied.DataSource=dr;
SDSApplied.DataTextField="SDSApplied";
SDSApplied.DataBind();
LoanApplied.DataSource=dr;
LoanApplied.DataSource="LoanApplied";
LoanApplied.DataBind();
NursProg.DataSource=dr;
NursProg.DataTextField="NursProg";
NursProg.DataBind();
ProgType.DataSource=dr;
ProgType.DataTextField="ProgType";
ProgType.DataBind();
AwardWilling.DataSource=dr;
AwardWilling.DataTextField="AwardWilling";
AwardWilling.DataBind();
StayType.DataSource=dr;
StayType.DataTextField="StayType";
StayType.DataBind();
ParentGrad.DataSource=dr;
ParentGrad.DataTextField="ParentGrad";
ParentGrad.DataBind();
FirstStudy.DataSource=dr;
FirstStudy.DataTextField="FirstStudy";
FirstStudy.DataBind();
EnrollmentType.DataSource=dr;
EnrollmentType.DataTextField="EnrollmentType";
EnrollmentType.DataBind();
EnrollmentTerm.DataSource=dr;
EnrollmentTerm.DataTextField="EnrollmentTerm";
EnrollmentTerm.DataBind();
HoldVisa.DataSource=dr;
HoldVisa.DataMember="HoldVisa";
HoldVisa.DataTextField="HoldVisa";
HoldVisa.DataBind();
dr.Close();
dbConnection1.Close();
Well Here this code was for when PAGE LOAD.
Well The desired data was being Binded to the TEXT BOXES but.... THE DROP
DOWN LIST BOXES arent displaying anything... I donot know what the error
is. I wish some one could help me solve this or point the Error Out.
Well and the --------- code of each Drop DOwn List Boxes Initially designed
as........
WELL BELOW IS THE ASP DROP DOWN LIST CODE..... WHEN INITIALLY DESIGNED THIS
FORM.
I JUST WANT TO KNOW WHY THE DATA IS NOT BEING DISPLAYED BY THE ... DROP
DOWN LIST BOXES.
PLEASE HELP ME OUT.
WELL ONE MORE THING IS THAT---- THE TEXT AND THE VALUE ARE THE SAME -----
FOR THE DROP DOWN LIST ITEMS.
LIKE FOR THE NAME --- ARKANSAS> the VALUE WAS ALSO SET TO ARKANSAS.
SO I donot know how to retrieve the data in the database and to bind to
these controls.
Initially when the user fills the data from the drop down lists is added
into the database and when he second time comes in for editing the data, I
wish to show him the items he chose, I was successful in Binding the data
to ... TEXTBOXES but not to these Drop Down List Boxes.
SOME ONE PLEASE HELP ME OUT.
THANKS AND REGARDS>
WAITING FOR AN EARLY RESPONSE>
viggi.
<asp:dropdownlist id="SchoolState" style="Z-INDEX: 159; LEFT: 504px;
POSITION: absolute; TOP: 536px"
tabIndex="15" runat="server" BackColor="Gold" Width="120px">
<asp:ListItem Selected="True"></asp:ListItem>
<asp:ListItem Value="Alabama">Alabama</asp:ListItem>
<asp:ListItem Value="Alaska ">Alaska </asp:ListItem>
<asp:ListItem Value="Arizona ">Arizona </asp:ListItem>
<asp:ListItem Value="Arkansas ">Arkansas </asp:ListItem>
<asp:ListItem Value="California ">California </asp:ListItem>
<asp:ListItem Value="Colorado ">Colorado </asp:ListItem>
<asp:ListItem Value=" Connecticut "> Connecticut </asp:ListItem>
<asp:ListItem Value="Delaware ">Delaware </asp:ListItem>
<asp:ListItem Value="Florida ">Florida </asp:ListItem>
<asp:ListItem Value="Georgia ">Georgia </asp:ListItem>
<asp:ListItem Value="Hawaii ">Hawaii </asp:ListItem>
<asp:ListItem Value="Idaho ">Idaho </asp:ListItem>
<asp:ListItem Value="Illinois ">Illinois </asp:ListItem>
<asp:ListItem Value="Indiana ">Indiana </asp:ListItem>
<asp:ListItem Value="Iowa ">Iowa </asp:ListItem>
<asp:ListItem Value="Kansas ">Kansas </asp:ListItem>
<asp:ListItem Value="Kentucky ">Kentucky </asp:ListItem>
<asp:ListItem Value="Louisiana">Louisiana</asp:ListItem>
<asp:ListItem Value="Maine ">Maine </asp:ListItem>
<asp:ListItem Value="Maryland ">Maryland </asp:ListItem>
<asp:ListItem Value="Massachusetts ">Massachusetts </asp:ListItem>
<asp:ListItem Value="Michigan ">Michigan </asp:ListItem>
<asp:ListItem Value="Minnesota ">Minnesota </asp:ListItem>
<asp:ListItem Value="Mississippi ">Mississippi </asp:ListItem>
<asp:ListItem Value="Missouri ">Missouri </asp:ListItem>
<asp:ListItem Value="Montana ">Montana </asp:ListItem>
<asp:ListItem Value="Nebraska ">Nebraska </asp:ListItem>
<asp:ListItem Value="Nevada">Nevada</asp:ListItem>
<asp:ListItem Value="New Hampshire ">New Hampshire </asp:ListItem>
<asp:ListItem Value="New Jersey ">New Jersey </asp:ListItem>
<asp:ListItem Value="New Mexico ">New Mexico </asp:ListItem>
<asp:ListItem Value="New York">New York</asp:ListItem>
<asp:ListItem Value="North Carolina ">North Carolina </asp:ListItem>
<asp:ListItem Value="North Dakota ">North Dakota </asp:ListItem>
<asp:ListItem Value="Ohio ">Ohio </asp:ListItem>
<asp:ListItem Value="Oklahoma">Oklahoma</asp:ListItem>
<asp:ListItem Value="Oregon ">Oregon </asp:ListItem>
<asp:ListItem Value="Pennsylvania ">Pennsylvania </asp:ListItem>
<asp:ListItem Value="Rhode Island ">Rhode Island </asp:ListItem>
<asp:ListItem Value="South Carolina ">South Carolina </asp:ListItem>
<asp:ListItem Value="South Dakota ">South Dakota </asp:ListItem>
<asp:ListItem Value="Tennessee ">Tennessee </asp:ListItem>
<asp:ListItem Value="Texas ">Texas </asp:ListItem>
<asp:ListItem Value="Utah ">Utah </asp:ListItem>
<asp:ListItem Value="Vermont">Vermont</asp:ListItem>
<asp:ListItem Value="Virginia ">Virginia </asp:ListItem>
<asp:ListItem Value="Washington ">Washington </asp:ListItem>
<asp:ListItem Value="West Virginia ">West Virginia </asp:ListItem>
<asp:ListItem Value="Wisconsin ">Wisconsin </asp:ListItem>
<asp:ListItem Value="Wyoming ">Wyoming </asp:ListItem>
<asp:ListItem Value="Other">Other</asp:ListItem>
</asp:dropdownlist><asp:textbox id="AGraduationDate" style="Z-INDEX:
127; LEFT: 368px; POSITION: absolute; TOP: 488px"
tabIndex="13" runat="server" BackColor="Gold"
BorderColor="Gold"></asp:textbox><asp:dropdownlist id="Lstate" style="Z-
INDEX: 125; LEFT: 168px; POSITION: absolute; TOP: 312px" tabIndex="7"
runat="server" CssClass="gold" BackColor="Gold" Width="120px">
<asp:ListItem Value="Alabama">Alabama</asp:ListItem>
<asp:ListItem Value="Alaska ">Alaska </asp:ListItem>
<asp:ListItem Value="Arizona ">Arizona </asp:ListItem>
<asp:ListItem Value="Arkansas ">Arkansas </asp:ListItem>
<asp:ListItem Value="California ">California </asp:ListItem>
<asp:ListItem Value="Colorado ">Colorado </asp:ListItem>
<asp:ListItem Value=" Connecticut "> Connecticut </asp:ListItem>
<asp:ListItem Value="Delaware ">Delaware </asp:ListItem>
<asp:ListItem Value="Florida ">Florida </asp:ListItem>
<asp:ListItem Value="Georgia ">Georgia </asp:ListItem>
<asp:ListItem Value="Hawaii ">Hawaii </asp:ListItem>
<asp:ListItem Value="Idaho ">Idaho </asp:ListItem>
<asp:ListItem Value="Illinois ">Illinois </asp:ListItem>
<asp:ListItem Value="Indiana ">Indiana </asp:ListItem>
<asp:ListItem Value="Iowa ">Iowa </asp:ListItem>
<asp:ListItem Value="Kansas ">Kansas </asp:ListItem>
<asp:ListItem Value="Kentucky ">Kentucky </asp:ListItem>
<asp:ListItem Value="Louisiana">Louisiana</asp:ListItem>
<asp:ListItem Value="Maine ">Maine </asp:ListItem>
<asp:ListItem Value="Maryland ">Maryland </asp:ListItem>
<asp:ListItem Value="Massachusetts ">Massachusetts </asp:ListItem>
<asp:ListItem Value="Michigan ">Michigan </asp:ListItem>
<asp:ListItem Value="Minnesota ">Minnesota </asp:ListItem>
<asp:ListItem Value="Mississippi ">Mississippi </asp:ListItem>
<asp:ListItem Value="Missouri ">Missouri </asp:ListItem>
<asp:ListItem Value="Montana ">Montana </asp:ListItem>
<asp:ListItem Value="Nebraska ">Nebraska </asp:ListItem>
<asp:ListItem Value="Nevada">Nevada</asp:ListItem>
<asp:ListItem Value="New Hampshire ">New Hampshire </asp:ListItem>
<asp:ListItem Value="New Jersey ">New Jersey </asp:ListItem>
<asp:ListItem Value="New Mexico ">New Mexico </asp:ListItem>
<asp:ListItem Value="New York">New York</asp:ListItem>
<asp:ListItem Value="North Carolina ">North Carolina </asp:ListItem>
<asp:ListItem Value="North Dakota ">North Dakota </asp:ListItem>
<asp:ListItem Value="Ohio ">Ohio </asp:ListItem>
<asp:ListItem Value="Oklahoma">Oklahoma</asp:ListItem>
<asp:ListItem Value="Oregon ">Oregon </asp:ListItem>
<asp:ListItem Value="Pennsylvania ">Pennsylvania </asp:ListItem>
<asp:ListItem Value="Rhode Island ">Rhode Island </asp:ListItem>
<asp:ListItem Value="South Carolina ">South Carolina </asp:ListItem>
<asp:ListItem Value="South Dakota ">South Dakota </asp:ListItem>
<asp:ListItem Value="Tennessee ">Tennessee </asp:ListItem>
<asp:ListItem Value="Texas ">Texas </asp:ListItem>
<asp:ListItem Value="Utah ">Utah </asp:ListItem>
<asp:ListItem Value="Vermont">Vermont</asp:ListItem>
<asp:ListItem Value="Virginia ">Virginia </asp:ListItem>
<asp:ListItem Value="Washington ">Washington </asp:ListItem>
<asp:ListItem Value="West Virginia ">West Virginia </asp:ListItem>
<asp:ListItem Value="Wisconsin ">Wisconsin </asp:ListItem>
<asp:ListItem Value="Wyoming ">Wyoming </asp:ListItem>
<asp:ListItem Selected="True"></asp:ListItem>
</asp:dropdownlist><asp:dropdownlist id="SClassification" style="Z-
INDEX: 124; LEFT: 320px; POSITION: absolute; TOP: 448px"
tabIndex="12" runat="server" BackColor="Gold" Width="160px">
<asp:ListItem Selected="True"></asp:ListItem>
<asp:ListItem Value="Sophomore">Sophomore</asp:ListItem>
<asp:ListItem Value="Junior">Junior</asp:ListItem>
<asp:ListItem Value="Senior">Senior</asp:ListItem>
<asp:ListItem Value="Graduating Senior">Graduating Senior</asp:ListItem>
</asp:dropdownlist><asp:dropdownlist id="HoldVisa" style="Z-INDEX: 122;
LEFT: 392px; POSITION: absolute; TOP: 408px"
tabIndex="11" runat="server" BackColor="Gold">
<asp:ListItem Selected="True"></asp:ListItem>
<asp:ListItem Value="Yes">Yes</asp:ListItem>
<asp:ListItem Value="No">No</asp:ListItem>
</asp:dropdownlist><asp:label id="Label12" style="Z-INDEX: 121; LEFT:
120px; POSITION: absolute; TOP: 408px" runat="server"
CssClass="GoldNormalFont" Width="258px">Do you currently hold a student
visa?</asp:label><asp:dropdownlist id="USCitizen" style="Z-INDEX: 120;
LEFT: 496px; POSITION: absolute; TOP: 352px"
tabIndex="10" runat="server" BackColor="Gold" Width="88px">
<asp:ListItem Selected="True"></asp:ListItem>
<asp:ListItem Value="yes">yes</asp:ListIte
--
Message posted via http://www.dotnetmonster.com