C# Tutorial 13:Show database values in Table or DataGridView

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 พ.ย. 2024

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

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

    wow mate, this video is the problem solver, ive been searching out the whole lot of forums about datagridview but i have a problem of repeating the rows, i tried and i lost my mind, and after some time i find this video of yours, truly great work and again you are a life saver bro
    very much appreciated
    thanx again

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

    your work enlightened me!thanks a lot!

  • @ChaosRevealsOrder
    @ChaosRevealsOrder 6 ปีที่แล้ว

    Cool, thx I have been trying to learn this thing for a while now. I Thought I have to add all columns manually, but this method of yours so much easier.

  • @pinhastoav6647
    @pinhastoav6647 7 ปีที่แล้ว

    There are some changes for different versions of Visual Studio but it was very helpful for me.
    Thank you!

  •  11 ปีที่แล้ว

    It is so clear and easy to follow. Thanks for sharing!

  • @awfominaya
    @awfominaya 10 ปีที่แล้ว

    Perfect! That solved my issue completely and almost instantly.

  • @hurstonhurst2242
    @hurstonhurst2242 7 ปีที่แล้ว

    Thank you for this. You sharing your knowledge is fantastic and I learn a lot from your videos. don't listen to the people who fail to focus on the material... and want to be crybabies... Yeah that was at you Jay53089.

  • @didupati
    @didupati 11 ปีที่แล้ว

    nice one:-) I started liking your videos:-) good job...Thanks for your time....pls continue doing..Thank you!

  • @kevinkastrowiak
    @kevinkastrowiak 11 ปีที่แล้ว

    VIDEO IS GREAT ! ! thank ya for doing such an interesting things..... Could ya do a video for sessions....... thanks .....

  • @ratulvlogs99
    @ratulvlogs99 7 ปีที่แล้ว

    Thanks for the helpful tutorial

  • @thisisgoodify
    @thisisgoodify 11 ปีที่แล้ว

    You should start a blog so that others can get the code and read what u explain in your videos

  • @youtuber-xo6fl
    @youtuber-xo6fl 6 ปีที่แล้ว

    Thanks. I got it to work on sql sever.

  • @rztutul8824
    @rztutul8824 7 ปีที่แล้ว

    just awesome...Thank you

  • @demispap8552
    @demispap8552 8 ปีที่แล้ว

    Nice work!

  • @hasancakr4127
    @hasancakr4127 6 ปีที่แล้ว

    Thank you sir, I love so much...

  • @khateejahlatif9294
    @khateejahlatif9294 8 ปีที่แล้ว

    very helpfull it is...

  • @goalexboxer
    @goalexboxer 11 ปีที่แล้ว

    Thank you, it is so easy

  • @AproxianBG
    @AproxianBG 6 ปีที่แล้ว

    great work man❤️

  • @glennteo4871
    @glennteo4871 9 ปีที่แล้ว

    Great! Thank you

  • @conventionalischeating
    @conventionalischeating 7 ปีที่แล้ว

    Which directives and references do we need to add?

  • @markomolnar9032
    @markomolnar9032 8 ปีที่แล้ว

    good job

  • @uzeirdalip9499
    @uzeirdalip9499 7 ปีที่แล้ว

    thank you, that worked for me :)

  • @luigi0654
    @luigi0654 11 ปีที่แล้ว

    hey great vid and very easy to follow. I only have a question, when i try to do this to display data from my db in my datagridview and the querry has a 'WHERE' statement it sends an error... do you know what i can do to fix it?

  • @xmsnmx
    @xmsnmx 11 ปีที่แล้ว

    sir, thank you . help me alot

  • @TheSk8diego
    @TheSk8diego 11 ปีที่แล้ว

    Ty

  • @raymondmikalsen7185
    @raymondmikalsen7185 11 ปีที่แล้ว

    Is there a tutorial showing how to use one to many mysql setup, lets say one person with several pictures , and the picture paths stored in db.

  • @AnelEzio
    @AnelEzio 11 ปีที่แล้ว

    Oh my god, Thank you very much,bro.

  • @hasancakr4127
    @hasancakr4127 6 ปีที่แล้ว

    There are DataGridView and tetxBox tools on the C# Form screen. When the value which is entered from SQL to tetxBox has changed, data is displayed on DataGridView screen.
    Barcode Unit Quantity
    0001 Piece 1
    How can we increase the value of quantity adding +1 or more on the exactly same row when we read/input the barcode to the Textbox? (NOTE: It will be without SQL)

  • @muiepsd279
    @muiepsd279 8 ปีที่แล้ว

    thanks

  • @cliffcabz429
    @cliffcabz429 9 ปีที่แล้ว +1

    thank you sir so much!

  • @mrwolf2758
    @mrwolf2758 6 ปีที่แล้ว

    Thanks for the helpful tutorial but can i display 3 tables in the same datagridview like for an exemple the informations of an employee and the company name he works for as well as for his department ?

  • @mateusandreatta3233
    @mateusandreatta3233 6 ปีที่แล้ว

    you rock! valeu brother! jamal ama vc

  • @nonamezz20
    @nonamezz20 9 ปีที่แล้ว

    Could you create a tutorial how to store data from MySql Database to an arraylist?

  • @katakunakaido5853
    @katakunakaido5853 7 ปีที่แล้ว

    Is it possible to do this when working on a MVC style? I got all my database methods and connectionstring in a class i call DataAccessLayer or DBConnect

  • @ardaputra9378
    @ardaputra9378 9 ปีที่แล้ว

    very good tutorial (y)
    but i want to ask..
    how to add RadioButton in dataGridView?
    thank you

  • @AleksandarDjurdjevic47
    @AleksandarDjurdjevic47 11 ปีที่แล้ว

    How to use this to show database from SQLite?
    SQLiteDataAdapter sda = new SQLiteDataAdapter();
    sda.SelectCommand = sqlite_cmd;
    DataTable dbdataset = new DataTable();
    sda.Fill(dbdataset);
    BindingSource bSource = new BindingSource();
    bSource.DataSource = dbdataset;
    dataGridView1.DataSource = bSource;
    sda.Update(dbdataset);
    Fill:SelectCommand.Connection property has not been initialized

  • @tejashwinimurthy8781
    @tejashwinimurthy8781 6 ปีที่แล้ว

    I have a doubt for each button shd we write the code for connection to backend??

  • @silentwra1th110
    @silentwra1th110 9 ปีที่แล้ว

    can make videos about how to delete data record in DataGridView

  • @govalle3
    @govalle3 7 ปีที่แล้ว

    how do you do for the table has the slide button. When i press the button the table gets more bigger

  • @JinzouArt
    @JinzouArt 8 ปีที่แล้ว

    you rock!

  • @CrAzY799999
    @CrAzY799999 8 ปีที่แล้ว

    what is the declared value for your MySQLDataAdapter sda?

  • @udaykrishn
    @udaykrishn 8 ปีที่แล้ว

    How to fetch the data using two text boxes? Please help me
    i want search the data using textbox1 and textbox2.

  • @tejashasabnis9839
    @tejashasabnis9839 7 ปีที่แล้ว +1

    sir , actually I want to display my oracle database table after clicking on say a button "show_table"! but i am unable to do that so can u please help me by sharing a link or direct code?

  • @yeldoskadyrkul3583
    @yeldoskadyrkul3583 8 ปีที่แล้ว

    how to realize that method with a stored procedure, data table and data reader?

  • @AleksandarDjurdjevic47
    @AleksandarDjurdjevic47 11 ปีที่แล้ว

    Fill:SelectCommand.Connection property has not been initialized. ???

  • @DrCornTato
    @DrCornTato 11 ปีที่แล้ว +1

    I am trying to get the first value of the clumn Eid, which is a changeable value, but I can't get it. I tried using the "SELECT * FROM users.infos LIMIT 0,1 ;", but it doesn't work. It always says "Connection must be valid and open". But when I don't write anything about it, it works, which means it isn't the connection. How can I get the value and set a "int id = valueFromTheDatabase"?

  • @RichardTonata
    @RichardTonata 11 ปีที่แล้ว

    How do i display data on a data grid from Multiple Tables.. I have Customer Table and People Table..

  • @mazkaibil9108
    @mazkaibil9108 8 ปีที่แล้ว

    Hello i am having problem with datagrid view not allowing sql to insert date defaulted in sql table and SUSER_SNAME. Can you please add a tutorial to explain how to?

  • @khateejahlatif9294
    @khateejahlatif9294 8 ปีที่แล้ว

    sir, please tell me how i can show different names in dataGridVies for the same selected Column
    plz reply
    thank you..

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

    Hey I don't know if anybody could help me... the part of the DataTable dbdataset = new DataTable... "DataTable" shows up giving an error saying the type or namespace could not be found.

  • @Jay53089
    @Jay53089 10 ปีที่แล้ว +20

    Please don't move your cursor around so much during your demo.. it's quite annoying

    • @MartinEden-ps6ld
      @MartinEden-ps6ld 7 ปีที่แล้ว

      да нет. Я вот русский и мне так видосик понятней

    • @Dimon12321
      @Dimon12321 6 ปีที่แล้ว +1

      Someone likes it, someone not. I can tolerate any video that helps me with my course work, but this one doesn't annoy me at all. Саша Безгин says the video is more understandable this way.

  • @auraarzadun9127
    @auraarzadun9127 8 ปีที่แล้ว

    Can you post the whole source code of the tutorial regarding load data into datagridview this tutorial of yours.

  • @DrCornTato
    @DrCornTato 11 ปีที่แล้ว

    What if I only want the first value in the column Eid, but I don't know the current Value of that one?

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

    u forgot to mention link for the code u showed in video

  • @bohdankalytovskyy
    @bohdankalytovskyy 9 ปีที่แล้ว

    I need to read sql script with multiple select statements that will dysplay multiple tables, how can I display multiple tables in datagridview ?

    •  9 ปีที่แล้ว

      bohdan kalytovskyy Try to use different query using JOIN or something else :)

  • @sambath7057
    @sambath7057 11 ปีที่แล้ว

    How about 2 combobox ?

  • @usamaahmed6262
    @usamaahmed6262 6 ปีที่แล้ว

    hi i am working on my assignment in C# i am a student of software engineering please help me
    i just want to know that (i have two data grid views in a form in first grid view am fetching data from database and i select some data from it and show that data in second grid view and its working but now am stuck in how to save that 2nd grid views data in SQL database) please help me??any one
    can share a link of video which will be helpful.

  • @milanvasic1116
    @milanvasic1116 8 ปีที่แล้ว

    How i can do this with Oracle database?

  • @zakiraimanazakaria
    @zakiraimanazakaria 9 ปีที่แล้ว +2

    Hi, i'm using sqlite and create the DataGrid in WPF. However I didn't found the "BindingSource" and also "DataSource". Could you help me whether there is another way to use. Thank You.

  • @ziv156
    @ziv156 11 ปีที่แล้ว

    download please?

  • @mariam12300
    @mariam12300 6 ปีที่แล้ว

    Could you pls post your code?

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

    exceptional handling error in my code plzzz tell me

  • @10000years
    @10000years 10 ปีที่แล้ว

    when i type DataTable it come out as error

  • @elainearevalo-alejar9360
    @elainearevalo-alejar9360 9 ปีที่แล้ว +2

    unable to connect any of the specified mysql host :( ?

    • @DanielRodrigues-rb8qy
      @DanielRodrigues-rb8qy 9 ปีที่แล้ว

      i have the same problem.

    •  9 ปีที่แล้ว

      Elaine Arevalo Well, I had no problems :) BUt.. Probably needs to create own class or lib for easier access of database and data. I think I'll be trying to make one for my self. If anyone will need - contact me :)

  • @AbdulMajid-eu9gl
    @AbdulMajid-eu9gl 8 ปีที่แล้ว

    HOW TO SHOW data in GRID VIEW AUTOMATICALLY IN START OF SOFTWARE would pleases upport me

  • @muhammadhambalie8104
    @muhammadhambalie8104 9 ปีที่แล้ว +1

    Table load when click button ?
    but can we make if table auto load when form open ?

    • @khaledsale7
      @khaledsale7 9 ปีที่แล้ว +1

      +M Hambalie invoke it in the constructor

    • @kimlapitan3794
      @kimlapitan3794 9 ปีที่แล้ว

      +khaled saleh could you show me the code that automatically load the values??

    • @khaledsale7
      @khaledsale7 9 ปีที่แล้ว +1

      +kim lapitan its the same as the method fillTable which contain the query select * from tableName
      and just invoke it in the constructor

  • @omerkhan8972
    @omerkhan8972 6 ปีที่แล้ว

    Thanks My Nigga

  • @leluong8743
    @leluong8743 6 ปีที่แล้ว +1

    lol dude, you don't explain anything. You was just saying what code you wrote so it is kinda useless

  • @wasabikimchi7891
    @wasabikimchi7891 11 ปีที่แล้ว

    Fucking hell, thank you!

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

    I don't know if the video is good because I get nauseous watching you move the mouse around. STOP!

  • @haijunluo4464
    @haijunluo4464 9 ปีที่แล้ว

    thank you sir so much!