如何阅读NotePad并将数据保存到SQL Server
问题描述：
我在Sqlserver中有数据库表。我想使用带有c＃的asp.net将数据从一个记事本插入数据库。 Notepad formate用一些predifine标签修复。我想通过ASP.net页面上传记事本文件并保存在数据库表中。我正在使用MS SQL Server 2005.
有人可以给我这个解决方案..
这是非常紧急的... 。
提前多多谢谢...
I am having Database table in Sqlserver . I want to insert data from one notepad to database using asp.net with c#. Notepad formate is fixed with some predifine tags. I want upload notepad file through ASP.net page and save in database table. I am using MS SQL Server 2005.
can somebody give me solution for this one..
This is very very urgent ....
Lot of Thanks in Advance...
答
https://www.simple-talk.com/sql/t-sql-programming / read-write-writing-in-sql-server-using-t-sql / [ ^ ]
http://msdn.microsoft.com/en-us/library/ms162802。 aspx [ ^ ]
如果是一次性加载，请使用SQL server的Import Data选项。
如果你想自动化，你可以做到这一点使用平面文件源时的SSIS。
If it is a one time load, use SQL server's Import Data option.
If you want automated, you can do it with SSIS while using Flat file source.