table adapters

[Microsoft Newsserver]

Hi im using 2005/asp.net 2.0

I have added a query on one of my table adapters
getDataByIssueID( @IssueID )

....... sql query

select * from issues where (IssueID = @IssueID) or (@IssueID IS NULL)

The problem is that the function as declared by the designer has not used a
Nullable type.

How can I get around this ?

Cheers

[Munna]

On Jun 18, 6:27 pm, "Microsoft Newsserver" <[e-mail]:

Hi im using 2005/asp.net 2.0

I have added a query on one of my table adapters

getDataByIssueID( @IssueID )

...... sql query

select * from issues where (IssueID = @IssueID) or (@IssueID IS NULL)

The problem is that the function as declared by the designer has not used a
Nullable type.

How can I get around this ?

Cheers

Hi...

Can u be a tittle more descriptive about the problem

Thanks

Munna

[Microsoft Newsserver]

Well, the designer code generates the function to return the datatable. The
signature has parameter of type
System.Int32. However, the underlying SQL Statement has the parameter as

(IssueID = @IssueID) or (@IssueID IS NULL)

Which means it needs to be able to take a nullable type. Therefore, how else
can I use the function with a Null value.



"Munna" <mu******@gmail.comwrote in message
news:1e**********************************@e53g2000 hsa.googlegroups.com...

On Jun 18, 6:27 pm, "Microsoft Newsserver" <[e-mail]:

>Hi im using 2005/asp.net 2.0

I have added a query on one of my table adapters

getDataByIssueID( @IssueID )

...... sql query

select * from issues where >>
The problem is that the function as declared by the designer has not used
a
Nullable type.

How can I get around this ?

Cheers

Hi...

Can u be a tittle more descriptive about the problem

Thanks

Munna

[Microsoft Newsserver]

Dont worry, I solved it.

The basic problem was that the parameter takes the position of being not
nullable because the column was an ID non nullable field. I explictly
changed the parameter for the query and it was fine. Not sure if that would
revert back if reconfigured though ...


"Microsoft Newsserver" <[e-mail] in message
news:uf****************@TK2MSFTNGP02.phx.gbl...

Well, the designer code generates the function to return the datatable.
The signature has parameter of type
System.Int32. However, the underlying SQL Statement has the parameter as

(IssueID = @IssueID) or (@IssueID IS NULL)

Which means it needs to be able to take a nullable type. Therefore, how
else can I use the function with a Null value.



"Munna" <mu******@gmail.comwrote in message
news:1e**********************************@e53g2000 hsa.googlegroups.com...

>On Jun 18, 6:27 pm, "Microsoft Newsserver" <[e-mail]:

>>Hi im using 2005/asp.net 2.0

I have added a query on one of my table adapters

getDataByIssueID( @IssueID )

...... sql query

select * from issues where >>
The problem is that the function as declared by the designer has not
used a
Nullable type.

How can I get around this ?

Cheers

Hi...

Can u be a tittle more descriptive about the problem

Thanks

Munna