public CreateTableForm()
{
InitializeComponent();
Table = new SqlDataTable();
Table.Columns.Add(new SqlDataColumn {
Name = "Id", IsPKey = true, DefaultValue = null, Nullable = false, Type = "Integer"
});
UpdateColumnDisplay();
}
private List <ISqlDataObject> GetObjects(string type)
{
var tableList = new List <ISqlDataObject>();
string sql = string.Format("SELECT * FROM SYS_OBJECTS WHERE type = '{0}';", type);
try
{
using (SqlDatabaseConnection con = new SqlDatabaseConnection(ConnectionString))
{
try
{
con.Open();
}
catch
{
return(tableList);
}
using (var cmd = new SqlDatabaseCommand(sql, con))
{
var rdr = cmd.ExecuteReader();
while (rdr.Read())
{
if (type == "table")
{
var table = new SqlDataTable
{
TableName = rdr.GetString(3),
Name = rdr.GetString(2),
ConnectionString = con.ConnectionString
};
if (table.Name != "sys_sequences")
{
tableList.Add(table);
}
}
else if (type == "view")
{
var view = new SqlDataView
{
TableName = rdr.GetString(3),
Name = rdr.GetString(2),
ConnectionString = con.ConnectionString
};
view.GetColumns(con);
tableList.Add(view);
}
else if (type == "index")
{
var index = new SqlDataIndex
{
TableName = rdr.GetString(3),
Name = rdr.GetString(2),
ConnectionString = con.ConnectionString
};
index.GetColumns(con);
tableList.Add(index);
}
}
}
}
}
catch (Exception ex)
{
SqlDatabaseConnection con = new SqlDatabaseConnection(ConnectionString);
MessageBox.Show("Error reading data from " + con.Database);
}
return(tableList);
}