相关代码:
public partial class user_zhuce : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GirlsysConnectionString"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string str = "select * from types where classid=5";
SqlDataAdapter adp = new SqlDataAdapter(str,conn);
DataSet ds = new DataSet();
adp.Fill(ds,"yj");
sc.Items.Clear();
this.sc.Items.Insert(0, new ListItem("文本[请选择]", ""));
sc.DataSource=ds.Tables["yj"];
sc.DataTextField = "type";
sc.DataValueField = "id";
sc.DataBind();
}
}
运行后,值重复
public partial class user_zhuce : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GirlsysConnectionString"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string str = "select * from types where classid=5";
SqlDataAdapter adp = new SqlDataAdapter(str,conn);
DataSet ds = new DataSet();
adp.Fill(ds,"yj");
sc.Items.Clear();
this.sc.Items.Insert(0, new ListItem("文本[请选择]", ""));
sc.DataSource=ds.Tables["yj"];
sc.DataTextField = "type";
sc.DataValueField = "id";
sc.DataBind();
}
}
运行后,值重复
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GirlsysConnectionString"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string str = "select * from types where classid=5";
SqlDataAdapter adp = new SqlDataAdapter(str,conn);
DataSet ds = new DataSet();
adp.Fill(ds,"yj");
sc.Items.Clear();
sc.DataTextField = "type";
sc.DataValueField = "id";
sc.DataSource=ds.Tables["yj"];
sc.DataBind();
this.sc.Items.Insert(0, new ListItem("文本[请选择]", ""));
}
} 如果这样还重复,说明你查询出的数据是重复的。
用distinct
{
DropDownList2.Items.Clear();
Socut.Reader MinCheng = new Socut.Reader("SELECT * FROM Xian WHERE ChuanJian like '%" + "%" + "%'");
while (MinCheng.Read())
{
int nn = DropDownList2.Items.Count; bool kg = false;
string d_MinCheng = MinCheng["Ming_Cheng"].ToString();
for (int ii = 0; ii <= nn - 1; ii++)
{
string d_mlb = DropDownList2.Items[ii].Value;
if (d_mlb == d_MinCheng)
{ kg = true; break; }
}
if (kg == false && d_MinCheng != "") { DropDownList2.Items.Add(d_MinCheng); }
}
MinCheng.Close();
}呵呵,当时考一位教师时,教师自己给写的;另外还有SQL直接筛选的语句可以不重值:
"SELECT DISTINCT JIFAN FROM SHUXIN WHERE QUYU like '%"。。