Generate Data for Display [C#]

S

Shaitan00

Well-known member
Joined
Aug 11, 2003
Messages
343
Location
Hell
Given the following semi-code:
string[] MachineNames = new String[#ofMachines];
object[,] objectArray = new object[#ofSettings, #ofMachines];
int iSettingIndex = 0;

foreach (Setting in Settings)
{
for (int iMachineIndex = 0; iMachineIndex < #ofMachines; iMachineIndex++)
{
MachineNames[iMachineIndex] = getName(iMachineIndex);
objectArray[iSettingIndex, iMachineIndex] = getValue(iMachineIndex, strPath, strKey);
}
iSettingIndex++;
}

This will generate a 2Dimension Object Array, which would resemble something like:

Index 1 2 3
1 X Y Z
2 X Y Z
3 X Y Z
Where X,Y, and Z are the values for each setting on each Robot

My goal is to take this code and overlay it all in a Datagrid of some kind.

This requires 2 changes:
a) I need to add a Row0 [for the actual Machine names and not just the index] and a Column0 [for the actual Setting name (path+key) and not just the index]

b) I need to somehow set this 2 dimensional Object Array as the datasource for my Datagrid [when I do it directly C# gives me an error stating that: An unhandled exception of type System.ArgumentException occurred in mscorlib.dll Additional information: Array was not a one-dimensional array.]

The end results should look like [in a Datagrid of some kind, without the Index information]:

Index 1 2 3
1 X Robot1 Robot2
2 \\Path1\Key1 X Y
3 \\Path2\Key2 X Y
4 \\Path3\Key3 X Y
 
If youre going to store information in a table, it makes much more
sense to use an instance of a [mshelp=ms-help://MS.MSDNQTR.2003FEB.1033/vbcon/html/vboriDatasets.htm]DataSet[/mshelp] or a [mshelp=ms-help://MS.MSDNQTR.2003FEB.1033/cpguide/html/cpconworkingwithtypeddataset.htm]strongly-typed
DataSet[/mshelp] to store your data. Then its a piece of cake to display in
a DataGrid (or any other data control); just set the DataSource
and DataMember properties and call DataBind(). Plus, you can
easily serialize the data into an XML file to save your settings.
 
I agree, using a Dataset would be ideal [no clue about DataBind, never tried that before], I have often used Datasets when dealing with SQL [to display results in Datagrids] however this is rather different seeing as the results are generated dynamically [and not just a Dataset.fill].

But for example, forget the Foreach loops, if I wanted to generate a dataset to fill my datagrid to look like the following:

Robot1
Key1 X

How could I do that? [given the values are hardcoded].
How do I fill the Dataset by saying, use "Robot1" as Column1, "Key1" as Row1, and "X" as the result?
And then: Datagrid.datasource = Dataset

If I can do that then filling the Dataset dynamically should be simple enough.
 
Sure!
Code: 
Dim data As New DataSet()
Dim table As New DataTable()

 Add the columns
With table.Columns
  .Add(New DataColumn("Index"))
  .Add(New DataColumn("Value 1"))
  .Add(New DataColumn("Value 2"))
  .Add(New DataColumn("Value 3"))
End With

 Add the table to the dataset
data.Tables.Add(table)

 Get the row and set the values
Dim row As DataRow = table.NewRow()
row(0) = "Robot1"
row(1) = "x"
row(2) = "y"
row(3) = "z"
table.Rows.Add(row)

And there you have it. Simple, eh?

[mshelp=ms-help://MS.MSDNQTR.2003FEB.1033/cpguide/html/cpconcreatingusingdatasets.htm]Read more![/mshelp]
 
Back
Top