public static DataTable DisplayAllColumnsName()
{
DataTable tempTable = new DataTable();
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
SqlCommand command = new SqlCommand("SELECT TABLE_NAME AS [Tabellens namn], COLUMN_NAME AS [Kolumnens namn] FROM INFORMATION_SCHEMA.COLUMNS " +
"JOIN TablesOfInterest AS[TI] ON INFORMATION_SCHEMA.COLUMNS.TABLE_NAME = TI.tableName; ", connection);
connection.Open();
//command.Prepare();
SqlDataReader dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
tempTable.Columns.Add("Tabellnamn", typeof(String));
tempTable.Columns.Add("Kolumnnamn", typeof(String));
while (dataReader.Read())
{
String tempOne = dataReader.GetString(0).ToString();
String tempTwo = dataReader.GetString(1).ToString();
tempTable.Rows.Add(new String[] { tempOne, tempTwo });
}
}
}
}
catch (SqlException e)
{
Controller_PCTwo.ErrorHandler(19171251);
MessageBox.Show(e.Message);
}
return(tempTable);
}
public static DataTable DisplayAllColumnsName(string specificTableName)
{
DataTable tempTable = new DataTable();
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string query = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS " +
"JOIN TablesOfInterest ON INFORMATION_SCHEMA.COLUMNS.TABLE_NAME = TablesOfInterest.tableName " +
"WHERE TablesOfInterest.tableName = @Value";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
command.Prepare();
command.Parameters.AddWithValue("@Value", specificTableName);
SqlDataReader dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
tempTable.Columns.Add("Kolumnnamn", typeof(String));
while (dataReader.Read())
{
String tempOne = dataReader.GetString(0).ToString();
tempTable.Rows.Add(tempOne);
}
}
}
}
catch (SqlException e)
{
Controller_PCTwo.ErrorHandler(19171252);
MessageBox.Show(e.Message);
}
return(tempTable);
}
public static DataTable DisplayNumberOfRows()
{
DataTable tempTable = new DataTable();
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
SqlCommand command = new SqlCommand("SELECT[Tables].name AS [Tabellens namn], SUM([Partitions].[rows]) AS[Antalet rader] " +
"FROM sys.tables AS[Tables] JOIN sys.partitions AS[Partitions] ON[Tables].[object_id] = [Partitions].[object_id] " +
"AND[Partitions].index_id IN(0, 1) JOIN TablesOfInterest ON[Tables].name = TablesOfInterest.tableName GROUP BY[Tables].name; ", connection);
connection.Open();
//command.Prepare();
SqlDataReader dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
tempTable.Columns.Add("Tabellnamn", typeof(String));
tempTable.Columns.Add("Antal rader", typeof(String));
while (dataReader.Read())
{
String tempOne = dataReader.GetString(0).ToString();
String tempTwo = dataReader.GetInt64(1).ToString();
tempTable.Rows.Add(new String[] { tempOne, tempTwo });
}
}
}
}
catch (SqlException e)
{
Controller_PCTwo.ErrorHandler(19171250);
MessageBox.Show(e.Message);
}
return(tempTable);
}