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