DbProviderFactory DbProviderFactory = DbProviderFactories.GetFactory(this.m_ProviderInvariantName);
using (DbConnection conn = DbProviderFactory.CreateConnection())
{
conn.ConnectionString = this.m_ConnStr;
conn.Open();
string sSql = "Update T_Sequence Set SequenceCode = @SequenceCode"
+ " Where SequenceDistrict = @SequenceDistrict";
//string sSql = "insert into T_Sequence(SequenceDistrict,SequenceCode)"
// + " values(@SequenceDistrict,@SequenceCode)";
DbCommand dbCommand = DbProviderFactory.CreateCommand();
dbCommand.Connection = conn;
dbCommand.CommandText = sSql;
DbParameter pa1 = DbProviderFactory.CreateParameter();
pa1.ParameterName = "@SequenceDistrict";
pa1.DbType = DbType.String;
pa1.Value = pKey;
dbCommand.Parameters.Add(pa1);
pa1 = DbProviderFactory.CreateParameter();
pa1.ParameterName = "@SequenceCode";
pa1.DbType = DbType.Int32;
pa1.Value = pCode;
dbCommand.Parameters.Add(pa1);
int iReturn = dbCommand.ExecuteNonQuery();
if (iReturn != 1)
{
throw new ApplicationException("error");
}
}
使用update语句时,iReturn返回是0,表示没有修改数据,但是使用insert语句时,返回1,表示插入一条记录。另外,把表的字段SequenceCode改成字符型,update的语句却又正常了
using (DbConnection conn = DbProviderFactory.CreateConnection())
{
conn.ConnectionString = this.m_ConnStr;
conn.Open();
string sSql = "Update T_Sequence Set SequenceCode = @SequenceCode"
+ " Where SequenceDistrict = @SequenceDistrict";
//string sSql = "insert into T_Sequence(SequenceDistrict,SequenceCode)"
// + " values(@SequenceDistrict,@SequenceCode)";
DbCommand dbCommand = DbProviderFactory.CreateCommand();
dbCommand.Connection = conn;
dbCommand.CommandText = sSql;
DbParameter pa1 = DbProviderFactory.CreateParameter();
pa1.ParameterName = "@SequenceDistrict";
pa1.DbType = DbType.String;
pa1.Value = pKey;
dbCommand.Parameters.Add(pa1);
pa1 = DbProviderFactory.CreateParameter();
pa1.ParameterName = "@SequenceCode";
pa1.DbType = DbType.Int32;
pa1.Value = pCode;
dbCommand.Parameters.Add(pa1);
int iReturn = dbCommand.ExecuteNonQuery();
if (iReturn != 1)
{
throw new ApplicationException("error");
}
}
使用update语句时,iReturn返回是0,表示没有修改数据,但是使用insert语句时,返回1,表示插入一条记录。另外,把表的字段SequenceCode改成字符型,update的语句却又正常了
解决方案 »
- 类和属性的问题?
- 查询结果显示少了秒值
- 新建Thread的问题
- WINFORM如何传递COOKIE给网站?
- 请问,在一个DataGrid里,怎么控制其中一列模板列的显示?
- 在WEB MATRIX中如何数据,比如说DATAGRID,不要使用SQLDATASOURCE的,像是在VS2003中那样绑定DATASOURCE可以吗??在线等
- c# 26位十进制
- 请问如何修改dataset中datatable的行列的状态?
- 这个属性怎么写
- WPF,自定义的UserControl怎么绑定属性?
- 谁会做winform的异步开发吗,我想后台在处理,前台显示进度条。
- 我用dataview绑定Listbox,然后我在dataview增加了条row,我在用sort排序却无法用,这是为什么
*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码) 最新版本:20070212http://www.cnblogs.com/feiyun0112/archive/2006/09/20/509783.html