Come ADO experts!!!

  • Thread starter Thread starter Ian Frawley
  • Start date Start date
I

Ian Frawley

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?
 
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.
 
"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.
 
Back
Top