(asp.net)CSV文件列转行显示

来源：互联网发布：淘宝店标图片免费下载编辑：程序博客网时间：2024/05/16 04:44

aspx:
<asp:GridView ID="dgData" runat="server">
</asp:GridView>

cs:
private void CSVToDS(string path)
{
DataTable mydt = new DataTable("myTableName");

DataColumn mydc;

System.IO.StreamReader mysr = new System.IO.StreamReader(path);

List<String[]> list = GetCountCSV(path);

int columnNum = list.Count + 1;

int rowNum = mysr.ReadLine().Split(',').Length;

int counter = 0, errRowIndex = 0;

        foreach (string[] arr in list)
        {
            if (arr.Length.Equals(rowNum))
                counter++;
            else
                errRowIndex = counter + 1;
        }

        if (!counter.Equals(list.Count))
        {
            Page.RegisterClientScriptBlock("JS", "<script language='javascript'>alert('in uploaded .csv file at row " + errRowIndex.ToString() + " lack data item, please check it.');</script>");
            return;
        }

        for (int k = 0; k < columnNum; k++)
        {
            if (k == 0)
            {
                mydc = new DataColumn("Column", System.Type.GetType("System.String"));
            }
            else if (k == 1)
            {
                mydc = new DataColumn("Field Name", System.Type.GetType("System.String"));
            }
            else
            {
                mydc = new DataColumn("Data Example " + Convert.ToString(k - 1), System.Type.GetType("System.String"));
            }
            mydt.Columns.Add(mydc);
        }

        for (int m = 0; m < rowNum; m++)
        {
            DataRow newRow = mydt.NewRow();
            newRow["Column"] = m.ToString();
            for (int n = 1; n < columnNum - 1; n++)
            {
                newRow[n] = String.Empty;
            }
            mydt.Rows.Add(newRow);
        }

       for (int k = 1; k < mydt.Columns.Count; k++)
        {
            for (int j = 0; j < mydt.Rows.Count; j++)
            {
                mydt.Rows[j][k] = ((string[])list[k - 1])[j].ToString().Replace("/"", "");
            }
        }

        if (mydt.Rows.Count > 0)
        {
            dgData.DataSource = mydt.DefaultView;
            dgData.DataBind();
        }
        else
        {
            dgData.DataSource = null;
            dgData.DataBind();
        }
    }
public static List<String[]> GetCountCSV(string filePathName)
    {
        List<String[]> ls = new List<String[]>();
        using (StreamReader fileReader = new StreamReader(filePathName))
        {
            string strLine = "";
            while (strLine != null)
            {
                strLine = fileReader.ReadLine();
                if (strLine != null && strLine.Length > 0)
                {

                    ls.Add(strLine.Split(new char[] { ',' }));
                }
            }
        }
        return ls;
    }

//filepathName=Server.MapPath("文件夹" + "/" + "文件名")