如何将数据绑定到gridview中的下拉列表 [英] how bind data to a dropdown in gridview

问题描述

大家好，

我在grid中有一个下拉列表.在这里，我的问题是如何将数据库数据绑定到我正在使用vb.net 2.0的网格中的下拉列表中，所以请帮助我.

在此先感谢
Seshu

Hi all,

I have dropdown list in grid .here my question is how to bind the database data to the dropdown list in grid i am using vb.net 2.0 so please help me.

Thanks in Advance
Seshu

推荐答案

您尝试 CP文章 [

Did you try googling[^] this first? Or CP Articles[^]? Is this a windows forms app? Web app? What have you tried? Why isn''t it working? What errors are you getting?

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            obj.da = new SqlDataAdapter("select Group_ID, Group_Name from dbo.Group_Details where MobileNo=''" + Session["MobNo"].ToString() + "''", obj.cn);
            ds.Reset();
            obj.da.Fill(ds);
            DropDownList groupdwn = (DropDownList)e.Row.FindControl("DropDownList2");
            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                groupdwn.DataSource = ds;
                groupdwn.DataValueField = "Group_ID";
                groupdwn.DataTextField = "Group_Name";
                groupdwn.DataBind();
                groupdwn.Items.Insert(0, new ListItem("Select", "0"));
            }
            else
            {
                groupdwn.DataSource = null;
                groupdwn.DataBind();
                groupdwn.Items.Insert(0, new ListItem("Select", "0"));

            }
        }
    }

这篇关于如何将数据绑定到gridview中的下拉列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！