使用ASP.NET MVC将字符串转换为DataTable

debugcn 发表于 Dev

萨拉

我正在尝试使用以下方法将字符串转换为DataTable，但这没有用

public static DataTable convertStringToDataTable(string data)
    {
        DataTable dataTable = new DataTable();
        bool columnsAdded = false;
        foreach (string row in data.Split('\n'))
        {
            DataRow dataRow = dataTable.NewRow();
            foreach (string cell in row.Split(','))
            {
                string[] keyValue = cell.Split('"');
                if (!columnsAdded)
                {
                    DataColumn dataColumn = new DataColumn(keyValue[0]);
                    dataTable.Columns.Add(dataColumn);
                }
                dataRow[keyValue[0]] = keyValue[1];
            }
            columnsAdded = true;
            dataTable.Rows.Add(dataRow);
        }
        return dataTable;
    }

包含数据字符串的代码：

StringWriter sw = new StringWriter();
                    sw.WriteLine("\"NumClient\",\"Raisons Sociale\",\"DateDocument\",\"NumCommandeNAV\",\"Réference\",\"Designation\",\"QteCommandée\",\"QteLivrée\",\"QteAnnulée\",\"Reste à Livrer\",\"Type Disponibilite\",\"DateDisponibilite\"");

                    var EnTete =
                        db.AURES_GROS_EnTeteCommande.Where(e => e.NumCommandeNAV != " " && e.NumCommandeNAV != "_")
                            .OrderBy(x => x.CodeMagasin)
                            .ThenBy(s => s.NumClient)
                            .ThenBy(c => c.DateDocument)
                            .OrderByDescending(x => x.NumCommandeNAV)
                            .ToList();

                    foreach (var element in EnTete)
                    {
                        string statut = RecuperStatut(element.NumCommandeNAV);
                        if (statut == "A livrer")
                        {
                            Raison = context.Users.First(x => x.No_ == element.NumClient).RaisonSociale;
                            lignes = db.AURES_GROS_LigneCommande.Where(x => x.NumDocument == element.NumDocument).ToList();

                        foreach (var elt in lignes)
                        {
                            sw.WriteLine(string.Format("\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\",\"{8}\",\"{9}\",\"{10}\",\"{11}\"",
                                            element.NumClient,
                                             Raison,
                                             element.DateDocument,
                                             element.NumCommandeNAV,
                                             elt.CodeArticle,
                                             elt.Designation,
                                             elt.Quantite,
                                             0,
                                             elt.QteANNULEE,
                                             elt.Quantite,
                                             element.Couleur,
                                             elt.DateDisponibilite
                                             ));
                            }
                        }
                    }
                    DataTable t = convertStringToDataTable(sw.ToString());

                    Response.ClearContent();
                    Response.ClearHeaders();
                    Response.BufferOutput = true;
                    Response.ContentType = "text/excel";
                    Response.AddHeader("Content-Disposition", "attachment; filename=Reliquat" + DateTime.Now.ToString("yyyy_MM_dd") + ".csv");
                    Response.Write(t);
                    Response.Flush();
                    Response.Close();
                    //Response.End();

在此代码中，我希望自己将数据导出到Excel文件

任何人都有解决方案，谢谢，

斯克罗比

您可以将列foreach转换为for循环。

public static DataTable convertStringToDataTable(string data)
    {
        DataTable dataTable = new DataTable();
        bool columnsAdded = false;
        foreach (string row in data.Split('\n'))
        {
            DataRow dataRow = dataTable.NewRow();
            string[] cell = row.Split(',');
            for (int i = 0; i < cell.Length; i++)
            {
                string[] keyValue = cell[i].Split('"');
                if (!columnsAdded)
                {
                    DataColumn dataColumn = new DataColumn();
                    dataTable.Columns.Add(dataColumn);
                }
                dataRow[i] = keyValue[1];
            }
            columnsAdded = true;
            dataTable.Rows.Add(dataRow);
        }
        return dataTable;
    }

但是，如果您的split string [] keyValue = cell.Split（'“'）;未返回您期望的结果，则可能需要进一步调查。

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。