Reply to thread

Hi.

 Im very new to Visual Studio and ASP.NET. Im not very versed in ASP.NET but I am learning as I go along. A lot of what I have done was through the Visual Studio interface and I havent done much manual programming so far.

 I am using Visual Studio 2010 and .NET Framework 4.0 to create a small application to track IT equipment (Assets) in our department. I have reached a small stumbling block where I am using a DataGridView (DGV) control in a form so that I can mimic the sub-form

 feature that is available in MS Access. What I want to do with the DGV control is display all Assets that are related to a Tracking Form. The Primary Key/Foreign Key is the Tracking ID. So far it is showing every record that is in the Transaction table.

 Here is a screenshot of what it looks like in my form when I run the debug (you will notice that the forms Tracking ID is 1 but the DGV shows records for Tracking ID 1 and Tracking ID 2):

 NB: I had to remove the image as my account wasnt verified as yet.

 Is there a way to filter the records being shown in the DGV to match the Tracking ID in the form using just SQL?

 If not, how can I accomplish this with ASP.NET?

 Thank you.

<br/>


View the full article


Back
Top