internal static DataSet GetTableColumns(string connectString, string tableName)
{
SqlConnection conn = new SqlConnection();
SqlCommand cmd = new SqlCommand();
DataSet tableColumns = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
try
{
conn.ConnectionString = connectString;
cmd.CommandText = GetSqlColumnsForTable(tableName);
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = conn;
da.SelectCommand = cmd;
da.Fill(tableColumns);
}
catch(Exception ex)
{
throw ex;
}
finally
{
if(conn != null)
conn.Close();
}
return tableColumns;
}