Transfer selected ASP.Net ListBox DataValueField and DataTextField to another ListBox using C#

developm...

SOLVED CLOSED ACTIVE ANSWERED
User: developmin
Posted: on Jan 04, 2018 03:23 AM
Forum: Data Controls
Answer: 1
Views: 4985

I have 3 listboxes. The listbox fetches two values by code-datatextfield and datavaluefield. 1st listbox transfers the datatextfield items from 1st listbox to 2nd listbox. i want to transfer the datavaluefield of selected 1st listbox items to 3rd listbox.

datatextfields are transferred from Listbox 3 to Listbox 2 and datavaluefields from Listbox 3 to Listbox 1 which is not done.I have written the code for transferring datavaluefields from Listbox 3 to Listbox 1 but the problem is as I am using a session value it stores only single value in listbox 1 and get replaced everytime i select another item from listbox.

So kindly help me if i can transfer datavaluefields of selected items in listbox.

if (ListBox3.SelectedIndex >= 0
{
   for (int i = 0; i < ListBox3.Items.Count; i++)
    {
       if (ListBox3.Items[i].Selected)
       {
            if (!arraylist1.Contains(ListBox3.Items[i]))
            {
                arraylist1.Add(ListBox3.Items[i]);
                Session["value"] = ListBox3.Items[i];
            }
        }
    }
    for (int i = 0; i < arraylist1.Count; i++)
    {
        if (!ListBox2.Items.Contains(((ListItem)arraylist1[i])))
        {
            ListBox2.Items.Add(((ListItem)arraylist1[i]));

        }
        ListBox3.Items.Remove(((ListItem)arraylist1[i]));
    }
    ListBox2.SelectedIndex = -1;

}
else
{

}



SqlConnection con = new SqlConnection(strcon);
SqlCommand command = new SqlCommand("select * from IT_1_BOILER_DESK_1_PARAMETERS where paramtext='" + Session["value"] + "'", con);
SqlDataAdapter dataAadpter = new SqlDataAdapter(command);
DataSet ds = new DataSet();
dataAadpter.Fill(ds);
if (ds != null)
{
    ListBox1.DataSource = ds.Tables[0];
    ListBox1.DataTextField = "param";
    //ListBox3.DataValueField = "param";
    ListBox1.DataBind();
}

For listbox 3

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
    SqlConnection con = new SqlConnection(strcon);
    SqlCommand command = new SqlCommand("select * from IT_1_BOILER_DESK_1_PARAMETERS where pname='" + this.DropDownList1.SelectedValue + "'" ,con);
    SqlDataAdapter dataAadpter = new SqlDataAdapter(command);
    DataSet ds = new DataSet();
    dataAadpter.Fill(ds);
    if (ds != null)
    {
        ListBox3.DataSource = ds.Tables[0];
        ListBox3.DataTextField = "paramtext";
        ListBox3.DataValueField = "param";
        ListBox3.DataBind();
    }
}

But i want to display the datavaluefield of the items that are selected from listbox3 to listbox1

kalpesh

0 4

Reply
ANSWER
User: kalpesh
Replied: on Jan 04, 2018 05:35 AM
Modified: on Jan 04, 2018 05:37 AM
Report

Refer the below sample code for your Reference and implement it as per your code logic.

I have created ViewState Property with name as SelectedValue to store the selected values of ListBox3 item to retain the each selected item value of ListBox3. You can use ViewState or session value as per your requirement.

I have used Northwind Database to work similar functionality at my end.

HTML

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:DropDownList ID="DropDownList1" runat="server" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"
            AutoPostBack="true">
            <asp:ListItem Text="Belgium" Value="Belgium"></asp:ListItem>
            <asp:ListItem Text="Austria" Value="Austria"></asp:ListItem>
            <asp:ListItem Text="France" Value="France"></asp:ListItem>
            <asp:ListItem Text="Brazil" Value="Brazil"></asp:ListItem>
        </asp:DropDownList>
        <br />
        <asp:ListBox ID="ListBox3" runat="server" OnSelectedIndexChanged="ListBox3_SelectedIndexChanged"
            AutoPostBack="true"></asp:ListBox>
        <asp:ListBox ID="ListBox1" runat="server" AutoPostBack="true"></asp:ListBox>
        <asp:ListBox ID="ListBox2" runat="server" AutoPostBack="true"></asp:ListBox>
    </div>
    </form>
</body>
</html>

private string SelectedValue
{
    get
    {
        return ViewState["SelectedValue"] != null ? (string)ViewState["SelectedValue"] : "";
    }
    set
    {
        ViewState["SelectedValue"] = value;
    }
}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
    string constr = ConfigurationManager.ConnectionStrings["ConStr1"].ConnectionString;
    SqlConnection con = new SqlConnection(constr);
    SqlCommand command = new SqlCommand("select * from [Customers] where [Country]='" + this.DropDownList1.SelectedValue + "'", con);
    SqlDataAdapter dataAadpter = new SqlDataAdapter(command);
    DataSet ds = new DataSet();
    dataAadpter.Fill(ds);
    if (ds != null)
    {
        ListBox3.DataSource = ds.Tables[0];
        ListBox3.DataTextField = "CompanyName";
        ListBox3.DataValueField = "CustomerID";
        ListBox3.DataBind();
    }
}

protected void ListBox3_SelectedIndexChanged(object sender, EventArgs e)
{
    List<ListItem> arraylist1 = new List<ListItem>();
    if (ListBox3.SelectedIndex >= 0)
    {
        for (int i = 0; i < ListBox3.Items.Count; i++)
        {
            if (ListBox3.Items[i].Selected)
            {
                if (!arraylist1.Contains(ListBox3.Items[i]))
                {
                    arraylist1.Add(ListBox3.Items[i]);
                    if (!string.IsNullOrEmpty(SelectedValue))
                    {
                        SelectedValue += ",";
                    }
                    SelectedValue = SelectedValue + "'" + ListBox3.Items[i].Value + "'";
                }
            }
        }
        for (int i = 0; i < arraylist1.Count; i++)
        {
            if (!ListBox2.Items.Contains(((ListItem)arraylist1[i])))
            {
                ListBox2.Items.Add(((ListItem)arraylist1[i]));

            }
            ListBox3.Items.Remove(((ListItem)arraylist1[i]));
        }
        ListBox2.SelectedIndex = -1;
    }
    else
    {
        //
    }
    string constr = ConfigurationManager.ConnectionStrings["ConStr1"].ConnectionString;
    SqlConnection con = new SqlConnection(constr);
    SqlCommand command = new SqlCommand("select * from [Customers] where [CustomerID] IN (" + SelectedValue + ")", con);
    SqlDataAdapter dataAadpter = new SqlDataAdapter(command);
    DataSet ds = new DataSet();
    dataAadpter.Fill(ds);
    if (ds != null)
    {
        ListBox1.DataSource = ds.Tables[0];
        ListBox1.DataTextField = "CustomerID";
        ListBox1.DataBind();
    }
}

Screenshot

Transfer selected ASP.Net ListBox DataValueField and DataTextField to another ListBox using C#

Company

Explore

Follow us

Contact Us