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; }