private void LoadDgw1() { string query = " select top " + txtRows.Text + " DESCRIPTION FieldName, count(*) Cnt " + " from dbo.SCA_TAB_COLUMNS " + " where DESCRIPTION <> '' " + " and DESCRIPTION like '" + txtCol.Text.Trim() + "%'"; query = query + " group by DESCRIPTION order by 1"; using (SqlConnection connection = new SqlConnection(GlobalVar.connString)) { connection.Open(); SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = connection; sqlCmd.CommandType = CommandType.Text; sqlCmd.CommandText = query; SqlDataAdapter sqlDataAdap = new SqlDataAdapter(sqlCmd); DataTable dtRecord = new DataTable(); sqlDataAdap.Fill(dtRecord); Dgw1.DataSource = dtRecord; Dgw1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } }
private void LoadDgw1() { string subQuery = " (SELECT sc.name scName, ta.name tbName " + " , SUM(pa.rows) RowCnt " + " FROM sys.tables ta " + " INNER JOIN sys.partitions pa " + " ON pa.OBJECT_ID = ta.OBJECT_ID " + " INNER JOIN sys.schemas sc " + " ON ta.schema_id = sc.schema_id " + " WHERE ta.is_ms_shipped = 0 AND pa.index_id IN(1, 0) " + " GROUP BY sc.name, ta.name "; if (rbRec.Checked == true) { subQuery = subQuery + " having SUM(pa.rows) > 0 "; } subQuery = subQuery + " )" + " x on SCHEMA_NAME(schema_id)=scName and name=tbName "; string query = " select top " + txtRows.Text + " SCHEMA_NAME(schema_id) as SchemaName, name TableName "; if (chkRowCnt.Checked == true) { query = query + " , RowCnt "; } query = query + " from sys.tables "; if (rbRec.Checked == true) { query = query + " inner join " + subQuery; } else if (chkRowCnt.Checked == true) { query = query + " left outer join " + subQuery; } query = query + " where name like '" + txtTable.Text.Trim() + "%'"; if (rbExist.Checked == true) { query = query + " and TableName<>''"; } using (SqlConnection connection = new SqlConnection(GlobalVar.connString)) { connection.Open(); SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = connection; sqlCmd.CommandType = CommandType.Text; sqlCmd.CommandText = query; SqlDataAdapter sqlDataAdap = new SqlDataAdapter(sqlCmd); DataTable dtRecord = new DataTable(); sqlDataAdap.Fill(dtRecord); Dgw1.DataSource = dtRecord; Dgw1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } }