944,032 Members | Top Members by Rank

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

Convert DataView to DataTable

by on Jan 31st, 2008
Enables DataView to DataTable conversion
C# Code Snippet (Toggle Plain Text)
  1. public static DataTable CreateTable(DataView obDataView)
  2. {
  3. if (null == obDataView)
  4. {
  5. throw new ArgumentNullException
  6. ("DataView", "Invalid DataView object specified");
  7. }
  8.  
  9. DataTable obNewDt = obDataView.Table.Clone();
  10. int idx = 0;
  11. string[] strColNames = new string[obNewDt.Columns.Count];
  12. foreach (DataColumn col in obNewDt.Columns)
  13. {
  14. strColNames[idx++] = col.ColumnName;
  15. }
  16.  
  17. IEnumerator viewEnumerator = obDataView.GetEnumerator();
  18. while (viewEnumerator.MoveNext())
  19. {
  20. DataRowView drv = (DataRowView)viewEnumerator.Current;
  21. DataRow dr = obNewDt.NewRow();
  22. try
  23. {
  24. foreach (string strName in strColNames)
  25. {
  26. dr[strName] = drv[strName];
  27. }
  28. }
  29. catch (Exception ex)
  30. {
  31. Trace.WriteLine(ex.Message);
  32. }
  33. obNewDt.Rows.Add(dr);
  34. }
  35.  
  36. return obNewDt;
  37. }
Comments on this Code Snippet
Nov 11th, 2008
0

Re: Convert DataView to DataTable

public static DataTable CreateTable(DataView obDataView) { if (null == obDataView) { throw new ArgumentNullException ("DataView", "Invalid DataView object specified"); } DataTable obNewDt = obDataView.Table.Clone(); int idx = 0; string[] strColNames = new string[obNewDt.Columns.Count]; foreach (DataColumn col in obNewDt.Columns) { strColNames[idx++] = col.ColumnName; } IEnumerator viewEnumerator = obDataView.GetEnumerator(); while (viewEnumerator.MoveNext()) { DataRowView drv = (DataRowView)viewEnumerator.Current; DataRow dr = obNewDt.NewRow(); try { foreach (string strName in strColNames) { dr[strName] = drv[strName]; } } catch (Exception ex) { Trace.WriteLine(ex.Message); } obNewDt.Rows.Add(dr); } return obNewDt; }public static DataTable CreateTable(DataView obDataView)
{
if (null == obDataView)
{
throw new ArgumentNullException
("DataView", "Invalid DataView object specified");
}

DataTable obNewDt = obDataView.Table.Clone();
int idx = 0;
string[] strColNames = new string[obNewDt.Columns.Count];
foreach (DataColumn col in obNewDt.Columns)
{
strColNames[idx++] = col.ColumnName;
}

IEnumerator viewEnumerator = obDataView.GetEnumerator();
while (viewEnumerator.MoveNext())
{
DataRowView drv = (DataRowView)viewEnumerator.Current;
DataRow dr = obNewDt.NewRow();
try
{
foreach (string strName in strColNames)
{
dr[strName] = drv[strName];
}
}
catch (Exception ex)
{
Trace.WriteLine(ex.Message);
}
obNewDt.Rows.Add(dr);
}

return obNewDt;
}

i write above in my program to convert dataview to data table, but their is an error shows that
"Using the Generic type 'System.Collection.Generic.IEnumerable<T>' required '1' type argument
please help me how i can solve this problem
thanks in advance
Newbie Poster
Aliasgher is offline Offline
1 posts
since Nov 2008
Nov 16th, 2008
0

Re: Convert DataView to DataTable

thsi is vb code

Dim dTable As DataTable
dTable = dv.ToTable

for more details :

http://vb.net-informations.com/datav...-datatable.htm

thanks.
Newbie Poster
bruce2424 is offline Offline
23 posts
since Jun 2008
Message:
Previous Thread in C# Forum Timeline: Searching for specfic strings in a splitted plsfile?
Next Thread in C# Forum Timeline: any idea how to assign values to specific variables





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


Follow us on Twitter


© 2011 DaniWeb® LLC