Hello everybody,

I'm totally frustrated!

Let's say we have a table "Xs" with 3 columns:

"ModuleId" int,
"XId" int identity (1,1),
"Xxxxxx" char (20),
"Xyyyy"  char (20)

- in database and some stored procedures like "GetXs":

select * from Xs

Go

and "AddXs":
@ModuleId int, @Xxxxx char (20), @Xyyyy char (20)

as

insert into {objectQualifier}Xs (ModuleId, Xxxxx, Xyyyy)

values (@ModuleId, @Xxxxx, @Xyyyy)

select SCOPE_IDENTITY ()

DAL functions and BLL functions work correctly and when I'm trying to add new data from my webApplication I get good result as I chek it from SQL tab (select * from Xs) by signing as host. But when I'm tryng to get the data I get nothing, I mean that IDataReader object is empty somehow . I investigated that SqlHelper.ExecuteReader in my sqlProvider.GetXs connects to the database and try to populate the data, because it get the names of the fields in good way, but it do not get any rows for these fields. It looks like the table of  Xs is empty (?!).., although I have add the data.

Any ideas where the mistake could be?

Well yes, if I would like to get the exact Xs, I need the condition.. But what if want to get all of Xs.. the WHERE clause do not fit here and no need for parameter.

Or I do not understand something?

Well, acctually I've already checked that. But as I think the mistake is somewhere in DAL.

The IDataReader object which is returned by SqlDataProvider (Function GetXs) has the values as follows:

IDataReader dr = CType(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner & ObjectQualifier & "GetXs"), IDataReader)

dr.GetName (0) - "ModuleId"
dr.GetName (1) - "LabasId"
dr.GetName (2) - "Xxxxx"
dr.GetName (3) - "Xyyyy"

dr.GetValue (0) - "Invalid attempt to read when no data is present"
........

As I said, If I try to select data from SQL tab in Host section, I get everything that I need.