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的语句却又正常了
解决方案 »
- C# Print2Flash 文件转换
- for循环次数比较多,如何提高速度?
- winfrom动态创建CheckBox
- C#中添加数据到数据库....总是出错..
- 讨教指令执行方案
- 实时采集系统的数据存储问题,欢迎讨论。
- 如何取得客户端IP??
- 用C#怎么将一程序的图标发往桌面的快捷方式?
- 急需:C#语句如何HOOK API
- 使用ado.net访问远程sqlserver上的链接数据库(链接access),在2003下调试没有问题,但是在2000或者xp上旧有问题?来者有分
- 谁会做winform的异步开发吗,我想后台在处理,前台显示进度条。
- 我用dataview绑定Listbox,然后我在dataview增加了条row,我在用sort排序却无法用,这是为什么
*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码) 最新版本:20070212http://www.cnblogs.com/feiyun0112/archive/2006/09/20/509783.html