datacolumn ; datatable in Visual Studio 2005 Beta 2

The program failes at the 'IIF' expression. The whole code is working
properly with Visual Studio 2003. Does anybody know a patch or a work around.

Thanks
Gerhrad


Dim table As DataTable = New DataTable("MyTable")

' Create the first column.
Dim priceColumn As DataColumn = New DataColumn
With priceColumn
.DataType = System.Type.GetType("System.Decimal")
.ColumnName = "price"
.DefaultValue = 50
End With

' Create the second, calculated, column.
Dim taxColumn As DataColumn = New DataColumn
With taxColumn
.DataType = System.Type.GetType("System.Decimal")
.ColumnName = "tax"
.Expression = "price * 0,0862"
End With

' Create third column
Dim totalColumn As DataColumn = New DataColumn
With totalColumn
.DataType = System.Type.GetType("System.Decimal")
.ColumnName = "total"
.Expression = "IIF price > 0, price * tax, 0)"
End With




System.Data.SyntaxErrorException was unhandled
Message="Syntax error: Missing operand after 'price' operator."
Source="System.Data"
StackTrace:
at System.Data.ExpressionParser.Parse()

at System.Data.DataExpression..ctor(DataTable table, String
expression, Type type)

at System.Data.DataColumn.set_Expression(String value)

at TestExpressionSQL2005.Form1.CalcColumns() in D:\ProgEnt\Visual
Studio\projects\vb\TestExpressionSQL2005\TestExpressionSQL2005\Form1.vb:line
31

at TestExpressionSQL2005.Form1.Button1_Click(Object sender, EventArgs
e) in D:\ProgEnt\Visual
Studio\projects\vb\TestExpressionSQL2005\TestExpressionSQL2005\Form1.vb:line
49

at System.Windows.Forms.Control.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
button, Int32 clicks)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ButtonBase.WndProc(Message& m)

at System.Windows.Forms.Button.WndProc(Message& m)

at
System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd,
Int32 msg, IntPtr wparam, IntPtr lparam)

at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

at
System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32
dwComponentID, Int32 reason, Int32 pvLoopData)

at
System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32
reason, ApplicationContext context)

at
System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason,
ApplicationContext context)

at System.Windows.Forms.Application.Run(ApplicationContext context)

at
Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()

at
Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()

at
Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)

at TestExpressionSQL2005.My.MyApplication.Main(String[] Args) in
17d14f5c-a337-4978-8281-53493378c1071.vb:line 76

at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)

at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
assemblySecurity, String[] args)

at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()

at System.Threading.ThreadHelper.ThreadStart_Context(Object state)

at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state)

at System.Threading.ThreadHelper.ThreadStart()

.