I've been trying to become a self taught database programmer for both the client and server end using in large part SQL Server 2008 and VB2008 and after over a year and getting my back end to a point where I feel comfortable venturing into the front end of this venture of mine I'm hitting a road block and all the apress help books and searches on the internet aren't seeming to get me any closer to resolving my problem.
It seems most of the internet instructional stuff for noobs like me are not really made for someone trying to build a DB application using only stored procedures to access the back end. After all my research this tendency seems a wee bit counter intuitive as stored procedures seem like the optimal way to do things. But that's an aside. Anyway my issue is that I've started making forms with the aid of VisualStudio's VB.net GUI and the little bit of VB code I've learned and I've got the forms almost exactly how I want them but the problem I'm facing, and that's starting to drive me absolutely bonkers, is that I can't for the life of me figure out how to get my datagrids to update without closing the form and reopening it. Here's what I'm trying to do. I have a datagrid that uses a stored procedure to populate initially. Then I have a seperate stored procedure for input into the tables that are the source behind the stored procedure that populates the data grid on the form. I've got both working right with the problem that in all my noobiness I can't figure out how to get the system to call upon the stored procedure populating the data grid a second time to refresh the data grid after running the other stored procedure that inputs the data. If anyone can help me in any way I'll be very appreciative. Thanks for your time. Here's a link to the code http://dotnetdevelopment.pastebin.com/W8GeG7Sz
