Solved

Help with nullable variables and a webmethod

Posted on 2008-10-29
5
858 Views
Last Modified: 2008-11-07
I have a web methods that is set up like so

public DataSet updateAppRecord(int app_id, string app_acro, string app_name, int? app_type_id, int control_level_id, bool active)

As you can see there is one variable that is "nullable" int?  

It has to be nullable because a value will not ALWAYS be passed though with this...sometimes it will be null

on the back end I call it like so

DataSet ds = almsvc.updateAppRecord(app_id.Value, app_acro, app_name, app_type_id.Value, ctl_level_id.Value, active.Value);

I ahve also tried it like so

DataSet ds = almsvc.updateAppRecord(app_id.Value, app_acro, app_name, app_type_id, ctl_level_id.Value, active.Value);

I have to beleive that the issue is occuring because of the int? for the app_type_id   app_type_id.Value would be the way you woudl normally cast an int? to an int variable....but if it is int? to int? my understanding is you dont need the.Value.     Why do I get a SOAP exception when I try to pass the int? variable to the web service when the web service is asking for an int? variable?



0
Comment
Question by:Prysson
  • 2
  • 2
5 Comments
 
LVL 55

Expert Comment

by:Jaime Olivares
ID: 22834053
at your database design, is this variable declared as nullable? (Allow null)
0
 
LVL 13

Expert Comment

by:TechTiger007
ID: 22834660
int will be automatically converted into int? So that should not be the issue. I dont think DBNull will be converted into integer. Before calling the web method check if the value passed is DBNull
0
 

Author Comment

by:Prysson
ID: 22840069
1. The database allow for null values in all columns.
2. a step through of the code during testing shows that no dbnull values are being passed into the web method.

Whats more..I removed all possibility of null in teh variables by using conversion methods converting null entries into "0" or "false" depending on the variable...so no null are being passed no nulls are being expected and nullas are allowed bythe database...still I am getting the error...I am totally confused now..I cant see any reason why this would be happening.

0
 

Author Comment

by:Prysson
ID: 22840880
Ok I have eliminated the interface and even the web service..the error is occuring in the BLL and DAL layers compiled into a dll.

A method that fills a datatble querying data from the database give a foreign key constraint error...Now this I totally dont understand.  I have revied the datatable and its data..none of the data violates foreign key constraints and the datatable allows nulls for all columns...unless thats it..is it a violation of a foreign key constraint to have a null value?
0
 
LVL 13

Accepted Solution

by:
TechTiger007 earned 500 total points
ID: 22842941
Foreign key does not allow null values, that should be the issue.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now