public void AddItem(string title, string description, decimal price, int categoryID) { SqlConnection con = new SqlConnection(connectionString); // Create the Command. string insertSQL = "INSERT INTO Items "; insertSQL += "(Title, Description, Price, Category_ID)"; insertSQL += "VALUES (@Title, @Description, @Price, @CategoryID)"; SqlCommand cmd = new SqlCommand(insertSQL, con); cmd.Parameters.AddWithValue("@Title", title); cmd.Parameters.AddWithValue("@Description", description); cmd.Parameters.AddWithValue("@Price", price); cmd.Parameters.AddWithValue("@CategoryID", categoryID); try { con.Open(); cmd.ExecuteNonQuery(); } finally { con.Close(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)