本文整理汇总了C#中System.Data.SqlClient.SqlParameterCollection.Clear方法的典型用法代码示例。如果您正苦于以下问题：C# SqlParameterCollection.Clear方法的具体用法？C# SqlParameterCollection.Clear怎么用？C# SqlParameterCollection.Clear使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlClient.SqlParameterCollection的用法示例。
在下文中一共展示了SqlParameterCollection.Clear方法的5个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SetParameters
public override void SetParameters( SqlParameterCollection parameters )
{
parameters.Clear();
parameters.Add( "@id", SqlDbType.Int ).Value = DBNull.Value;
parameters.Add( "@itemId", SqlDbType.Int ).Value = DBNull.Value;
parameters.Add( "@source", SqlDbType.VarChar, 100 ).Value = DBNull.Value;
parameters.Add( "@bankId", SqlDbType.NVarChar, 100 ).Value = DBNull.Value;
parameters.Add( "@date", SqlDbType.DateTime ).Value = DBNull.Value;
parameters.Add( "@amount", SqlDbType.Decimal ).Value = DBNull.Value;
parameters.Add( "@number", SqlDbType.VarChar, 20 ).Value = DBNull.Value;
parameters.Add( "@description", SqlDbType.NVarChar, 200 ).Value = DBNull.Value;
parameters.Add( "@machine", SqlDbType.NVarChar, 100 ).Value = DBNull.Value;
parameters.Add( "@now", SqlDbType.DateTime ).Value = DBNull.Value;
}示例2: executeSQL
/// <summary>
/// Executes any SQL statement on the database.
/// </summary>
/// <param name="Parameters" >The Input/Output Parameters</param>
/// <param name="ResultSetType" >The Desired Result Set Type</param>
/// <param name="StoredProcedure" >A Command Object encapsulating the Stored Procedure Call</param>
/// <param name="SQLCommandType">The SQL command type.</param>
/// <value>An Object containing the Desired Result Set Type</value>
private object executeSQL(SqlCommand SqlCommand, TResultSetTypes ResultSetType, CommandType SQLCommandType, SqlParameterCollection Parameters)
{
SqlDataAdapter da = null;
DataTable returnDt = null;
DataSet returnDs = null;
Exception SaveException = null;
if (mTimeout != 0) {
SqlCommand.CommandTimeout = mTimeout;
mTimeout = 0;
}
lock (mSynchLock) {
try {
OpenIfClosed(SqlCommand);
SqlCommand.CommandType = SQLCommandType;
if (Parameters != null) {
List<SqlParameter> plist = new List<SqlParameter>();
foreach (SqlParameter p in Parameters) {
if (!this.NVarcharAllowed && p.SqlDbType == SqlDbType.NVarChar)
p.SqlDbType = SqlDbType.VarChar;
plist.Add(p);
}
Parameters.Clear();
SqlCommand.Parameters.AddRange(plist.ToArray());
}
if (ResultSetType != TResultSetTypes.None && ResultSetType != TResultSetTypes.Scalar) {
da = new SqlDataAdapter(SqlCommand);
}
for (int i = 1; i <= mnMAX_COMMAND_EXECUTION_RETRIES; i++) {
OpenIfClosed(SqlCommand);
try {
switch (ResultSetType) {
case TResultSetTypes.Scalar:
return SqlCommand.ExecuteScalar();
case TResultSetTypes.None:
return SqlCommand.ExecuteNonQuery();
case TResultSetTypes.Single:
returnDt = new DataTable();
fillFromAdapter(da, returnDt);
return returnDt;
case TResultSetTypes.Multiple:
returnDs = new DataSet();
fillFromAdapter(da, returnDs);
return returnDs;
default:
throw new EnumerationValueException(ResultSetType);
}
} catch (SqlException sqlEx) {
if (InTransaction() != null)
throw sqlEx;
if ((isTimeRelatedError(sqlEx.ToString()) ||
sqlEx.Message == "Unknown error." ||
sqlEx.Message == "A severe error occurred on the current command. The results, if any, should be discarded.") && i < mnMAX_COMMAND_EXECUTION_RETRIES) {
AuditLog.AuditException((Exception)sqlEx, "sql will retry", null);
Thread.Sleep(TimeSpan.FromSeconds(SECONDS_TO_WAIT_BEFORE_A_COMMAND_RETRY));
continue;
} else
throw sqlEx;
} catch (InvalidOperationException iEx) {
if (InTransaction() != null)
throw iEx;
if ((isTimeRelatedError(iEx.ToString()) ||
iEx.Message == "Unknown error." ||
iEx.Message == "A severe error occurred on the current command. The results, if any, should be discarded.") && i < mnMAX_COMMAND_EXECUTION_RETRIES) {
AuditLog.AuditException((Exception)iEx, "sql will retry", null);
Thread.Sleep(TimeSpan.FromSeconds(SECONDS_TO_WAIT_BEFORE_A_COMMAND_RETRY));
continue;
} else
throw iEx;
}
}
} catch (SqlException sqlEx) {
SaveException = (Exception)sqlEx;
//Lets Use The MS Application Block here w/a custom publisher that sends out an eMail & Publishes exception data to a structure in the Shared Database.
//If Shared DB is not available then publish exception data to the event log.
throw sqlEx;
} catch (Exception ex) {
SaveException = ex;
//Lets Use The MS Application Block here w/a custom publisher that sends out an eMail & Publishes exception data to a structure in the Shared Database.
//If Shared DB is not available then publish exception data to the event log.
throw new Exception(ex.Message, ex);
} finally {
if (SaveException != null)
AuditLog.AuditException(SaveException, "sqlutil failure", null);
if (da != null)
da.Dispose();
if (returnDt != null)
//.........这里部分代码省略.........
示例3: SetParameters
public override void SetParameters( SqlParameterCollection parameters )
{
parameters.Clear();
parameters.Add( "@id", SqlDbType.Int ).Value = DBNull.Value;
parameters.Add( "@name", SqlDbType.NVarChar, 50 ).Value = DBNull.Value;
parameters.Add( "@type", SqlDbType.VarChar, 20 ).Value = DBNull.Value;
parameters.Add( "@source", SqlDbType.VarChar, 100 ).Value = DBNull.Value;
parameters.Add( "@startingBalance", SqlDbType.Decimal ).Value = DBNull.Value;
parameters.Add( "@startingDate", SqlDbType.DateTime ).Value = DBNull.Value;
parameters.Add( "@machine", SqlDbType.NVarChar, 100 ).Value = DBNull.Value;
parameters.Add( "@now", SqlDbType.DateTime ).Value = DBNull.Value;
}示例4: SetParameters
public override void SetParameters( SqlParameterCollection parameters )
{
parameters.Clear();
parameters.Add( "@id", SqlDbType.Int ).Value = DBNull.Value;
parameters.Add( "@date", SqlDbType.DateTime ).Value = DBNull.Value;
parameters.Add( "@amount", SqlDbType.Decimal ).Value = DBNull.Value;
parameters.Add( "@payee", SqlDbType.NVarChar, 200 ).Value = DBNull.Value;
parameters.Add( "@memo", SqlDbType.NVarChar, 200 ).Value = DBNull.Value;
parameters.Add( "@generated", SqlDbType.Bit ).Value = DBNull.Value;
parameters.Add( "@voided", SqlDbType.Bit ).Value = DBNull.Value;
parameters.Add( "@machine", SqlDbType.NVarChar, 100 ).Value = DBNull.Value;
parameters.Add( "@now", SqlDbType.DateTime ).Value = DBNull.Value;
}示例5: SetParameters
public override void SetParameters( SqlParameterCollection parameters )
{
parameters.Clear();
parameters.Add( "@id", SqlDbType.Int ).Value = DBNull.Value;
parameters.Add( "@transId", SqlDbType.Int ).Value = DBNull.Value;
parameters.Add( "@onlineId", SqlDbType.Int ).Value = DBNull.Value;
parameters.Add( "@accountId", SqlDbType.Int ).Value = DBNull.Value;
parameters.Add( "@date", SqlDbType.DateTime ).Value = DBNull.Value;
parameters.Add( "@type", SqlDbType.Char, 1 ).Value = DBNull.Value;
parameters.Add( "@number", SqlDbType.VarChar, 20 ).Value = DBNull.Value;
parameters.Add( "@amount", SqlDbType.Decimal ).Value = DBNull.Value;
parameters.Add( "@memo", SqlDbType.NVarChar, 200 ).Value = DBNull.Value;
parameters.Add( "@category", SqlDbType.NVarChar, 20 ).Value = DBNull.Value;
parameters.Add( "@reconciled", SqlDbType.Bit ).Value = DBNull.Value;
parameters.Add( "@machine", SqlDbType.NVarChar, 100 ).Value = DBNull.Value;
parameters.Add( "@now", SqlDbType.DateTime ).Value = DBNull.Value;
}