here are the additions to make...
Insert
Code:
public void InsertCustomer(Customer cust)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("CustomerInsert", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
// assuming parameters
cmd.Parameters.AddWithValue("@CustomerName", cust.Name);
cmd.Parameters.AddWithValue("@CustomerAddress", cust.Address);
conn.Open();
cmd.ExecuteNonQuery();
}
}
}
Update
Code:
public void UpdateCustomer(Customer cust)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("CustomerUpdate", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
// assuming parameters
cmd.Parameters.AddWithValue("@CustomerName", cust.Name);
cmd.Parameters.AddWithValue("@CustomerAddress", cust.Address);
conn.Open();
cmd.ExecuteNonQuery();
}
}
}
Delete
Code:
// you could either pass in the Customer object, or just the customer ID
// for simplicity
public void DeleteCustomer(int ID)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("CustomerDelete", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
// assuming parameters
cmd.Parameters.AddWithValue("@CustomerID", ID);
conn.Open();
cmd.ExecuteNonQuery();
}
}
}