dropdownlist question

[Newbie]

I have a C# asp.net webform that contains a dropdownlist and a button that
allows the user to select another item in the dropdownlist. The webform
should work as follows:

When the user selects an item in the dropdownlist and clicks the button, his
selection will appear as a line of text somewhere in the webform. The user
can then select another item and clicks the button and his selection will
again appear as a line of text.

In order to avoid duplication, I need to remove (or disable) the selected
item from the dropdownlist. That way, the user wont be able to select an item
that he previously selected. I need to do this without modifying the
database. My code follows and thanks in advance.

string sCCI = "SELECT activity_no,des 1
category,Conver t(activity_uom, 'US7ASCII') bill_rate "
+ "FROM pa_activity "
+ "WHERE (activity_no LIKE Upper('D0%') or activity_no LIKE Upper('S0%'))
And last_status <> 'D' "
+ " And activity_type = 'L' "
+ "ORDER BY des1 ";
OracleConnectio n oraConn = new OracleConnectio n(connStr);
OracleCommand oraCMD = new OracleCommand(s CCI, oraConn);
oraConn.Open();
OracleDataAdapt er adapter = new OracleDataAdapt er(oraCMD);
DataSet ds = new DataSet();
adapter.Fill(ds );
if (ds.Tables[0].Rows.Count > 0)
{
ddlConsultantCa tegory.DataSour ce = ds.Tables[0];
ddlConsultantCa tegory.DataText Field = "category";
ddlConsultantCa tegory.DataValu eField = "category";
ddlConsultantCa tegory.DataBind ();
ddlConsultantCa tegory.Items.In sert(0, "(Select Consultant Category)");
}
oraConn.Close() ;

where ddlConsultantCa tegory is the dropdownlist.

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,
Use DropDownList.It ems.Remove ( DropDownList1.S electedItem ) or
DropDownList.It ems.RemoveAt ( DropDownList1.S electedIndex )
BTW, the code you posted is only the DB access portion, do you have problem
with it?
cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Newbie" <Ne****@discuss ions.microsoft. com> wrote in message
news:EE******** *************** ***********@mic rosoft.com...

I have a C# asp.net webform that contains a dropdownlist and a button that
allows the user to select another item in the dropdownlist. The webform
should work as follows:

When the user selects an item in the dropdownlist and clicks the button,
his
selection will appear as a line of text somewhere in the webform. The
user
can then select another item and clicks the button and his selection will
again appear as a line of text.

In order to avoid duplication, I need to remove (or disable) the selected
item from the dropdownlist. That way, the user wont be able to select an
item
that he previously selected. I need to do this without modifying the
database. My code follows and thanks in advance.

string sCCI = "SELECT activity_no,des 1
category,Conver t(activity_uom, 'US7ASCII') bill_rate "
+ "FROM pa_activity "
+ "WHERE (activity_no LIKE Upper('D0%') or activity_no LIKE Upper('S0%'))
And last_status <> 'D' "
+ " And activity_type = 'L' "
+ "ORDER BY des1 ";
OracleConnectio n oraConn = new OracleConnectio n(connStr);
OracleCommand oraCMD = new OracleCommand(s CCI, oraConn);
oraConn.Open();
OracleDataAdapt er adapter = new OracleDataAdapt er(oraCMD);
DataSet ds = new DataSet();
adapter.Fill(ds );
if (ds.Tables[0].Rows.Count > 0)
{
ddlConsultantCa tegory.DataSour ce = ds.Tables[0];
ddlConsultantCa tegory.DataText Field = "category";
ddlConsultantCa tegory.DataValu eField = "category";
ddlConsultantCa tegory.DataBind ();
ddlConsultantCa tegory.Items.In sert(0, "(Select Consultant Category)");
}
oraConn.Close() ;

where ddlConsultantCa tegory is the dropdownlist.

[Newbie]

Thanks a lot, sir. It's working! I do have another question which I'll post
later.

"Ignacio Machin ( .NET/ C# MVP )" wrote:

Hi,
Use DropDownList.It ems.Remove ( DropDownList1.S electedItem ) or
DropDownList.It ems.RemoveAt ( DropDownList1.S electedIndex )
BTW, the code you posted is only the DB access portion, do you have problem
with it?
cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Newbie" <Ne****@discuss ions.microsoft. com> wrote in message
news:EE******** *************** ***********@mic rosoft.com...

I have a C# asp.net webform that contains a dropdownlist and a button that
allows the user to select another item in the dropdownlist. The webform
should work as follows:

When the user selects an item in the dropdownlist and clicks the button,
his
selection will appear as a line of text somewhere in the webform. The
user
can then select another item and clicks the button and his selection will
again appear as a line of text.

In order to avoid duplication, I need to remove (or disable) the selected
item from the dropdownlist. That way, the user wont be able to select an
item
that he previously selected. I need to do this without modifying the
database. My code follows and thanks in advance.

string sCCI = "SELECT activity_no,des 1
category,Conver t(activity_uom, 'US7ASCII') bill_rate "
+ "FROM pa_activity "
+ "WHERE (activity_no LIKE Upper('D0%') or activity_no LIKE Upper('S0%'))
And last_status <> 'D' "
+ " And activity_type = 'L' "
+ "ORDER BY des1 ";
OracleConnectio n oraConn = new OracleConnectio n(connStr);
OracleCommand oraCMD = new OracleCommand(s CCI, oraConn);
oraConn.Open();
OracleDataAdapt er adapter = new OracleDataAdapt er(oraCMD);
DataSet ds = new DataSet();
adapter.Fill(ds );
if (ds.Tables[0].Rows.Count > 0)
{
ddlConsultantCa tegory.DataSour ce = ds.Tables[0];
ddlConsultantCa tegory.DataText Field = "category";
ddlConsultantCa tegory.DataValu eField = "category";
ddlConsultantCa tegory.DataBind ();
ddlConsultantCa tegory.Items.In sert(0, "(Select Consultant Category)");
}
oraConn.Close() ;

where ddlConsultantCa tegory is the dropdownlist.