想用listbox显示数据库中的表内容应该怎么写代码啊?
来源:百度知道 编辑:UC知道 时间:2024/06/19 14:46:03
这是DAL层的方法
public List<pro_GuibinUserInfo> SelectAll()
{
string sql = "select * from GuibinInfo";
using (OleDbConnection con = new OleDbConnection(AccessDBHelper.m_strConn))
{
DataTable dt = AccessDBHelper.ExecuteQuery(con, sql);
List<pro_GuibinUserInfo> list = new List<pro_GuibinUserInfo>();
for (int i = 0; i < dt.Rows.Count; i++)
{
pro_GuibinUserInfo model = new pro_GuibinUserInfo();
model.GuibinId = (int)dt.Rows[i]["GuibinId"];
model.GuibinName = (string)dt.Rows[i]["GuibinName"];
model.GuibinTell = (string)dt.Rows[i]["GuibinTell"];
model.GuibinNum = (string)dt.Rows[i]["GuibinNum"];