Filter Data in Dataset Using C#

How To Filter Data In Dataset using C#?

//First Step should load Dataset in Page Load Function.

        private void frmCreditCustomerList_Load(object sender, EventArgs e)

        {

            Ds = AObj.ListofCreditCustomer();

            if (Ds.Tables.Count > 0)

            {

                if (Ds.Tables[0].Rows.Count > 0)

                {

                    dgData.DataSource = Ds.Tables[0];

                }

            }

        }

        

Design page like this

In txtCustomerName text box Key Up event write this code

        private void txtCustomerName_KeyUp(object sender, KeyEventArgs e)

        {

            string sCond = string.Format("CustomerName like '%" + txtCustomerName.Text + "%'");

            DataRow[] drArray = Ds.Tables[0].Select(sCond);

            DataTable dtData = new DataTable();

            dtData = Ds.Tables[0].Clone();

            foreach (DataRow dr in drArray)

            {

                dtData.ImportRow(dr);

                dgData.DataSource = dtData;

            }

        }

That’s it Cheer’s