Try
Request.getvalues("listboxname")(0)
Or
Request.form.getvalues("listboxname")(0)

Thanks,

Chris Thompson

-+-+-+-+-+-+-+-+-+-+-+-
cthompson@n...
xxx-xxx-xxxx
-+-+-+-+-+-+-+-+-+-+-+-



-----Original Message-----
From: jchristiana@k... [mailto:jchristiana@k...]
Sent: Thursday, January 16, 2003 12:10 PM
To: ASPX_Professional
Subject: [aspx_professional] Multi Select

Hello. I am having some problems with my listbox. Here we go...

I have created a form that has a listbox that is hardcoded with 30
departments. When I do a CTRL and select 2 or more from the list and
submit it to my SQL database it only grabs the first on of what I had
Selected.

A
B
C
 only A is sent to the database.

Can anyone help here. Is there anywhere Books, website or forum that has

an example of this? For submitting a multiselect listbox to a SQL
Database.

Thanks.

Here is the code of the first page.

>>>>
public string CSOOptionsgroups
{
get
{
return csooptionsgroups.SelectedItem.Text;
}
}



<asp:listbox id=3D"csooptionsgroups"
		rows=3D"3"
		selectionmode=3D"multiple"
		runat=3D"server">

	<asp:listitem>Admin and Support</asp:listitem>
  <asp:listitem>Admitting</asp:listitem>
  <asp:listitem>Admitting Nurses</asp:listitem>
  <asp:listitem>AHS Outreach</asp:listitem>

</asp:listbox>
//I have shortend the list//
>>>>

************************************************************
Then when this is submited, it is sent to this page.

<%@ Page Language=3D"C#" %>
<%@ Reference Page=3D"ComputerSOForm.aspx" %>
<%@ Import Namespace=3D"System.Data" %>
<%@ Import Namespace=3D"System.Data.SqlClient" %>

<script language=3D"c#" runat=3D"server">

CSOPageClass fp;

void Page_Load(object sender, EventArgs e)


	{
	if (!IsPostBack)
		{
			fp =3D (CSOPageClass)Context.Handler;
		}
	string[] strArrayDetails =3D new string[27];
	strArrayDetails[0] =3D fp.IdUni;
	strArrayDetails[1] =3D fp.CSOEmployeenamefirst;
	strArrayDetails[2] =3D fp.CSOEmployeenamelast;
	strArrayDetails[3] =3D fp.CSOEmployeenamemiddle;
	strArrayDetails[4] =3D fp.CSONickname;
	strArrayDetails[5] =3D fp.CSOSsnumber;
	strArrayDetails[6] =3D fp.CSODate;
	strArrayDetails[7] =3D fp.CSOEmployeexpdate;
	strArrayDetails[8] =3D fp.CSOPcdevice;
	strArrayDetails[9] =3D fp.CSODepartment;
	strArrayDetails[10] =3D fp.CSOPosition;
	strArrayDetails[11] =3D fp.CSODateeffective;
	strArrayDetails[12] =3D fp.CSOPersonreplacing;
	strArrayDetails[13] =3D fp.CSOMirrorprofile;
	strArrayDetails[14] =3D fp.CSOOptionswww;
	strArrayDetails[15] =3D fp.CSOOptionsbh;
	strArrayDetails[16] =3D fp.CSOOptionscsi;
	strArrayDetails[17] =3D fp.CSOOptionsint;
	strArrayDetails[18] =3D fp.CSOOptionsstm;
	strArrayDetails[19] =3D fp.CSOOptionsstt;
	strArrayDetails[20] =3D fp.CSOOptionsoutlook;
	strArrayDetails[21] =3D fp.CSOOptionsics;
	strArrayDetails[22] =3D fp.CSODepart;
	strArrayDetails[23] =3D fp.CSOWorktimeuser;
	strArrayDetails[24] =3D fp.CSOProvider;
	strArrayDetails[25] =3D fp.CSOLocation;
	strArrayDetails[26] =3D fp.CSOOptionsgroups;
=09

=09
=09
	SqlConnection thisConnection =3D new SqlConnection(
		@"Data Source=3DKRMC-VPN;user
id=3DHelpDesk;password=3Ddeleted;"
+
		"Initial Catalog=3DCSO");
		thisConnection.Open();

	SqlDataAdapter thisAdapter =3D new SqlDataAdapter(
		"SELECT * FROM CSOData", thisConnection);
	=09
	SqlCommandBuilder thisBuilder =3D new
SqlCommandBuilder(thisAdapter);
	=09
	DataSet thisDataSet =3D new DataSet();
=09
	thisAdapter.Fill(thisDataSet, "CSOData");
=09
	DataRow thisRow =3D thisDataSet.Tables["CSOData"].NewRow();
=09
	thisRow["IdUni"] =3D (strArrayDetails[0]);
	thisRow["CSOEmployeenamefirst"] =3D (strArrayDetails[1]);
	thisRow["CSOEmployeenamelast"] =3D (strArrayDetails[2]);
	thisRow["CSOEmployeenamemiddle"] =3D (strArrayDetails[3]);
	thisRow["CSONickname"] =3D (strArrayDetails[4]);
	thisRow["CSOSsnumber"] =3D (strArrayDetails[5]);
	thisRow["CSODate"] =3D (strArrayDetails[6]);
	thisRow["CSOEmployeexpdate"] =3D (strArrayDetails[7]);
	thisRow["CSOPcdevice"] =3D (strArrayDetails[8]);
	thisRow["CSODepartment"] =3D (strArrayDetails[9]);
	thisRow["CSOPosition"] =3D (strArrayDetails[10]);
	thisRow["CSODateeffective"] =3D (strArrayDetails[11]);
	thisRow["CSOPersonreplacing"] =3D (strArrayDetails[12]);
	thisRow["CSOMirrorprofile"] =3D (strArrayDetails[13]);
	thisRow["CSOOptionswww"] =3D (strArrayDetails[14]);
	thisRow["CSOOptionsbh"] =3D (strArrayDetails[15]);
	thisRow["CSOOptionscsi"] =3D (strArrayDetails[16]);
	thisRow["CSOOptionsint"] =3D (strArrayDetails[17]);
	thisRow["CSOOptionsstm"] =3D (strArrayDetails[18]);
	thisRow["CSOOptionsstt"] =3D (strArrayDetails[19]);
	thisRow["CSOOptionsoutlook"] =3D (strArrayDetails[20]);
	thisRow["CSOOptionsics"] =3D (strArrayDetails[21]);
	thisRow["CSODepart"] =3D (strArrayDetails[22]);
	thisRow["CSOWorktimeuser"] =3D (strArrayDetails[23]);
	thisRow["CSOProvider"] =3D (strArrayDetails[24]);
	thisRow["CSOLocation"] =3D (strArrayDetails[25]);
	thisRow["CSOOptionsgroups"] =3D (strArrayDetails[26]);

	thisDataSet.Tables["CSOData"].Rows.Add(thisRow);
	thisAdapter.Update (thisDataSet, "CSOData");
=09
	thisConnection.Close();

	=09
	}

</script>
<html>
<head>
<title>Form has been Submitted</title>
</head>
<body>

<%
  Response.Redirect("http://10.6.3.2:68/FormSubmitsuccess.aspx");
%>

<br />

  </body>
</html>