Gridview or DataGrid
Posted on 2008-11-19
Let me first start by saying I'm very new to ASP.net, and I'm trying to duplicate something that I've been doing in Visual Basic 6.0 on an ASP.net page.
Here is what I'm trying to accomplish and hopefully someone can tell me how I can do this using something like a GridView or something similar.
In my VB program I use a DataGrid to pull in a recordset that has rows like Endpoint Number, Endpoint Name, TransitAmt, TransitItems. The Endpoint Number and Endpoint Name come from a SQL Stored Procedure and TransitAmt and TransitItems are set empty or zero in the recordset and using the DataGrid the user updates the endpoints with the correct Amounts and Item Counts. Once the user has input the data and hit the OK button the data gets sent to another stored procedure that updates a different table then where the endpoints orginially came from.
To make this more simple I need to pull in data from one table using a stored procedure and update a different table using a stored procedure, with input from a Gridview or something simlar. I can't use Text Boxes since the endpoints change from month to month and I don't want to have to constatly keep updating the page with new or delete text boxes.