Asp.Net Interview Question Display Only 5 Records In Grid View without Using Where Condition

---

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

namespace Ntire

{

    public partial class Task2 : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

            if(!IsPostBack)

            { FillData();

            GridView2.DataSource = DataFill();

            GridView2.DataBind();

            }

           

        }

        public List<Employee> DataFill()

        {

            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString);

            SqlCommand cmd = new SqlCommand("Select*from EmployeeTbl", con);

            con.Open();

            SqlDataReader Dr = cmd.ExecuteReader();

            List<Employee> emplist = new List<Employee>();

           

            if(Dr.HasRows)

            {

               

               

                while(Dr.Read())

                {

                    Employee emp = new Employee();

                    emp.Id=Convert.ToInt32(Dr["Id"].ToString());

                    emp.Name = Dr["Name"].ToString();

                    emp.Gender = Dr["Gender"].ToString();

                    emp.Salary = Convert.ToDecimal(Dr["Salary"].ToString());

                    emplist.Add(emp);

                    if (emplist.Count == 5)

                    {

                        return emplist;

                        

                    }

                }

               

            }

            con.Close();

            return emplist;

           

        }

        public void FillData()

        {

            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString);

           

            SqlDataAdapter da = new SqlDataAdapter("Select*from EmployeeTbl", con);

            DataSet ds = new DataSet();

          

            da.Fill(ds);

            List<Employee> EmployeeList = new List<Employee>();

          

           

            for (int i=0; i< 5;i++ )

            {

                Employee emp = new Employee();

                emp.Id = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0].ToString());

                emp.Name = ds.Tables[0].Rows[i].ItemArray[1].ToString();

                emp.Gender = ds.Tables[0].Rows[i].ItemArray[2].ToString();

                emp.Salary = Convert.ToDecimal(ds.Tables[0].Rows[i].ItemArray[3].ToString());

                

                EmployeeList.Add(emp);

              

            }

            GridView1.DataSource = EmployeeList;

            GridView1.DataBind();

        }

    }

}

/ /Another Method of Getting Data Using Dataset

            Employee emp = new Employee();

            emp.Id = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[0].ToString());

            emp.Name = ds.Tables[0].Rows[0].ItemArray[1].ToString();

            emp.Gender = ds.Tables[0].Rows[0].ItemArray[2].ToString();

            emp.Salary = Convert.ToDecimal(ds.Tables[0].Rows[0].ItemArray[3].ToString());

            Employee emp1 = new Employee();

            emp1.Id = Convert.ToInt32(ds.Tables[0].Rows[1].ItemArray[0].ToString());

            emp1.Name = ds.Tables[0].Rows[1].ItemArray[1].ToString();

            emp1.Gender = ds.Tables[0].Rows[1].ItemArray[2].ToString();

            emp1.Salary = Convert.ToDecimal(ds.Tables[0].Rows[1].ItemArray[3].ToString());

            Employee emp2 = new Employee();

            emp2.Id = Convert.ToInt32(ds.Tables[0].Rows[2].ItemArray[0].ToString());

            emp2.Name = ds.Tables[0].Rows[2].ItemArray[1].ToString();

            emp2.Gender = ds.Tables[0].Rows[2].ItemArray[2].ToString();

            emp2.Salary = Convert.ToDecimal(ds.Tables[0].Rows[2].ItemArray[3].ToString());

            Employee emp3 = new Employee();

            emp3.Id = Convert.ToInt32(ds.Tables[0].Rows[3].ItemArray[0].ToString());

            emp3.Name = ds.Tables[0].Rows[3].ItemArray[1].ToString();

            emp3.Gender = ds.Tables[0].Rows[3].ItemArray[2].ToString();

            emp3.Salary = Convert.ToDecimal(ds.Tables[0].Rows[3].ItemArray[3].ToString());

            Employee emp4 = new Employee();

            emp4.Id = Convert.ToInt32(ds.Tables[0].Rows[4].ItemArray[0].ToString());

            emp4.Name = ds.Tables[0].Rows[4].ItemArray[1].ToString();

            emp4.Gender = ds.Tables[0].Rows[4].ItemArray[2].ToString();

            emp4.Salary = Convert.ToDecimal(ds.Tables[0].Rows[4].ItemArray[3].ToString());

            List<Employee> EmployeeList = new List<Employee>();

            EmployeeList.Add(emp);

            EmployeeList.Add(emp1);

            EmployeeList.Add(emp2);

            EmployeeList.Add(emp3);

            EmployeeList.Add(emp4);