ASP.NET dropdownlist/gridview databinding using SqlDataSource

Hi,

I have to databind gridview with sproc resultset that has parameters from two DropDownLists. First  parameter should be equal the value of DataTextField and second should be equal the value of DataValueField . What should be written instead of ‘?????’ .

<asp:SqlDataSource  .....  >
  <SelectParameters>
    <asp:ControlParameter ControlID="DropDownList1" PropertyName="?????"  ... />
    <asp:ControlParameter ControlID="DropDownList2" PropertyName="?????"  ... />
  </SelectParameters>
</asp:SqlDataSource>


Thanks.
quasar_eeAsked:
Who is Participating?
 
guru_samiConnect With a Mentor Commented:
Try Text and SelectedValue properties
0
 
AliSyedCommented:
<asp:ControlParameter ControlID="DropDownList1" PropertyName="SelectedValue" />
    <asp:ControlParameter ControlID="DropDownList2" PropertyName="Text"/>
0
 
mr_nadgerConnect With a Mentor Commented:
example attached for you
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Default.aspx.vb" Inherits="dummy._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        text
        <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True">
            <asp:ListItem>Monday</asp:ListItem>
            <asp:ListItem>Tuesday</asp:ListItem>
            <asp:ListItem>Wednesday</asp:ListItem>
            <asp:ListItem>Thursday</asp:ListItem>
            <asp:ListItem>Friday</asp:ListItem>
            <asp:ListItem>Saturday</asp:ListItem>
            <asp:ListItem>Sunday</asp:ListItem>
        </asp:DropDownList>
        <br />
        <br />
        value         
        <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True">
            <asp:ListItem Value="1">High</asp:ListItem>
            <asp:ListItem Value="2">Low</asp:ListItem>
        </asp:DropDownList>
        
    
    </div>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ServiceBridgeV3ConnectionString %>" 
        SelectCommand="p_test" SelectCommandType="StoredProcedure">
        <SelectParameters>
            <asp:ControlParameter ControlID="DropDownList1" Name="day" 
                PropertyName="Text" Type="String" />
            <asp:ControlParameter ControlID="DropDownList2" Name="sev" 
                PropertyName="SelectedValue" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataKeyNames="intID" DataSourceID="SqlDataSource1">
        <Columns>
            <asp:BoundField DataField="intID" HeaderText="intID" InsertVisible="False" 
                ReadOnly="True" SortExpression="intID" />
            <asp:BoundField DataField="HPOVID" HeaderText="HPOVID" 
                SortExpression="HPOVID" />
        </Columns>
    </asp:GridView>
    </form>
</body>
</html>

Open in new window

0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
AliSyedCommented:
Gurusami already gave the same  answer i gave. Please do not accept my answer as solution.
0
 
quasar_eeAuthor Commented:
ok
0
 
quasar_eeAuthor Commented:
ok
0
 
Kumaraswamy RCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.