Hai,
I have a listbox control that having multiple selections.It is populating the values from sql table.In the below code "lstPrimaryImpactedArea" is listbox name.If we select multiple items it should be inserted into sql table.It is working in UI.But if we use dataaccesslayer how we can solve this.
<tr>
<td align="right">
<asp:Label ID="lblPrimaryImpactedArea" runat="server" Text="Primary Impact Area"></asp:Label>
</td>
<td>
<asp:ListBox ID="lstPrimaryImpactedArea" runat="server" SelectionMode="Multiple">
</asp:ListBox>
</td>
</tr>
foreach (ListItem item in lstPrimaryImpactedArea.Items)
{
if (item.Selected)
{
try
{
lblMessage.Text = lblMessage.Text + item.Text+",";
cmd.Parameters[
"@primaryimpactedarea"].Value = lblMessage.Text;
}
catch (Exception ex)
{
}
}
}
Thanks in advance
[EDIT - Data Access Layer Code]
SqlCommand dCmd = new SqlCommand("InsertBugsdata", conn);
dCmd.CommandType = CommandType.StoredProcedure;
try
{
dCmd.Parameters.AddWithValue("@bugnumber", bugs.BugNumber);
dCmd.Parameters.AddWithValue("@publishtopartner", bugs.PublishToPartner);
dCmd.Parameters.AddWithValue("@impactscale", bugs.ImpactScale);
dCmd.Parameters.AddWithValue("@primaryimpactedarea", bugs.PrimaryImpactedArea);
dCmd.Parameters.AddWithValue("@secondaryimpactedarea", bugs.SecondaryImpactedArea);
dCmd.Parameters.AddWithValue("@impactedentity", bugs.ImpactedEntity);
dCmd.Parameters.AddWithValue("@impacttype", bugs.ImpactType);
dCmd.Parameters.AddWithValue("@percentimpact", bugs.PercentImpact);
dCmd.Parameters.AddWithValue("@title", bugs.Title);
dCmd.Parameters.AddWithValue("@description", bugs.Description);
dCmd.Parameters.AddWithValue("@defectdiscovered", bugs.DefectDiscovered);
dCmd.Parameters.AddWithValue("@eta", bugs.ETA);
dCmd.Parameters.AddWithValue("@defectstatus", bugs.DefectStatus);
dCmd.Parameters.AddWithValue("@defectstatusdetails", bugs.DefectStatusDetails);
dCmd.Parameters.AddWithValue("@defectclosetime", bugs.DefectCloseTime);
return dCmd.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
dCmd.Dispose();
conn.Close();
conn.Dispose();
}