How to Filter the DataSet?

Question

Give me the Sample Coding about All type of Filtering of DataSet???

Jignesh Trivedi · Answer

hi, As per my knowledge Data set can not be filter and datatable and dataview can filter because dataset is collection of table. for filtering datatable you may use. DataTable dt = "some Method to retrive data"; // new DataTable DataTable dt1 = dt.Select(filterExpression); DataTable dt2 = dt.Select(filterExpression,sortingExpression); hope this help.

Prabhu Raja · Answer

You also can use Select method and filter expressions. private DataTable DoDataTableFilter(DataTable dt, string filter) { DataTable dt1 = dt.Clone(); foreach (DataRow dr in dt.Select(filter)) { dt1.ImportRow(dr); } return dt1; } Referred from Article

Satyapriya Nayak · Answer

Hi Rk, These are three methods below... Method-1 SqlConnection con=new SqlConnection("workstation id=\"HOME-Z8CKE1NER2\";packet size=4096;user id=sa;initial catalog=Dotn" + "et;persist security info=False"); SqlCommand com; SqlDataAdapter sqlda; DataSet ds=new DataSet(); String str; DataTable dt=new DataTable(); private void btndisplay_Click(object sender, System.EventArgs e) { con.Open(); str = "select * from student"; com = new SqlCommand(str, con); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds, "student"); DataView dv = new DataView(ds.Tables["student"]); dv.RowFilter = "smarks>70"; dv.Sort = "smarks asc"; listBox1.DataSource = dv; listBox1.DisplayMember = "sid"; con.Close(); } ----------------------------------------------------------------------------------------------- Method-2 private void btndisplay_Click(object sender, System.EventArgs e) { con.Open(); str = "select * from student"; com = new SqlCommand(str, con); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds, "student"); dt = ds.Tables["student"]; String s1; String s2; s1 = "smarks>60"; s2 = "smarks asc"; DataRow []result; result = dt.Select(s1, s2); int ctr; for( ctr =0;ctr listBox1.Items.Add(result[ctr]["smarks"].ToString()); } } ------------------------------------------------------------------------------------------------- Method-3 private void btndisplayall_Click(object sender, System.EventArgs e) { con.Open(); str="select * from student"; com=new SqlCommand(str,con); sqlda=new SqlDataAdapter(com); ds=new DataSet(); sqlda.Fill(ds,"student"); dataGrid1.DataSource=ds; dataGrid1.DataMember="student"; con.Close(); } private void btndisplay_Click(object sender, System.EventArgs e) { DataTable dt; dt=ds.Tables["student"]; DataView dv=new DataView(dt); dv.RowFilter ="sname='" + textBox1.Text + "'"; dataGrid1.DataSource =dv; } Thanks

How to Filter the DataSet?

Answers (3)