Import a CSV into a DataGrid
private void loadIntoGrid(string filename)
{
string ConnectionString = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" +
Server.MapPath("tmp_excel/") + ";";
csvConnection = new OdbcConnection(ConnectionString);
csvConnection.Open();
try
{
OdbcCommand csvCommand;
OdbcDataReader csvReader;
// DataTable per la lettura dei dati da .CSV
dt = new DataTable();
dt.Columns.Add(new DataColumn("campo1"));
dt.Columns["campo1"].DataType = System.Type.GetType("System.String");
dt.Columns.Add(new DataColumn("campo2"));
dt.Columns["campo2"].DataType = System.Type.GetType("System.String");
// Leggo il file .CSV
csvCommand = csvConnection.CreateCommand();
csvCommand.CommandText = "select * from [" + filename + "]";
csvCommand.CommandType = CommandType.Text;
csvReader = csvCommand.ExecuteReader();
try
{
while (csvReader.Read())
{
// Carico i dati nel DataTable
DataRow drNew = dt.NewRow();
drNew[0] = csvReader[0].ToString().Trim();
drNew[1] = csvReader[1].ToString().Trim();
dt.Rows.Add(drNew);
}
}
finally
{
csvReader.Close();
}
DataView aDV = new DataView(dt);
dg.DataSource = aDV;
dg.DataBind();
}
finally
{
csvConnection.Close();
}
}
Download Code...
Print Page