110,571
社区成员
发帖
与我相关
我的任务
分享
void BeginRec(byte[] data, SocketAsyncEventArgs ar)
{
//通过不同的data来执行insert或者update
}
void BeginRec(byte[] data, SocketAsyncEventArgs ar)
{
using (SqlConnection con = new SqlConnection(""))
{
con.Open();
using (SqlCommand cmd=new SqlCommand("insert into ......",con))
{
cmd.ExecuteNonQuery();
}
con.Close();
}
}
public static SqlConnection con = new SqlConnection("");
//当启动窗体的时候 执行
con.Open();
void BeginRec(byte[] data, SocketAsyncEventArgs ar)
{
using (SqlCommand cmd=new SqlCommand("insert into ......",con))
{
cmd.ExecuteNonQuery();
}
}
//判断connection的连接状态,防止con意外关闭
private void CheckConnection()
{
if (con.State != System.Data.ConnectionState.Open)
{
con.Close();
con.Open();
}
}
void BeginRec(byte[] data, SocketAsyncEventArgs ar)
{
using (SqlCommand cmd=new SqlCommand("insert into ......",con))
{
CheckConnection();
cmd.ExecuteNonQuery();
}
}