SQL Database Integration

Re: The name ' ' does not exist in the current context

Greg Collins — Mon, 04 Jun 2007 16:35:48 GMT

You should be able to change out your code to use VB.NET instead of C# if you are more comfortable with that. I don't have the exact steps, but they shouldn't be too hard to find.

For the IP07 OM, the MSDN site is the first place I'd go... http://www.msdn.com. I don't know of any others at this time.

If you stick with C#, you define your variables in a similar way to VB:

int currentElementID;
string myDataAdapter;

Re: The name ' ' does not exist in the current context

grimreaper0 — Wed, 30 May 2007 16:48:51 GMT

Greg, Thanks for the fast reply.

You are right about the OM i am trying to cut and paste from various examples i have found on sites to get the code to work as it is new to me. Can you recommend a could reference site for the new 07 OM? Other than using the help file.

I suppose i dont define either currentElementID or myDataAdapter anywhere in the form. I actually am unsure where. In VB i would simply use something such as:

DIM currentElementID as integer, myDataAdapter as text

can i define the same way here?

Re: The name ' ' does not exist in the current context

Greg Collins — Wed, 30 May 2007 16:41:21 GMT

You are stuck with different object models. You are currently working in the InfoPath 2007 OM (as identified by the fact that you have a "_Clicked" function and not an "_OnClick" function. Yet you are trying to use the InfoPath 2003 OM to write your code. This won't work.

You will either need to change your form to use the InfoPath 2003 OM and then use the coding style you are familiar with, or learn how to use the new InfoPath 2007 OM to code.

For Error 1, did you define currentElementID as a string anywhere? It doesn't look like it in your code sample above. The same question in regards to all the other variables you are using.

Re: The name ' ' does not exist in the current context

grimreaper0 — Wed, 30 May 2007 16:37:04 GMT

Sorry for doubling up some of the code. I tried editing it and it keeps posting some stuff twice.

The name ' ' does not exist in the current context

grimreaper0 — Wed, 30 May 2007 16:32:07 GMT

I am having the above problem in my code. I have searched the forum and have read the different ways of getting this to go away with no success. I am extremely new to infopath and .net. I am familiar with VB but not C#, unfortuanelty most examples are in C# so im trying to learn. Any help would be much appreciated. Thanks.

public void CTRL60_4_Clicked(object sender, ClickedEventArgs e)

{

// get the value of the DOM node that we’ll use to append to the WHERE clause

currentElementID = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:queryFields/q:_08-Estimate_tbl/@Cost_Center").text;

// get the value of the DOM node that we’ll use to append to the WHERE clause

currentElementID = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:queryFields/q:_08-Estimate_tbl/@Cost_Center").text;

// get the data adapter object

myDataAdapter = XDocument.DataAdapters("Actuals");

// set the SQL command property of the data adapter, providing a dynamic WHERE clause

myDataAdapter.Command = "SELECT DISTINCTROW Job Number as Job_Number, Cost Center as Cost_Center, Year, Month-Year, Sum(Actual Labor Costs) AS Sum_Of_Actual_Labor_Costs, Sum(Actual Non-Labor Costs) AS Sum_Of_Actual_Non-Labor_Costs, Sum(Total Actual Costs) AS Sum_Of_Total_Actual_Costs FROM actuals GROUP BY Job Number, Cost Center, Year, Month-Year";

// execute the query

myDataAdapter.Query();

}

myDataAdapter.Query();

}

// execute the query

myDataAdapter.Query();

}

Errors are:

Error 1 The name 'currentElementID' does not exist in the current context \My Documents\InfoPath Projects\SO Admin v91\FormCode.cs 38 13 SO Admin v9
Error 2 The name 'XDocument' does not exist in the current context \My Documents\InfoPath Projects\SO Admin v91\FormCode.cs 38 32 SO Admin v9
Error 3 The name 'myDataAdapter' does not exist in the current context \My Documents\InfoPath Projects\SO Admin v91\FormCode.cs 41 13 SO Admin v9
Error 4 The name 'XDocument' does not exist in the current context \My Documents\InfoPath Projects\SO Admin v91\FormCode.cs 41 29 SO Admin v9
Error 5 The name 'myDataAdapter' does not exist in the current context \My Documents\InfoPath Projects\SO Admin v91\FormCode.cs 45 13 SO Admin v9
Error 6 The name 'myDataAdapter' does not exist in the current context \My Documents\InfoPath Projects\SO Admin v91\FormCode.cs 48 13 SO Admin v9