定义类Ks 中读写属性
private int _kid; public int kid { get { return _kid; } set { _kid = value; } } private string _kname; public string kname { get { return _kname; } set { _kname = value; } } private string _kperson; public string kperson { get { return _kperson; } set { _kperson = value; } }定义获取整个表的函数
public List<Ks> SelectList(int id) { string strSql = "select * from 科室表 "; if (id > 0) { strSql += " where 编号=" + id; } DataTable objDataTable = StaticValue.SelectTable(strSql); //new SQLHelper().ExecuteSql(strSql, out objDataTable); List<Ks> lstKs = new List<Ks>(); foreach (DataRow row in objDataTable.Rows) { Ks objKs = new Ks(); objKs.kid = int.Parse(row["编号"].ToString()); objKs.kname = row["科室名称"].ToString(); objKs.kperson = row["科室负责人"].ToString(); lstKs.Add(objKs); } return lstKs; }初始化加载事件中使用（在web中）
protected void Page_Load(object sender, EventArgs e) { List<Ks> lstKs = new Ks().SelectList(0); this.szks.DataSource = lstKs; this.szks.DataValueField = "kid"; this.szks.DataTextField = "kname"; this.szks.DataBind(); }初始化加载事件中使用（在c# WindowsForm中）private void LoadKs() { List<Ks> lstKs = new Ks().SelectList(0); this.szks.DataSource = lstKs; this.szks.ValueMember = "kid"; this.szks.DataTextField = "kname"; this.cboLevel.SelectedIndex = 0;
}
