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
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.
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"?
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)
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.
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
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.
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?
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 ?
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?
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 :)
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.
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?
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.
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.
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
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
your work enlightened me!thanks a lot!
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.
nice one:-) I started liking your videos:-) good job...Thanks for your time....pls continue doing..Thank you!
It is so clear and easy to follow. Thanks for sharing!
There are some changes for different versions of Visual Studio but it was very helpful for me.
Thank you!
Perfect! That solved my issue completely and almost instantly.
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"?
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)
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.
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
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.
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?
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 ?
VIDEO IS GREAT ! ! thank ya for doing such an interesting things..... Could ya do a video for sessions....... thanks .....
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?
How to fetch the data using two text boxes? Please help me
i want search the data using textbox1 and textbox2.
I have a doubt for each button shd we write the code for connection to backend??
I need to read sql script with multiple select statements that will dysplay multiple tables, how can I display multiple tables in datagridview ?
bohdan kalytovskyy Try to use different query using JOIN or something else :)
unable to connect any of the specified mysql host :( ?
i have the same problem.
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 :)
how do you do for the table has the slide button. When i press the button the table gets more bigger
Which directives and references do we need to add?
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.
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.
great work man❤️
what is the declared value for your MySQLDataAdapter sda?
Thanks for the helpful tutorial
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?
Thanks. I got it to work on sql sever.
Thank you sir, I love so much...
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.
very good tutorial (y)
but i want to ask..
how to add RadioButton in dataGridView?
thank you
sir, please tell me how i can show different names in dataGridVies for the same selected Column
plz reply
thank you..
You should start a blog so that others can get the code and read what u explain in your videos
just awesome...Thank you
Please don't move your cursor around so much during your demo.. it's quite annoying
да нет. Я вот русский и мне так видосик понятней
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.
Nice work!
Thank you, it is so easy
how to realize that method with a stored procedure, data table and data reader?
Table load when click button ?
but can we make if table auto load when form open ?
+M Hambalie invoke it in the constructor
+khaled saleh could you show me the code that automatically load the values??
+kim lapitan its the same as the method fillTable which contain the query select * from tableName
and just invoke it in the constructor
Could you create a tutorial how to store data from MySql Database to an arraylist?
can make videos about how to delete data record in DataGridView
thank you, that worked for me :)
What if I only want the first value in the column Eid, but I don't know the current Value of that one?
thank you sir so much!
How do i display data on a data grid from Multiple Tables.. I have Customer Table and People Table..
you rock! valeu brother! jamal ama vc
very helpfull it is...
sir, thank you . help me alot
Can you post the whole source code of the tutorial regarding load data into datagridview this tutorial of yours.
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
Great! Thank you
Fill:SelectCommand.Connection property has not been initialized. ???
good job
HOW TO SHOW data in GRID VIEW AUTOMATICALLY IN START OF SOFTWARE would pleases upport me
Put Code Load() Function inside bro/...
exceptional handling error in my code plzzz tell me
Oh my god, Thank you very much,bro.
How i can do this with Oracle database?
thanks
u forgot to mention link for the code u showed in video
Ty
How about 2 combobox ?
Could you pls post your code?
download please?
when i type DataTable it come out as error
you rock!
lol dude, you don't explain anything. You was just saying what code you wrote so it is kinda useless
Thanks My Nigga
I don't know if the video is good because I get nauseous watching you move the mouse around. STOP!
Fucking hell, thank you!
thank you sir so much!