65.9K
CodeProject is changing. Read more.
Home

Binding Grid View Control

emptyStarIconemptyStarIconemptyStarIconemptyStarIconemptyStarIcon

0/5 (0 vote)

Oct 11, 2013

CPOL

1 min read

viewsIcon

9031

In this article I will sharing how to bind with GridView control with Database and without database using Data Table.Bind GridView with DatabaseI

In this article I will sharing how to bind with GridView control with Database and without database using Data Table.

Bind GridView with Database

I have define the GridView in the Web Form (Presentation Layer) and from this I am calling the method defined in BLL class (Business Logic Layer)

 

Here I am calling the method from presentation layer which was defined in BLL class (Business Login Layer)

Calling the BindEmpData class from the Web Form.
grdvTest.DataSource=BLL.BindEmpData(intEmpId);
grdvTest.DataBind();

Method in the BLL class and it is calling the other class in the Data Access Layer.
public static DataSet BindPlanData(int EmpId)
    {
        DataSet ds = new DataSet();
        ds = Dsll. GetEmployeeInfo(EmpId);
        return ds;
    }

Method defined in the DAL class

    public static DataSet GetEmployeeInfo(int intEmpId)
        {
            DataSet ds;
            int QType = 2;
            try
            {
                using (SqlConnection oConnection = new SqlConnection(ApplicationConnectionString()))
                {
                    SqlParameter[] parameters = new SqlParameter[1];

                    parameters[0] = new SqlParameter(intEmpId, System.Data.SqlDbType.Int);
                    parameters[0].Value = intEmpId

                    ds = SqlHelper.ExecuteDataset(oConnection, CommandType.StoredProcedure, "mySP_GetEmployeeInfo", parameters);
                }
                return ds;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message + " GetEmployeeInfo", ex);
            }
        }

 


Bind GridView without Database using Data Table

void connectGrid()
    {
DataTable dt = new DataTable();
        dt.Columns.Add("EmpId");
        dt.Columns.Add("EmpName");
        dt.Columns.Add("EmpTel");

        dt.Rows.Add("10023", "Abdullah Khan", "882-2221");
        dt.Rows.Add("11002", "Abulrehman Ali", "882-1132");
        dt.Rows.Add("23211", "Asim Afzal", "KG", "882-4211");

        grdvTest.DataSource = dt;
        grdvTest.DataBind();
}