Hi All
I have 2 DropDownList boxes on a page.
The first (id= "Operation" ) is populated on PageLoad with the contents
of a database table.
The second id="WorkStation s" will not be populated until the first has
been changed
The definitions are below.
<ASP:DropDownLi st id="Operation"
runat="server"
AppendDataBound Items="True"
AutoPostBack="T rue"
OnSelectedIndex Changed="Operat ion_SelectedInd exChanged">
</ASP:DropDownLis t>
<ASP:DropDownLi st id="WorkStation s"
runat="server"
AppendDataBound Items="True"
AutoPostBack="T rue"
OnSelectedIndex Changed="WorkSt ations_Selected IndexChanged">
</ASP:DropDownLis t>
..
Both events fire successfully - on every item change.
When I change the Operation box it fires correctly and the WorkStations
box is populated correctly. However when I select an item in the
WorkStations box none of the items are listed as Selected in the event
handler. The event fires - I am using Delphi Developer Studio 2006 to
develop and I have debugged the event handler - and the dropdownlist
box is being picked up.
The 2 event handlers are
protected void Operation_Selec tedIndexChanged (object sender, EventArgs
e)
{
OleDbConnection conoper = new OleDbConnection ("provider=IBMD A400;Data
Source=xx.xxx.x x.xxx;User Id=xxxxxxx;pass word=xxxxxxxxxx ");
OleDbCommand cmdoper = new OleDbCommand();
string LString;
foreach(ListIte m item in Operation.Items ) // This is dropdownlist
box 1
{
if(item.Selecte d)
{
if (item.Value == "Please Select An Operation")
{
LString = "<script language=JavaSc ript>alert('No Operation Selected.
\n Please Select An Operation');</script>";
RegisterStartup Script("startup Script", LString);
}
else
{
LString = "<script language=JavaSc ript>alert('" + item.Value +
"');</script>";
conoper.Open();
cmdoper.Connect ion = conoper;
cmdoper.Command Type = CommandType.Tex t;
LString = "select * from WRKINSTRUC.WORK STATN Where OPERNAME = '" +
item.Value + "'";
cmdoper.Command Text = LString;
OleDbDataReader dsWorkCenters = cmdoper.Execute Reader();
WorkStations.Da taSource = dsWorkCenters;
WorkStations.Da taTextField = "WORKSTATN" ;
WorkStations.Da taValueField = "WORKSTATN" ;
WorkStations.Da taBind();
conoper.Close() ;
WorkStations.It ems.Insert(0, new ListItem("Pleas e Select A
Workstation", "0"));
WorkStations.Se lectedIndex = 0;
}
}
}
}
protected void WorkStations_Se lectedIndexChan ged(object sender,
EventArgs e) // This is dropdownlist box 2
{
string LString;
int indexNum;
indexNum = WorkStations.Se lectedIndex;
Response.Write( indexNum );
foreach(ListIte m item in WorkStations.It ems)
{
if(item.Selecte d)
{
if (item.Value == "Please Select A Workstation")
{
LString = "<script language=JavaSc ript>alert('No Workstation
Selected. \n Please Select A Workstation');</script>";
RegisterStartup Script("startup Script", LString);
}
else
{
LString = "<script language=JavaSc ript>alert('" + item.Text +
"');</script>";
RegisterStartup Script("startup Script", LString);
}
}
}
}
As I am new to C# and ASP.NET could anyone please give me an idea of
what is going wrong here
Thanks in advance for any assistance offered
Iain
