In C# how to I query from an access database using a Windows Application?

// assumes dropping values into a textboxes on a form
playerFirstName.Text = dr.GetValue(0).ToString());
playerLastName.Text = dr.GetValue(1).ToString());
playerHomeTown.Text = dr.GetValue(2).ToString());

I just made up the names of the textboxes (playerFirstName.Text, etc).  Do you actually have these text boxes in the form?

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.Sql;

namespace WindowsApplication1

public partial class SB : Form

public SB()

private void Form1_Load(object sender, EventArgs e)

// TODO: This line of code loads data into the 'steelersDataSet.Player' table. You can move, or remove it, as needed.

this.playerTableAdapter.Fill(this.steelersDataSet.Player);

private void button1_Click(object sender, EventArgs e)

int playerNum = 7;

if (player.Text == "b")

pic.Visible = true;

bio.Visible = true;

pic.Image = Image.FromFile("C:\\Documents and Settings\\Brandi\\Desktop\\Ben.jpg");

this.Cursor = Cursors.WaitCursor;

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\My Documents\Steelers.mdb");

string sSql = "SELECT * FROM player WHERE (number='" + playerNum,ToString() + "')";

OleDbCommand cmd = new OleDbCommand(sSql, conn);

if (dr.HasRows == true)

while (dr.Read())

try

// assumes dropping values into a textboxes on a form

catch

// go on to the next

catch (Exception ex)

MessageBox.Show(ex.Message.ToString() + " : " + ex.StackTrace.ToString(), "Load Error");

this.Cursor = Cursors.Default;

private void clear_Click(object sender, EventArgs e)

bio.Visible = false;

pic.Visible = false;

this.Cursor = Cursors.WaitCursor;
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\YourFolder\YourAccessDb.mdb");

try
{
     conn.Open();

     string sSql = "SELECT * FROM players WHERE (number='" + playerNum,ToString() + "')";
     OleDbCommand cmd = new OleDbCommand(sSql, conn);
     OleDbDataReader dr = cmd.ExecuteReader();

     if (dr.HasRows == true)
     {
          while (dr.Read())
          {
               try
               {
                   // assumes dropping values into a textboxes on a form
                    playerFirstName.Text = dr.GetValue(0).ToString());
                    playerLastName.Text = dr.GetValue(1).ToString());
                    playerHomeTown.Text = dr.GetValue(2).ToString());
               }
               catch
               {
                    // go on to the next
               }
          }
     }
}
catch (Exception ex)
{
     MessageBox.Show(ex.Message.ToString() + " : " + ex.StackTrace.ToString(), "Load Error");
}
finally
{
     conn.Close();
     this.Cursor = Cursors.Default;
}

private void button1_Click(object sender, EventArgs e)

if (player.Text == "b")

pic.Visible = true;

bio.Visible = true;

pic.Image = Image.FromFile("C:\\Documents and Settings\\Brandi\\Desktop\\Ben.jpg");

Select * from player where number = '7';

What does your code look like (including the select statement you are using)?