Morpheusweb.it - Risorse per webmaster: script, ASP.NET, C#, Visual Basic .Net, tutorial, asp, javascript, css, php, html, java, ADO, VBScript, forms, frames, Active Server Pages, Dynamic HTML, database, gratis per webmaster e webdesigner

CSV to DataGrid - << VB.NET VERSION >>


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


 








Page top

risorse per webmaster