/// <summary> /// 快速填充; /// 读取数据表,并设为列表控件的数据源; /// </summary> /// <param name="dbHelper">数据库助手</param> /// <param name="commandText">命令文本</param> /// <param name="listControl">列表控件</param> /// <param name="displayMember">显示值</param> /// <param name="valueMember">实际值</param> public static void QuickFill(this DbHelperBase dbHelper, string commandText, ListControl listControl, string displayMember = "Name", string valueMember = "No") { DataTable dataTable = dbHelper.NewCommand(commandText).ReturnTable(); listControl.DataSource = dataTable; listControl.DisplayMember = "Name"; listControl.ValueMember = "No"; }
/// <summary> /// 快速填充; /// 利用数据读取器,读取记录并添加至组合框控件的项集合; /// </summary> /// <param name="dbHelper">数据库助手</param> /// <param name="commandText">命令文本</param> /// <param name="comboBox">组合框控件</param> /// <param name="displayMember">显示值</param> public static void QuickFill(this DbHelperBase dbHelper, string commandText, ComboBox comboBox, string displayMember = "Name") { IDataReader dataReader = dbHelper.NewCommand(commandText).ReturnReader(); while (dataReader.Read()) { comboBox.Items.Add(dataReader[displayMember]); } }
/// <summary> /// 快速填充; /// 读取数据表,并设为数据网格视图的数据源; /// </summary> /// <param name="dbHelper">数据库助手</param> /// <param name="commandText">命令文本</param> /// <param name="dataGridView">数据网格视图</param> public static void QuickFill(this DbHelperBase dbHelper, string commandText, DataGridView dataGridView) { DataTable dataTable = dbHelper.NewCommand(commandText).ReturnTable(); dataGridView.DataSource = dataTable; }