942,511 Members | Top Members by Rank

Ad:
  • C# Code Snippet
  • Views: 12046
  • C# RSS
0

Select top from for datatable and dataview

by on Jan 31st, 2008
SelectTopFrom method gets the top rows from dataview or datatable
C# Code Snippet (Toggle Plain Text)
  1. public static DataTable SelectTopFrom(DataTable dt, int rowCount)
  2. {
  3. DataTable dtn = dt.Clone();
  4. for (int i = 0; i < rowCount; i++)
  5. {
  6. dtn.ImportRow(dt.Rows[i]);
  7. }
  8. return dtn;
  9. }
  10.  
  11. public static DataView SelectTopFrom(DataView dv, int rowCount)
  12. {
  13. DataTable dt = CreateTable(dv);
  14. DataTable dtn = dt.Clone();
  15. for (int i = 0; i < rowCount; i++)
  16. {
  17. dtn.ImportRow(dt.Rows[i]);
  18. }
  19. DataView dvn = new DataView(dtn);
  20. return dvn;
  21. }
Comments on this Code Snippet
Jan 31st, 2008
0

Re: Select top from for datatable and dataview

I forgot to write "CreateTable" method above, you can look at it in the snipped named "Convert DataView To DataTable".
I think it is better to seperate these two snippets
Banned
serkan sendur is offline Offline
2,057 posts
since Jan 2008
Message:
Previous Thread in C# Forum Timeline: Updating a DGV?
Next Thread in C# Forum Timeline: Publishing Project





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC