hi frds,
I want to show link b/w 2 table. Where both table is genrate at run time with same name.
& want to establish to relation .
but problem is how i access columns of both table ..
my code is
OleDbConnection con11;
OleDbDataAdapter daquery;
DataSet dsquery;
void chktable1_MouseDown(object sender, MouseEventArgs e)
{
CheckedListBox chktable1 = (CheckedListBox)sender;
mdown=chktable1.Name.ToString();
//MessageBox.Show(mdown);
Point ClickPoint = new Point(e.X, e.Y);
selectcdown = chktable1.SelectedItem.ToString();
//MessageBox.Show(selectcdown);
con11 = new OleDbConnection();
ss = ((MDIParent1)this.mdi_form).s5;
con11 = new OleDbConnection(ss);
daquery = new OleDbDataAdapter("Select * from " + mdown + " ", con11);
dsquery = new DataSet();
con11.Open();
daquery.Fill(dsquery, mdown);
}
string mup;
void chktable1_MouseUp(object sender, MouseEventArgs e)
{
CheckedListBox chktable1 = (CheckedListBox)sender;
mup = chktable1.Name.ToString();
string selectcup = chktable1.SelectedItem.ToString();
MessageBox.Show(selectcup);
daquery.SelectCommand = new OleDbCommand("Select * from " + mup + "", con11);
daquery.Fill(dsquery, mup);
dsquery.Relations.Add("Temp", dsquery.Tables[mdown].Columns[selectcdown], dsquery.Tables[mup].Columns[selectcup]);
}