private void Form1_Load(object sender, EventArgs e)
{
SqlConn.OpenConn();
dataSet = new DataSet();
bindingSourceFirst = new BindingSource();
dataAdapterFirst = new SqlDataAdapter(ConfigurationManager.AppSettings.Get("selectAllFromParent"), SqlConn.connection);
dataAdapterSecond = new SqlDataAdapter(ConfigurationManager.AppSettings.Get("selectAllFromChildren"), SqlConn.connection);
commandBuilder = new SqlCommandBuilder(dataAdapterSecond);
dataAdapterFirst.Fill(dataSet, ConfigurationManager.AppSettings.Get("ParentTable"));
dataAdapterSecond.Fill(dataSet, ConfigurationManager.AppSettings.Get("ChildTable"));
DataRelation dr = new DataRelation(ConfigurationManager.AppSettings.Get("FkServ"),
dataSet.Tables[ConfigurationManager.AppSettings.Get("ParentTable")]
.Columns[ConfigurationManager.AppSettings.Get("FK")],
dataSet.Tables[ConfigurationManager.AppSettings.Get("ChildTable")]
.Columns[ConfigurationManager.AppSettings.Get("FK")]);
dataSet.Relations.Add(dr);
bindingSourceFirst = new BindingSource
{
DataSource = dataSet,
DataMember = ConfigurationManager.AppSettings.Get("ParentTable")
};
bindingSourceSecond = new BindingSource();
bindingSourceSecond.DataSource = bindingSourceFirst;
bindingSourceSecond.DataMember = ConfigurationManager.AppSettings.Get("FkServ");
GridFirst.DataSource = bindingSourceFirst;
GridSecond.DataSource = bindingSourceSecond;
}
public static void ConnectionState()
{
string msg = "Connection state: " + "The connection is ";
string title = SqlConn.myApp();
MessageBoxButtons btn = MessageBoxButtons.OK;
MessageBoxIcon icon = MessageBoxIcon.Information;
MessageBox.Show(msg + connection.State.ToString(), title, btn, icon);
}
public static void OpenConn()
{
connection.Close();
try
{
connection.ConnectionString = SqlConn.GetConnectionString();
connection.Open();
}
catch (Exception e)
{
MessageBox.Show("The sysyem failed to establish a connection." + Environment.NewLine + e);
}
//finally
//{
// ConnectionState();
//}
}
public Form1()
{
InitializeComponent();
this.Text = SqlConn.myApp();
}
private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
SqlConn.CloseConn();
}