VB.NET Tutorial - Insert Update Delete Data in Database from DataGridView | FoxLearn

แชร์
ฝัง
  • เผยแพร่เมื่อ 8 ก.ย. 2024
  • Programming in Visual Basic .Net: CRUD VB NET Insert Update Delete data from SQL Database using Entity Framework VB.NET SQL Server Database Windows Forms Application.
    Website: foxlearn.com
    Through this video you will learn the following topics:
    Learn crud database include crud operation in vb.net windows application and how to connect vb to database.
    As you know, crud operations in vb net include insert update delete in vb.net using sql server.
    Learn how to insert delete update codings in vb.net, to play the demo you can design a simple modern ui support insert update delete in windows form vb.net example or vb net update sql table from datagridview.
    You can also search for this video through the keyword below:
    insert update and delete data from sql database using vb.net
    update data from datagridview to database vb.net
    insert update and delete data with datagridview in windows form using vb.net
    update and insert data in database from datagridview vb.net
    insert update delete with datagridview control in vb.net windows application
    how to edit update delete in datagridview in vb.net windows application
    insert delete and update data in database from datagridview in vb net

ความคิดเห็น • 73

  • @user-rq9tv2hv8r
    @user-rq9tv2hv8r หลายเดือนก่อน

    Thank you very much for this tutorial because it provides useful knowledge

  • @pppp2998
    @pppp2998 4 ปีที่แล้ว

    Thank you very much for your kindness.....I need some more information

  • @nicador100
    @nicador100 3 ปีที่แล้ว

    Thanks very much !!!!!!!!!!!!!!

  • @joves100
    @joves100 4 ปีที่แล้ว

    i really appreciated of your tutorial thanks a lot..

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว

      Thank you !

  • @Jorge34909
    @Jorge34909 4 ปีที่แล้ว +3

    Why all these tutorials have just one table? What about relationships? A nice menu to change tables?
    Also.. is it possible to view all tables one at a time with a DataGridView on just 1 form?
    Apreciate the content!

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว +2

      OK. Thank you for your suggestion. I'll upload soon !

    • @Jorge34909
      @Jorge34909 4 ปีที่แล้ว

      @@foxlearn Thanks :) Appreciate you!

    • @Jorge34909
      @Jorge34909 4 ปีที่แล้ว

      @@foxlearn Also when inserting, updating and removing you could use try catch and show the exception trown on a MsgBox

    • @rushmoore.valorant
      @rushmoore.valorant 2 ปีที่แล้ว

      @@foxlearn Where's the tutorial when dealing with 2 or more tables having relationship?

  • @danj7348
    @danj7348 4 ปีที่แล้ว +2

    The message for delete is a little ambiguous:
    "Delete this record" -> only this one
    "Delete these records" -> several
    Especially with delete, its good to be clear unless you want too keep your users on edge ... ;)

  • @Nedwin
    @Nedwin 3 ปีที่แล้ว +1

    Love this!

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      Thank you !

  • @edukasiprogram751
    @edukasiprogram751 3 ปีที่แล้ว

    good

  • @joobboxx
    @joobboxx 2 ปีที่แล้ว +1

    Hi, how does it works in Visual Studio 2022?

  • @MrVishnu123456789
    @MrVishnu123456789 4 ปีที่แล้ว +1

    Hello I have one question,
    For delete option you choose "dim name as string......"
    Incase there is have two similar name but position all things are different
    But if you delete one name it will delete all similar name.
    How to avoid this issue

  • @eloytv8639
    @eloytv8639 10 หลายเดือนก่อน

    Hello I have question for update option, if possible to update the primary key because I having typographical error in the primary key.

  • @abouilyas9656
    @abouilyas9656 5 ปีที่แล้ว

    thanks bro
    good job

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      Thank you so much !

  • @samsudeens7372
    @samsudeens7372 4 ปีที่แล้ว +1

    Video for database relationship.

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว +1

      OK. Thank you !

  • @rushmoore.valorant
    @rushmoore.valorant 2 ปีที่แล้ว

    how to populate the data into datagridview if the table has foreign-key on it?

  • @trevorparnham
    @trevorparnham 4 ปีที่แล้ว +1

    I've hit a problem. db.new_table.load() throws an error 'load isn't a member of 'system.data.entity.dbset(of Parcelmanagement.new_table)' new_table is the name of my table and parcelmanagement2 is the name of my application. Can you help? This is my first attempt using entity framework

    • @trevorparnham
      @trevorparnham 4 ปีที่แล้ว +1

      I discovered the problem and solution. Thanks for a great tutorial. Now, can you tell me how to filter the data with a where statement

    • @gothicdash
      @gothicdash 4 ปีที่แล้ว +1

      You had to install the entity Framework? Tell us the solution pls

    • @Mikami_The_Bard
      @Mikami_The_Bard 3 ปีที่แล้ว

      @@trevorparnham Please tell us what to do...

  • @NOT_AVAILABLE2006
    @NOT_AVAILABLE2006 3 ปีที่แล้ว

    How the data is getting manipulated in the textboxes when we click on any row element? Is there any click method/event?

    • @extechwizard
      @extechwizard ปีที่แล้ว

      i think it's because of the binding source that can be done through the text boxes' properties at 9:57

  • @sasuke46491
    @sasuke46491 3 ปีที่แล้ว

    why do i have an error in the button save? they said savechanges() is not part of the binding source?

  • @harshithaharshi3337
    @harshithaharshi3337 4 ปีที่แล้ว +1

    What do you mean by Northwind entities

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว

      Northwind entities is model, you can create an entity framework model, then select northwind database, enter your model name is Northwind

  • @Chess_Improvement
    @Chess_Improvement 4 ปีที่แล้ว

    thank you , i need to know how to use 2 DataGridview and filter the second one using the selected item from the first one
    example:"select a customer from the 1st datagrid and filter the second to see only his orders"

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว +1

      You mean filter orders by customer ?

    • @Chess_Improvement
      @Chess_Improvement 4 ปีที่แล้ว

      @@foxlearn yes

  • @abdomostafa4512
    @abdomostafa4512 4 ปีที่แล้ว

    how to add access data base ??? what you took about is only sql server

  • @hamadjan7128
    @hamadjan7128 4 ปีที่แล้ว

    very great work can you please tell me which tool you use for background voice ?????

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว +1

      youtube library

    • @hamadjan7128
      @hamadjan7128 4 ปีที่แล้ว

      ​@@foxlearn​ sir i am telling about the start up voice of a girl is this is a tool or its your voice ???

  • @Naj0112
    @Naj0112 3 ปีที่แล้ว

    Is it also deleted inside of database?

  • @everythingcando132
    @everythingcando132 4 ปีที่แล้ว

    How to run it like a software? I mean , I want to click an icon and the page will open without any coding window.

    • @manojo123
      @manojo123 3 ปีที่แล้ว

      Build and get the .exe from source

  • @marceloreichert6446
    @marceloreichert6446 3 ปีที่แล้ว

    Is there a way to save images?

  • @myfirstladycateringservice6529
    @myfirstladycateringservice6529 10 หลายเดือนก่อน

    Am confused where is the db from

  • @samsudeens7372
    @samsudeens7372 4 ปีที่แล้ว

    How to insert update delete data from multiple table in datagridview. Showing multiple table values in datagridview

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว +1

      OK. Thank you for your suggestion !

  • @CristianQuiroga
    @CristianQuiroga 4 ปีที่แล้ว

    Seguí los pasos y funciona, pero si necesito agregar una Data Grid mas, dependiente del primero (Maestro-->Detalle) como quedaría el código?

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว +1

      is it the same as order and orderdetail ?

    • @CristianQuiroga
      @CristianQuiroga 4 ปีที่แล้ว

      @@foxlearn yes the same!!!!

  • @ra37clashofclashier56
    @ra37clashofclashier56 3 ปีที่แล้ว

    HI, if Textbox1 * Textbox2=Textbox3 then textbox3 answer frist digit on label1,answer second digit on label2, on vb. net plz help me???
    i m waiting your ans.
    plz send this method coding

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      You should create property, for example a=b*c, then binding data to textbox

    • @ra37clashofclashier56
      @ra37clashofclashier56 3 ปีที่แล้ว

      @@foxlearn binding data spilt on maximum labels

  • @Foodlove1680
    @Foodlove1680 5 ปีที่แล้ว

    Can you make it with Java?

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว +1

      Thank you for your suggestion !

  • @joshuapsalmochavillo708
    @joshuapsalmochavillo708 3 ปีที่แล้ว

    What is this northwindentities?

  • @bengislason8843
    @bengislason8843 4 ปีที่แล้ว

    Is it just me or does this video have nothing to do with SQL or database? All I see if setting up a bunch of form entries...

    • @bengislason8843
      @bengislason8843 4 ปีที่แล้ว

      Nevermind, I missed second half of video somehow

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว

      Thank you !

  • @francescostrano8314
    @francescostrano8314 ปีที่แล้ว

    Salve, uso da tempo vb6, da circa 2 anni sono passato a visual studio 2019 e non con molti problemi , ora tutti fila liscio.
    In questi giorni cercavo in rete qualche esempio chiaro ,di come trattare un data base sql, per l’appunto mai fatto per svariati motivi…ora vorrei fare un programma personale co data base sql per archiviare tutti i componeti elettronici che ho a casa e ricercarli anche da remoto..
    Quindi creare un data base sql che sia residente su un server ..locale o remoto non importa.
    Sinceramente no so da dove iniziare ,potreste darmi un aiutino anche formando solo una tabella anagrafica, e per capire come proseguire
    Grazie infinitamente
    Francesco Strano anni 67

    • @FedericoZagnoni
      @FedericoZagnoni ปีที่แล้ว

      Secondo te ti risponde ? In italiano poi ? ... Mah

  • @yaekai1437
    @yaekai1437 5 ปีที่แล้ว

    Hey, can i have the .sln please ?

  • @builditontutorial
    @builditontutorial 4 ปีที่แล้ว +1

    9:03

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว

      Thank you !

  • @justinmontevirgen1157
    @justinmontevirgen1157 3 ปีที่แล้ว

    How to add image?

  • @user-cf6dv1ed2z
    @user-cf6dv1ed2z 6 หลายเดือนก่อน

    hello,thank you ,how i can contact you