gridview fileter from multi-select listbox

Question

0.00/5 (No votes)

See more:

HiI have a list box that is bound to a table in a database. it produces a list of companies. The user will then come along and select multiple companies that they want to view information about, and then they hit a selet button which ill display the company information (e.g company name, company site, address e.t.c) in a gridview underneath. however the issue that i am having is that it only displays ONE of the multiple companies selected and its always the top one.

Can someone please shed some light on how i get all the companies to be displayed in the gridview?

i am programming in vb.net

please see source code below

XML

<asp:ListBox ID="ListBox1" runat="server"
            DataSourceID="SqlDataSource11" DataTextField="compName"
            DataValueField="compDataID" SelectionMode="Multiple" AutoPostBack="True"></asp:ListBox>
        <asp:SqlDataSource ID="SqlDataSource11" runat="server"
            ConnectionString="<%$ ConnectionStrings:IWSRiskAssessmentConnectionString %>"
            SelectCommand="SELECT [compDataID], [compName] FROM [tblCompany] WHERE ([compDataID] &lt;&gt; @compDataID) ORDER BY [compName]">
            <SelectParameters>
                <asp:ControlParameter ControlID="DropDownList1" Name="compDataID"
                    PropertyName="SelectedValue" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>

XML

<asp:GridView
            ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
            DataSourceID="SqlDataSource2">
            <Columns>
                <asp:BoundField DataField="compName" HeaderText="compName"
                    SortExpression="compName" />
                <asp:BoundField DataField="Site Name" HeaderText="Site Name"
                    SortExpression="Site Name" />
                <asp:BoundField DataField="Reference Number" HeaderText="Reference Number"
                    SortExpression="Reference Number" />
                <asp:BoundField DataField="Asset" HeaderText="Asset" ReadOnly="True"
                    SortExpression="Asset" />
                <asp:BoundField DataField="Location" HeaderText="Location"
                    SortExpression="Location" />
                <asp:BoundField DataField="Block" HeaderText="Block" SortExpression="Block" />
                <asp:BoundField DataField="Room" HeaderText="Room" SortExpression="Room" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server"
            ConnectionString="<%$ ConnectionStrings:IWSRiskAssessmentConnectionString %>"
            SelectCommand="SELECT tblCompany.compName, tblSite.siteName AS [Site Name], tblSite.siteUPRN AS [Reference Number], tblIncMain.incAsset + ' ' + CAST(tblIncMain.incNumber AS varchar) AS Asset, tblIncMain.incLocation AS Location, tblIncMain.incBlock AS Block, tblIncMain.incRoom AS Room FROM tblIncMain INNER JOIN tblSite ON tblIncMain.incSite = tblSite.siteID INNER JOIN tblCompany ON tblSite.siteCompany = tblCompany.compDataID WHERE (tblIncMain.incActive = 1) AND (tblSite.siteActive = 1) AND (tblIncMain.incRemoved = 0) AND (tblCompany.compDataID = @compDataID) ORDER BY [Site Name], tblIncMain.incAsset, tblIncMain.incNumber">
            <SelectParameters>
                <asp:ControlParameter ControlID="ListBox1" Name="compDataID"
                    PropertyName="SelectedValueList" />
            </SelectParameters>
        </asp:SqlDataSource>

any help is much appreciated

Posted 5-Oct-11 4:02am

reid0588

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Espen Harlinn · Answer 1 · 2011-10-05T05:03:00

Solution 1

Take a look at:
GridView Multiple Filter AJAX Control[^]
and
MultiDropDown v2: A multiple selection Dropdown control for ASP.NET[^]

Those two articles covers most of what you need to know...

Best regards
Espen Harlinn

Posted 5-Oct-11 5:03am

Espen Harlinn

Comments

Simon Bang Terkildsen 6-Oct-11 7:57am

My 5

Espen Harlinn 6-Oct-11 10:24am

Thank you, Simon!

Muralikrishna8811 · Answer 2 · 2011-10-05T09:30:00

Hi,

Here I'm providing some code for your requirement.

Just check once this it can helps you to get solution

ASP.NET

<asp:listbox id="ListBox1" runat="server" selectionmode="Multiple" xmlns:asp="#unknown">
    Height="176px" Width="130px" ></asp:listbox><br />
<asp:button id="Button1" runat="server" text="Button" onclick="Button1_Click" xmlns:asp="#unknown" /><br />
<asp:datalist id="DataList1" runat="server" xmlns:asp="#unknown">
 <HeaderTemplate >
    <table width="100%" align="center">
       <tr>
          <td>Company ID</td>
          <td>Company Name</td>
          <td>Company Addr</td>
          <td>Company Url</td>
       </tr>

 </HeaderTemplate>
 <itemtemplate>
     <tr>
          <td><![CDATA[<%#Eval("id") %>]]></td>
          <td><![CDATA[<%#Eval("compname") %>]]></td>
          <td><![CDATA[<%#Eval("compaddr") %>]]></td>
          <td><![CDATA[<%#Eval("compurl") %>]]></td>
       </tr>
 </itemtemplate>
 <footertemplate>
 </footertemplate></table>

</asp:datalist>

And the code behind file contains

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        filllist();
    }
}
public void filllist()
{
    TestingDBLinqDataContext db = new TestingDBLinqDataContext();
    var d = from w in db.CompanyTabs
            select new {id=w.id,cname=w.compname  };
    foreach (var h in d)
    {
        ListBox1.Items.Add(new ListItem(h.cname, h.id.ToString ()));
    }
}

protected void Button1_Click(object sender, EventArgs e)
{
    int[] st=ListBox1.GetSelectedIndices ();
    string sd="";
    for(int i=0;i<st.length mode="hold" />        {
         int h=st[i];
        if(i==0)
        {

        sd=ListBox1.Items [h].Value ;
        }
        else
        {
           sd=sd+","+ListBox1.Items [h].Value ;
        }
    }


    SqlConnection con = new SqlConnection(@"dbconnectionstring");
    DataTable dt = new DataTable();
    SqlDataAdapter da = new SqlDataAdapter("select * from CompanyTab where id in ("+sd+")", con);
    da.Fill(dt);
    DataList1.DataSource = dt;
    DataList1.DataBind();


}

All the Best