Data View Row Filter

 DataTable dtCQDeatils = BL.GetQuoteID(strCustomQuoteID);

        DataView dv= new DataView();
         dv = dtCQDeatils.DefaultView;
        dv.RowFilter = "pages=1";
GridView.Datasource=dv;
GridView.Databind();

Row Filter in asp.net

 DataView dv = ((DataTable)ViewState["AppliedLeave"]).DefaultView;
            dv.RowFilter = "StatusId=1";
            gvAppliedLeave.DataSource = dv;
            gvAppliedLeave.DataBind();

Data View Row Filter

 DataView dv = ((DataTable)ViewState["AppliedLeave"]).DefaultView;
            dv.RowFilter = "StatusId=1";
            gvAppliedLeave.DataSource = dv;
            gvAppliedLeave.DataBind();

What is DataSet and DataView?

Click Here To View Latest ASP.NET Questions

DataSet- is an object used to store the data retrieved from the database. It can contain one or more tables .Each table in the dataset is known as Datatable. The constraints supported by the datatable are


1)UniqueConstraint.
2)ForeignKeyConstraint.


DataView - is used for the customized view of data of datatable, with the help of dataview we can filtered, searched or sort the data.

Click Here To View Latest ASP.NET Questions