110,537
社区成员
发帖
与我相关
我的任务
分享
public partial class frmMain:Form
{
public const int WM_USER = 0x0400;
public const int WM_RECO = WM_USER + 100;
string strConn = "Max Pool Size = 1024;Data Source=192.168.0.121;Initial Catalog=ODCar;Integrated Security=false;Uid=sa;Pwd=sa";
protected override void DefWndProc(ref System.Windows.Forms.Message m)
{
switch(m.Msg)
{
case WM_RECO:
{
Thread thread = new Thread(insertData);
thread.IsBackground = true;
thread.Start();
}
break;
default:
base.DefWndProc(ref m);//调用基类函数处理非自定义消息。
break;
}
}
static object ooo = new object();
private void InsertData( )
{
string strCmmd = "Insert Into Record EquID Values ('1111') ";
using(SqlConnection conn = new SqlConnection(strConn))
{
using(SqlCommand cmd = new SqlCommand(strCmmd,conn))
{
try
{
conn.Open();
if(Equals(cmd.ExecuteNonQuery(),0))//如果未更新则记录到log日志里
{
}
}
catch(Exception exception)
{
lock(ooo)
using(StreamWriter sw = File.AppendText("Data.log"))
{
sw.WriteLine(nCount.ToString()+" "+ strCmmd);//写时间不含毫秒
sw.Flush();
}
}
}
}
}
}
SqlConnection conn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand(strCmmd,conn);
cmd.CommandTimeout = 0;
try
{
conn.Open();
if(Equals(cmd.ExecuteNonQuery(),0))//如果未更新则记录到log日志里
{
}
}
catch(Exception exception)
{
lock(ooo)
using(StreamWriter sw = File.AppendText("Data.log"))
{
nCount++;
sw.WriteLine(nCount.ToString()+" "+ strCmmd);//写时间不含毫秒
sw.Flush();
}
}
finally
{
cmd.Dispose();
conn.Close();
}