系统:Windows Xp
环境:VS2008+SQL2008+SQLPRESS
功能:读取文件夹内的txt文件.将数据分割导入数据库(网上的教程)
string FilePath = @"F:\360云盘\手机号码归属地\";
//目标文件夹文件数组
string[] Files = Directory.GetFiles(FilePath);
//循环读取文件
int i = 0;
int j = 0;
foreach (string file in Files)
{
//文件个数
i = i + 1;
//label1.Text = file.Replace(FilePath,"");
string filename = file.Replace(FilePath, "");
//读取文件
using (FileStream PhoneNumber = File.OpenRead(file))
{
//将文件内容以流的形式读取
using (StreamReader streamReader = new StreamReader(PhoneNumber, Encoding.GetEncoding("gb2312")))
{
//数据库连接
using (SqlConnection objConn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFileName=|DataDirectory|\xx.mdf;Integrated Security=True;User Instance=true"))
{
//打开数据库
objConn.Open();
//初始化SQLCommand对象,准备执行SQL
using (SqlCommand objCmd = objConn.CreateCommand())
{
//objCmd.CommandText = "Insert Into Phone(starNum,endNum,address) values (@starNum,@endNum,@address)";
string line = null;
//判断文件是否读到最后
while ((line = streamReader.ReadLine()) != null)
{
//以-号分割为数组
string[] phone = line.Split('-');
string strNum = phone[0];
string endNum = phone[1];
string addr = phone[2];
//将文件名与城市名组合
addr = filename.Replace(".txt","") +" - " + addr;
//执行SQL语句
objCmd.CommandText = "insert into Phone(starNum,endNum,address) values(" + strNum + "," + endNum + ",'" + addr + "')";
objCmd.ExecuteNonQuery();
j = j + 1;
}
}
}
}
}
label1.Text = "此次共导入" + i + "个文件," + j + "条数据";
}
MessageBox.Show("导入完成!");
i和j显示的数据都正常
但SQLPRESS的Phone表没有数据
使用断点跟踪.运行的SQL语句都正常解析了.整体程序运行也没有出错..就是SQLPRESS里面没有数据.
疯了....
