
Untitled
By: a guest on
May 10th, 2012 | syntax:
None | size: 1.27 KB | hits: 13 | expires: Never
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
namespace Data.DataAccessLayer.DatabaseOperation
{
public class CustomersDataBaseOperation
{
public static SqlConnection ConnStr
{
get { return new SqlConnection(ConfigurationManager.ConnectionStrings["CustomerConnString"].ConnectionString); }
}
\\here is the error Erro ...Data.DataAccessLayer.DatabaseOperation.CustomersDataBaseOperation.Insert(Data.DataAccessLayer.Storedprocedure, int, string, string)': not all code paths return a value C:\Users\Administrator\Documents\Visual Studio 2010\Projects\Form1\Data\DataAccessLayer\DatabaseOperation\CustomersDataBaseOperation.cs
public int Insert (Storedprocedure storedprocedure, int id, string name, string mail)
{
using (ConnStr)
{
SqlCommand command= new SqlCommand(storedprocedure.ToString(),ConnStr);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@ID", id);
command.Parameters.AddWithValue("@Name",name);
command.Parameters.AddWithValue("@Mail", mail);
command.Connection.Open();
command.ExecuteNonQuery();