ConsoleApplication2.DAL.EmployeeDAL.GetAllEmployee C# (CSharp) Méthode

GetAllEmployee() public méthode

public GetAllEmployee ( ) : DataTable
Résultat System.Data.DataTable
        public DataTable GetAllEmployee()
        {
            DataTable tblEmployee = new DataTable();
            SqlDataReader rdr = null;

            cmd.CommandType = CommandType.Text;
            cmd.CommandText = @"SELECT ID, NAME, DESIGNATION, BLOODGROUP FROM EMPLOYEE";

            try
            {
                if (sqlConn.State == ConnectionState.Closed)
                    sqlConn.Open();

                rdr = cmd.ExecuteReader();
                tblEmployee.Load(rdr);
            }
            catch (Exception exp)
            {
                throw (exp);
            }
            finally
            {
                if (sqlConn.State == ConnectionState.Open)
                    sqlConn.Close();
            }

            return tblEmployee;
        }

Usage Example

Exemple #1
0
 public DataTable GetAllEmployee()
 {
     EmployeeDAL objCustomerDAL = new EmployeeDAL();
     try
     {
         return objCustomerDAL.GetAllEmployee();
     }
     catch(Exception exp)
     {
         throw (exp);
     }
 }