本文整理汇总了C#中System.Data.Common.DbParameter类的典型用法代码示例。如果您正苦于以下问题:C# DbParameter类的具体用法?C# DbParameter怎么用?C# DbParameter使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
DbParameter类属于System.Data.Common命名空间,在下文中一共展示了DbParameter类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: PrepareUpdateCommand
/// <summary>
/// 为更新一条数据准备参数
/// </summary>
internal static void PrepareUpdateCommand(ZSystem.Model.t_Product model, out StringBuilder strSql, out DbParameter[] cmdParms)
{
strSql = new StringBuilder();
strSql.Append("UPDATE t_Product SET ");
strSql.Append("[email protected]_sProductName,");
strSql.Append("[email protected]_iPrice,");
strSql.Append("[email protected]_Memo,");
strSql.Append("[email protected]_iDiscount,");
strSql.Append("[email protected]_IsEnable,");
strSql.Append("[email protected]_Begindate,");
strSql.Append("[email protected]_Enddate,");
strSql.Append("[email protected]_LastUpdate");
strSql.Append(" WHERE [email protected]_KeyID");
cmdParms = new DbParameter[]{
dbHelper.CreateInDbParameter("@in_sProductName", DbType.String, model.sProductName),
dbHelper.CreateInDbParameter("@in_iPrice", DbType.Double, model.iPrice),
dbHelper.CreateInDbParameter("@in_Memo", DbType.String, model.Memo),
dbHelper.CreateInDbParameter("@in_iDiscount", DbType.Int32, model.iDiscount),
dbHelper.CreateInDbParameter("@in_IsEnable", DbType.Boolean, model.IsEnable),
dbHelper.CreateInDbParameter("@in_Begindate", DbType.DateTime, model.Begindate),
dbHelper.CreateInDbParameter("@in_Enddate", DbType.DateTime, model.Enddate),
dbHelper.CreateInDbParameter("@in_LastUpdate", DbType.DateTime, model.LastUpdate),
dbHelper.CreateInDbParameter("@in_KeyID", DbType.Guid, model.KeyID)};
}
开发者ID:ViniciusConsultor,项目名称:ccplatform,代码行数:28,代码来源:t_Product.cs
示例2: Consultar
public DataSet Consultar(DbParameter[] aParams)
{
using (DbConnection conProxy = AbrirConexion())
{
return Consultar(aParams, conProxy, null);
}
}
开发者ID:ErwinNiwre,项目名称:ControlStudent,代码行数:7,代码来源:DBCAD.cs
示例3: PrepareCommand
private static void PrepareCommand(
DbCommand command,
DbConnection connection,
DbTransaction transaction,
CommandType commandType,
string commandText,
DbParameter[] commandParameters)
{
if (command == null) throw new ArgumentNullException("command");
if (commandText == null || commandText.Length == 0) throw new ArgumentNullException("commandText");
command.Connection = connection;
command.CommandText = commandText;
command.CommandType = commandType;
if (transaction != null)
{
if (transaction.Connection == null) throw new ArgumentException("The transaction was rollbacked or commited, please provide an open transaction.", "transaction");
command.Transaction = transaction;
}
if (commandParameters != null)
{
AttachParameters(command, commandParameters);
}
return;
}
开发者ID:freemsly,项目名称:cloudscribe,代码行数:27,代码来源:AdoHelper.cs
示例4: SetupParameter
public virtual void SetupParameter(DbParameter param, string name, object value)
{
name.MustNotBeEmpty();
param.ParameterName = ParamPrefix+name;
param.Value = value ?? DBNull.Value;
}
开发者ID:sapiens,项目名称:SqlFu,代码行数:7,代码来源:DbProvider.cs
示例5: CopyParameter
public bool CopyParameter(ref DbParameter param)
{
switch (GetDataType().Name)
{
case "String":
param.DbType = DbType.String;
break;
case "Int32":
case "UInt32":
param.DbType = DbType.Int32;
break;
case "Int16":
case "UInt16":
param.DbType = DbType.Int16;
break;
case "SByte":
case "Byte":
param.DbType = DbType.SByte;
break;
default:
return false;
}
param.Value = GetData();
return true;
}
开发者ID:MysteryGuest,项目名称:KO-AIOEditor,代码行数:30,代码来源:DatabaseParameter.cs
示例6: getFromActiveDirectory
internal DataTable getFromActiveDirectory(string username)
{
try
{
sqlop = new SqlOperations();
sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString();
DbParameter[] dbp = new DbParameter[1];
dbp[0] = new SqlParameter();
dbp[0].ParameterName = "UserID";
dbp[0].DbType = DbType.String;
dbp[0].Direction = ParameterDirection.Input;
dbp[0].Value = username;
SqlCommandObject sco = new SqlCommandObject();
sco.SPName = "Utenti.SP_Utenti_ADData_Get";
sco.SPParams = dbp;
DataTable dt;
string proc = sqlop.ExecuteProcedure(sco, out dt);
return dt;
}
catch (Exception ex)
{
throw ex;
}
}
开发者ID:walkstudio,项目名称:AnagD,代码行数:29,代码来源:UtenteMng.cs
示例7: CreateCommand
private IDbCommand CreateCommand(DbMetaLog dblog, IDbConnection conn)
{
string fields = "";
string vals = "";
DbParameter[] dbParameters = new DbParameter[dblog.FiledValues.Count];
int i = 0;
foreach (string key in dblog.FiledValues.Keys)
{
fields += string.Format("{0},", key);
vals += string.Format("@{0},", key);
dbParameters[i] = this.CreateDbParameter(dblog.DbDialect, "@" + key, dblog.FiledValues[key]);
i++;
}
fields = fields.Trim(',');
vals = vals.Trim(',');
string commandText = string.Format("INSERT INTO {0} ({1}) VALUES ({2})", dblog.DestTable, fields, vals);
IDbCommand cmd = conn.CreateCommand();
cmd.CommandText = commandText;
cmd.CommandType = CommandType.Text;
this.AttachParameters(cmd, dbParameters);
return cmd;
}
开发者ID:peterchen,项目名称:gaopincai,代码行数:25,代码来源:DBLogAppender.cs
示例8: ExecuteInsertQuery
/// <summary>
/// Insert Query
/// </summary>
/// <param name="query">
/// </param>
/// <param name="sqlParameter">
/// </param>
/// <returns>
/// The <see cref="bool"/>.
/// </returns>
public bool ExecuteInsertQuery(string query, DbParameter[] sqlParameter)
{
using (var cmd = new SqlCommand())
{
try
{
cmd.Connection = this.OpenConnection();
cmd.CommandText = query;
cmd.Parameters.AddRange(sqlParameter);
this.sqlDataAdapter.InsertCommand = cmd;
cmd.ExecuteNonQuery();
}
catch (SqlException exception)
{
throw new Exception(
"Error - ExecuteInsertQuery - Query:" + query + "\nException" + exception.StackTrace);
return false;
}
finally
{
this.conn.Close();
}
return true;
}
}
开发者ID:Stayrony,项目名称:Moody,代码行数:36,代码来源:SqlDataManager.cs
示例9: ConsultarPruebas
public List<PruebaBE> ConsultarPruebas(int idPrueba)
{
List<PruebaBE> pruebas = new List<PruebaBE>();
try
{
string nameSP = "ConsultarPruebas";
BaseDatos db = new BaseDatos();
db.Conectar();
db.CrearComandoSP(nameSP);
DbParameter[] parametros = new DbParameter[3];
parametros[0] = db.Comando.CreateParameter();
parametros[0].ParameterName = "vrIdPrueba";
parametros[0].Value = idPrueba;
parametros[0].Direction = ParameterDirection.Input;
db.Comando.Parameters.Add(parametros[0]);
parametros[1] = db.Comando.CreateParameter();
parametros[1].ParameterName = "vrCodResult";
parametros[1].Value = 0;
parametros[1].Direction = ParameterDirection.Output;
db.Comando.Parameters.Add(parametros[1]);
parametros[2] = db.Comando.CreateParameter();
parametros[2].ParameterName = "vrDescResult";
parametros[2].Value = "";
parametros[2].Direction = ParameterDirection.Output;
parametros[2].Size = 200;
parametros[2].DbType = DbType.String;
db.Comando.Parameters.Add(parametros[2]);
DbDataReader datos = db.EjecutarConsulta();
PruebaBE p = null;
while (datos.Read())
{
try
{
p = new PruebaBE();
p.IdPrueba = Int32.Parse(datos.GetValue(0).ToString());
p.Descripción = datos.GetString(1);
p.Fecha = datos.GetDateTime(2);
pruebas.Add(p);
}
catch (InvalidCastException ex)
{
throw new Exception("Los tipos no coinciden.", ex);
}
catch (DataException ex)
{
throw new Exception("Error de ADO.NET.", ex);
}
}
datos.Close();
db.Desconectar();
}
catch (Exception ex)
{
throw new Exception("Error al acceder a la base de datos para obtener los PruebaBEs.");
}
return pruebas;
}
开发者ID:jalpiste,项目名称:cyltrack,代码行数:60,代码来源:PruebaDL.cs
示例10: GestioneRicerca
internal string GestioneRicerca(string strRicerca, string user)
{
sqlop = new SqlOperations();
sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString();
SqlCommandObject sco = new SqlCommandObject();
DbParameter[] dbp = new DbParameter[2];
dbp[0] = new SqlParameter();
dbp[0].ParameterName = "Ricerca";
dbp[0].DbType = DbType.Xml;
dbp[0].Direction = ParameterDirection.Input;
dbp[0].Value = strRicerca;
dbp[1] = new SqlParameter();
dbp[1].ParameterName = "Utente";
dbp[1].DbType = DbType.String;
dbp[1].Direction = ParameterDirection.Input;
dbp[1].Value = user;
sco.SPParams = dbp;
sco.SPName = "[Utility].[SP_ArchivioRicerca_Insert]";
DataTable dt;
string proc = sqlop.ExecuteProcedure(sco, out dt);
return proc;
}
开发者ID:walkstudio,项目名称:Anagrafica-Dealer,代码行数:26,代码来源:RicercaMng.cs
示例11: ConsultaCiudades
public List<CiudadBE> ConsultaCiudades(string id_dep)
{
List<CiudadBE> lstCiudades = new List<CiudadBE>();
try
{
string nameSP = "ConsultarCiudades";
BaseDatos db = new BaseDatos();
db.Conectar();
db.CrearComandoSP(nameSP);
DbParameter[] parametros = new DbParameter[3];
parametros[0] = db.Comando.CreateParameter();
parametros[0].ParameterName = "vrId_Departamento";
parametros[0].Value = id_dep;
parametros[0].Direction = ParameterDirection.Input;
db.Comando.Parameters.Add(parametros[0]);
parametros[1] = db.Comando.CreateParameter();
parametros[1].ParameterName = "vrCodResult";
parametros[1].Value = 0;
parametros[1].Direction = ParameterDirection.Output;
db.Comando.Parameters.Add(parametros[1]);
parametros[2] = db.Comando.CreateParameter();
parametros[2].ParameterName = "vrDescResult";
parametros[2].Value = "";
parametros[2].Direction = ParameterDirection.Output;
parametros[2].Size = 200;
parametros[2].DbType = DbType.String;
db.Comando.Parameters.Add(parametros[2]);
DbDataReader datos = db.EjecutarConsulta();
CiudadBE c = null;
while (datos.Read())
{
try
{
c = new CiudadBE();
c.Id_Ciudad = datos.GetValue(0).ToString();
c.Nombre_Ciudad= (datos.GetString(1));
lstCiudades.Add(c);
}
catch (InvalidCastException ex)
{
throw new Exception("Los tipos no coinciden.", ex);
}
catch (DataException ex)
{
throw new Exception("Error de ADO.NET.", ex);
}
}
datos.Close();
db.Desconectar();
}
catch (Exception ex)
{
throw new Exception("Error al acceder a la base de datos para obtener los CiudadesBEs.");
}
return lstCiudades;
}
开发者ID:jalpiste,项目名称:cyltrack,代码行数:60,代码来源:RutaDL.cs
示例12: TryLogin
public bool TryLogin(string username, string password, out string hash)
{
bool loginSuccess = false;
_db.Open();
hash = "";
DbParameter[] parameters = new DbParameter[] { new SqlParameter("@username", username),
new SqlParameter("@password", password),
new SqlParameter("@connectionTime", System.Data.SqlDbType.DateTime) };
parameters[2].Direction = System.Data.ParameterDirection.Output;
int userCount = (int)_db.ExecuteScalar(DbNames.USERLOGIN_STOREDPROC,
System.Data.CommandType.StoredProcedure, parameters);
if (userCount == 1)
{
DateTime loginTime = (DateTime)parameters[2].Value;
hash = loginTime.ToString("yyyyMMddHHmmss");
loginSuccess = true;
}
_db.Close();
return loginSuccess;
}
开发者ID:zarut,项目名称:xiah-gcf-emulator,代码行数:25,代码来源:LoginManager.cs
示例13: Add
public string Add(DbParameter parameter)
{
var name = ":p" + (NamedParameters.Count + 1);
parameter.ParameterName = name;
NamedParameters.Add(parameter);
return name;
}
开发者ID:dstimac,项目名称:revenj,代码行数:7,代码来源:ParameterAggregator.cs
示例14: ExecuteDataTable
/// <summary>
/// 执行一个查询语句,返回一个包含查询结果的DataTable
/// </summary>
/// <param name="sql">要执行的查询语句</param>
/// <param name="parameters">执行SQL查询语句所需要的参数,参数必须以它们在SQL语句中的顺序为准</param>
/// <returns></returns>
public DataTable ExecuteDataTable(string sql, DbParameter[] parameters)
{
try
{
using (SQLiteConnection connection = new SQLiteConnection(connectionString))
{
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(sql, connection))
{
if (parameters != null)
{
command.Parameters.AddRange(parameters);
}
SQLiteDataAdapter adapter = new SQLiteDataAdapter(command);
DataTable data = new DataTable();
adapter.Fill(data);
return data;
}
}
}
catch (Exception)
{
throw;
}
}
开发者ID:haisapan,项目名称:YongHeApp,代码行数:32,代码来源:SqlLiteDataBaseManager.cs
示例15: PrepareUpdateCommand
/// <summary>
/// 为更新一条数据准备参数
/// </summary>
internal static void PrepareUpdateCommand(ZSystem.Model.t_IVRControl model, out StringBuilder strSql, out DbParameter[] cmdParms)
{
strSql = new StringBuilder();
strSql.Append("UPDATE t_IVRControl SET ");
strSql.Append("[email protected]_sFileName,");
strSql.Append("[email protected]_iKeyNum,");
strSql.Append("[email protected]_SubID,");
strSql.Append("[email protected]_sIVRName,");
strSql.Append("[email protected]_IsEnable,");
strSql.Append("[email protected]_BeginDate,");
strSql.Append("[email protected]_EndDate,");
strSql.Append("[email protected]_LastUpdate");
strSql.Append(" WHERE [email protected]_KeyID");
cmdParms = new DbParameter[]{
dbHelper.CreateInDbParameter("@in_sFileName", DbType.String, model.sFileName),
dbHelper.CreateInDbParameter("@in_iKeyNum", DbType.Int32, model.iKeyNum),
dbHelper.CreateInDbParameter("@in_SubID", DbType.String, model.SubID),
dbHelper.CreateInDbParameter("@in_sIVRName", DbType.String, model.sIVRName),
dbHelper.CreateInDbParameter("@in_IsEnable", DbType.Boolean, model.IsEnable),
dbHelper.CreateInDbParameter("@in_BeginDate", DbType.DateTime, model.BeginDate),
dbHelper.CreateInDbParameter("@in_EndDate", DbType.DateTime, model.EndDate),
dbHelper.CreateInDbParameter("@in_LastUpdate", DbType.DateTime, model.LastUpdate),
dbHelper.CreateInDbParameter("@in_KeyID", DbType.String, model.KeyID)};
}
开发者ID:ViniciusConsultor,项目名称:ccplatform,代码行数:28,代码来源:t_IVRControl.cs
示例16: Clear
/// <summary>
/// 清除当前所有数据
/// </summary>
public void Clear()
{
CurrentDbParameter = null;
_currentFieldName = null;
_paramsCount = 0;
SqlList.Clear();
}
开发者ID:lirongjun0926,项目名称:Farseer.Net,代码行数:10,代码来源:DbExpressionBoolProvider.cs
示例17: ApplyParameterInfo
protected override void ApplyParameterInfo(DbParameter parameter, DataRow datarow, StatementType statementType, bool whereClause)
{
SqlParameter parameter2 = (SqlParameter) parameter;
object obj3 = datarow[SchemaTableColumn.ProviderType];
parameter2.SqlDbType = (SqlDbType) obj3;
parameter2.Offset = 0;
if ((parameter2.SqlDbType == SqlDbType.Udt) && !parameter2.SourceColumnNullMapping)
{
parameter2.UdtTypeName = datarow["DataTypeName"] as string;
}
else
{
parameter2.UdtTypeName = string.Empty;
}
object obj2 = datarow[SchemaTableColumn.NumericPrecision];
if (DBNull.Value != obj2)
{
byte num2 = (byte) ((short) obj2);
parameter2.PrecisionInternal = (0xff != num2) ? num2 : ((byte) 0);
}
obj2 = datarow[SchemaTableColumn.NumericScale];
if (DBNull.Value != obj2)
{
byte num = (byte) ((short) obj2);
parameter2.ScaleInternal = (0xff != num) ? num : ((byte) 0);
}
}
开发者ID:pritesh-mandowara-sp,项目名称:DecompliedDotNetLibraries,代码行数:27,代码来源:SqlCommandBuilder.cs
示例18: DeleteProfilo
internal string DeleteProfilo(int idObj)
{
sqlop = new SqlOperations();
sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString();
DbParameter[] dbp = new DbParameter[1];
dbp[0] = new SqlParameter();
dbp[0].ParameterName = "IDProfilo";
dbp[0].DbType = DbType.Int32;
dbp[0].Direction = ParameterDirection.Input;
dbp[0].Value = idObj;
SqlCommandObject sco = new SqlCommandObject();
sco.SPName = "Utenti.SP_Profilo_Delete";
sco.SPParams = dbp;
DataTable dt;
string proc = sqlop.ExecuteProcedure(sco, out dt);
if (proc != string.Empty)
return proc;
return "";
}
开发者ID:walkstudio,项目名称:AnagD,代码行数:25,代码来源:ProfiloMng.cs
示例19: DeleteRelazione
internal string DeleteRelazione(int idRelazione, int idTipoDealer)
{
sqlop = new SqlOperations();
sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString();
DbParameter[] dbp = new DbParameter[2];
dbp[0] = new SqlParameter();
dbp[0].ParameterName = "IDRelazione";
dbp[0].DbType = DbType.Int32;
dbp[0].Direction = ParameterDirection.Input;
dbp[0].Value = idRelazione;
dbp[1] = new SqlParameter();
dbp[1].ParameterName = "IDTipoDealer";
dbp[1].DbType = DbType.Int32;
dbp[1].Direction = ParameterDirection.Input;
dbp[1].Value = idTipoDealer;
SqlCommandObject sco = new SqlCommandObject();
sco.SPName = "Dealer.SP_RelazioniDealer_Delete";
sco.SPParams = dbp;
DataTable dt;
string proc = sqlop.ExecuteProcedure(sco, out dt);
if (proc != string.Empty)
return proc;
return "";
}
开发者ID:walkstudio,项目名称:Anagrafica-Dealer,代码行数:32,代码来源:RelazioniMng.cs
示例20: ExecuteScalar
public int ExecuteScalar(string sqlstr, DbParameter[] parameters)
{
if (string.IsNullOrEmpty(sqlstr))
{
return 0;
}
OpenConn();
Cmd.CommandType = CommandType.Text;
Cmd.CommandText = sqlstr;
Cmd.Parameters.Clear();
if (parameters != null)
{
Cmd.Parameters.AddRange(parameters);
}
try
{
return Convert.ToInt32(Cmd.ExecuteScalar());
}
catch
{
throw;
}
finally
{
Cmd.Dispose();
}
}
开发者ID:gkpeng19,项目名称:MyFramework,代码行数:28,代码来源:DBProvider.cs
注:本文中的System.Data.Common.DbParameter类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论