asp.net, c#, listbox

[ctzack]

hi there.
i'm a new member here n i'm a beginner in asp.net - C#
i have a problem here, i hope sumbody out there can help me to solve this prob.

here's my prob :
i have few other textboxes for user to insert datas, and a listbox for the user to select multiple item on my page which loads a list of empname from empa table.
here's my code to load the list in the listbox :

dbEmp.Open();
cmd = new SqlCommand("Select empno, empname " +
"from empa order by empname", dbEmp);
dr = cmd.ExecuteReader();
lstEmp.DataSource = dr;
lstEmp.DataValueField = "empno";
lstEmp.DataTextField = "empname";
lstEmp.DataBind();
cmd = null;
dbEmp.Close();

i am not sure how to write the code for the listbox item in order to insert the item selected by user into sql.

right now i am stuck, this is my code to insert into d db :
dbEmp.Open();
cmd = new SqlCommand("Create_Memo", dbEmp);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("pempno1", lstEmp.Items[1].Value);
cmd.Parameters.AddWithValue("pempno2", lstEmp.Items[2].Value);
cmd.Parameters.AddWithValue("pempno3", lstEmp.Items[3].Value);
cmd.Parameters.AddWithValue("pempno4", lstEmp.Items[4].Value);
cmd.Parameters.AddWithValue("pempno5", lstEmp.Items[5].Value);
cmd.Parameters.AddWithValue("pempno6", lstEmp.Items[6].Value);
cmd.Parameters.AddWithValue("pempno7", lstEmp.Items[7].Value);
cmd.Parameters.AddWithValue("pempno8", lstEmp.Items[8].Value);
cmd.Parameters.AddWithValue("pempno9", lstEmp.Items[9].Value);
cmd.Parameters.AddWithValue("pempno10", lstEmp.Items[10].Value);
cmd.Parameters.AddWithValue("ppriorityid", ddlPrio.SelectedValue);
cmd.Parameters.AddWithValue("pmemodate", DateTime.Today.ToShortDateString());
cmd.Parameters.AddWithValue("pmemotitle", txtTitle.Text);
cmd.Parameters.AddWithValue("pmemocontent", txtContent.Text);
cmd.ExecuteNonQuery();
dbEmp.Close();
Response.Redirect("previewMemo.aspx");

fyi, i use store proc to insert data into d particualr table.
here is my stored proc :

create proc Create_Memo
@pempno1 varchar (6),
@pempno2 varchar (6),
@pempno3 varchar (6),
@pempno4 varchar (6),
@pempno5 varchar (6),
@pempno6 varchar (6),
@pempno7 varchar (6),
@pempno8 varchar (6),
@pempno9 varchar (6),
@pempno10 varchar (6),
@pPriorityID varchar (1),
@pMemoDate smalldatetime,
@pMemoTitle varchar (100),
@pMemoContent varchar (1000)

as
insert into memo (empno1, empno2, empno3, empno4, empno5, empno6, empno7, empno8,
empno9, empno10, PriorityID, MemoDate, MemoTitle, MemoContent)
values (@pempno1, @pempno2, @pempno3, @pempno4, @pempno5, @pempno6, @pempno7, @pempno8, @pempno9, @pempno10,
@pPriorityID, @pmemodate, @pMemoTitle, @pMemoContent)


i hope sumbody can help me. tq in advance.

[kirupa]

Hi ctzack!
If you only want to get the selected items from your listbox, you can use the following code:


foreach (ListItem item in MyListBox.Items)
{
if (item.Selected)
{
//lblResults.Text += item.Text + "\r";
}
}
Basically I go through each item in the listbox and check whether it is selected. If that item is selected, then you can do something with those items. In your case, those selected items would be sent to your code that does the database processing.

Cheers!
Kirupa :)

[ctzack]

hi Kirupa. thx 4 ur fast reply.

1st of all, sori if this Q sounds er.. pathetic? since im a a beginner, i hope u dun mind to answer my further Q.here is my Q :

i'm stil abit blurr abt wats goin on in d code u gv. i noe dat it wil check whc item is selected by the user, but Q is, how do i modify this statement below, in order to store d data into db?

cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("pempno1", lstEmp.Items[1].Value);

thx in advance.