show label data based on gridview data

Question

show label data based on gridview data

RAVI 1,076

Hello

I have girdivew1 in that i have this data forexample

User's image

And i have one dropdownlist and one label

if i select from dropdownlist MANGO it has to in label as 10

if i select from dropdownlist APPLE it has to in label as 4

how to do so

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Hi @RAVI,

Is your girdivew data obtained from the database? If so, you can refer to the code below.

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.7.1/jquery.min.js"></script>
    <script>
        $(function () {
            $("#DropDownList1").change(function () {
                document.getElementById('Label1').innerHTML = this.value;
            })
        })
    </script>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <asp:DropDownList ID="DropDownList1" runat="server"></asp:DropDownList>
            <asp:Label ID="Label1" runat="server"></asp:Label>
            <asp:GridView ID="GridView1" runat="server"></asp:GridView>
        </div>
    </form>
</body>
</html>

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        string constr = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT Field1,  Field2, Field3 FROM Table_1"))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    cmd.Connection = con;
                    sda.SelectCommand = cmd;
                    using (DataTable dt = new DataTable())
                    {
                        sda.Fill(dt);
                        GridView1.DataSource = dt;
                        GridView1.DataBind();
                        DropDownList1.DataSource = dt;
                        DropDownList1.DataBind();
                        DropDownList1.DataValueField = "Field2";
                        DropDownList1.DataTextField = "Field1";
                        DropDownList1.DataBind();
                        DropDownList1.Items.Insert(0, "Select");
                    }
                }
            }
        }
    }
}

User's image

Best regards,
Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

RAVI 1,076 Reputation points

2024-04-04T09:18:19.1866667+00:00

If Two data then its not working for example

APPLE 4

APPLE 2
Lan Huang-MSFT 30,206 Reputation points Microsoft External Staff

2024-04-05T01:35:19.7933333+00:00

Hi @RAVI,

If Two data then its not working for example

The above method is not suitable for obtaining two data. To obtain two pieces of data, you need to match the database value based on the Id. Refer to the code below:

<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" AutoPostBack="true" OnSelectedIndexChanged="OnSelectedIndexChanged"></asp:DropDownList> <br /> Field2: <asp:Label ID="Label1" runat="server"></asp:Label><br /> Field4: <asp:Label ID="Label2" runat="server"></asp:Label> <asp:GridView ID="GridView1" runat="server"></asp:GridView> </div> </form> </body> </html>

string constr = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString; SqlConnection con; SqlDataAdapter adapt; DataTable dt; protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { dt = new DataTable(); con = new SqlConnection(constr); con.Open(); adapt = new SqlDataAdapter("SELECT * FROM Table_1", con); adapt.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); DropDownList1.DataSource = dt; DropDownList1.DataBind(); DropDownList1.DataValueField = "Id"; DropDownList1.DataTextField = "Field1"; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, "Select"); con.Close(); } } protected void OnSelectedIndexChanged(object sender, EventArgs e) { var id = DropDownList1.SelectedItem.Value; con = new SqlConnection(constr); con.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM Table_1 where ID=@id", con); cmd.Parameters.AddWithValue("@id", DropDownList1.SelectedItem.Value); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); Label1.Text = dt.Rows[0]["Field2"].ToString(); Label2.Text = dt.Rows[0]["Field4"].ToString(); }
Lan Huang-MSFT 30,206 Reputation points Microsoft External Staff

2024-04-08T06:40:28.0133333+00:00

Hi @RAVI,

May I know if you have got any chance to check my reply? Please feel free to share more detailed information to us and it will be very helpful for us to better work out this issue.

Share via

show label data based on gridview data

0 additional answers

Your answer