private void btnGetTables_Click(object sender, EventArgs e)
{
try
{
//获取用户表和视图
DataTable dt = ORMTools.GetU_V(txtConnString.Text);
if (dt.Rows.Count > 0)
{
lbxTables.Properties.Items.Clear();
//显示表名
foreach (DataRow dr in dt.Rows)
{
lbxTables.Properties.Items.Add(dr["name"]);
}
if (lbxTables.Properties.Items.Count > 0)
{
lbxTables.SelectedIndex = 0;
}
lbxTables.ShowPopup();
}
else
{
MessageBox.Show("当前数据库没有用户表和视图!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnGetStuct_Click(object sender, EventArgs e)
{ //取表结构
try
{
DataTable dtColumns = ORMTools.GetTableStructure(txtConnString.Text, this.SelectedTableName);
DataTable result = ORMTools.CreateMapList(dtColumns, cbxDbType.Checked);
gcStuct.DataSource = null;
gcStuct.DataSource = result;
}
catch (Exception x)
{
MessageBox.Show(x.Message.ToString());
}
}
