I asked this question before:

I have a Strongly typed DataSet one of the datatables within it has data in
it. I have a stored procedure that expects a parameter that returns data
that also has got to go into the same datatable. Is it possible to bind one
of the columns that is already populated to a paramter of a Dataadapters
select command and call the .Fill to execute the stored procedure which will
fill the remaining empty columns?

--

Regards

Ian

I would set a variable to the value of the column that has the parameter
that you need. Then after you do a fill for the second select, you will have
to attach those columns to the main datatable. But it sounds like you
already have the columns but not the data (not sure why you do it this way,
but to each his own), so you will have to remove the existing empty columns
and attach the new columns that you pulled with the second sproc. This is
do-able, but it sure sounds ugly.

"Ian Frawley" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I asked this question before:
>
> I have a Strongly typed DataSet one of the datatables within it has data
> in
> it. I have a stored procedure that expects a parameter that returns data
> that also has got to go into the same datatable. Is it possible to bind
> one
> of the columns that is already populated to a paramter of a Dataadapters
> select command and call the .Fill to execute the stored procedure which
> will
> fill the remaining empty columns?
>
> --
>
> Regards
>
> Ian
>
>

"Earl" wrote in message

Cheers Earl, its pretty hard to explain the problem I am having but I
thought a data adapter would just do this for me, I'm fairly sure it will I
just need to find an example.

>I would set a variable to the value of the column that has the parameter
>that you need. Then after you do a fill for the second select, you will
>have to attach those columns to the main datatable. But it sounds like you
>already have the columns but not the data (not sure why you do it this way,
>but to each his own), so you will have to remove the existing empty columns
>and attach the new columns that you pulled with the second sproc. This is
>do-able, but it sure sounds ugly.
>
>