Filtering dataset
-
Hi, Looking for a bit of help. What I want to do to filter a table in my database by a month select. So for example I want to see the results for January. I have populated my dataset with all the records in my database when I first start my application. da.Fill(ds,"Records) 'da is my dataadapter and ds is my dataset So is there some way I can filter my dataset to show the results that I just want or should I re populate my dataset with the dataadapter using a SQL Statment such as SELECT * Records WHERE etc... Is there anyother way Thanks for your help
-
Hi, Looking for a bit of help. What I want to do to filter a table in my database by a month select. So for example I want to see the results for January. I have populated my dataset with all the records in my database when I first start my application. da.Fill(ds,"Records) 'da is my dataadapter and ds is my dataset So is there some way I can filter my dataset to show the results that I just want or should I re populate my dataset with the dataadapter using a SQL Statment such as SELECT * Records WHERE etc... Is there anyother way Thanks for your help
Work with the
Selectmethod provided inDataTableclass.Navaneeth How to use google | Ask smart questions
-
Hi, Looking for a bit of help. What I want to do to filter a table in my database by a month select. So for example I want to see the results for January. I have populated my dataset with all the records in my database when I first start my application. da.Fill(ds,"Records) 'da is my dataadapter and ds is my dataset So is there some way I can filter my dataset to show the results that I just want or should I re populate my dataset with the dataadapter using a SQL Statment such as SELECT * Records WHERE etc... Is there anyother way Thanks for your help
use can use DataView see this http://www.csharp-examples.net/dataview-rowfilter/[^] Hope it helps
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswam@its.co.za
-
Work with the
Selectmethod provided inDataTableclass.Navaneeth How to use google | Ask smart questions