Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 10th, 2012  |  syntax: None  |  size: 1.27 KB  |  hits: 13  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. using System.Configuration;
  2. using System.Data;
  3. using System.Data.SqlClient;
  4.  
  5. namespace Data.DataAccessLayer.DatabaseOperation
  6. {
  7.    public class CustomersDataBaseOperation
  8.     {
  9.        public static SqlConnection ConnStr
  10.        {
  11.            get { return new SqlConnection(ConfigurationManager.ConnectionStrings["CustomerConnString"].ConnectionString); }
  12.        }
  13.  
  14. \\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
  15.  
  16.         public int Insert (Storedprocedure storedprocedure, int id, string name, string mail)
  17.         {
  18.             using (ConnStr)
  19.             {
  20.                 SqlCommand command= new SqlCommand(storedprocedure.ToString(),ConnStr);
  21.  
  22.                 command.CommandType = CommandType.StoredProcedure;
  23.                 command.Parameters.AddWithValue("@ID", id);
  24.                 command.Parameters.AddWithValue("@Name",name);
  25.                 command.Parameters.AddWithValue("@Mail", mail);
  26.  
  27.                 command.Connection.Open();
  28.                 command.ExecuteNonQuery();