<asp:GridView ID="GridView2" runat="server" DataSourceID="SqlDataSource1">
                </asp:GridView>
 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:BingQiHuaGongConnectionString %>"
        SelectCommand="select b.companyname,b.companyType,a.re,b.tel,b.fax,b.webAddress,b.email,&#13;&#10;a.companyState,a.price,a.scale,a.sl ,a.Pricesl,&#13;&#10;a.relationkey,a.amount from proandcomp_tb as &#13;&#10;a inner join companyinfo_tb as b on b.companyKey=a.companykey&#13;&#10;where a.prokey=@prokey  and b.companyType= @companyType&#13;&#10;order by a.scale desc" DeleteCommand="delete proandComp_tb where relationkey=@relationKey">
        <SelectParameters>
            <asp:SessionParameter DefaultValue="" Name="proKey" SessionField="proKey" />
            <asp:SessionParameter DefaultValue=" " Name="companyType" SessionField="CompanyType" />
        </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="relationKey" />
        </DeleteParameters>
    </asp:SqlDataSource>