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