private void JoinButton_Click(object sender, EventArgs e)//Join swimmers
{
Form jointest = new JoinForm();
jointest.ShowDialog();
LoadData();
}
private void btnAddJoin_Click(object sender, EventArgs e)
{
var elementsForQuery = listBoxSelected.Items.Cast <string>().ToArray();
string Tables = String.Join(",", elementsForQuery.Select(x => x.Substring(0, x.IndexOf("."))).Distinct());
JoinForm joinForm = new JoinForm(metaDbContainer, dbConnection, Tables);
joinForm.ShowDialog();
if (joinForm.Status)
{
string newJoin = $"{joinForm.getOp} : {joinForm.getT1String}.{joinForm.getA1String} {joinForm.getOn} {joinForm.getT2String}.{joinForm.getA2String}";
listBoxJoins.Items.Add(newJoin);
}
}
