C#

int selected = listView1.SelectedItems[0].Index;  // get the first selected item's index

textBox1.Text = listView1.Items[selected].Text // to get the data in the the first column.

textBox2.Text = listView1.Items[selected].SubItems[1].Text; // to get the data in the second column

private void button1_Click(object sender, EventArgs e)
{
    OpenFileDialog music = new OpenFileDialog();
    music.Title = "Add a music file";
    music.InitialDirectory = "C:\\";
    music.Filter = "Supported File Types|*.mp3,*.wma|All files (*.*)|*.*";
    music.FilterIndex = 2;
    music.RestoreDirectory = false;

    if (music.ShowDialog() == DialogResult.OK)
    {
        music.Multiselect = true;
        foreach (string fileName in music.FileNames)
        {
            textBox1.Text = fileName;
            textBox2.Text = "Audio";
            textBox3.Text = "Pending";
        }
        string[] myItems = new string[]
            {
                textBox1.Text,
                textBox2.Text,
                textBox3.Text
            };
        ListViewItem lvi = new ListViewItem(myItems);

        listView1.Items.Add(lvi);
    }

}

private void button6_Click(object sender, EventArgs e)
{
    string path = textBox1.Text;
    string path2 = textBox4.Text;

    try
    {
        // Copy the file.
        File.Copy(path, path2);
        this.syncstat.Text = "Status: Files Copied";
    }

    catch
    {
        this.syncstat.Text = "Status:  Cannot copy into the same folder";
    }

private void button6_Click(object sender, EventArgs e)
{
    int selected = listView1.SelectedItems[0].Index;  // get the first selected item's index
    textBox1.Text = listView1.Items[selected].Text; // to get the data in the the first column.
    textBox2.Text = listView1.Items[selected].SubItems[1].Text; // to get the data in the second column
    textBox3.Text = listView1.Items[selected].SubItems[2].Text;


}

SELECT * FROM Groups WHERE [Group] = 1

OleDbCommand cmd = new OleDbCommand("SELECT COUNT(*) FROM Groups", conn);

conn.Open();

OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
    int count = reader[0];
}

conn.Close();

<code>
static void Main(string[] args)
{
   string dataPath = @"C:\Documents and Settings\Administrator\Desktop\Transimount_Data.MDB";
   OleDbConnection conn = new OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0; data source=" + dataPath);

   OleDbCommand cmd = new OleDbCommand("SELECT COUNT(*) FROM Mounts WHERE Group_Number = 1", conn);

   conn.Open();
   int count = cmd.ExecuteScalar();
   conn.Close();

   Console.WriteLine(count); 
}
</code>