Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Runs the CustomerAdd stored procedure

using System; using System.Data; using System.Data.SqlClient; public class AddCustomer {     public static void Main()      {         string connectionString = "Data Source=localhost;Initial Catalog=store;Integrated Security=SSPI";         string procedure = "CustomerAdd";         SqlConnection con = new SqlConnection(connectionString);         SqlCommand cmd = new SqlCommand(procedure, con);         cmd.CommandType = CommandType.StoredProcedure;         SqlParameter param;         param = cmd.Parameters.Add("@FullName", SqlDbType.NVarChar, 50);         param.Value = "AAA";         param = cmd.Parameters.Add("@Email", SqlDbType.NVarChar, 50);         param.Value = "j@my.com";         param = cmd.Parameters.Add("@Password", SqlDbType.NVarChar, 50);         param.Value = "password";         param = cmd.Parameters.Add("@CustomerID", SqlDbType.Int);         param.Direction = ParameterDirection.Output;         con.Open();         cmd.ExecuteNonQuery();         con.Close();         Console.WriteLine(param.Value);     } }