Updating record in textchanged event confuse navigat record

ahmed sa

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

17 Replies

Know the answer? Post it — somebody with the same question will find it here.

SUNIL GUTTA12y ago
Accepted 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---------------------
0
SUNIL GUTTA12y ago
Humm no issues Do mark the answer ..
0
ahmed sa12y ago
Thank you very much for helping really i sorry for headache
0
ahmed sa12y ago
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
0
ahmed sa12y ago
ry
0
SUNIL GUTTA12y ago
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=@drivername,nationality=@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 ..
0
SUNIL GUTTA12y ago
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
0
ahmed sa12y ago
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
0
ahmed sa12y ago
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
0
SUNIL GUTTA12y ago
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
0
ahmed sa12y ago
This is my database i attached with my message
0
SUNIL GUTTA12y ago
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 DriverName,string Nationality,string 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
0
ahmed sa12y ago
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
0
ahmed sa12y ago
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
0
SUNIL GUTTA12y ago
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 ..
0
ahmed sa12y ago
i try to code above but it make problem can you modify to me if possible
thanks
0
SUNIL GUTTA12y ago

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----------------------------------
0

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 DriverName,string Nationality,string 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