本文整理汇总了C#中System.Data.OleDb.OleDbCommand.Prepare方法的典型用法代码示例。如果您正苦于以下问题：C# System.Data.OleDb.OleDbCommand.Prepare方法的具体用法？C# System.Data.OleDb.OleDbCommand.Prepare怎么用？C# System.Data.OleDb.OleDbCommand.Prepare使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.OleDb.OleDbCommand的用法示例。
在下文中一共展示了System.Data.OleDb.OleDbCommand.Prepare方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: OLEDBDeleteCommandObject
public System.Data.OleDb.OleDbCommand OLEDBDeleteCommandObject(string strWhere, bool Prepared)
{
if (cmdOLEDBDelete == null)
{
cmdOLEDBDelete = new System.Data.OleDb.OleDbCommand();
cmdOLEDBDelete.Connection = OLEDBConn;
if (m_OLEDBTrans != null)
cmdOLEDBDelete.Transaction = m_OLEDBTrans;
string strSQL = "Delete from " + pTablename + " WHERE " + strWhere;
cmdOLEDBDelete.CommandText = strSQL;
if (Prepared)
cmdOLEDBDelete.Prepare();
}
else
{
// Nur WHERE ändern !
int i = Strings.InStr(cmdOLEDBDelete.CommandText, " WHERE ");
cmdOLEDBDelete.CommandText = Strings.StrLeft(cmdOLEDBDelete.CommandText, i - 1) + " WHERE " + strWhere;
cmdOLEDBDelete.Transaction = m_OLEDBTrans;
}
return cmdOLEDBDelete;
} 示例2: OLEDBInsertCommandObject
// <<<<<<<<<<<<<<<<<<<<<<< OLE-DB >>>>>>>>>>>>>>>>>>>>>>>>
public System.Data.OleDb.OleDbCommand OLEDBInsertCommandObject(bool Prepared)
{
SQLColumnDefinition def;
if (cmdOLEDBInsert == null)
{
cmdOLEDBInsert = new System.Data.OleDb.OleDbCommand();
cmdOLEDBInsert.Connection = OLEDBConn;
if (m_OLEDBTrans != null)
cmdOLEDBInsert.Transaction = m_OLEDBTrans;
StringBuilder SB = new StringBuilder();
SB.Append("Insert into " + pTablename + " (");
SQLColumnDefinition d;
bool bFlag = false;
foreach (string ColumnName in ColumnNames)
{
d = Columns[ColumnName];
if (d.bActive)
{
if (bFlag)
SB.Append(", ");
SB.Append(ColumnName);
bFlag = true;
}
}
SB.Append(") Values (");
bFlag = false;
foreach (string ColumnName in ColumnNames)
{
d = Columns[ColumnName];
if (d.bActive)
{
if (bFlag)
SB.Append(", ");
SB.Append("@" + Column2ParameterName(ColumnName));
bFlag = true;
}
}
SB.Append(")");
cmdOLEDBInsert.CommandText = SB.ToString();
SetCommandParameters(ref cmdOLEDBInsert);
if (Prepared)
cmdOLEDBInsert.Prepare();
}
// Data
foreach (string ColumnName in ColumnNames)
{
def = Columns[ColumnName];
if (def.bActive)
{
cmdOLEDBInsert.Parameters["@" + Column2ParameterName(ColumnName)].Value = def.DBValue(pDBMSType);
}
}
return cmdOLEDBInsert;
}