using System;
      using System.Collections;
      using System.Collections.Generic;
      using System.Configuration;
      using System.Data;
      using System.Linq;
      using System.Web;
      using System.Web.Security;
      using System.Web.UI;
      using System.Web.UI.HtmlControls;
      using System.Web.UI.WebControls;
      using System.Web.UI.WebControls.WebParts;
      using System.Xml.Linq;
      using System.Data.SqlClient;
      using System.IO;
       
      namespace EpamSystem
      {
          public partial class _Default : System.Web.UI.Page
          {
              private DataTable ReadCSVFile(string pathToCsvFile)
              {
       
       
                  //создаём таблицу
                  DataTable dt = new DataTable("CSV");
       
                  //создаём колонки
                  DataColumn colDate;
                  colDate = new DataColumn("Date", typeof(String));
       
                  DataColumn colOpen;
                  colOpen = new DataColumn("Open", typeof(String));
       
                  DataColumn colHigh;
                  colHigh = new DataColumn("High", typeof(String));
       
                  DataColumn colLow;
                  colLow = new DataColumn("Low", typeof(String));
       
                  DataColumn colClose;
                  colClose = new DataColumn("Close", typeof(String));
       
                  DataColumn colVolume;
                  colVolume = new DataColumn("Volume", typeof(String));
       
                  //добавляем колонки в таблицу
                  dt.Columns.AddRange(new DataColumn[] {colDate, colOpen,
                                               colHigh, colLow,
                                               colClose, colVolume  });
                  try
                  {
                      DataRow dr = null;
       
                      string[] carValues = null;
       
                      string[] cars = File.ReadAllLines(pathToCsvFile);
       
                      for (int i = 0; i < cars.Length; i++)
                      {
                          if (!String.IsNullOrEmpty(cars[i]))
                          {
                              carValues = cars[i].Split(',');
       
       
                              //создаём новую строку
                              dr = dt.NewRow();
       
                              dr["Date"] = carValues[0];
                              dr["Open"] = carValues[1];
                              dr["High"] = carValues[2];
                              dr["Low"] = carValues[3];
                              dr["Close"] = carValues[4];
                              dr["Volume"] = carValues[5];
                              //добавляем строку в таблицу
                              dt.Rows.Add(dr);
                          }
                      }
                  }
       
                  catch (Exception ex)
                  {
                      //MessageBox.Show(ex.Message);
                  }
       
                  return dt;
              }
       
              protected void Page_Load(object sender, EventArgs e)
              {
       
              }
       
       
       
              protected void GetQuotes_Click(object sender, EventArgs e)
              {
                  if (tb_EnterHistData.Text.Trim().ToLower() == "msft")
                  {
       
       
                      lv_Information.DataSource = ReadCSVFile(@"G:\msft.csv");
                      DataBind();
                      //gv_information.DataSource = ReadCSVFile(@"G:\msft.csv");
                      //DataBind();
       
                  }
              }
          }
      }