troubleshooting Question

asp.net show selected gridview data in 2nd area on page

Avatar of SimonPrice33
SimonPrice33 asked on
.NET ProgrammingASP.NETVisual Basic.NET
5 Comments1 Solution612 ViewsLast Modified:
Hi Experts,

I currently have a gridview that shows information from a db2 database, the SQL is a little messy but given how I have been asked to pull the data it works and will be refined shortly..

The new requriement is that the data is selectable and the selected data shows in a second area.

The way this has been laid out in the spec shows that is must not be a second gridview, but more a table with textfields

the code used to bind the data to the gridview is

 txtSuName.Text = txtSuName.Text.ToUpper
        'If txtSuName.Text.Length = 0 And txtSupNo.Text.Length = 0 And drp20.SelectedValue = "" And drp21.SelectedValue = "" And drp22.SelectedValue = "" And drp23.SelectedValue = "" And drp23.SelectedValue = "" Then
        If txtSuName.Text.Length = 0 And drp20.SelectedValue = "" And drp21.SelectedValue = "" And drp22.SelectedValue = "" Then
            Exit Sub

        End If

        Dim supNo, supName, cat20, cat21, cat22 As String
        If rdoSupName.SelectedValue = "Name" Then
            If txtSuName.Text = Nothing Then
                supName = Nothing
            Else
                supName = "and a.ABALPH like '%" & txtSuName.Text & "%'"
            End If
        End If

        If rdoSupName.SelectedValue = "Number" Then
            If txtSuName.Text = Nothing Then
                supNo = Nothing
            Else
                supNo = "and a.ABAN8 like '%" & txtSuName.Text & "%'"
            End If
        End If

        If drp20.SelectedValue = Nothing Then
            cat20 = Nothing
        Else
            cat20 = " and b.drdl01ac20 = '" & drp20.SelectedValue & "'"
        End If

        If drp21.SelectedValue = Nothing Then
            cat21 = Nothing
        Else
            cat21 = "and c.drdl01ac21 = '" & drp21.SelectedValue & "'"
        End If

        If drp22.SelectedValue = Nothing Then
            cat22 = Nothing
        Else
            cat22 = "and d.drdl01ac22 = '" & drp22.SelectedValue & "'"
        End If

                sqlstr = "select distinct a.ABAN8 as Number, a.ABALPH as Name, a.ABAT1 as Type, g.aladdz as PostCode, " & _
        "b.drkyac20 as Level_1, b.drdl01ac20 as Level_1_Description,  " & _
        "c.drkyac21 as Level_2, c.drdl01ac21 as Level_2_Description,  " & _
        "d.drkyac22 as Level_3, d.drdl01ac22 as Level_3_Description,  " & _
        "g.aladd2 as Address, g.aladd3 as Address, g.aladd4 as Address, g.alcty1 as City, g.alcoun as County, g.alctr as Country " & _
        "FROM TRDTA.F0101 as a,  trdta.f0005_ac20 as b, trdta.f0005_ac21 as c, trdta.f0005_ac22 as d, trdta.f0005_ac23 as e, trdta.f0005_ac24 as f, trdta.f0116 as g  " & _
        "where ABAT1 IN ('V', 'VF', 'VM', 'VH') " & _
        "and trim(a.abac20) = trim(b.drkyac20) " & _
        "and trim(a.abac21) = trim(c.drkyac21) " & _
        "and trim(a.abac22) = trim(d.drkyac22) " & _
        "and a.aban8 = g.alan8 " & _
supNo & _
    supName & _
    cat20 & _
    cat21 & _
    cat22


        sqlconn.ConnectionString = connstr
        sqlconn.Open()
        sqlcmd.Connection = sqlconn

        sqlcmd.CommandText = sqlstr

        sqldr = sqlcmd.ExecuteReader


        GridView1.DataSource = sqldr
        GridView1.DataBind()
        sqldr.Close()
        sqlconn.Close()

This is the gridview as is currently stands...

 <asp:GridView ID="GridView1" runat="server" CellPadding="4" 
                EnableModelValidation="True" ForeColor="#333333" GridLines="None" 
                AllowPaging="false">

                 <Columns>
                    <asp:CommandField ShowSelectButton="True" />
                <%--    <asp:TemplateField>            
                    <ItemTemplate>                
                    <asp:CheckBox ID="chkSel" runat="server" />            
                    </ItemTemplate>        
                    </asp:TemplateField>--%>
                                       
                </Columns>

            <AlternatingRowStyle BackColor="White" />
            <EditRowStyle BackColor="#2461BF" />
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="False" ForeColor="White" Font-Size="12px" Font-Names="Arial" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" Font-Size="12px" Font-Names="Arial" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        </asp:GridView>

Any and all help very much appreciated.

thanks

Simon
ASKER CERTIFIED SOLUTION
Pratima Pharande

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros