drpdown list使用查询填充 [英] drpdown list fill using query

问题描述

 SqlCommand cmd = new SqlCommand（select * from user_login where groupid = 1，cnn）; 
 SqlDataAdapter da = new SqlDataAdapter（cmd）; 
 DataSet ds = new DataSet（）; 
 da.Fill（ds）; 
 
 
 ddlstudentname.DataTextField =name; 
 ddlstudentname.DataBind（）; 
 

i必须填写下拉列表中的名称（来自查询的名称）。但是这个编码不起作用。没有给出错误什么是问题。

解决方案

你没有将DataSet分配给你的DropDownList。 br />


请试试这个

 SqlCommand cmd =  new  SqlCommand（  select * from user_login where groupid = 1，cnn）; 
 SqlDataAdapter da =  new  SqlDataAdapter（cmd）; 
 DataSet ds =  new  DataSet（）; 
 da.Fill（ds）; 
 ddlstudentname.DataSource = ds; 
 ddlstudentname.DataTextField =   name; 
 ddlstudentname.DataVlaueField =   name; 
 ddlstudentname.DataBind（）; 
 

见下面的代码。

Bold Case是新添加的行。

< pre lang =c＃> SqlCommand cmd = new SqlCommand（ select * from user_login where groupid = 1，cnn）;
SqlDataAdapter da = new SqlDataAdapter（cmd）;
DataSet ds = new DataSet（）;
da.Fill（ds）;

ddlstudentname.DataSource = ds;
ddlstudentname.DataVlaueField = name;
ddlstudentname.DataTextField = name;

ddlstudentname.DataBind（）;

SqlCommand cmd = new SqlCommand("select * from user_login where groupid=1", cnn);
          SqlDataAdapter da = new SqlDataAdapter(cmd);
          DataSet ds = new DataSet();
          da.Fill(ds);


          ddlstudentname.DataTextField="name";
          ddlstudentname.DataBind();

i have to fill dropdown list with name ( name comming from query).but this coding not working.Not give error.what is problem.

解决方案

Hi,

your not assign the DataSet to your DropDownList.

Please try this

SqlCommand cmd = new SqlCommand("select * from user_login where groupid=1", cnn);
          SqlDataAdapter da = new SqlDataAdapter(cmd);
          DataSet ds = new DataSet();
          da.Fill(ds);
          ddlstudentname.DataSource=ds;
          ddlstudentname.DataTextField="name";
          ddlstudentname.DataVlaueField="name";
          ddlstudentname.DataBind();

See Below code.
Bold Case is newly added line.

SqlCommand cmd = new SqlCommand("select * from user_login where groupid=1", cnn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);

ddlstudentname.DataSource=ds;
ddlstudentname.DataVlaueField="name";
ddlstudentname.DataTextField="name";

ddlstudentname.DataBind();

这篇关于drpdown list使用查询填充的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！