62,243
社区成员




FileStream fs = new FileStream(txtFilePath.Text, FileMode.Open);
StreamReader sr = new StreamReader(fs);
string strCardNumber = sr.ReadToEnd();
string[] arrCardNumber = strCardNumber.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
if (bussiness.UploadTxt(arrCardNumber,((KeyValueMember)comboArea.SelectedItem).ValueMember))
{
dataGridView1.DataSource = bussiness.GetNewData(arrCardNumber.Length).Tables[0];
}
public bool UploadTxt(string[] arrCardNumber,string areaId)
{
try
{
for (int i = 0; i < arrCardNumber.Length; i++)
{
string sql = string.Format("INSERT INTO cards (CardNumber,GetDate,Area_ID) VALUES('{0}',#{1}#,{2})", arrCardNumber[i], DateTime.Now.ToLocalTime().ToString(),areaId);
if (!dataEntity.ExeSQL(sql))
return false;
}
return true;
}
catch (Exception ex)
{
return false;
throw ex;
}
}
command.CommandText = "BULK INSERT test from 'c:\\de.txt' with (fieldterminator=',',rowterminator='\n',batchsize=10000)";
string connectstr = "Data Source= ;Initial Catalog= ;Integrated Security=True";
SqlConnection conn = new SqlConnection(connectstr);
conn.Open();
SqlCommand command = new SqlCommand();
SqlTransaction mytran; //建事务
mytran = conn.BeginTransaction();
try
{
//从此开始,基于该连接的数据操作都被认为是事务的一部分
command.CommandTimeout = 0;
command.Connection = conn;
command.Transaction = mytran; //定位数据库
//command.ExecuteNonQuery();
command.CommandText = "BULK INSERT test from 'c:\\de.txt' with (fieldterminator=',',rowterminator='\n',batchsize=10000)";
//conn.Open();
command.ExecuteNonQuery();
mytran.Commit(); //提交事务
}
catch (Exception err)
{
throw new ApplicationException("事务操作出错,系统信息:" + err.Message);
}
finally
{
conn.Close();
}
TimeSpan ts = DateTime.Now - begin;
MessageBox.Show("ts=" + ts.TotalSeconds);