在c＃中按钮点击基于ID的搜索和显示数据 [英] Searching and displaying data based on ID in excel on button click in c#

问题描述

我有窗口形式& microsoft excel作为数据库。我想实现搜索功能。我有1个文本框1 datagridview& 1个按钮&希望每当我点击按钮时，都应该根据文本框中提供的id在excel文件中进行搜索。它的描述应该以gridview显示。

我正在使用的代码不是动态的，它的静态我的意思是它只显示我在代码和代码中提供的数据的描述。不在文本框中？

帮帮我，我急需这个代码????

我的代码是

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

推荐答案

;

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;

}

"; 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; }

Cha查询。

Change the query.

string query = "SELECT * FROM [Sheet1

其中ID = 105;

where ID= 105";

欲了解更多信息，请阅读此帖子

这篇关于在c＃中按钮点击基于ID的搜索和显示数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！