Dear SirI unable to display CSV file with mention formatsPlease help me sirCSV file read but unable to display correct formatsUOMPM10PM25S02NONO2NOxCO2TEMPWDWSRHSRraingauge 193484884450InvalidInvalidInvalid1013831171 58317 7564775000 namespace CSV public partial class WebForm2 SystemWebUIPage protected void PageLoadobject sender EventArgs e string filePath 34DAAQMS DataAQ11csv34

Read and display CSV file with formats in ASP.Net GridView using C#

indradeo

SOLVED CLOSED ACTIVE ANSWERED
User: indradeo
Posted: on Jun 14, 2023 10:43 PM
Forum: Data Controls
Answer: 1
Views: 1202

Dear Sir,

I unable to display .CSV file with mention formats.

Please help me sir.

.CSV file read but unable to display correct formats.

PM10	PM2.5	S02	NO	NO2	NOx	CO2	TEMP	WD
193.48	48.84	4.50	Invalid	Invalid	Invalid	101.38	31.17	1
5.83	1.7

7.56	477.5	0.00

namespace CSV
{
    public partial class WebForm2 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string filePath = @"D:\AAQMS Data\AQ11.csv";
            string csvData = " ";
            using (var stream = File.Open(filePath, FileMode.Open))
            {
                using (var reader = new StreamReader(stream))
                {
                    //Read the contents of CSV file.
                    csvData = reader.ReadToEnd();
                }
            }
            //Create a DataTable.
            DataTable dt = new DataTable();
            dt.Columns.AddRange(new DataColumn[]
            {
                new DataColumn("UOM", typeof(int)),
                new DataColumn("PM10", typeof(string)),
                new DataColumn("PM2.5",typeof(string)),
                new DataColumn("S02", typeof(string)),
                new DataColumn("NO", typeof(string)),
                new DataColumn("NO2", typeof(string)),
                new DataColumn("NOx", typeof(string)),
                new DataColumn("CO2", typeof(string)),
                new DataColumn("TEMP" ,typeof(string)),
                new DataColumn("WD", typeof(string)),
                new DataColumn("WS", typeof(string)),
                new DataColumn("RH",typeof(string)),
                new DataColumn("SR", typeof(string)),
                new DataColumn("rain_gauge",typeof(string))
            });

           
            //Execute a loop over the rows.
            foreach (string Column in csvData.Split('2'))
            {
                if (!string.IsNullOrEmpty(Column))
                {
                    dt.Rows.Add();
                    int i = 1;
                    //int j = 1;
                    //int k = 1;
                    Double num = 0;
                    //bool isDouble = Double.TryParse(1);
                    // for (int i = 0; i < Convert.ToInt32(1); i++)

                    //Execute a loop over the columns.
                    foreach (string cell in Column.Split(';'))
                    {
                        dt.Rows[dt.Rows.Count - 1][i] = cell;
                       //  dt.Rows[dt.Rows.Count - 1][j] = cell;
                       // dt.Rows[dt.Rows.Count - 1][k] = cell;
                        i++;
                       // j++;
                       // k++;
                    }
                }
            }
           
            //Bind the DataTable.
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }        
    }
}

Download FREE API for Word, Excel and PDF in ASP.Net

steven

0 8

Reply
ANSWER
User: steven
Replied: on Jun 19, 2023 07:15 AM
Report

Hi indradeo,

Please refer the below code.

HTML

<asp:GridView ID="GridView1" runat="server">
</asp:GridView>

NameSpace

using System.Data;
using System.IO;

Code

protected void Page_Load(object sender, EventArgs e)
{
    string filePath = @"D:\Test.csv";
    string csvData = " ";
    using (var stream = File.Open(filePath, FileMode.Open))
    {
        using (var reader = new StreamReader(stream))
        {
            //Read the contents of CSV file.
            csvData = reader.ReadToEnd();
        }
    }
    //Create a DataTable.
    DataTable dt = new DataTable();
    dt.Columns.AddRange(new DataColumn[]
    {
        new DataColumn("UOM", typeof(string)),
        new DataColumn("PM10", typeof(string)),
        new DataColumn("PM2.5",typeof(string)),
        new DataColumn("S02", typeof(string)),
        new DataColumn("NO", typeof(string)),
        new DataColumn("NO2", typeof(string)),
        new DataColumn("NOx", typeof(string)),
        new DataColumn("CO2", typeof(string)),
        new DataColumn("TEMP" ,typeof(string)),
        new DataColumn("WD", typeof(string)),
        new DataColumn("WS", typeof(string)),
        new DataColumn("RH",typeof(string)),
        new DataColumn("SR", typeof(string)),
        new DataColumn("rain_gauge",typeof(string))
    });


    //Execute a loop over the rows.
    bool firstRow = true;
    foreach (string row in csvData.Split('\n'))
    {
        if (firstRow)
        {
            firstRow = false;
        }
        else
        {
            if (!string.IsNullOrEmpty(row))
            {
                int i = 0;
                DataRow dr = dt.NewRow();
                foreach (string cell in row.Split(','))
                {
                    dr[i] = cell;
                    i++;
                }
                dt.Rows.Add(dr);
            }
        }
    }

    //Bind the DataTable.
    GridView1.DataSource = dt;
    GridView1.DataBind();
}

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Read and display CSV file with formats in ASP.Net GridView using C#

Company

Explore

Follow us

Contact Us