Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SourceGrid.DataSource = null; String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + txtSource.Text + ";Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnection(strConn); OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * from [Sheet1$] Where [Name] like '%name_parameter%'", conn); DataSet myDataSet = new DataSet(); myCommand.Fill(myDataSet); conn.Close(); SourceGrid.DataSource = myDataSet.Tables;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Need to sort columns in DataGridView||4||64|
|Read top line from CSV file||14||58|
|advancedDataGridView / cancel / filter / using / button||5||29|
Join the community of 500,000 technology professionals and ask your questions.