Convert DataView to DataTable

Please support our C# advertiser: Intel Parallel Studio Home
serkan sendur serkan sendur is offline Offline Jan 31st, 2008, 10:08 am |
0
Enables DataView to DataTable conversion
Quick reply to this message  
C# Syntax
  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. }
0
Aliasgher Aliasgher is offline Offline | Nov 11th, 2008
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
 
0
bruce2424 bruce2424 is offline Offline | Nov 16th, 2008
thsi is vb code

Dim dTable As DataTable
dTable = dv.ToTable

for more details :

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

thanks.
 
 

Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC