Looking for var types

[spjansen]

hello,
I want to create a dataset/datatable from an ttx file (thats for Crystal Reports) and I have to mimic the ms sql server fieldtypes for that.
I create the columns like this:

Dim DS As DataSet = New DataSet("test")
Dim DT1 As DataTable = DS.Tables.Add("ORDERS")
DT1.Columns.Add("NUMMER", Type.GetType("System.Int32"))

My problem ist to find a "System.foobar" type to create a blob and a memo field.

can anybody help?

 

[SqueakinSweep]

You could try using System.Object


Sweep
...if it works dont f*** with it
...if its f****ed blame someone else
...if its your fault that its f***ed, say and admit nothing.

 

[ThatRickGuy]

Check the System.Data.SQLTypes namespace.

Dim x As System.Data.SqlTypes.SqlBinary
Dim y As System.Data.SqlTypes.SqlString

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.