private void Compact_NS_Load(object sender, EventArgs e)
{
AccessDB aa = new AccessDB();
List <string> colomn_name;
colomn_name = aa.GetTableColumnNames(table.Text);
Des1.Tag = colomn_name[1];
Des2.Tag = colomn_name[2];
Des3.Tag = colomn_name[3];
Des4.Tag = colomn_name[4];
Des5.Tag = colomn_name[5];
Des6.Tag = colomn_name[6];
Des7.Tag = colomn_name[7];
Des8.Tag = colomn_name[8];
Des9.Tag = colomn_name[9];
Des10.Tag = colomn_name[10];
Des11.Tag = colomn_name[11];
Des12.Tag = colomn_name[12];
Des13.Tag = colomn_name[13];
Des14.Tag = colomn_name[14];
Ref1.Tag = colomn_name[15];
Ref2.Tag = colomn_name[15];
Ref3.Tag = colomn_name[15];
Des1.DataSource = aa.GetData(aa.Dic_in, table.Text, Des1.Tag.ToString()); //data source accept list
Des9.DataSource = aa.GetData(aa.Dic_in, table.Text, Des9.Tag.ToString()); //data source accept list
Des12.DataSource = aa.GetData(aa.Dic_in, table.Text, Des12.Tag.ToString()); //data source accept list
}
private void Des4_SelectedIndexChanged(object sender, EventArgs e)
{
AccessDB aa = new AccessDB();
aa.Dic_in.Add(Des4.Tag.ToString(), Des4.Text);
Des5.DataSource = aa.GetData(aa.Dic_in, table.Text, Des5.Tag.ToString());//data source accept list
}
private void Des5_SelectedIndexChanged(object sender, EventArgs e)
{
AccessDB aa = new AccessDB();
aa.Dic_in.Add(Des4.Tag.ToString(), Des4.Text);
aa.Dic_in.Add(Des5.Tag.ToString(), Des5.Text);
if (Des5.SelectedIndex > 0)
{
Ref2.Text = aa.GetData(aa.Dic_in, table.Text, Ref2.Tag.ToString())[1];
Des6.Text = aa.GetData(aa.Dic_in, table.Text, Des6.Tag.ToString())[1];//data source accept list
}
else
{
Ref2.Text = "";
Des6.Text = "";
}
}
private void Des3_SelectedIndexChanged(object sender, EventArgs e)
{
AccessDB aa = new AccessDB();
aa.Dic_in.Add(Des1.Tag.ToString(), Des1.Text);
aa.Dic_in.Add(Des2.Tag.ToString(), Des2.Text);
aa.Dic_in.Add(Des3.Tag.ToString(), Des3.Text);
if (Des3.SelectedIndex > 0)
{
Ref1.Text = aa.GetData(aa.Dic_in, table.Text, Ref1.Tag.ToString())[1];
Note1.Text = aa.GetData(aa.Dic_in, table.Text, Note1.Tag.ToString())[1];
}
else
{
Ref1.Text = "";
Note1.Text = "";
}
}
private void VigilohmCables_Load(object sender, EventArgs e)
{
AccessDB aa = new AccessDB();
List <string> colomn_name;
colomn_name = aa.GetTableColumnNames(table.Text);
Des1.Tag = colomn_name[1];
Des2.Tag = colomn_name[2];
Des3.Tag = colomn_name[3];
Des4.Tag = colomn_name[4];
Des5.Tag = colomn_name[5];
Des6.Tag = colomn_name[6];
Ref1.Tag = colomn_name[7];
Ref2.Tag = colomn_name[7];
Ref3.Tag = colomn_name[7];
Des1.DataSource = aa.GetData(aa.Dic_in, table.Text, Des1.Tag.ToString()); //data source accept list
Des3.DataSource = aa.GetData(aa.Dic_in, table.Text, Des3.Tag.ToString()); //data source accept list
Des5.DataSource = aa.GetData(aa.Dic_in, table.Text, Des5.Tag.ToString()); //data source accept list
}
private void ControlAuxiliaries_Load(object sender, EventArgs e)
{
AccessDB aa = new AccessDB();
List <string> colomn_name;
colomn_name = aa.GetTableColumnNames(table.Text);
Des1.Tag = colomn_name[1];
Des2.Tag = colomn_name[2];
Des3.Tag = colomn_name[3];
Note1.Tag = colomn_name[4];
Note2.Tag = colomn_name[5];
Ref1.Tag = colomn_name[6];
Des1.DataSource = aa.GetData(aa.Dic_in, table.Text, Des1.Tag.ToString());//data source accept list
}
private void Des2_SelectedIndexChanged(object sender, EventArgs e)
{
AccessDB aa = new AccessDB();
aa.Dic_in.Add(Des1.Tag.ToString(), Des1.Text);
aa.Dic_in.Add(Des2.Tag.ToString(), Des2.Text);
//description.DataSource = aa.GetData(aa.Dic_in, table.Text, description.Name);//data source accept list
if (Des2.SelectedIndex > 0)
{
Ref1.Text = aa.GetData(aa.Dic_in, table.Text, Ref1.Tag.ToString())[1];
}
else
{
Ref1.Text = "";
}
}
