Ask c# to import data from excel and text documents into DataGridView

djkent

Instead of using excel or text documents as the data source, import the data into the datagridview.

For example, my datagridview originally had 4 rows of records. Now I want to import the data in a text document or excel behind the 4 rows of data, that is, add a few rows to the datagridview. The added row data is the data in excel or text document.

magicater

The datagridview should correspond to a DATATABLE, first use another DATATABLE (the structure is the same as the previous one) to get the data in EXCEL or TXT, use the MERGE of the DATATABLE, and then re-bind, the idea is generally like this.

lll572

XmlDocument doc =new Xmldocument();
doc.Load("Your Path");
XmlNode s=doc.CreateElement();

..........
There is information online, search more

57162356

System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection();
cn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Book1.xls;Extended Properties=Excel 8.0;";
cn.Open();
string sql = "select * from [Sheet1$A2:F10]";
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(sql, cn);
System.Data.OleDb.OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
  MessageBox.Show(dr[0].ToString());
}

cn.Close();

Use the above statement to connect first and then add

djkent

Thanks everyone for helping