you should consider the following:
where does your data actually live when you're doing all your different calls? Is there any data getting lost? If so, when does it get lost? May I suggest you try a "toy system" where you have minimal amounts of data being manipulated. Can you list some sample data? Can you show before and after states? On 3 March 2010 19:01, VooBer <[email protected]> wrote: > 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 > -- Charles A. Lopez [email protected] What's your vision for your organization? What's your biggest challenge? Let's talk. (IBM Partner)
