Database

var ds = new DataSet();

using (var connection = new SqlConnection("..."))
{
    var da = new SqlDataAdapter("SELECT ...", connection);
    da.SelectCommand.Parameters.AddWithValue(...);
    da.Fill(ds, "FirstTable");
}

using (var connection = new OleDbConnection("..."))
{
    var da = new OleDbDataAdapter("SELECT ...", connection);
    da.SelectCommand.Parameters.AddWithValue(...);
    da.Fill(ds, "SecondTable");
}

Create table tutor(
id integer, auto_increment;
tutorName varchar(50), not null,
tutorNRIC varchar(50), not null, (Primary Key)
tutorEmail varchar(50), not null,
);

Create table subject(
id integer, auto_increment;
subject varchar950), not null;
subject_id, integer, not null, (Primary Key)
_;

Create table tutor_subject(
tutorNRIC integer,
subject_id integer,
Primary Key(tutorNRIC, subject_id),
Foreign Key(tutorNRIC) references tutor(tutorNRIC),
Foreign Key(subject_id) references subject(subject_id));

karengsh wrote:

Is it possible to use tutorNRIC as my primary key

karengsh wrote:

my tutorID is just an index for me to keep track how many people have signed up.

karengsh wrote:

And I'd like tutorID as my index with incremental value