用C#语言编程将TXT文件里的数据读取保存（导入）到SQL数据库表中

显示全部楼层 · 2011-10-18 11:57:57

C#编程还分asp.net跟winform呢。。给你个简单的winform的实例代码首先肯定是一个按钮
OleDbConnection conn = new OleDbConnection("sql连接字符串");
OleDbTransaction tran = null;
try
{
//把TXT文本转换为datatable
string sql = string.Format("select * from [Text;Database={0}].{1}", "这个是你的txt文件路径"...

千问 · 2011-10-18 11:57:57

ResultSet rs = Statemnet.excuteQuery();List list1 = new ArrayList();List list2 = new ArrayList();while(rs.hasnext()){
list1.add(rs.next.getString(0));
l...

千问 · 2011-10-18 11:57:57

path = @"D:/test.txt";//读取文件txt
using (FileStream fs = new FileStream(path, FileMode.Open))
{
using (StreamReader sr = new StreamReader(fs...