01.
using
System;
02.
using
System.Collections.Generic;
03.
using
System.Linq;
04.
using
System.Text;
05.
using
System.Threading.Tasks;
06.
using
System.Data.SqlClient;
07.
using
System.Data;
08.
09.
namespace
MyApplication
10.
{
11.
class
Program
12.
{
13.
static
void
Main(
string
[] args)
14.
{
15.
SqlConnection objConn =
new
SqlConnection();
16.
SqlCommand objCmd =
new
SqlCommand();
17.
18.
String strConnString, strStored;
19.
20.
strConnString =
"Server=localhost;UID=sa;PASSWORD=;database=mydatabase; "
+
21.
" Max Pool Size=400;Connect Timeout=600;"
;
22.
objConn.ConnectionString = strConnString;
23.
objConn.Open();
24.
25.
string
strCustomerID =
"C005"
;
26.
string
strName =
"Fun Wipa"
;
27.
string
strEmail =
"fun.wipa@thaicreate.com"
;
28.
string
strCountryCode =
"TH"
;
29.
decimal
dBudget = 100000;
30.
decimal
dUsed = 0;
31.
32.
strStored =
"insertCustomer"
;
33.
objCmd.Parameters.Add(
new
SqlParameter(
"pCustomerID"
, SqlDbType.VarChar, 4)).Value = strCustomerID;
34.
objCmd.Parameters.Add(
new
SqlParameter(
"pName"
, SqlDbType.VarChar, 150)).Value = strName;
35.
objCmd.Parameters.Add(
new
SqlParameter(
"pEmail"
, SqlDbType.VarChar, 150)).Value = strEmail;
36.
objCmd.Parameters.Add(
new
SqlParameter(
"pCountryCode"
, SqlDbType.VarChar, 2)).Value = strCountryCode;
37.
objCmd.Parameters.Add(
new
SqlParameter(
"pBudget"
, SqlDbType.VarChar)).Value = dBudget;
38.
objCmd.Parameters.Add(
new
SqlParameter(
"pUsed"
, SqlDbType.VarChar)).Value = dUsed;
39.
40.
objCmd.Parameters.Add(
new
SqlParameter(
"pResult"
, SqlDbType.Int)).Direction = ParameterDirection.Output;
41.
objCmd.Parameters.Add(
new
SqlParameter(
"pMessage"
, SqlDbType.VarChar, 500)).Direction = ParameterDirection.Output;
42.
43.
objCmd.Connection = objConn;
44.
objCmd.CommandText = strStored;
45.
objCmd.CommandType = CommandType.StoredProcedure;
46.
47.
objCmd.ExecuteNonQuery();
48.
49.
50.
51.
Console.WriteLine(
string
.Format(
"pResult = {0}"
, objCmd.Parameters[
"pResult"
].Value));
52.
53.
54.
Console.WriteLine(
string
.Format(
"pMessage = {0}"
, objCmd.Parameters[
"pMessage"
].Value));
55.
56.
objConn.Close();
57.
objConn =
null
;
58.
}
59.
}
60.
}