本文整理汇总了C#中TdsMetaParameterCollection.Add方法的典型用法代码示例。如果您正苦于以下问题：C# TdsMetaParameterCollection.Add方法的具体用法？C# TdsMetaParameterCollection.Add怎么用？C# TdsMetaParameterCollection.Add使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类TdsMetaParameterCollection的用法示例。
在下文中一共展示了TdsMetaParameterCollection.Add方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Prepare
public override string Prepare (string commandText, TdsMetaParameterCollection parameters)
{
Parameters = parameters;
TdsMetaParameterCollection parms = new TdsMetaParameterCollection ();
TdsMetaParameter parm = new TdsMetaParameter ("@Handle", "int", null);
parm.Direction = TdsParameterDirection.Output;
parms.Add (parm);
parms.Add (new TdsMetaParameter ("@VarDecl", "nvarchar", BuildPreparedParameters ()));
parms.Add (new TdsMetaParameter ("@Query", "nvarchar", commandText));
ExecProc ("sp_prepare", parms, 0, true);
SkipToEnd ();
return OutputParameters[0].ToString () ;
//if (ColumnValues == null || ColumnValues [0] == null || ColumnValues [0] == DBNull.Value)
// throw new TdsInternalException ();
//return string.Empty;
//return ColumnValues [0].ToString ();
}示例2: Unprepare
public override void Unprepare (string statementId)
{
TdsMetaParameterCollection parms = new TdsMetaParameterCollection ();
parms.Add (new TdsMetaParameter ("@P1", "int", Int32.Parse (statementId)));
ExecProc ("sp_unprepare", parms, 0, false);
}示例3: Prepare
public override string Prepare (string commandText, TdsMetaParameterCollection parameters)
{
Parameters = parameters;
TdsMetaParameterCollection parms = new TdsMetaParameterCollection ();
// Tested with MS SQL 2008 RC2 Express and MS SQL 2012 Express:
// You may pass either -1 or 0, but not null as initial value of @Handle,
// which is an output parameter.
TdsMetaParameter parm = new TdsMetaParameter ("@Handle", "int", -1);
parm.Direction = TdsParameterDirection.Output;
parms.Add (parm);
parms.Add (new TdsMetaParameter ("@VarDecl", "nvarchar", BuildPreparedParameters ()));
parms.Add (new TdsMetaParameter ("@Query", "nvarchar", commandText));
ExecProc ("sp_prepare", parms, 0, true);
SkipToEnd ();
return OutputParameters[0].ToString () ;
//if (ColumnValues == null || ColumnValues [0] == null || ColumnValues [0] == DBNull.Value)
// throw new TdsInternalException ();
//return string.Empty;
//return ColumnValues [0].ToString ();
}