看看我写的这个.我的没有这个问题了
/// <summary>
/// 将数据写到正式库中
/// </summary>
/// <param name="omc">trueOMC;FalseOMC1</param>
private void InsertIntoData(bool omc)
{
SqlConnection Conncl = new SqlConnection();
Conncl.ConnectionString = SqlConn;
Conncl.Open();
SqlCommand Command = new SqlCommand();
SqlDataAdapter DataAd = new SqlDataAdapter();
DataSet MyData = new DataSet();
try
{
if (omc == true)
{
= "select name from moto_omc.dbo.sysobjects where type='u' and status>0";
}
else
{
= "select name from moto_omc.dbo.sysobjects where type='u' and status>0";
}
Command.Connection = Conncl;
DataAd.SelectCommand = Command;
DataAd.Fill(MyData, "tablenames");
Command.Dispose();
DataAd.Dispose();
Conncl.Dispose();
Conncl.Close();
for (int i = 0; i < MyData.Tables[0].Rows.Count; i++)
{
SqlExpro MySqlexe = new SqlExpro();
if (omc == true)
{
MySqlexe.Conn = SqlCon;
}
else
{
MySqlexe.Conn = SqlConn;
}
MySqlexe.InsertData(MyData.Tables[0].Rows[i]["name"].ToString(),omc);
}
}
catch (Exception Err)
{
MessageBox.Show(Err.Message);
}
}
/// <summary>
/// 将数据写到正式库中
/// </summary>
/// <param name="table">表名</param>
/// <param name="omc">true表示OMC,flase表示OMC1</param>
public void InsertData(string table, bool omc)
{
SqlConnection MyCon = new SqlConnection();
SqlCommand MyCmd = new SqlCommand();
MyCon.ConnectionString = Conn;
MyCon.Open();
string Sql;
try
{
WriteReadini Myini = new WriteReadini(Application.StartupPath + "\\InsertInto.ini");
if (omc == true)
{
Sql = Myini.IniReadValue("insert into", table);
}
else
{
Sql = Myini.IniReadValue("insert into OMC1", table);
}
if (table == "network_classes")
{
SqlCommand MyCommand = new SqlCommand();
SqlConnection MyConn = new SqlConnection();
MyConn.ConnectionString = Conn;
MyConn.Open();
= "TRUNCATE TABLE " + table + "";
MyCommand.Connection = MyConn;
MyCommand.ExecuteNonQuery();
MyCommand.Dispose();
MyConn.Dispose();
MyConn.Close();
}
= Sql;
= 360000;
MyCmd.Connection = MyCon;
MyCmd.ExecuteNonQuery();
MyCmd.Dispose();
MyCon.Dispose();
MyCon.Close();
}
catch(Exception Err)
{
StreamWriter write = new StreamWriter(Application.StartupPath + "\\Error.log", true);
//Application.StartupPath;
write.WriteLine("库名称为:"+omc+"写数据表"+table+"出错;错误信息:" + Err.Message + "时间为:" + System.DateTime.Now);
write.Dispose();
write.Close();
}
}
}