40分发个简单的啦

[chenruoxi3001]

DAL层：
public DataSet Select1()
{
string sql = "select * from newclass";
SqlHelper help = new SqlHelper();
return help.run(sql, CommandType.Text, null);
}

SQLHelper:
public DataSet run(string cmdName, CommandType cmdType, SqlParameter[] Sqlparams)
{
myConnection = new SqlConnection(ConfigurationManager.AppSettings["SQLCONNECTIONSTRING"].ToString());
SqlCommand cmd = new SqlCommand(cmdName, myConnection);
cmd.CommandType = cmdType;

if(Sqlparams != null)
{
foreach (SqlParameter sp in Sqlparams)
{
cmd.Parameters.Add(sp);
}
}

SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
return ds;
}


页面我把DateSet绑定到dropdownlist上
public void Bind1()
{
DAL_NewClass dl = new DAL_NewClass();
DropDownList1.DataSource = dl.Select1().Tables[0].DefaultView;
DropDownList1.DataBind();
DropDownList1.DataTextField = "classname";
DropDownList1.DataValueField = "classid";
}


怎么显示不出数据呢？？？？？显示 很多System.Data.DataRowView

[wuyi8808]

DAL_NewClass dl = new DAL_NewClass();
DropDownList1.DataSource = dl.Select1().Tables[0].DefaultView;
DropDownList1.DataTextField = "classname";
DropDownList1.DataValueField = "classid";
DropDownList1.DataBind();

[zhangguofang1129]

public void Bind1()
{
DAL_NewClass dl = new DAL_NewClass();
DropDownList1.DataSource = dl.Select1().Tables[0].DefaultView;
DropDownList1.DataTextField = "classname";
DropDownList1.DataValueField = "classid";
DropDownList1.DataBind();
}

[chenruoxi3001]

谢谢，，知道了，，，没注意，，，原来这也又关系艘

[zhangguofang1129]

晕，没抢到沙发，楼主给分

[aluogang]

[Quote=引用 1 楼 wuyi8808 的回复:]
DAL_NewClass dl = new DAL_NewClass();
DropDownList1.DataSource = dl.Select1().Tables[0].DefaultView;
DropDownList1.DataTextField = "classname";
DropDownList1.DataValueField = "classid";
Dr……
[/Quote]
+1

[chenruoxi3001]

哈哈，，，今天aluogang帮我不少啊，，，谢谢，，

[houzhenya]

[Quote=引用 1 楼 wuyi8808 的回复:]
DAL_NewClass dl = new DAL_NewClass();
DropDownList1.DataSource = dl.Select1().Tables[0].DefaultView;
DropDownList1.DataTextField = "classname";
DropDownList1.DataValueField = "classid";
Dr……
[/Quote]```