How to save multiple selected list items in database and dropdowns list items?

Question

hi can any one suggest me how to insert selected multiple list items to database and dropdowns list items?

Satyapriya Nayak · Answer

Hi Fahad Try this... Select all the items from listbox2 and then click the insert button. Untitled Page using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Listboxes { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; string str; SqlCommand com; protected void Page_Load(object sender EventArgs e) { SqlConnection con = new SqlConnection(strConnString); if (!IsPostBack) { // ListBox1.Items.Add(Choose); con.Open(); str = select * from animal; com = new SqlCommand(str con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { ListBox1.Items.Add(reader[category].ToString()); } reader.Close(); con.Close(); } } protected void Button1_Click(object sender EventArgs e) { ListBox1.Items.Add(ListBox2.SelectedItem.Text); int i = 0; i = ListBox2.SelectedIndex; ListBox2.Items.RemoveAt(i); } protected void Button2_Click(object sender EventArgs e) { ListBox2.Items.Add(ListBox1.SelectedItem.Text); int i = 0; i = ListBox1.SelectedIndex; ListBox1.Items.RemoveAt(i); } protected void Button3_Click(object sender EventArgs e) { int j = 0; for (j = 0; j { ListBox1.Items.Add(ListBox2.Items[j]); } ListBox2.Items.Clear(); } protected void Button4_Click(object sender EventArgs e) { int j = 0; for (j = 0; j { ListBox2.Items.Add(ListBox1.Items[j]); } ListBox1.Items.Clear(); } protected void Button5_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); for (int i = 0; i { if (ListBox2.Items[i].Selected == true) { str = insert into animal1 values(' + ListBox2.Items[i].ToString() + '); com = new SqlCommand(str con); com.ExecuteNonQuery(); } } Response.Write(Inserted); } } } Thanks If this post helps you mark it as answer

fahad sheikhji · Answer

hi bro thanks..how to add in one table it contains 3 columns...two to add drop downs selected items and one for to add selected items how to give coding for that together??

fahad sheikhji · Answer

hi this is my code protected void imgbtnSave_Click(object sender ImageClickEventArgs e) { for (int i = 0; i { SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings[dbConnection].ToString()); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = usp_InsertWorkAllocation; SqlParameter pLID = new SqlParameter(@LID SqlDbType.VarChar 50); SqlParameter pBID = new SqlParameter(@BID SqlDbType.VarChar 50); SqlParameter pTID = new SqlParameter(@TID SqlDbType.VarChar 50); cmd.Connection = conn; Session[LID] = ddlTesterName.SelectedItem.Text; Session[BID] = ddlBuildNO.SelectedItem.Text; Session[TID] = lbAddedItems.SelectionMode; string selectedItem = lbAddedItems.Items[i].Text; cmd.Parameters.AddWithValue(@LID Session[LID]); cmd.Parameters.AddWithValue(@BID Session[BID]); cmd.Parameters.AddWithValue(@TID Session[TID]); cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } } this is my aspx page. when i selcet multiple records in secod lis box like this saving to sql table i want to save in tid like test8test6test10.but its adding only 1..and if i select other testers also its adding only Tester..can any one help?

fahad sheikhji · Answer

hi in my project m binding list items from sql like for example 1listbox and items like[tigerlioncatdog(this values from one particular column from sql)]when i select it should show in another listbox tats 2listbox[liondogcat] when i click save it should insert into sqltable.

Satyapriya Nayak · Answer

Hi Fahad Try this... Untitled Page onselectedindexchanged=DropDownList1_SelectedIndexChanged> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace WebApplication9 { public partial class WebForm1 : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; string str; SqlCommand com; protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { DropDownList1.AutoPostBack = true; DropDownList1.Items.Add(Select); DropDownList1.Items.Add(Raj); DropDownList1.Items.Add(Ravi); DropDownList1.Items.Add(Rahul); DropDownList1.Items.Add(Rajesh); } } protected void DropDownList1_SelectedIndexChanged(object sender EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); for (int i = 0; i { if (DropDownList1.Items[i].Selected == true) { str = insert into employee values(' + DropDownList1.Items[i].ToString() + '); com = new SqlCommand(str con); com.ExecuteNonQuery(); Response.Write( alert('Items Inserted'); ); } } } } } Thanks If this post helps you mark it as answer