PLEASE HELP!!! almost got this working

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;

using System.Data.OleDb;

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);

string mFirstName = string.Empty;

string mLastName = string.Empty;

string mSql = string.Empty;

private void button1_Click(object sender, EventArgs e)

if (player.Text != string.Empty)

string[] arrName = player.Text.Split(' ');

this.Cursor = Cursors.WaitCursor;

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

try

string mSql = "SELECT * FROM player WHERE firstName='" + mFirstName +"' AND lastName='" + mLastName + "'";

OleDbCommand cmd = new OleDbCommand(mSql, conn);

OleDbDataReader dr = cmd.ExecuteReader();

if (dr.HasRows == true)

while (dr.Read())

try

// assumes dropping values into a textboxes on a form

bio.Text = "Name: " + dr.GetValue(0).ToString() + " " + dr.GetValue(1).ToString() + " \nNumber: " + dr.GetValue(2).ToString() + "\nPosition: " + dr.GetValue(3).ToString() + "\nDate Of Birth: " + dr.GetValue(4).ToString() + " \nExperience: " + dr.GetValue(5).ToString() + " \nCollege:" + dr.GetValue(6).ToString() + " \nHeight: " + dr.GetValue(7).ToString() + " \nWeight:" + dr.GetValue(8).ToString();

catch

// go on to the next

catch (Exception ex)

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

finally

this.Cursor = Cursors.Default;

private void clear_Click(object sender, EventArgs e)

pic.Visible = false;

bio.Visible = false;

helmet.Visible = false;

Set up some variables to hold the values collected:

string mFirstName = string.Empty;
string mLastName = string.Empty;
string mSql = string.Empty;

Split the content of the textbox text holding the player's name into a string array and then format your SQL statement:

You might want to use a like instead of an equal to in the WHERE clause in case the spelling does not match.  Better yet, use a first name and a separate last name textbox because if the player has a name like "Chi Chi" the first name will be set to "Chi" and the last name will be set to "Chi".