LectorSP,
Это не сложно
| Код |
private void frmMyForm_Load(object sender, EventArgs e)
{
con = new OleDbConnection();
con.ConnectionString = @"provider=Microsoft.Jet.oledb.4.0;" +
@"data source=D:\vti\Margo\Cyberpro.mdb";
ds = new DataSet();
//maken tabelen in DataSet
String sql = "select * from tblKlanten order by [Naam klant]";
da = new OleDbDataAdapter(sql, con);
da.Fill(ds, "klanten");
sql = "select * from [tblArtikels_(verkoop)] order by [Code artikel]";
da = new OleDbDataAdapter(sql, con);
da.Fill(ds, "artikelen");
sql = "select * from tblVerkopen";
da = new OleDbDataAdapter(sql, con);
da.Fill(ds, "verkopen");
con.Close();
}
|
 |