using System.Data;            // Primary ADO.NET Namespace
using System.Data.OleDb;      // Tools for OLE Databases (such as MS Access)
using System.Data.SqlClient;  // SQL Server specific support

int age = int.Parse(myRecordet.Fields["Age"].ToString());  

int age = myDataset.Contacts.Age;

private string ClientName(int TimeLogID)
{
    ADODB.RecordsetClass rs = new ADODB.RecordsetClass();
    rs.ActiveConnection = adoConnection;
    rs.Source = "SELECT * FROM TimeLog WHERE TimeLogID=" + TimeLogID;
    int ProjectID = int.Parse(rs.Fields["ProjectID"].ToString());
    rs.Source = "SELECT * FROM Projects WHERE ProjectID=" + ProjectID;
    int ClientID = int.Parse(rs.Fields["ClientID"].ToString());
    rs.Source = "SELECT * FROM Clients WHERE ClientID=" + ClientID;
    return rs.Fields["Name"].ToString();
}

private string ClientName(int TimeLogID)
{
    ADODB.RecordsetClass rs = new ADODB.RecordsetClass();
    rs.ActiveConnection = adoConnection;
    string sql = "SELECT Clients.Name FROM Clients INNER JOIN (Projects " +
        "INNER JOIN TimeLog ON Projects.ProjectID = TimeLog.ProjectID) ON " +
        "Clients.ClientID = Projects.ClientID  WHERE TimeLog.TimeLogID=" +
        TimeLogID;
    rs.Source = sql;
    return rs.Fields["Name"].ToString();
}

private string ClientName(myDataSet.TimeLogRow tlr)
{
    return tlr.ProjectsRow.ClientsRow.Name;
}

private void btnFill_Click(object sender, System.EventArgs e)
{
    // Fills the form's dataset with
    // the 'Contacts' table from the database
    this.dbaContacts.Fill(dsMain);
}

private void btnUpdate_Click(object sender, System.EventArgs e)
{
    // End the editing on the current record, saving changes
    // to the underlying dataset
    BindingContext[dsMain, "Contacts"].EndCurrentEdit();

    // Updates the database with all the changes
    // made to the dataset's 'Contacts' table
    this.dbaContacts.Update(dsMain.Contacts);
}

private void btnNext_Click(object sender, System.EventArgs e)
{
    // Advances the form's data-bound controls by one record
    this.BindingContext[dsMain, "Contacts"].Position++;
}

private void btnBack_Click(object sender, System.EventArgs e)
{
    // Decrements the form's data-bound controls by one record
    this.BindingContext[dsMain, "Contacts"].Position--;
}

private void btnFirst_Click(object sender, System.EventArgs e)
{
    // Moves to the first record in the table
    this.BindingContext[dsMain, "Contacts"].Position = 0;
}

private void btnLast_Click(object sender, System.EventArgs e)
{
    // Moves to the last record in the table
    this.BindingContext[dsMain, "Contacts"].Position = 
        this.BindingContext[dsMain, "Contacts"].Count - 1;
}

private void btnDelete_Click(object sender, System.EventArgs e)
{
    // Deletes the current record
    this.BindingContext[dsMain, "Contacts"].RemoveAt(
        this.BindingContext[dsMain, "Contacts"].Position);
}

private void btnAddNew_Click(object sender, System.EventArgs e)
{
    // Adds a new record
    this.BindingContext[dsMain, "Contacts"].AddNew();
}

// Obtains the 'BindingManagerBase' for the 'Contacts' table
// Where 'dsMain' is the dataset and 'Contacts' is the table name
BindingManagerBase bmb = this.BindingContext[dsMain, "Contacts"];

// Number of records available in this table on the form
Console.WriteLine("Number of Records: " + bmb.Count);

// The position within the table of the current record
Console.WriteLine("Current Position: " + bmb.Position);

// Obtain the currently shown record (returns a DataRowView)
DataRowView drv = (DataRowView) bmb.Current; 

// Cast to the current type of DataRow
dsContacts.ContactsRow row = (dsContacts.ContactsRow) drv.Row;

// Now that we have the correct type, show this contact's name
Console.WriteLine("Current Contact's Name: " +
    row.FirstName + " " + row.LastName);

private void AddNewRecord()
{
    // Obtains the 'BindingManagerBase' for the 'Contacts' table
    // currently being used on this form
    BindingManagerBase bmb = this.BindingContext[dsMain, "Contacts"];

    // Display a message box asking if the current record should be kept
    DialogResult result =
        MessageBox.Show("Keep changes made to the current record?",
        "", MessageBoxButtons.YesNo);

    // If yes, end the editing of the current record, thereby saving it
    // otherwise disregard the changes made
    if (result == DialogResult.Yes) bmb.EndCurrentEdit();
    else bmb.CancelCurrentEdit();

    // Add a new record an navigate to it
    bmb.AddNew();

    // Obtain the current (new) row
    dsContacts.ContactsRow row =
        (dsContacts.ContactsRow) ((DataRowView) bmb.Current).Row;

    // Show that the current row state is 'Detached', it has
    // not actually been added to the underlying DataTable yet
    Console.WriteLine(row.RowState);

    // End the editing on this new row
    // The BindingManagerBase will add the row to the table
    bmb.EndCurrentEdit();

    // Show that the current row state is now 'Added', it has
    // now been put in the data table
    Console.WriteLine(row.RowState);
}

private void InitTextBox()
{
    // Attach events to the first/primary Binding class of txtPrice
    txtPrice.DataBindings[0].Format += new ConvertEventHandler(txtPrice_Format);
    txtPrice.DataBindings[0].Parse += new ConvertEventHandler(txtPrice_Parse);
}

private void txtPrice_Format(object sender, ConvertEventArgs e)
{
    // Make sure this direction is from the database to the form
    // If so, data comes in as a decimal and leaves as a currency string
    if (e.Value is decimal)
        e.Value = ((decimal) e.Value).ToString("c");
}

private void txtPrice_Parse(object sender, ConvertEventArgs e)
{
    // Make sure that the format wanted is a decimal
    if (e.DesiredType == typeof(decimal))
    {
        // Convert to correct type
        string price = e.Value.ToString();

        // Remove dollar signs and commas
        price = price.Replace("$", "").Replace(",", "");

        // Convert to the correct data type
        e.Value = decimal.Parse(price);
    }
}

private void ShowByState_Select(string state)
{
    // Filter the Contacts for those living in 'state',
    // sorted by 'LastName'
    DataRow[] results = this.dsMain.
        Contacts.Select("State='" + state + "'", "LastName");

    // Show the last name for each row in the results
    foreach (dsContacts.ContactsRow row in results)
        Console.WriteLine(row.LastName);
}

private void ShowByState_DataView(string state)
{
    // Create a new DataView object from the Contacts table
    // filtered by state and sorted by LastName
    // Include all rows that have not been deleted
    DataView dv = new DataView(dsMain.Contacts,
        "State='" + state + "'", "LastName", DataViewRowState.CurrentRows);
    
    // Show each results' LastName, not strongly-typed
    foreach (DataRowView drv in dv)
        Console.WriteLine(drv["LastName"].ToString());
}