473,372 Members | 1,089 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

ods calls business object then method calls ta with output params

I have the ods calling the business object. This is the method it is calling

public DataTable GetEditManager(string tab, string state, int rows, int
pageselected, int nbrpages, string sort, byte sortdir, int totaledits, string
userid)
{
int a = nbrpages;
int b = totaledits;

if (dtProv == null)
dtProv = taProv.GetData(tab, state, rows, pageselected, ref a,
sort, sortdir, ref b, userid);
return dtProv; //dtProv is a datatable

}

Here is the header of the sp:

CREATE procedure sp_web_edit_manager (
@tabselected varchar(5) -- which tab was selected
,@stateselected varchar(5) = null -- which state was selected, optional
,@nbr_edits int = 0 --Number of edits per page
,@page int = 1 --Which page should be returned
,@nbr_pages int =1 output --Let the app know how many pages there are
,@sort_option varchar(255) = 'edit_mast.edit_id' --How should we sort:
1=edit_id, 2=edit_name, 3=error_msg
,@desc tinyint = 0 --What is the sort order 0 = ascending, 1 = descending
,@total_edits int = 0 output --How many edits are there for this tab
,@user_id varchar(20) = 'Install'
) as

Now I need to call the stored proc which is inside of a xsd. The sp is inside
of the ta GetData. The params above nbrpages and totaledits are output params
in the sp. When I try to build the site I get this error message: cannot
convert from 'ref int' to 'out int?'. How do I get the method taProv.GetData
with its input and output params to call the stored proc?

--
Message posted via http://www.dotnetmonster.com
Jun 8 '06 #1
2 1488
Ummm, change it to out int instead of ref int?

andy6 wrote:
I have the ods calling the business object. This is the method it is calling

public DataTable GetEditManager(string tab, string state, int rows, int
pageselected, int nbrpages, string sort, byte sortdir, int totaledits, string
userid)
{
int a = nbrpages;
int b = totaledits;

if (dtProv == null)
dtProv = taProv.GetData(tab, state, rows, pageselected, ref a,
sort, sortdir, ref b, userid);
return dtProv; //dtProv is a datatable

}

Here is the header of the sp:

CREATE procedure sp_web_edit_manager (
@tabselected varchar(5) -- which tab was selected
,@stateselected varchar(5) = null -- which state was selected, optional
,@nbr_edits int = 0 --Number of edits per page
,@page int = 1 --Which page should be returned
,@nbr_pages int =1 output --Let the app know how many pages there are
,@sort_option varchar(255) = 'edit_mast.edit_id' --How should we sort:
1=edit_id, 2=edit_name, 3=error_msg
,@desc tinyint = 0 --What is the sort order 0 = ascending, 1 = descending
,@total_edits int = 0 output --How many edits are there for this tab
,@user_id varchar(20) = 'Install'
) as

Now I need to call the stored proc which is inside of a xsd. The sp is inside
of the ta GetData. The params above nbrpages and totaledits are output params
in the sp. When I try to build the site I get this error message: cannot
convert from 'ref int' to 'out int?'. How do I get the method taProv.GetData
with its input and output params to call the stored proc?

--
Message posted via http://www.dotnetmonster.com


Jun 8 '06 #2
received errore: cannot convert from 'out int' to 'out int?'

sd********@gmail.com wrote:
Ummm, change it to out int instead of ref int?
I have the ods calling the business object. This is the method it is calling

[quoted text clipped - 32 lines]
convert from 'ref int' to 'out int?'. How do I get the method taProv.GetData
with its input and output params to call the stored proc?


--
Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/For...p-net/200606/1
Jun 9 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Magnus Lyck? | last post by:
Something really strange is happening to me (sometimes). I'm using Python 2.3.2 on NT 4.0 as well as win32all-157, adodbapi and db_row. During a recursive call to a method, it seems Python...
6
by: Ivan Voras | last post by:
Can this be done: (this example doesn't work) ---- class A: def a_lengthy_method(self, params): # do some work depending only on data in self and params class B:
1
by: craigkenisston | last post by:
Hi, I'm trying to create a generic function to call stored procedures in a SQL Server database. I'm passing the params, values and the direction of the params in arrays. The function is...
1
by: Darsin | last post by:
Hi all, I am a new programmer to C# and i am having a following problem. I want to make a single method which takes a variable length array and display it contents. i have defined the method as:...
7
by: The Crow | last post by:
code snippet below briefly shows what i need to do : public void Method1(params object args) { Method2(args); } public void Method2(params object args) { //Do something.
9
by: Hasan O. Zavalsiz | last post by:
Hi , i am trying to figure out which approach is better to use . let me explain the scenario. i am using the "Nortwind" database . in this database i have "Customers " table .The following is the...
6
by: Pucca | last post by:
I have a program that originally compiles into a exe file. I changed the compile option to generate dll file. This program calls a com component. Can I use pinvoke in C# to call it? The...
1
by: =?Utf-8?B?TWFyaw==?= | last post by:
Hi... There are a few questions wrapped up in this, but the main one is that the WebService.MyMethodAsync() methods that are automatically generated in the client code by VS 2005 don't seem to...
8
by: carton | last post by:
Any opinions on this code as part of a general purpose framework? I expect people will have varying opinions on the use of $ in the property names. I did it for several reasons: 'interface' is...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.