Tech Off Thread

5 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

Table names in sprocs

Back to Forum: Tech Off
  • User profile image
    W3bbo

    'lo

    Is there any thing I can do to my sprocs (with multiple SELECT blocks) to define the "TableName" of each returned table, so that ADO.NET can fill in the .TableName property properly?

  • User profile image
    Minh

    No.

    But you can manually rename (90% sure) your tables from the ADO.net side.

  • User profile image
    wavesmash

    How about Select * from tablename
    then
    Select 'tablename' as tablename

    1st result set is the table
    2nd is the name of the table



  • User profile image
    bitmask

    I don't believe so. Have you looked at the TableMapping collection of the DataAdapter class? You can use this to apply table names when Fill executes.

  • User profile image
    W3bbo

    bitmask wrote:
    I don't believe so. Have you looked at the TableMapping collection of the DataAdapter class? You can use this to apply table names when Fill executes.


    Yeah, that's what I'm doing now.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.