T
Tmuld
Oh man - there is a great example here:
http://www.c-sharpcorner.com/Code/2003/July/NavigationSystemInASPNet.asp
In C# (I think) but I am having difficult converting it to VB.NET.
Especially this part:
public DataSet GoDoReShape(DataSet ds)
{
DataSet NewDs=new DataSet();
NewDs.Tables.Add();
//Create Two Columns with names "ColumnName" and "Value"
//ColumnName -> Displays all ColumnNames
//Value -> Displays ColumnData
NewDs.Tables[0].Columns.Add("ColumnName");
NewDs.Tables[0].Columns.Add("Value");
foreach(DataRow dr in ds.Tables [0].Rows )
{
foreach(System.Data.DataColumn dcol in ds.Tables[0].Columns)
{
//Declare Array
string[]MyArray={dcol.ColumnName.ToString(),dr[dcol.ColumnName.ToString()].ToString()};
NewDs.Tables[0].Rows.Add(MyArray);
}
}
return NewDs;
}
I am not sure what the string[]MyArray <the rest> is telling me.
Should I dim MyArray as a string or as an Array - me thinks array.
So I tried it.
Dim myArray as Array
MyArray={dcol.ColumnName.ToString(),dr[dcol.ColumnName.ToString()].ToString()}
~
I get a squiggly saying 'Expression Expected'.
Or do I have this wrong?
Thanks,
Tmuld.
http://www.c-sharpcorner.com/Code/2003/July/NavigationSystemInASPNet.asp
In C# (I think) but I am having difficult converting it to VB.NET.
Especially this part:
public DataSet GoDoReShape(DataSet ds)
{
DataSet NewDs=new DataSet();
NewDs.Tables.Add();
//Create Two Columns with names "ColumnName" and "Value"
//ColumnName -> Displays all ColumnNames
//Value -> Displays ColumnData
NewDs.Tables[0].Columns.Add("ColumnName");
NewDs.Tables[0].Columns.Add("Value");
foreach(DataRow dr in ds.Tables [0].Rows )
{
foreach(System.Data.DataColumn dcol in ds.Tables[0].Columns)
{
//Declare Array
string[]MyArray={dcol.ColumnName.ToString(),dr[dcol.ColumnName.ToString()].ToString()};
NewDs.Tables[0].Rows.Add(MyArray);
}
}
return NewDs;
}
I am not sure what the string[]MyArray <the rest> is telling me.
Should I dim MyArray as a string or as an Array - me thinks array.
So I tried it.
Dim myArray as Array
MyArray={dcol.ColumnName.ToString(),dr[dcol.ColumnName.ToString()].ToString()}
~
I get a squiggly saying 'Expression Expected'.
Or do I have this wrong?
Thanks,
Tmuld.