各位大虾,C#对数据库操作时一些关于参数的简单问题.给分啊
各位大虾,我用C#对ORACLE数据库操作时,用到了参数。具体如下:private const string strSql= "SELECT DISTINCT AFFILIATED FROM t_ZoneMsg where RPOVINCE=?";
public OracleCommand FillCityToComb()
{
OracleCommand SelectCityCommand = new OracleCommand(strSql, db.mConnection);
OracleParameterCollection selectCityPC = SelectCityCommand.Parameters;
OracleParameter selectCityPm;
selectCityPm = selectCityPC.Add("Provin_new", OracleType.VarChar, 20, "PROVINCE");
selectCityPm.SourceVersion = DataRowVersion.Original;
return SelectCityCommand;
}
定义的这个方法,怎么定义参又,怎么传参啊?谢谢 --------------------编程问答-------------------- OracleParameter selectCityPm=new OracleParameter(此处省略);
selectCityPm.Value="你的值";
???
--------------------编程问答-------------------- 见这篇文章:http://blog.csdn.net/zhoufoxcn/archive/2008/03/19/2195618.aspx
--------------------编程问答-------------------- 谢谢楼上,而我的参数的表示法用的是"?",有什么区别?又该怎么做。 --------------------编程问答-------------------- 请看我博客上的那篇文章,那上面说明了在不同数据库该用什么,如:或者@或者?
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;
/// <summary>
/// 在Oracle中使用参数化SQL的例子
/// 代码编写:周公
/// 日期:2008-3-19
/// 发表网址:http://blog.csdn.net/zhoufoxcn/archive/2008/03/19/2195618.aspx
/// </summary>
public class OracleUtil
{
public OracleUtil()
{
}
public bool InsertAdmin(string userName, string password, string remark, string mail, int departId, int power)
{
string sql = "insert into S_Admin(UserName,Password,Remark,Mail,DepartId,Power)values(:UserName,:Password,:Remark,:Mail,:DepartId,:Power)";
OracleConnection connection = new OracleConnection();
connection.ConnectionString = "";//此处设置链接字符串
OracleCommand command = new OracleCommand(sql, connection);
command.Parameters.Add(":UserName", OracleType.NVarChar, 60).Value = userName;
command.Parameters.Add(":Password", OracleType.NVarChar, 60).Value =password;
command.Parameters.Add(":Remark", OracleType.NVarChar, 60).Value = remark;
command.Parameters.Add(":Mail", OracleType.NVarChar, 60).Value =mail;
command.Parameters.Add(":DepartId", OracleType.Int32, 4).Value =departId;
command.Parameters.Add(":Power", OracleType.Int32, 4).Value = power;
connection.Open();
int rowsAffected=command.ExecuteNonQuery();
connection.Close();
command.Dispose();
return rowsAffected > 0;
}
}
补充:.NET技术 , C#