前台实时获取数据库字典并展示

千门枫

已于 2022-07-24 16:44:30 修改

阅读量467

点赞数

文章标签：数据库 c#

于 2022-07-23 10:49:29 首次发布

本文链接：https://blog.csdn.net/sunyuan005431/article/details/125944543

版权

如果想要把数据字典搬到前台，做到实时更新，就要每次去查数据库整体结构，并做好字段的中文标识，有点不用多说，至少实时

public override void ExcuteQuery(string strwhere)
{
btnDelete.Enabled = btnEdit.Enabled = false;
DataSet ds = dcdata.SelectDataDictionaryData(strwhere);
if (ds != null && ds.Tables.Count > 1)
{
masterTable = ds.Tables[0];
detailTable = ds.Tables[1];
mBs.DataSource = masterTable;
this.masterGridControl.DataSource = mBs;
}
else
mBs.DataSource = null;
}
private void MBs_CurrentChanged(object sender, EventArgs e)
{
DataRowView row = (DataRowView)mBs.Current;
if (row != null)
{
string tablename = PubFuncs.FormatString(row[“TABLENAME”]);
DataView view = detailTable.DefaultView;
view.RowFilter = " TABLENAME=‘" + tablename + "’";
dBs.DataSource = view.ToTable();
this.detailGridControl.DataSource = dBs;
bool editable = tablename.Contains(“TABLE_”) ? true : false;
btnDelete.Enabled = btnEdit.Enabled = editable;
}
else
dBs.DataSource = null;
}