Expression Field not working in code.

I have a table with a simple expression column. I'm multiplying quantity *
AveLaborRate to come up with total_labor. When I do the 'preview data' it
works fine, but when I run my program, all I get is the default 0. All of the
other fields have the same data as the preview.

What could be causing the total_labor field not to calculate?

Is there a way to view all of the contents in a table while I'm in debug
mode? FoxPro has the 'Browse' command. Is there anything similar in C#?

I'm using VS2005 C# and SQL 2005.

Vasco
Wed May 03 01:09:54 CDT 2006

What datatypes are you using ?
Can you share the schema of your dataset ?
(do for example yourDsVariable.WriteXmlSchema( Console.Out ) )

To see the data inside the dataset, you can use the debugger visualizer that
appears if you hover with your mouse on the dataset variable (a magnifier
icon appears, and if you press it a viewer similar to the one you see when
you preview data will appear). The same magnifier appears if you add a watch
for the dataset.

Yet another way is using the Immediate Window (usually Ctrl+Alt_I) and then
execute
> ? yourDsVariable.GetXml()

--VV [MS]
vascov@microsoft.com

"Irvin McCoy" <IrvinMcCoy@discussions.microsoft.com> wrote in message
news:01ACD56A-9BED-47BA-A3AB-9C67B1F945DE@microsoft.com...
>I have a table with a simple expression column. I'm multiplying quantity *
> AveLaborRate to come up with total_labor. When I do the 'preview data' it
> works fine, but when I run my program, all I get is the default 0. All of
> the
> other fields have the same data as the preview.
>
> What could be causing the total_labor field not to calculate?
>
> Is there a way to view all of the contents in a table while I'm in debug
> mode? FoxPro has the 'Browse' command. Is there anything similar in C#?
>
> I'm using VS2005 C# and SQL 2005.

IrvinMcCoy
Wed May 03 09:55:03 CDT 2006

What datatypes are you using ? double

Can you share the schema of your dataset ?
(do for example yourDsVariable.WriteXmlSchema( Console.Out ) )
I can't find the WriteXmlSchema method. My DS is gDataSet, but when I do a
'gDataSet.' the WriteXmlSchema is not listed. There is a GetDataSetSchema,
but I can't get it to work either. Sorry if this is simple stuff, but I'm
just learning OOP & C#.

In debug, I did look in the watch window, and the variable
'gtEstCrewLabor.TotalLabHourlyRateColumn.Expression' is empty. When I
manually add the expression in the watch window it works.

I checked the gDataSet.Designer.cs file, and the expression is in there.
It's the middle one below:

private void InitExpressions() {
this.EstCrewEqp.TotalRepHourlyRateColumn.Expression = "quantity
* AveRepHourlyRate";
this.EstCrewLabor.TotalLabHourlyRateColumn.Expression =
"quantity * AveLabHourlyRate";
this.usp_OpnCrewDetails.tot_lab_hrly_rateColumn.Expression =
"labquantity * labave_lab_base_rate";
}

I deleted the expression and re-entered it, but that didn't help. I did
notice that it was automatically removed and re-entered in the
gDataSet.Designer.cs file.

Any suggestions?

Thanks!


"Vasco Veiga [MS]" wrote:

> What datatypes are you using ?
> Can you share the schema of your dataset ?
> (do for example yourDsVariable.WriteXmlSchema( Console.Out ) )
>
> To see the data inside the dataset, you can use the debugger visualizer that
> appears if you hover with your mouse on the dataset variable (a magnifier
> icon appears, and if you press it a viewer similar to the one you see when
> you preview data will appear). The same magnifier appears if you add a watch
> for the dataset.
>
> Yet another way is using the Immediate Window (usually Ctrl+Alt_I) and then
> execute
> > ? yourDsVariable.GetXml()
>
> --VV [MS]
> vascov@microsoft.com
>
> "Irvin McCoy" <IrvinMcCoy@discussions.microsoft.com> wrote in message
> news:01ACD56A-9BED-47BA-A3AB-9C67B1F945DE@microsoft.com...
> >I have a table with a simple expression column. I'm multiplying quantity *
> > AveLaborRate to come up with total_labor. When I do the 'preview data' it
> > works fine, but when I run my program, all I get is the default 0. All of
> > the
> > other fields have the same data as the preview.
> >
> > What could be causing the total_labor field not to calculate?
> >
> > Is there a way to view all of the contents in a table while I'm in debug
> > mode? FoxPro has the 'Browse' command. Is there anything similar in C#?
> >
> > I'm using VS2005 C# and SQL 2005.
>
>
>