Posted on: 10/9/2013 4:05:01 PM | Views : 668

here is the code
average.aspx.cs
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.IO; using System.Data.OleDb; using System.Globalization; using System.Web.UI.HtmlControls; using System.Text; public partial class _Default : System.Web.UI.Page { string[] csvFilesList; static int index = -1; protected void Page_Load(object sender, EventArgs e) { csvFilesList = new string[] { "~/App_Code/avg_file_disp_monthly.csv"}; } static DataTable GetDataTableFromCsv(string path, bool isFirstRowHeader) { string header = isFirstRowHeader ? "Yes" : "No"; string pathOnly = Path.GetDirectoryName(path); string fileName = Path.GetFileName(path); string sql = @"SELECT * FROM [" + fil ...

Go to the complete details ...