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 :
[SIZE=2]dbEmp.Open();
cmd = [/SIZE][SIZE=2][COLOR=#0000ff]new[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#008080]SqlCommand[/COLOR][/SIZE][SIZE=2]([/SIZE][SIZE=2][COLOR=#800000]"Select empno, empname "[/COLOR][/SIZE][SIZE=2] +
[/SIZE][SIZE=2][COLOR=#800000]“from empa order by empname”[/COLOR][/SIZE][SIZE=2], dbEmp);
dr = cmd.ExecuteReader();
lstEmp.DataSource = dr;
lstEmp.DataValueField = [/SIZE][SIZE=2][COLOR=#800000]“empno”[/COLOR][/SIZE][SIZE=2];
lstEmp.DataTextField = [/SIZE][SIZE=2][COLOR=#800000]“empname”[/COLOR][/SIZE][SIZE=2];
lstEmp.DataBind();
cmd = [/SIZE][SIZE=2][COLOR=#0000ff]null[/COLOR][/SIZE][SIZE=2];
dbEmp.Close();
[/SIZE]
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 :
[SIZE=2]dbEmp.Open();
cmd = [/SIZE][SIZE=2][COLOR=#0000ff]new[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#008080]SqlCommand[/COLOR][/SIZE][SIZE=2]([/SIZE][SIZE=2][COLOR=#800000]“Create_Memo”[/COLOR][/SIZE][SIZE=2], dbEmp);
cmd.CommandType = [/SIZE][SIZE=2][COLOR=#008080]CommandType[/COLOR][/SIZE][SIZE=2].StoredProcedure;
cmd.Parameters.AddWithValue([/SIZE][SIZE=2][COLOR=#800000]“pempno1”[/COLOR][/SIZE][SIZE=2], lstEmp.Items[1].Value);
cmd.Parameters.AddWithValue([/SIZE][SIZE=2][COLOR=#800000]“pempno2”[/COLOR][/SIZE][SIZE=2], lstEmp.Items[2].Value);
cmd.Parameters.AddWithValue([/SIZE][SIZE=2][COLOR=#800000]“pempno3”[/COLOR][/SIZE][SIZE=2], lstEmp.Items[3].Value);
cmd.Parameters.AddWithValue([/SIZE][SIZE=2][COLOR=#800000]“pempno4”[/COLOR][/SIZE][SIZE=2], lstEmp.Items[4].Value);
cmd.Parameters.AddWithValue([/SIZE][SIZE=2][COLOR=#800000]“pempno5”[/COLOR][/SIZE][SIZE=2], lstEmp.Items[5].Value);
cmd.Parameters.AddWithValue([/SIZE][SIZE=2][COLOR=#800000]“pempno6”[/COLOR][/SIZE][SIZE=2], lstEmp.Items[6].Value);
cmd.Parameters.AddWithValue([/SIZE][SIZE=2][COLOR=#800000]“pempno7”[/COLOR][/SIZE][SIZE=2], lstEmp.Items[7].Value);
cmd.Parameters.AddWithValue([/SIZE][SIZE=2][COLOR=#800000]“pempno8”[/COLOR][/SIZE][SIZE=2], lstEmp.Items[8].Value);
cmd.Parameters.AddWithValue([/SIZE][SIZE=2][COLOR=#800000]“pempno9”[/COLOR][/SIZE][SIZE=2], lstEmp.Items[9].Value);
cmd.Parameters.AddWithValue([/SIZE][SIZE=2][COLOR=#800000]“pempno10”[/COLOR][/SIZE][SIZE=2], lstEmp.Items[10].Value);
cmd.Parameters.AddWithValue([/SIZE][SIZE=2][COLOR=#800000]“ppriorityid”[/COLOR][/SIZE][SIZE=2], ddlPrio.SelectedValue);
cmd.Parameters.AddWithValue([/SIZE][SIZE=2][COLOR=#800000]“pmemodate”[/COLOR][/SIZE][SIZE=2], [/SIZE][SIZE=2][COLOR=#008080]DateTime[/COLOR][/SIZE][SIZE=2].Today.ToShortDateString());
cmd.Parameters.AddWithValue([/SIZE][SIZE=2][COLOR=#800000]“pmemotitle”[/COLOR][/SIZE][SIZE=2], txtTitle.Text);
cmd.Parameters.AddWithValue([/SIZE][SIZE=2][COLOR=#800000]“pmemocontent”[/COLOR][/SIZE][SIZE=2], txtContent.Text);
cmd.ExecuteNonQuery();
dbEmp.Close();
Response.Redirect([/SIZE][SIZE=2][COLOR=#800000]“previewMemo.aspx”[/COLOR][/SIZE][SIZE=2]);
[/SIZE]
fyi, i use store proc to insert data into d particualr table.
here is my stored proc :
[SIZE=2][COLOR=#0000ff]create[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]proc[/COLOR][/SIZE][SIZE=2] Create_Memo
@pempno1 [/SIZE][SIZE=2][COLOR=#0000ff]varchar[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2]COLOR=#808080,
[/COLOR][/SIZE][SIZE=2]@pempno2 [/SIZE][SIZE=2][COLOR=#0000ff]varchar[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2]COLOR=#808080,
[/COLOR][/SIZE][SIZE=2]@pempno3 [/SIZE][SIZE=2][COLOR=#0000ff]varchar[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2]COLOR=#808080,
[/COLOR][/SIZE][SIZE=2]@pempno4 [/SIZE][SIZE=2][COLOR=#0000ff]varchar[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2]COLOR=#808080,
[/COLOR][/SIZE][SIZE=2]@pempno5 [/SIZE][SIZE=2][COLOR=#0000ff]varchar[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2]COLOR=#808080,
[/COLOR][/SIZE][SIZE=2]@pempno6 [/SIZE][SIZE=2][COLOR=#0000ff]varchar[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2]COLOR=#808080,
[/COLOR][/SIZE][SIZE=2]@pempno7 [/SIZE][SIZE=2][COLOR=#0000ff]varchar[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2]COLOR=#808080,
[/COLOR][/SIZE][SIZE=2]@pempno8 [/SIZE][SIZE=2][COLOR=#0000ff]varchar[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2]COLOR=#808080,
[/COLOR][/SIZE][SIZE=2]@pempno9 [/SIZE][SIZE=2][COLOR=#0000ff]varchar[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2]COLOR=#808080,
[/COLOR][/SIZE][SIZE=2]@pempno10 [/SIZE][SIZE=2][COLOR=#0000ff]varchar[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2]COLOR=#808080,
[/COLOR][/SIZE][SIZE=2]@pPriorityID [/SIZE][SIZE=2][COLOR=#0000ff]varchar[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2]COLOR=#808080,
[/COLOR][/SIZE][SIZE=2]@pMemoDate [/SIZE][SIZE=2][COLOR=#0000ff]smalldatetime[/COLOR][/SIZE][SIZE=2][COLOR=#808080],
[/COLOR][/SIZE][SIZE=2]@pMemoTitle [/SIZE][SIZE=2][COLOR=#0000ff]varchar[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2]COLOR=#808080,[/COLOR][/SIZE][SIZE=2]
@pMemoContent [/SIZE][SIZE=2][COLOR=#0000ff]varchar[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2]COLOR=#808080
[/COLOR][/SIZE][SIZE=2]
[/SIZE][SIZE=2][COLOR=#0000ff]as
[/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#0000ff]insert[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]into[/COLOR][/SIZE][SIZE=2] memo [/SIZE][SIZE=2][COLOR=#808080]([/COLOR][/SIZE][SIZE=2]empno1[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] empno2[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] empno3[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] empno4[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] empno5[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] empno6[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] empno7[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] empno8[/SIZE][SIZE=2][COLOR=#808080],
[/COLOR][/SIZE][SIZE=2]empno9[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] empno10[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] PriorityID[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] MemoDate[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] MemoTitle[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] MemoContent[/SIZE][SIZE=2][COLOR=#808080])
[/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#0000ff]values[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#808080]([/COLOR][/SIZE][SIZE=2]@pempno1[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] @pempno2[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] @pempno3[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] @pempno4[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] @pempno5[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] @pempno6[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] @pempno7[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] @pempno8[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] @pempno9[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] @pempno10[/SIZE][SIZE=2][COLOR=#808080],
[/COLOR][/SIZE][SIZE=2]@pPriorityID[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] @pmemodate[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] @pMemoTitle[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE][SIZE=2] @pMemoContent[/SIZE][SIZE=2][COLOR=#808080])
[/COLOR][/SIZE][SIZE=2]
[/SIZE]
i hope sumbody can help me. tq in advance.
