Hi, I would like to get data using GetMultiAsDataTable using the following statement:

ds.Tables.Add(AllCol.GetMultiAsDataTable(Nothing, Nothing, sortOrder))

Works fine, but the the table ends up being called Table1

I would like to table be given a name I want. Is this possible. I am also unable to find method to rename Table1 to something else. I keep looking.

Thanks in advance.

Best Regards.

sparmar2000 wrote:

Hi, I would like to get data using GetMultiAsDataTable using the following statement:

ds.Tables.Add(AllCol.GetMultiAsDataTable(Nothing, Nothing, sortOrder))

Works fine, but the the table ends up being called Table1

I would like to table be given a name I want. Is this possible. I am also unable to find method to rename Table1 to something else. I keep looking.

Thanks in advance.

Best Regards.

Dim table As DataTable = AllCol.GetMultiAsDataTable(Nothing, Nothing, sortOrder)
table.TableName = "Foo"
ds.Tables.Add(table)

should work.