Using the column of a datatable as a paramter for a command object

Hi everyone,

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


.

Relevant Pages

  • Using the column of a datatable as a paramter for a command object
    ... I have a Strongly typed DataSet one of the datatables within it has data in ... I have a stored procedure that expects a parameter that returns data ... fill the remaining empty columns? ...
    (microsoft.public.dotnet.framework.adonet)
  • Come ADO experts!!!
    ... I have a Strongly typed DataSet one of the datatables within it has data in ... I have a stored procedure that expects a parameter that returns data ... fill the remaining empty columns? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Come ADO experts!!!
    ... so you will have to remove the existing empty columns ... and attach the new columns that you pulled with the second sproc. ... > I have a Strongly typed DataSet one of the datatables within it has data ... I have a stored procedure that expects a parameter that returns data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SPs/ADO.NET/DataSets/DataTables/DataAdapters/TableMapping
    ... If you add all other tables that your query returns to the end, ... > Let's say that I have a stored procedure which looks like this ... > What I get back is a DataSet containing the 3 DataTables I want, ... > I have a statistical Stored Procedure library which is broken into smaller ...
    (microsoft.public.dotnet.framework.adonet)
  • SPs/ADO.NET/DataSets/DataTables/DataAdapters/TableMapping
    ... What I get back is a DataSet containing the 3 DataTables I want, ... instead of relying on the table position indexes. ... This is because I know this stored procedure will change over time and I ... I have a statistical Stored Procedure library which is broken into smaller ...
    (microsoft.public.dotnet.framework.adonet)