使用ASP.NET将CSV文件上传到My SQL数据库 [英] Upload csv file into My SQL Database using ASP.NET

问题描述

//string filepath = @"C:\Documents and Settings\HPFS.HPFS\Desktop\rajmal.csv";
        string file = FileUpload1.PostedFile.FileName;
        file = Path.GetFileName(file);
        string filepath = Server.MapPath("~/csv/")+file;
        FileUpload1.SaveAs(filepath);
        StreamReader sr = new StreamReader(filepath);
        string line = sr.ReadLine();
        string[] value = line.Split(';');
        DataTable dt = new DataTable();
        DataRow row;
        foreach (string dc in value)
        {
            dt.Columns.Add(new DataColumn(dc));
        }
        while ( !sr.EndOfStream )
        {
            value = sr.ReadLine().Split(';');
            if(value.Length == dt.Columns.Count)
            {
                row = dt.NewRow();
                row.ItemArray = value;
                dt.Rows.Add(row);
            }
        }
        
        SqlBulkCopy bc = new SqlBulkCopy(sc.ConnectionString, SqlBulkCopyOptions.TableLock);

        bc.DestinationTableName = "company";

        bc.BatchSize = dt.Rows.Count;

        sc.Open();

        bc.WriteToServer(dt);

        Response.Write("Ok");

        bc.Close();

        sc.Close(); 

此代码将在SQL SERVER(如果已完成SQL SERVER CONNECTIONS MADE)中工作，而在MYSQL DATABASE中则无效. :(

请提供示例代码.

帮帮我吧:)

我需要使用ASP.NET将CSV文件上传到MYSQL数据库中:)

This code will work in SQL SERVER(IF SQL SERVER CONNECTIONS MADE) but not in MYSQL DATABASE. :(

Please Provide me a sample code.

Help me out guys please :)

I need to upload csv file into MYSQL DATABASE using ASP.NET :)

推荐答案

create table tbl_BulkUpload([id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
    [EmpName] [nvarchar](max) NULL,
    [LastName] [nvarchar](max) NULL,
    [Email] [nvarchar](max) NULL
) ON [PRIMARY]

create view tbl_View_BulkUpload
as
select EmpName,LastName from tbl_BulkUpload

BULK INSERT tbl_View_BulkUpload
FROM 'D:\BulkUpload.txt'
WITH
(
FIELDTERMINATOR =',',
ROWTERMINATOR = '\n'
)

这篇关于使用ASP.NET将CSV文件上传到My SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！