1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
OleDbConnection oleDbConnex=
new OleDbConnection("Provider=SQLNCLI;Server=" + "server\\SQLExpress" + ";Database=" + "EDV" + ";Trusted_Connection=" + "Yes" + ";");
DataSet ds = new DataSet();
OleDbCommand cmd = new OleDbCommand("select * from EDV_ARTICLE", oleDbConnex);
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds,"ARTICLE");
cmd.CommandText = "SELECT * FROM EDV_MATTER";
da.SelectCommand = cmd;
da.Fill(ds, "MATTER");
oleDbConnex.Close();
DataRelation dr = new DataRelation("dr",
ds.Tables["MATTER"].Columns["MAT_L_MATTER"],
ds.Tables["ARTICLE"].Columns["ART_N_MATTER"]);
ds.Relations.Add(dr);
this.gridArticle.DataSource = ds;
this.gridArticle.DataMember = "ARTICLE";
this.tbART_L_ARTICLE.DataBindings.Add(new Binding("Text", ds, "ARTICLE.ART_L_ARTICLE"));
this.tbART_NAME.DataBindings.Add(new Binding("Text", ds, "ARTICLE.ART_NAME"));
this.cbMAT_NAME.DataSource = ds.Tables["MATTER"]; |
Partager