private void btnConnection_Click(object sender, EventArgs e)
{
DataTable dtData = new DataTable();
dtData.Columns.Add("s", typeof(bool));
dtData.Columns.Add("tablename", typeof(string));
dtData.Columns.Add("tablekey", typeof(string));
dtData.Columns.Add("tablemark", typeof(string));
databasename = this.tboxDatabaseName.Text.Trim();
string selectSql = Utility.GetTableQuery(databasename);
DataTable dataTable = getDatable(selectSql);
foreach (DataRow dr in dataTable.Rows)
{
selectSql = string.Format("exec sp_pkeys '{0}'", dr["TABLE_NAME"].ToString());
DataTable dataKey = getDatable(selectSql);
string strKey = dataKey.Rows.Count > 0 ? dataKey.Rows[0]["COLUMN_NAME"].ToString() : "";
dtData.Rows.Add(new object[] { false, dr["TABLE_NAME"].ToString(), strKey, "" });
}
this.dataGridView1.AutoGenerateColumns = false;
this.dataGridView1.DataSource = dtData;
}
