Searching and displaying data based on ID column from excel

I have window form & microsoft excel as database. I want to implement searching feature. i have 1 textbox 1 datagridview & 1 button & want whenever i click on button a search should be made in excel file based on the id provided in textbox & its description should be displayed in gridview.
The code i'm using is not dynamic its static i mean it'll only show description of data i provided in code & not in textbox ?
Help me i urgently need this code ????
My Code is

private void srch()
{
string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= 'c:\\Product Details.xlsx';Extended Properties='Excel 8.0;HDR=Yes;'";
// double id = Convert.ToDouble(textBox1.Text);
string query = "SELECT * FROM [Sheet1$]";
DataSet excelDataSet = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter(query, strConn); da.Fill(excelDataSet); dataGridView1.DataSource = excelDataSet.Tables[0];
DataView dv = ((DataTable)dataGridView1.DataSource).DefaultView;
DataView dv_filter = new DataView(); dv_filter.Table = excelDataSet.Tables[0];
dv_filter.RowFilter = "ID = '105'"; dataGridView1.DataSource = dv_filter;
}

hi i modified your code just check it:

private void srch()
    {
        string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= 'c:\\Product Details.xlsx';Extended Properties='Excel 8.0;HDR=Yes;'";
        // double id = Convert.ToDouble(textBox1.Text);
        string query = "SELECT * FROM [Sheet1$]";
        DataSet excelDataSet = new DataSet();
        OleDbDataAdapter da = new OleDbDataAdapter(query, strConn);
        da.Fill(excelDataSet);
        if (txtBox1.Text != String.Empty)
        {
            DataView dv_filter = excelDataSet.Tables[0].DefaultView;
            dv_filter.RowFilter = "ID ='" + txtBox1.Text + "'";
            dataGridView1.DataSource = dv_filter;
        }
        else
            dataGridView1.DataSource = excelDataSet.Tables[0];
    }

just change your textbox name here and call this method within search button click.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka13y ago
hi i modified your code just check it:

private void srch()
    {
        string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= 'c:\\Product Details.xlsx';Extended Properties='Excel 8.0;HDR=Yes;'";
        // double id = Convert.ToDouble(textBox1.Text);
        string query = "SELECT * FROM [Sheet1$]";
        DataSet excelDataSet = new DataSet();
        OleDbDataAdapter da = new OleDbDataAdapter(query, strConn);
        da.Fill(excelDataSet);
        if (txtBox1.Text != String.Empty)
        {
            DataView dv_filter = excelDataSet.Tables[0].DefaultView;
            dv_filter.RowFilter = "ID ='" + txtBox1.Text + "'";
            dataGridView1.DataSource = dv_filter;
        }
        else
            dataGridView1.DataSource = excelDataSet.Tables[0];
    }

just change your textbox name here and call this method within search button click.
0