RE: datacolumn ; datatable in Visual Studio 2005 Beta 2

Of Course I know there is a mistake. The expression must be
.Expression = "IIf (price > 0, price * tax, 0)"

but it is still the same result.

GScaefer

"GSchaefer" wrote:

> 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()
>
.