using System.Data;
using System.Data.OleDb;

public partial class GridHypher : System.Web.UI.Page
{
    OleDbConnection con = new OleDbConnection(@"access connection string");
    OleDbCommand cmd;
    OleDbDataAdapter da;
    DataTable dt = new DataTable();
   

    protected void Button1_Click(object sender, EventArgs e)
    {
        con.Open();
        cmd = new OleDbCommand("select * from emp where name='" + TextBox1.Text + "'", con); //here pass that name 
        da = new OleDbDataAdapter(cmd);
        da.Fill(dt);
        GridView1.DataSource = dt;
        GridView1.DataBind();  
    }
}

Dim strcon As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\sample.accdb;;Persist Security Info=False"
Dim con As New OleDbConnection(strcon)
Dim cmd As New OleDbCommand()
Dim da As New OleDbDataAdapter()
Dim dt As New DataTable()
Try
con.Open()
cmd = New OleDbCommand("select * from Table1", con)
da = New OleDbDataAdapter(cmd)
da.Fill(dt)
DataGridView1.DataSource = dt
con.Close()
Catch ex As Exception

End Try

private void button1_Click(object sender, EventArgs e)
        {
            DataTable dt = GetData("SELECT * FROM user", "user");
            dataGridView1.DataSource = dt;
            dataGridView1.DataMember = "user";
        }

        public OleDbConnection GetAccessCon(string strFilePath)
        {
            OleDbConnection accesscon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" +
                                                     "Data Source=" + strFilePath + "; Jet OLEDB:Engine Type=5;" +
                                                     "Extended Properties=Excel 8.0;");
            return accesscon;
        }

        public DataTable GetData(string query, string tablename)
        {
            OleDbConnection con = GetAccessCon(@"C:\temp\List.mdb");
            con.Open();
            OleDbDataAdapter OleDa = new OleDbDataAdapter(query, con);
            System.Data.DataTable dt = new System.Data.DataTable();
            OleDa.Fill(dt);
            dt.TableName = tablename;
            con.Close();
            return dt;
        }