无法从连接到数据库的下拉列表中检索数据 [英] data can't be retrieved from drop down connected to database

问题描述

我正在使用以下代码填充下拉列表.这些值是从sql server中的表中导入的.代码中没有错误，但未检索到数据.问题是什么?提前谢谢.

I am using the following coding to fill a drop down list.The values are imported from a table in sql server.There''s no error in the code but the data isn''t retrieved. What is the problem? Thanks in advance.

SqlDataAdapter da;
SqlConnection con;
SqlCommand com;

string connect = ConfigurationSettings.AppSettings["connstring"];
con = new SqlConnection(connect);
con.Open();


com = new SqlCommand("select PostCode from PostCode", con);
da = new SqlDataAdapter(com);
DataTable dt = new DataTable();
da.Fill(dt);
PostCode.DataSource = dt;
PostCode.DataTextField = "PostCode";
PostCode.DataBind();
con.Close();

推荐答案

Smrng，

尝试这样使用！！

Hi Smrng,

try to use like this!!

ddl.datasource = dt;
PostCode.DataTextField = "PostCode";

PostCode.DataValueField = "PostCode";

 PostCode.DataBind();


otherwise use this


 string qry1 = "select RoutNo from Tbl_Bus_RoutDetails";
        da = new SqlDataAdapter(qry1, con);

        da.Fill(ds, "Tbl_Bus_RoutDetails");
        dt = ds.Tables["Tbl_Bus_RoutDetails"];

        DropDownList1.Items.Clear();
        foreach (DataRow Row in dt.Rows)
        {
            ListItem item1 = new ListItem();
            item1.Value = Row[0].ToString();
            DropDownList1.Items.Add(item1.Value);
        }
        DropDownList1.Items.Insert(0, new ListItem("Select", "Default value"));
        da.Dispose();

问候
sarva

regards
sarva

SqlDataAdapter da;
SqlConnection con;
SqlCommand com;

字符串连接= ConfigurationSettings.AppSettings ["connstring"];
con =新的SqlConnection(connect);
con.Open();


com = new SqlCommand(从PostCode中选择PostCode"，骗局);
da =新的SqlDataAdapter(com);
DataTable dt = new DataTable();
da.Fill(dt);
PostCode.DataSource = dt;
PostCode.DataTextField ="PostCode";
postcode.DatavalueField =提供值"
PostCode.DataBind();
con.Close();

SqlDataAdapter da;
SqlConnection con;
SqlCommand com;

string connect = ConfigurationSettings.AppSettings["connstring"];
con = new SqlConnection(connect);
con.Open();


com = new SqlCommand("select PostCode from PostCode", con);
da = new SqlDataAdapter(com);
DataTable dt = new DataTable();
da.Fill(dt);
PostCode.DataSource = dt;
PostCode.DataTextField = "PostCode";
postcode.DatavalueField="Provide value"
PostCode.DataBind();
con.Close();

尝试一下:

Try This:

 private void FillDropDownList1()
    {
        con.open();
        DataSet ds = new DataSet();
        SqlDataAdapter myda = new SqlDataAdapter("select PostCode from PostCode", connection Object);
        myda.Fill(ds);
        Drop_Postcode.DataSource = ds;
        Drop_Postcode.DataValueField = "Postcode";
        Drop_Postcode.DataBind();

    }

Call this function In Page Load Event....

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            FillDropDownList1();
        }
        
    }


if any Query,Please Post It....

这篇关于无法从连接到数据库的下拉列表中检索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！