在向一个SQL SERVER中插入数据,频率高时每1/3秒,提交后,Reader.RecordsAffected的值是1,但实际的数据库记录并没有增加,有人遇到过这样的问题吗?如何解决?classLib myclassLib = new classLib();
strSql = "insert into aslt(jm) values('" +Msg1+ "')";
m_return = myclassLib.exec_sql(strSql);
public class classLib
{
public classLib()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public int exec_sql(string mySelectQuery)
{
///执行insert、update语句
///
///参数说明:mySelectQuery (update语句)
///返回值 :执行影响的行数
///可复用 SqlConnection CNN = getConnection("mm1","dataserver","sa","12345data");
SqlCommand myCommand = new SqlCommand(mySelectQuery,CNN);
CNN.Open();
SqlDataReader myReader = myCommand.ExecuteReader();
int p_RecordsAffected = (int)myReader.RecordsAffected;
myReader.Close();
CNN.Close();
return p_RecordsAffected;
}
public SqlConnection getConnection(string dataSource,string cataLog,string userId,string passWord)
{
///数据库公共连接(SqlConnection方式)
///参数说明: dataSource (数据源)
/// cataLog (数据库)
/// userId (用户名)
/// passWord (密 码)
///返回类型:SqlConnection
///
SqlConnection CNN;
string str;
str="Data Source=" +dataSource+ ";Initial Catalog=" +cataLog+ ";User Id=" +userId+ ";Password=" +passWord+ ";"; CNN=new SqlConnection(str);
return CNN;
}
}
strSql = "insert into aslt(jm) values('" +Msg1+ "')";
m_return = myclassLib.exec_sql(strSql);
public class classLib
{
public classLib()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public int exec_sql(string mySelectQuery)
{
///执行insert、update语句
///
///参数说明:mySelectQuery (update语句)
///返回值 :执行影响的行数
///可复用 SqlConnection CNN = getConnection("mm1","dataserver","sa","12345data");
SqlCommand myCommand = new SqlCommand(mySelectQuery,CNN);
CNN.Open();
SqlDataReader myReader = myCommand.ExecuteReader();
int p_RecordsAffected = (int)myReader.RecordsAffected;
myReader.Close();
CNN.Close();
return p_RecordsAffected;
}
public SqlConnection getConnection(string dataSource,string cataLog,string userId,string passWord)
{
///数据库公共连接(SqlConnection方式)
///参数说明: dataSource (数据源)
/// cataLog (数据库)
/// userId (用户名)
/// passWord (密 码)
///返回类型:SqlConnection
///
SqlConnection CNN;
string str;
str="Data Source=" +dataSource+ ";Initial Catalog=" +cataLog+ ";User Id=" +userId+ ";Password=" +passWord+ ";"; CNN=new SqlConnection(str);
return CNN;
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货