111,092
社区成员




string[] TemLine = File.ReadAllLines(TxtDirectoryPath + "\\" + name, Encoding.GetEncoding("GB2312"));//读出数据有1万4千多条左右
foreach (string item in TemLine)
{
try
{
string[] Item = item.Split('\t');
//Item示例:邵小小 24,河南,未婚.
string[,] Values ={
{ "vName", Item[0] },
{"vInfo",Item[1]}
};
Add("UserInfo", Values);//执行数据插入操作
}
catch
{
;
}
}
//----------------------------------------------------------------------
//向数据库插入内容
/// <summary>
/// 向数据库添加内容
/// </summary>
/// <param name="TableName">表名</param>
/// <param name="ColumnsAndValues">由列名和值组成的二维数组</param>
public void Add(string TableName, string[,] ColumnsAndValues)
{
string Columns = null;
string Values = null;
for (int i = 0; i < ColumnsAndValues.GetLength(0); i++)
{
Columns = Columns + ColumnsAndValues[i, 0] + ",";
Values = "\"" + Values + ColumnsAndValues[i, 1] + "\",";
}
Columns = Columns.Substring(0, Columns.Length - 1);
Values = Values.Substring(0, Values.Length - 1);
string insertStr = "insert into " + TableName + "(" + Columns + ") values(" + Values + ")";
//创建Connection对象
OleDbConnection conn = CreateConnection();
conn.Open();
OleDbCommand cmd = new OleDbCommand(insertStr, conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
conn.Dispose();
}
private void Add(string FileName)
{
DateTime d = DateTime.Now;
csData cs = new csData();
string insertStr = "insert into userInfo (vName,vInfo) values('{0}','{1}')";
string[] Lines = File.ReadAllLines(FileName, Encoding.GetEncoding("GB2312"));
OleDbConnection conn = cs.CreateConnection(csData.GetDataPath);
conn.Open();
OleDbTransaction transaction = null;
OleDbCommand cmd = new OleDbCommand();
transaction = conn.BeginTransaction();
cmd.Transaction = transaction;
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
foreach (string line in Lines)
{
string[] item = line.Split('\t');
cmd.CommandText = string.Format(insertStr, item[0], item[1]);
cmd.ExecuteNonQuery();
}
transaction.Commit();
conn.Close();
conn.Dispose();
MessageBox.Show("己经导入所有的搜索结果,共用时" + (DateTime.Now - d));
}
string fileName = TxtDirectoryPath + "\\" + name;
string insertStr = "insert into UserInfo (vName, vInfo) values ('{0}','{1}')";
using (FileStream fs = new FileStream("", FileMode.Open))
{
using (StreamReader sr = new StreamReader(fs, System.Text.Encoding.GetEncoding("GB2312")))
{
OleDbConnection conn = CreateConnection();
OleDbCommand cmd = new OleDbCommand(conn);
conn.Open();
string line = null;
while ((line = sr.ReadLine()) != null)
{
string item = line.Split('\t');
cmd.CommandText = string.Format(insertStr, item[0], item[1]);
cmd.ExecuteNonQuery();
}
conn.Close();
conn.Dispose();
}
}
Values = "\"" + Values + ColumnsAndValues[i, 1] + "\",";
应该改为 Values = Values + "'" + ColumnsAndValues[i, 1] + "',";