Save Multiple ListBox selected Items in Database with commas using C# in ASP.Net

Question

httpwwwaspsnippetscomArticlesASPNetListBoxSaveMultipleSelectedItemsintheDatabaseaspxThe example in the link is perfect I just want the values to be entered in database seperated by commas in one recordeg    1  Vinz Mark RodI tried but no luck Can you do the codesThanks Asif

Indresh · Accepted Answer

Hi AsifpatelI have created sample code by refering the below article which fullfill your requirementASPNet ListBox Save Multiple Selected Items in the DatabaseHTMLltform id34form134 runat34server34gtltdivgt    Employee Names    ltbr gt    ltaspListBox ID34ListBox134 runat34server34 Height34149px34 SelectionMode34Multiple34        Width34113px34gt        ltaspListItemgtVinzltaspListItemgt        ltaspListItemgtJhenltaspListItemgt        ltaspListItemgtChrisltaspListItemgt        ltaspListItemgtShynneltaspListItemgt        ltaspListItemgtChultaspListItemgt        ltaspListItemgtMarkltaspListItemgt        ltaspListItemgtLilianltaspListItemgt        ltaspListItemgtRodltaspListItemgt        ltaspListItemgtGlendzyltaspListItemgt    ltaspListBoxgtltdivgtltbr gtltaspButton ID34Button134 runat34s

Indresh · Answer

Hi  AsifpatelPlease follow below codeCprotected void Button1Clickobject sender EventArgs e    string strEmployeeName  stringEmpty    string bossName  stringEmpty    foreach ListItem item in ListBox1Items            strEmployeeName  itemText  3434        foreach ListItem item in ListBox2Items            bossName  itemText  3434        InsertRecordsstrEmployeeNameRemovestrEmployeeNameLength  1 bossNameRemovebossNameLength  1private void InsertRecordsstring employeeName string bossName    SqlConnection conn  new SqlConnectionGetConnectionString    SqlCommand cmd  new SqlCommand34INSERT INTO EmployeesTest ValuesEmployeeNameBossNameEmployeeNumberjoinedDateAddresscitypostalphone34 conn    cmdCommandType  CommandTypeText    cmdParametersAddWithValue34EmployeeName34 employeeName    cmdParametersAddWithValue34BossName34 bossName    cmdParametersAddWithValue34

Save Multiple ListBox selected Items in Database with commas using C# in ASP.Net

Company

Explore

Follow us

Contact Us