c# - bindingnavigator understanding

ZeroHour

ho3 ho3 ho3
Joined
22 Mar 2004
Messages
1,118
Hi
I am a noobie with c# in VS 2005 but I have done some ASP.NET using c#.
The background:
I have a program that links into MySQL (MSSQL is damn expensive) using a reference called MySQLdriverCS (freeware). I can connect to the db and retrieve a datatable succesfully using this addon. Now once its retrieved and the using speficies a csv file it will compare the csv import (using another addon) with the datatable. This all works as it should thankfully, so then I compare the results from both to determine if there is a new department that needs to have data set (as in the csv has the name of a dep the db does not know about). The comparison then builds another datatable with all the relevant new deparments in there that need to have extra information queried from the user. I then pass this as a datatable parameter into the new form. Once the datatable is there it is bound to into a bindingsource which is then linked to a bindingnavigator and finally linked into the form elements with the following (repeated 3 times for 3 different fields):
DEP_name.DataBindings.Add(new Binding("Text", this.SETS_bsource, "dep_id", true));

The problem:
I can switch between records using the bindingnavigator but when I edit a field I can no longer switch records.
I know that I need to do something to put the data back into mysql but I was wondering if someone could point me in the right direction. Is my idea of this app flawed and if so how do you recommend doing what I need.
Thanks for all the advice
 

Members online

No members online now.

Latest profile posts

Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.
Terrahertz wrote on Electronic Punk's profile.
Yo fellas!
Electronic Punk wrote on Sazar's profile.
Where are you buddy?
Perris Calderon wrote on Electronic Punk's profile.
Hey EP! All good with me, applying for Microsoft MVP right now, should have done this a while ago.

Notifications don't work, I only found your response by coming back to hunt up some threads, if you want, give me your email address so we can keep in touch easier!
Perris Calderon wrote on Electronic Punk's profile.
EP, glad to see you come back and tidy up...did want to ask a one day favor, I want to enhance my resume , was hoping you could make me administrator for a day, if so, take me right off since I won't be here to do anything, and don't know the slightest about the board, but it would be nice putting "served administrator osnn", if can do, THANKS

Been running around Quora lately, luv it there!

Forum statistics

Threads
61,997
Messages
673,411
Members
5,591
Latest member
nodee