public FormJoin(List<string> sqlTable, string connectionString)
: this()
{
this.sqlTable = sqlTable;
int oldX = 0;
int oldY = 0;
foreach (var table in sqlTable)
{
var tableEntity = new Table();
tableEntity.Name = table;
tableEntity.setTitle(table);
DBService service = new DBService(connectionString);
List<QColumn> columns = service.GetColumns(table);
tableEntity.setSource(columns);
Point p = new Point();
p.X = panel1.Location.X + oldX;
p.Y = panel1.Location.Y + oldY;
tableEntity.Location = p;
oldX += tableEntity.Width + 5;
if (oldX > panel1.Width)
{
oldX = 0;
oldY += tableEntity.Height + 5;
}
tableEntity.MouseDown += new MouseEventHandler(Control_MouseDown);
tableEntity.MouseMove += new MouseEventHandler(Control_MouseMove);
tableEntity.MouseUp += new MouseEventHandler(Control_MouseUp);
panel1.Controls.Add(tableEntity);
}
panel1.Invalidate();
}
/// <summary>
/// An overloading constructor that accept a selected database and a connection string
/// </summary>
/// <param name="selectedDatabase">This is passed from the FormConectServer. We need this for our query statement that query the available tables in a database</param>
/// <param name="connectionString">This is a entire connection string. We need this to make a connection to our server</param>
public FormColumnSelection(string selectedDatabase, string connectionString)
{
InitializeComponent();
//begin showing the splashing screen
BackgroundWorker bw = new BackgroundWorker();
bw.WorkerSupportsCancellation = true;
bw.DoWork += new DoWorkEventHandler(bw_DoWork);
bw.RunWorkerAsync();
//load the real thing
this.selectedDatabase = selectedDatabase;
this.connectionString = connectionString;
service = new DBService(connectionString);
onLoadForm(); //end load real thing
bw.CancelAsync(); //close the splash screen
}
