add results to dataset

[Steve]

Ok, I hit a wall and I'm stuck. I have a web form that has a textbox were
the user can enter in 1 to many usernames, then the user has to validate the
user to make sure the user exists. I have a stored procedure that can only
take one username at a time, so I need to keep calling this stored procedure
with all of the usernames in the textbox( i have this portion working). The
issue I'm running into is that only the data for the last username passed to
the stored procedure is being passed back so if I enter in

JSmith, SLong, SHenry,

I'm only getting the details for SHenry, though I need to store and use the
details for all 3 users so I can add them to the user table.

so when I click the add buttong, its storing:
JSmith, SLong, SHenry in the user column of the table BUT storing SHenry,
phone number, email address etc. I need a row for each user with their own
information
So I either need somehow to keep adding it to the existing dataset or
somethign.

any suggestions on how to do this?

[Alexey Smirnov]

On Jul 11, 4:55 pm, "Steve" <S...@community .nospam.comwrot e:

Ok, I hit a wall and I'm stuck. I have a web form that has a textbox were
the user can enter in 1 to many usernames, then the user has to validate the
user to make sure the user exists. I have a stored procedure that can only
take one username at a time, so I need to keep calling this stored procedure
with all of the usernames in the textbox( i have this portion working). The
issue I'm running into is that only the data for the last username passed to
the stored procedure is being passed back so if I enter in

JSmith, SLong, SHenry,

I'm only getting the details for SHenry, though I need to store and use the
details for all 3 users so I can add them to the user table.

so when I click the add buttong, its storing:
JSmith, SLong, SHenry in the user column of the table BUT storing SHenry,
phone number, email address etc. I need a row for each user with their own
information

So I either need somehow to keep adding it to the existing dataset or
somethign.

any suggestions on how to do this?

Can we see the code of the stored procedure?

[Steve]

the stored procedure is actually a select statement that calls a view which
is doing a select, joins, etc on tables.
but the stored procedure is

select * from vGetUserInforma tion where ID = @id

and the view is doing all of the work
"Alexey Smirnov" <al************ @gmail.comwrote in message
news:11******** **************@ k79g2000hse.goo glegroups.com.. .

On Jul 11, 4:55 pm, "Steve" <S...@community .nospam.comwrot e:

>Ok, I hit a wall and I'm stuck. I have a web form that has a textbox were
the user can enter in 1 to many usernames, then the user has to validate
the
user to make sure the user exists. I have a stored procedure that can
only
take one username at a time, so I need to keep calling this stored
procedure
with all of the usernames in the textbox( i have this portion working).
The
issue I'm running into is that only the data for the last username passed
to
the stored procedure is being passed back so if I enter in

JSmith, SLong, SHenry,

I'm only getting the details for SHenry, though I need to store and use
the
details for all 3 users so I can add them to the user table.

so when I click the add buttong, its storing:
JSmith, SLong, SHenry in the user column of the table BUT storing SHenry,
phone number, email address etc. I need a row for each user with their
own
information

So I either need somehow to keep adding it to the existing dataset or
somethign.

any suggestions on how to do this?

Can we see the code of the stored procedure?

[Alexey Smirnov]

On Jul 11, 7:45 pm, "Steve" <S...@community .nospam.comwrot e:

the stored procedure is actually a select statement that calls a view which
is doing a select, joins, etc on tables.
but the stored procedure is

select * from vGetUserInforma tion where ID = @id

and the view is doing all of the work

Well, then it's something the code I guess... Need to see it :-)

[Steve]

need to see what? the .net code or the SQL code?

"Alexey Smirnov" <al************ @gmail.comwrote in message
news:11******** *************@w 3g2000hsg.googl egroups.com...

On Jul 11, 7:45 pm, "Steve" <S...@community .nospam.comwrot e:

>the stored procedure is actually a select statement that calls a view
which
is doing a select, joins, etc on tables.
but the stored procedure is

select * from vGetUserInforma tion where ID = @id

and the view is doing all of the work

Well, then it's something the code I guess... Need to see it :-)

[Alexey Smirnov]

On Jul 11, 8:20 pm, "Steve" <S...@community .nospam.comwrot e:

need to see what? the .net code or the SQL code?

Steve, you said that

issue I'm running into is that only the data for the last username passed to
the stored procedure is being passed back

So I think that the problem is somewhere either in the .net code which
runs the stored procedure, or in the stored procedure itself. If you
think that the stored procedure is ok then we should check the code
which calls the stored procedure. Maybe you call it only once, or
something like this... ??

[Steve]

i have something like

string userList = txtUsername.txt ;
string[] user= userList.split( ',');

foreach(String u in users)
{
DataSet dsUsers = new DataSet();
dsUsers = GetUserDetails( u);
}

//this calls the datalayer which houses the stored procedure
Public DataSet GetUserDetals(s tring userName)
{
DataSet ds = new DataSet();
ds = UserInformation .UserDetails(us erName);
return ds;
}
"Alexey Smirnov" <al************ @gmail.comwrote in message
news:11******** **************@ r34g2000hsd.goo glegroups.com.. .

On Jul 11, 8:20 pm, "Steve" <S...@community .nospam.comwrot e:

>need to see what? the .net code or the SQL code?

Steve, you said that

>issue I'm running into is that only the data for the last username passed
to
the stored procedure is being passed back

So I think that the problem is somewhere either in the .net code which
runs the stored procedure, or in the stored procedure itself. If you
think that the stored procedure is ok then we should check the code
which calls the stored procedure. Maybe you call it only once, or
something like this... ??

[Alexey Smirnov]

On Jul 11, 8:58 pm, "Steve" <S...@community .nospam.comwrot e:

i have something like

string userList = txtUsername.txt ;
string[] user= userList.split( ',');

foreach(String u in users)
{
DataSet dsUsers = new DataSet();
dsUsers = GetUserDetails( u);

}

What do you do with dsUsers after that?

[Steve]

I'm reading through it to see if the users in the textbox are in the
returned dataset from my stored procedure
"Alexey Smirnov" <al************ @gmail.comwrote in message
news:11******** **************@ r34g2000hsd.goo glegroups.com.. .

On Jul 11, 8:58 pm, "Steve" <S...@community .nospam.comwrot e:

>i have something like

string userList = txtUsername.txt ;
string[] user= userList.split( ',');

foreach(Stri ng u in users)
{
DataSet dsUsers = new DataSet();
dsUsers = GetUserDetails( u);

}

What do you do with dsUsers after that?

[Alexey Smirnov]

On Jul 11, 9:34 pm, "Steve" <S...@community .nospam.comwrot e:

I'm reading through it to see if the users in the textbox are in the
returned dataset from my stored procedure"Alexe y Smirnov" <alexey.smir... @gmail.comwrote in message

Okay, let's test it...

You have JSmith, SLong, SHenry in the txtUsername

So

string userList = txtUsername.txt ;
string[] user= userList.split( ',');

foreach(String u in users)
{
// user #1: JSmith

DataSet dsUsers = new DataSet();
dsUsers = GetUserDetails( u); // u = JSmith

// and now, what do you do with the data?
}

If database has that JSmith in the vGetUserInforma tion table, then you
should get some data from it

select * from vGetUserInforma tion where ID = @id // @id = 'JSmith'

if dsUsers is not empty than the error somewhere in the .net code
after the one you sent above.