Comments by SimbarasheM (Top 5 by date)

Hi Dave

I have two queries defined in SQL Server and they are then refined i.e. I use parameterised queries in my Dataset in VB.Net.

I have defined the relationship on the two DataTables based on say invoice number field.

What I would like to view on my report is as follows:

1. Table A contains the data I would like to display in the Header section of my report

2. Table B contains the data I would like displayed in the details section when the report runs.

However when I run the report I only get values from Table A and just the column headings for the Details with no data displayed.

How do I ensure Table A is displayed and then also the results of Table B are displayed.

Thanks

Thanks Simon.

I will be posting a detailed solution with a sample application in a shortwhile.

I have been able to effect some modifications to my code and am able to save to the database using a custom INSERT statement in the TableAdapter and I reference to it in my DataManager Class within the function for the insert, however I am still unable to retrieve the Newly created ID. Check the solution below for details

@Milenalucik

@@IDENTITY has it's inherent problems in multi tier applications and moreso multi-user applications. I prefer SCOPE_IDENTITY for the reason that it returns the primary key created for the transaction owned by the current insert statement. While @@Identity works well with single user database applications and for MS Access I don't see it working well for my application. Check This Article for more.

If you follow This Other Question. You will discover how I am working on a solution for an N-Tier VB.NET application using SCOPE_IDENTITY.

Thanks for your response

SimbarasheM