public void ExecuteQuery() { // add a customer Dictionary<string, SqlParameter> cmdParameters = new Dictionary<string, SqlParameter>(); cmdParameters["name"] = new SqlParameter("name", "Smith"); cmdParameters["state"] = new SqlParameter("state", "MD"); SqlDatabaseUtility.ExecuteCommand("mssqltips", "dbo.AddCustomer", cmdParameters); // query the customer table Dictionary<string, SqlParameter> queryParameters = new Dictionary<string, SqlParameter>(); SqlDataReader reader = SqlDatabaseUtility.ExecuteQuery( "mssqltips", "dbo.GetCustomerList", queryParameters); while (reader.Read() == true) { Console.WriteLine(string.Format("{0}\t{1}\t{2}", reader[0].ToString(), reader[1].ToString(), reader[2].ToString())); } }