C#

Kevin Marois wrote:

You're confusing a Business Rule Violation with an Exception.

Kevin Marois wrote:

What is an exception? It's simply a fancy word for Error. A BR violation isn't
an error. It's a condition that can't be allowed to continue on to the DAL.

Kevin Marois wrote:

And to say "There technically cannot be "duplicate" records in a relational
database" isn't always true. Again, this is something determined by the app
requirements.

Kevin Marois wrote:

My point in all this is that I think I've come up with a standardized way of
returning to the call ANYTHING that happens

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

public void GetTypeAndSetToOne(ref object Value)
{
    Value = new Frood("Towel");
}
...
int MyInt = 0;
GetTypeAndSetToOne(ref MyInt);
// What does MyInt contain now?

string MyString = "";
int MyInt = 0;

object temp = MyString;
GetTypeAndSetToOne(ref temp);
MyString = (string)temp;

temp = MyInt;
GetTypeAndSetToOne(ref temp);
MyInt = (int)temp;

class A {}
class B : A {}
class C : A {}
...
B b = new B();
Change(ref b);
// At this point, b contains an instance of C!
...
void Change(ref A a)
   {
   a = new C();
   }

public void Test()
    {
    string MyString = "";
    int MyInt = 0;
    object oS = MyString;
    GetTypeAndSetToOne(ref oS);
    MyString = (string) oS;
    object oI = MyInt;
    GetTypeAndSetToOne(ref oI);
    MyInt = (int) oI;
    }

using System;

namespace ConsoleApplication5
{
    class Program
    {
        static void GetTypeAndSetToOne<T>(ref T Value)
        {
            if (Value is int)
            {
                Value = (T)(object)1;
                Console.WriteLine("int");
            }
            else if (Value is string)
            {
                Value = (T)(object)"1";
                Console.WriteLine("string");
            }
        }

        static void Main(string[] args)
        {
            string myString = "";
            int myInt = 0;
            GetTypeAndSetToOne(ref myString);
            GetTypeAndSetToOne(ref myInt);
            Console.WriteLine("MyString, type = {0}, value = {1}", myString.GetType(), myString);
            Console.WriteLine("MyInt, type = {0}, value = {1}", myInt.GetType(), myInt);
            Console.ReadLine();
        }
    }
}

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

using (SqlConnection cnn = new SqlConnection(strConnect))
    {
    cnn.Open();
    using (SqlCommand cmd = new SqlCommand("SELECT * FROM LISTSTAFF()", cnn))
        {
        using (SqlDataAdapter da = new SqlDataAdapter(cmd))
            {
            DataTable dt = new DataTable();
            da.Fill(dt);
            gridview.DataSource = dt;
            }
        }
    }

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE LISTSTAFF 
AS
BEGIN
	SET NOCOUNT ON;
	SELECT * FROM tblStaff
END
GO

Member 2458467 wrote:

procedure does not return a value

Member 2458467 wrote:

gridview.DataSource =... how assign ?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]