access database question

S

slip

Member
Joined
Feb 27, 2005
Messages
7
Im using C# 2003 and right now im reading and writing directly to the database, but I belive at some point soon I will need to use datasets, I have never used datasets before so I have a few questions about them.
1. how easy will it be to convert my current update/read functions, or am I going to have to recode it all?

2. When using datasets 1 dataset will hold all my tables right or do I need to create a dataset for each table?

also if anyone knows of a good sample of doing this a link would be great

cheers :D
 
1. Since you are connecting to Access, I assume you already have an OleDbCommand. If this is the case then you only need to create an OleDbDataAdapter instance. From there you can fill a DataSet instance:
C#: 
using System;
using System.Data;
using System.Data.OleDb;

// ...

OleDbConnection conn = new OleDbConnection("YOUR CONNECTION STRING");
conn.Open();

OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "SELECT * FROM People";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;

OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);

conn.Close();

foreach (DataTable dt in ds.Tables)
{
    Console.WriteLine("TABLE: " + dt.TableName);

    foreach (DataRow dr in dt.Rows)
    {
        // access field with dr["FieldName"]
    }
}

2. Each DataSet has a collection of DataTables. See the above example.
 
Now when I load in all my tables can I just use this for each new table
cmd = new OleDbCmmand()

and do updates to datasets work the same way as directly to the database,
and can I use my current commands to check the dataset?
 
Back
Top