郑德才博客

//获取数据表信息并绑定到DataGridView中
TableClassBLL tableBLL = new TableClassBLL();
DataTable data = tableBLL.TableDBTable(where); //执行获取数据库中的表字段
DgvTable.DataSource = data;
DgvTable.AutoGenerateColumns = false; //手动生成列

public DataTable TableDBTable(string where)
{
DataTable db = null;
try
{
String tableSql = "select id, name from sysobjects where type = 'u'";

if (where != "")
{
tableSql = tableSql + where.Replace("where"," and ");
}
tableSql = tableSql + " order by name";

db = SQLDaoImpl.GetDBToDataTable(ConnHelper.getConnectionString(), tableSql);
//执行查询语句

db.Columns.Add("Valueid");
for (int i = 0; i < db.Rows.Count; i++)
{
if (db.Rows[i]["name"].ToString() != "")
{
db.Rows[i]["Valueid"] = (i + 1).ToString();
}
}
}
catch (Exception ex)
{
throw ex;
}
return db;
}