Add OutputStream and InputStream to IDbCommand

    


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

class Utility
{
    internal static IDbDataParameter AddOutputParam(this IDbCommand command, string name, DbType type)
    {
        IDbDataParameter param = command.CreateParameter();
        param.ParameterName = name;
        param.DbType = type;
        param.Direction = ParameterDirection.Output;
        command.Parameters.Add(param);
        return param;
    }
    internal static void AddInputParam(this IDbCommand command, string name, object value)
    {
        IDbDataParameter param = command.CreateParameter();
        param.ParameterName = name;
        param.Value = value;
        command.Parameters.Add(param);
    }
}

Related examples in the same category

1.	Use StreamWriter to create a text file
2.	Reading from a text file line by line
3.	Read data in line by line
4.	StreamReader.ReadLine
5.	Catch file read exception and retry
6.	Construct StreamWriter from FileSream
7.	Create a StreamWriter in UTF8 mode
8.	StreamReader And Writer
9.	illustrates reading and writing text data
10.	Asynchronously reads a stream
11.	The use of a buffered stream to serve as intermediate data holder for another stream
12.	Demonstrates attaching a StreamReader object to a stream
13.	Demonstrates attaching a StreamWriter object to a stream
14.	A simple key-to-disk utility that demonstrates a StreamWriter
15.	Open a file using StreamWriter
16.	A help program that uses a disk file to store help information
17.	Try and catch exceptions for StreamWriter
18.	Using StreamWriter 3
19.	Utility class that provides methods to manipulate stream of data.
20.	Reads a stream into a byte array.
21.	Copies one stream into another.
22.	Copy Stream from fromStream to toStream
23.	Enumerate Lines for StreamReader
24.	Enumerate non-empty Lines for StreamReader
25.	Fifo Stream
26.	Read from stream
27.	Read from a Stream ensuring all the required data is read.
28.	Serializes and object to a stream. It will flush and close the underlying stream.
29.	Read Stream to End
30.	Copy Stream and close
31.	Stream Converter
32.	Buffered InputStream
33.	Page Filter Stream
34.	Copies an Stream into another Stream.

Add OutputStream and InputStream to IDbCommand : Stream Read Write « File Stream « C# / C Sharp

Related examples in the same category