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("文件夹" + "/" + "文件名")