DataTable Class

[westsider]

Msdn DataTable Class:

https://msdn.microsoft.com/en-us/library/system.data.datatable(v=vs.110).aspx

DataTable Examples:

http://www.dotnetperls.com/datatable

I’d like to use a data table as a multidimensional dynamic array inside ninja 7 but have been unable to implement it. Does anyone have any experience with this or another data structure that will store vars like excel? ( In columns and rows and is dynamic )
Initializing and storing vars in the table is no problem. Reading the data is a problem. The MSDN recommended syntax doesn’t work inside ninja.

using System.Data;
        protected override void OnBarUpdate()
        {
			// Declare DataTable
			DataTable table = new DataTable();
			// Add columns 
			table.Columns.Add("Dosage", typeof(int));
			table.Columns.Add("Drug", typeof(string));
			table.Columns.Add("Patient", typeof(string));
			table.Columns.Add("Date", typeof(DateTime));

			// Add five DataRows.
			table.Rows.Add(25, "Indocin", "David", DateTime.Now);
			table.Rows.Add(50, "Enebrel", "Sam", DateTime.Now);
			table.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Now);
			table.Rows.Add(21, "Combivent", "Janet", DateTime.Now);
			table.Rows.Add(100, "Dilantin", "Melanie", DateTime.Now);
			

			// no matter what syntax I try I'm unable to read the data
			//	Print(table.Rows[0][0]);
	
        }

Thanks for any pointers or advice!
Westsider

[Calonious]

Any errors being reported?

Also, did you try DotNetPerls method for looping through the data to write it?

DataTable is very dynamic in that if you want data out of it, you need to get the type for it as well.

table.Rows[0].Field<string>(0)

[NinjaTrader_ChelseaB]

Hi westsider,

Calonious has the right idea. The item likely needs to be converted to a string.

Are you getting any error messages in the Log tab of the Control Center?
If so, what do these say?

[westsider]

Any errors being reported?

Also, did you try DotNetPerls method for looping through the data to write it?

DataTable is very dynamic in that if you want data out of it, you need to get the type for it as well.

table.Rows[0].Field<string>(0)

Thanks for looking at my issue!. Yes I did try every method on DotNetPerls including looping through. In the case of

foreach (DataRow row in table.Rows)
				{
					// ... Write value of first field as integer.
					Print( table.Rows[0].Field<string>(0) );
				}

I get an error -- CS1061 - click for info
'System.Data.DataRow' does not contain a definition for 'Field' and no extension method 'Field' accepting a first argument of type 'System.Data.DataRow' could be found (are you missing a using directive or an assembly reference?)

[Calonious]

I assume you have added the System.Data and System.Data.DataSetExtensions
reference to your NT Editor correct?

Field is an extension in the latter reference. If you don't wanna use that, then try using Item[string] instead to get the cell value -
https://msdn.microsoft.com/en-us/lib...v=vs.110).aspx

[westsider]

Ahh - Sorry, Didn't realize I needed System.Data.DataSetExtensions - when I add this I get the error:

The type or namespace name 'DataSetExtensions' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)

I'm assuming I need add this assembly reference but haven't done this before.

[westsider]

Found it here and have added it successfully.

C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\ System.Data.DataSetExtensions.dll

[Calonious]

Are you still getting compile errors now? Or are you able to move forward to testing?

[westsider]

Moving forward now. Thanks very much for the help.

I was missing the compiler directive. Here is the complete code if someone in the future wants to use a datatable;

// add these references
     using System.Data;
     using System.Data.DataSetExtensions;

			// Declare DataTable
			DataTable table = new DataTable();
			// Add columns 
			table.Columns.Add("Dosage", typeof(int));
			table.Columns.Add("Drug", typeof(string));
			table.Columns.Add("Patient", typeof(string));
			table.Columns.Add("Date", typeof(DateTime));

			// Add five DataRows.
			table.Rows.Add(25, "Indocin", "David", DateTime.Now);
			table.Rows.Add(50, "Enebrel", "Sam", DateTime.Now);
			table.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Now);
			table.Rows.Add(21, "Combivent", "Janet", DateTime.Now);
			table.Rows.Add(100, "Dilantin", "Melanie", DateTime.Now);
			
                        // Loop thru to read the data
			foreach (DataRow row in table.Rows)
				{
					Print(row.Field<int>(0));
				}

[westsider]

Thanks so much Calonious. I was stuck on that one for a while !!! I really appreciate the help.

Here is the full loop and print Syntax to read each column and row

foreach (DataRow row in table.Rows)
	{
		Print("Dose: " +row.Field<int>(0) +" Drug: " + row.Field<string>(1)+
			"Patient: " +row.Field<string>(2) +" Date: " + row.Field<DateTime>(3));			
	}

[spottysallrite]

Well, I can't get this to work. It compiles just fine, but when I run the script I get the following error message on the Output window: "AssemblyResolveEvent handlers cannot return Assemblies loaded for reflection only."

Any suggestions as to how to fix that ?