Updating record in textchanged event confuse navigat record

Question

Hi guys i have problem

I need to update data in tables without using button i want only using textbox changed event

FleetManagment.Fleet fleet1 = new FleetManagment.Fleet();
string a = fleet1.UpdateDriver("Data Source=" + value1 + ";Initial Catalog=" + value2 + ";User ID=" + value3 + ";Password=" + value4 + "", Convert.ToInt32(textBox1.Text), textBox2.Text, textBox3.Text, textBox4.Text);
              MessageBox.Show("Record changed successfully");

                fillcontrol();

but problem when i load the data using load event

or press on next navigation button it give me same message box

How i make this message "Record changed successfully" shown only when update record and not show when browsing records or incresing

SUNIL GUTTA · Answer

Humm i hope your new row inserting if incasse no no present  updating the row if changes made (will display message showing rows are updated )  some SPs are fixed .. Actually code can be way way better and reused in much better way .. Anyways look in this attachment fixed bugs going by ur path Regards ---------------------- RATE THE SOLUTION IF YOU FEEL IT DESERVES- --------------------

SUNIL GUTTA · Answer

Hi there Provided you some example try like this : private void button1_Click(object sender EventArgs e) { //write some condtions to verify data is same as in DB or not I PREFER USING SP'S if( // dataexists) { next_update(); } else { flag = true; next_update(); } } private void next_update() { if (flag) { //write some update conditions back to DB MessageBox.Show(uPDATED SUCESSFULLY); } else { //write next row Retrieval statements } } regards Sunil G --------------------------------Rate if you feel Helpful----------------------------------

SUNIL GUTTA · Answer

Humm no issues Do mark the answer ..

ahmed sa · Answer

Thank you very much for helping really i sorry for headache

ahmed sa · Answer

thank you very much for interest i actually do update as above but this message found in screen shoot above show when i prees show button or next button although i write message update in text_changed event

ahmed sa · Answer

ry

SUNIL GUTTA · Answer

Hi done some small modifications better you to keep working on it .. still i havent gone though entire code .. .. Added this SP : create proc update_driver @DriverID INT @DriverName nvarchar(50) @Nationality nvarchar(50) @Address nvarchar(50) as begin update dbo.driver set driverid=@DriverID  drivername=@drivernamenationality=@nationality where driverid=@driverid end Well as you requested to update on textchanged events of text_boxes i given a minor try but issue will be even a character modification in textbox also the textvalue goes to DB and updated . It will be burden on server .. Better plan like complete column check after next button click ... .. KEEP BREAK POINTS FRIEND AND IMPLEMENT .. YOU WILL UNDERSTAND THE FLOW ..

SUNIL GUTTA · Answer

I guess you are starter to this field if i am wrong excuse me :) Well dude there is lot of work to be done like you written stored procedures looks quite annoying improper naming conventions i.e code in c# looks mystery for others to understand at one look .. I am analyzing your code will update u by tomorrow . Regards

ahmed sa · Answer

Another solution for database you can create new database in sql server then press in new query button then past in database then parse and execute after that you will found table driver and his stored procedures procedure found in stored procedure file when you open the program in open database form write in server name ip of database found if local also write ip of computer and write name of database then user id write sa or any user found in these database password write password of user

ahmed sa · Answer

thank you very much this full backup from database fleet managment database from sql server 2005 to restore it righ click on database in sql server 2005-database-righ click-task-restore

SUNIL GUTTA · Answer

Hi Nice but its .bak file .. any idea where to place in sqlserver 2008 in local system ? if so tell me . The file is in unreadable format

ahmed sa · Answer

This is my database i attached with my message

SUNIL GUTTA · Answer

hey buddie .. i am hoping you need to display a messagebox.show(successfully updated); under next button_click event but you are trying to apply under textbox2_changed event in ur driver.cs Note in fleet.cs the method public string UpdateDriver(.........) alwAYS RETURN integer i.e executenonquery returns integer output i.e how many records updated .. public int UpdateDriver(string ConnectionString int DriverNo string DriverNamestring Nationalitystring Address) { { con.Open(); int updatecheck = Convert.ToString(cmd.ExecuteNonQuery()); con.Close(); return updatecheck; } later the updated result stored under variable a in ur code must be used in if condition like private void textBox2_TextChanged(object sender EventArgs e) { FleetManagment.Fleet fleet1 = new FleetManagment.Fleet(); int a = fleet1.UpdateDriver(Data Source= + value1 + ;Initial Catalog= + value2 + ;User ID= + value3 + ;Password= + value4 +  Convert.ToInt32(textBox1.Text) textBox2.Text textBox3.Text textBox4.Text); if(a > 0) { MessageBox.Show(Record changed successfully); } } I cant check the code properly because i cant match my DB with ur app as i dont know ur excat db table schema etc .. Try above modifications and revert back

ahmed sa · Answer

also update what i need is separate from next button and form i need to modify in it is form driver functions used found in class fleet I need to make update but using textbox_text changed event but not from button thank you if you are from any thing confuse tell me

ahmed sa · Answer

Im sorry to make confuse for you but really i put wrong file what i put in this time is true Next button for navigate records exist(meaning that found) and make also incremental by 1 when i need to add records by same serial(you will see code in this time as you tell me before and already success in this) the problem found now in form driver I need when i press next button in form driver message box that found in text2_text changed event not show when 1- i load data in form load 2-or click next button but only show message update when i update or change text in text box2 thank you very much for interest

SUNIL GUTTA · Answer

Hi just checked your form .. I am confused you are having seperate update & next buttons on form right .. so there wont be any issue further you can directly wirte messagbox.show() under update button click .. till now i am thinking your are using next button for dual purpose .. in which file i need to do modifications say i will do it . mention in detail possible ..

ahmed sa · Answer

i try to code above but it make problem can you modify to me if possible thanks