本文整理汇总了C#中System.Data.SqlClient.SqlParameterCollection.Item属性的典型用法代码示例。如果您正苦于以下问题:C# SqlParameterCollection.Item属性的具体用法?C# SqlParameterCollection.Item怎么用?C# SqlParameterCollection.Item使用的例子?那么恭喜您, 这里精选的属性代码示例或许可以为您提供帮助。您也可以进一步了解该属性所在类System.Data.SqlClient.SqlParameterCollection
的用法示例。
在下文中一共展示了SqlParameterCollection.Item属性的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CreateSqlParameters
static private string CreateSqlParameters(int documentID)
{
// Assumes GetConnectionString returns a valid connection string to the
// AdventureWorks sample database on an instance of SQL Server 2005.
using (SqlConnection connection =
new SqlConnection(GetConnectionString()))
{
connection.Open();
SqlCommand command = connection.CreateCommand();
try
{
// Setup the command to execute the stored procedure.
command.CommandText = "GetDocumentSummary";
command.CommandType = CommandType.StoredProcedure;
// Create the input parameter for the DocumentID.
SqlParameter paramID =
new SqlParameter("@DocumentID", SqlDbType.Int);
paramID.Value = documentID;
command.Parameters.Add(paramID);
// Create the output parameter to retrieve the summary.
SqlParameter paramSummary =
new SqlParameter("@DocumentSummary", SqlDbType.NVarChar, -1);
paramSummary.Direction = ParameterDirection.Output;
command.Parameters.Add(paramSummary);
// List the parameters and some of properties.
SqlParameterCollection paramCollection = command.Parameters;
string parameterList = "";
for (int i = 0; i < paramCollection.Count; i++)
{
parameterList += String.Format(" {0}, {1}, {2}\n",
paramCollection[i], paramCollection[i].DbType,
paramCollection[i].Direction);
}
Console.WriteLine("Parameter Collection:\n" + parameterList);
// Execute the stored procedure; retrieve
// and display the output parameter value.
command.ExecuteNonQuery();
Console.WriteLine((String)(paramSummary.Value));
return (String)(paramSummary.Value);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return null;
}
}
}