24 thoughts on “C# Tutorial 7: Edit/Update a data from Database with button

    Tom Yang

    (June 30, 2018 - 12:17 am)

    so what is the command that will update the data from the code ?

    uzeir dalip

    (June 30, 2018 - 12:17 am)

    thanks mate – 4 years later and this video is still helping people

    Aamir Karim

    (June 30, 2018 - 12:17 am)

    Suppose I left the last name textbox blank. Then what will be new value in database? The last value or surname will be updated to blank ?

    Kaz Tee

    (June 30, 2018 - 12:17 am)

    can someone please help with this sql i want the user to update his profile. i create a profile page now i cant get the sql correct for the upadte button. i tried
    update user (table)
    set firstname,lastname,address,email,telephone (fields in my table)
    where 'email' (email it uses to update that particular user account details

    dolev ben

    (June 30, 2018 - 12:17 am)

    stop moving your f mouse

    Kimu_chin卍

    (June 30, 2018 - 12:17 am)

    Thanks

    SHIVRAM SINGH

    (June 30, 2018 - 12:17 am)

    i make a Windows form. after debug and save form, i make a change in form but change not show in form when debug. why?

    Mrunal Ahirrao

    (June 30, 2018 - 12:17 am)

    Why used While loop(empty)?

    Jun Lee Martel

    (June 30, 2018 - 12:17 am)

    can you also have tutorial on How To Search Values From MySQL Database And Set It Into TextBox?

    ahmed magdy

    (June 30, 2018 - 12:17 am)

    dude u taught me a lot of stuff from your videos thanks man

    kim lapitan

    (June 30, 2018 - 12:17 am)

    could someone teach me how to update from the data grind not from the text box

    Balthier Sky

    (June 30, 2018 - 12:17 am)

    why there is no error when
    I did not put any number in EId.txt but the messagebox show is still update 

    I want to incounter it in error 
    edi.txt
    username.txt
    password.txt
    are missing please insert

    Vikal C

    (June 30, 2018 - 12:17 am)

    thank you..nice video. easy to learn also.

    Viktor Strate

    (June 30, 2018 - 12:17 am)

    Anyone know how to add horizontal lines in designmode (like in HTML <hr />)

    Simon Johansen

    (June 30, 2018 - 12:17 am)

    Great tutorials!
    I need some help, in the databse, my first column (the primary key) I have a name, so it's set to VARCHAR(45) and the rest of my columns are numbers, wich is  also set to VARCHAR(45).
    When i translate the data from my c# to MySQL, i Reads:
    "System.Windows.Forms.TextBox, Text: 58.8"
    This is what is says in the columns, insted of just 58.8, it says: "System.Windows.Forms.TextBox, Text:"   in front of it.
    Why is that?

    Boris Bahi

    (June 30, 2018 - 12:17 am)

    nothing esle to say . all is into this video .
    think you

    Khalil

    (June 30, 2018 - 12:17 am)

    even if u choose eld = 1000 they will show you that the data r changed !!

    fokziiie

    (June 30, 2018 - 12:17 am)

    I get : data type mismatch in critieria expresson. Any tips? Don't understand the error, when it works fine for adding (saving) users.

    eXtrem3_b0y

    (June 30, 2018 - 12:17 am)

    Very useful information! Thank you for your effort and hard work!
    1 question: What if I want to update just 1 field from DB, for example only the First Name and leave everything the same ?

    harrun prasadh

    (June 30, 2018 - 12:17 am)

    How to connect Database ?

    Yanky Kalifornia

    (June 30, 2018 - 12:17 am)

    thank for the video

    Fahrettin Perçin

    (June 30, 2018 - 12:17 am)

    This kind of tables contain a column that is marked as "Primary Key". Primary Key means that same data cannot repeat and null data cannot be inserted. In this table, I think "Eid" is primary key. Therefore, it is logical to depend to this column. However, if the column you use is not Primary Key or Unique Key, then you must add "AND tablename = ' " + tablenameValue + " ' " after "this.Eid_txt.Text +" code.

    Hayd Gately

    (June 30, 2018 - 12:17 am)

    Any idea how instead of not just depending on if it's the same eid but on another column as well at the same time?

    yinebeb kelemu

    (June 30, 2018 - 12:17 am)

    tnx

Leave a Reply

Your email address will not be published. Required fields are marked *