EDN Admin
Well-known member
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
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