how to filter a row from the dataset

Last post 10-13-2008, 3:47 PM by Dollarjunkie. 3 replies.
Sort Posts: Previous Next
  •  06-09-2008, 1:32 AM Post number 59318

    • sham is not online. Last active: 06-09-2008, 1:33 AM sham
    • Not Ranked
    • Joined on 06-09-2008
    • Level 1: Deep thought

    how to filter a row from the dataset

    how do i filter a particular row from a dataset?
  •  07-23-2008, 12:05 PM Post number 63664 in reply to post number 59318

    • vladibo is not online. Last active: 08-30-2008, 9:42 PM vladibo
    • Top 500 Contributor
    • Joined on 07-07-2008
    • Vancouver BC
    • Level 1: Deep thought

    Re: how to filter a row from the dataset

    dataSet.Tables[0].Rows.RemoveAt(index);

  •  09-29-2008, 4:56 AM Post number 69750 in reply to post number 59318

    Re: how to filter a row from the dataset

    hi please chech below code.

     DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            DataColumn dc1 = new DataColumn("c1");
            dt.Columns.Add(dc1);
            DataColumn dc2 = new DataColumn("c2");
            dt.Columns.Add(dc2);

            for (int i = 0; i < 5; i++)
            {
                DataRow dr1 = dt.NewRow();
                dr1[0] = i;
                dr1[1] = "A" + i.ToString();
                dt.Rows.Add(dr1);   
            }
           
        
           
            ds.Tables.Add(dt);

            //you can pass dyanamic condition here
            DataRow[] selectedrow= ds.Tables[0].Select("c1 = 1");

            Response.Write( "<br> C1 : " +selectedrow[0][0].ToString());
            Response.Write( "<br> C2 : " + selectedrow[0][1].ToString());

    thnx
    http://amitpatriwala.wordpress.com


    Amit S Patriwala
    http://amitpatriwala.wordpress.com
  •  10-13-2008, 3:47 PM Post number 69982 in reply to post number 69750

    Re: how to filter a row from the dataset

    You can easily use the DataTable Select method to do a select, passing your filter Or you use a Dataview .
View as RSS news feed in XML