string _last_sql = string.Empty;//最后执行的sql,用于刷新界面 /// <summary> /// 绑定列表数据 /// </summary> private void BindData() { var dt = ServerProxy.GetTable(_last_sql); dgv.DataSource = dt; dgv.Columns["Id"].Visible = false; dgv.Columns["CreateAt"].Visible = false; dgv.Columns["statu"].Visible = false; }
/// <summary> /// 初始化字典列表内容 /// </summary> private void InitDictItem() { //初始化代码 var sql = string.Format("sp_Search_dictionary '{0}','查询字段'", this.Text); var dt = ServerProxy.GetTable(sql); cbField.Items.Clear(); foreach (DataRow dr in dt.Rows) { cbField.Items.Add(dr["值"]); } if (cbField.Items.Count > 0) { cbField.SelectedIndex = 0; } }