HOW TO DISPLAY MS ACCESS DATABASE IN DATAGRIDVIEW OF VB.NET.avi 

Thank you po sir. Vey helpful po ng vid mo.

Idky do we have to learn from vb express 2008 NOW. This was really very helpful!! Thank you so much!

great little tutorial that uses mostly code instead of drag and drop methods to create a database datagrid in a clear and well explained way. top marks.

Thank you so much. Old video still helped very much.

thank for ur tutorial...it help me as beginner becoz ur explain in detail for each code and speak out loud what u write :) but it really help me...

This video was helpful for my payroll system.. thankzzzzzz.

@varkkha Happy holidays, Thanks for appreciating the video :)

I wrote my code just like this, but didn't think that it will need DataTable variable. Thank you for this video! :)

Just want to say thank you very much for the help! Saved me a lot of headaches!

Awesome video... i was looking for a simple way to retrieve data from a backup copy of a database with out giving the location.. this works perfectly and i was able to hide the launch trigger by using an extra label.. thanks a bunch..

its really helpful. Thanks.

Sir, your videos are very informative and easy to understand, please do more videos on VB6 / vb.net

On the issue of software vendors creating the perfect programming language, do you get the feeling that MS VB is taking us down the procedural declaration al route of structured programming needlessly as all this code does is display a table in a form and yet VB expects you to do a tour of its whole factory of assembly of an object when this could be done swiftly with new and better power command sets.

Thanks from Spain, this video was really helpfull.

thx, this is what I need for the assignment.

Works for me, thanks. But how to resize it to fit a bigger grid view?

my "da.Fill(dt)" line is having a problem, and I followed this tutorial precisely (with the exceptions of the 'Select' and my database 'directory'). I'm using VB 2010 Express. I've searched alot in this past few hours and got simililar codes with the same issue. Any suggestion?

@akosiDAN123 right now i started new project of my own, using access database vb.net 2010...and i would like to use code rather depending using tool(becoz it help me to understand where i can manipulate the code). so i hope u will do some more video on related topic.

This was really good. can please show me how can i create a button that when click it will change the database in the datagridview.. because i was planning to have one datagridview that can handle different msaccess.. so i dicided to create buttons that will change datagridview database.. thank you sir.. hope you can help me :D

hi. how to display data one row at a time until the all data is displayed on the datagridview. e.g when I search information it display on the first row and search the second one it must show on the second line and so on and so on until everything is displayed.

thanks u so much... simple tutorial was i found

Thank you po talaga kuya gumana :) HAHAHA ito na lg kulang sa system ko ei :)

what if i only wan to read the selected information from data base? example: i got a textbox to key in id, if i type 15 in the text box datagridview1 will show all the information from id 15 only

Can you please help to Write a program that displays the Colleges Alphabetically ordered (along with their year founded ) >>>

I want to display table using microsoft access 2010. I already type the code and use Microsoft.ACE.OLEDB.12.0 as the provider. But it still won't display. What should i do?

If I choose the data binding source, but after delete, update and add record, how can i reload/refresh the data on table

How to fix da.Fill(dt) The Microsoft Access database engine cannot find the input table or query 'phonebooktable'. Make sure it exists and that its name is spelled correctly. did not work help me pleassseeee! Reply me plss i need your response right now

@akosiDAN123, when I did this, it said "Two output field names resolved to the same output path. Please can you help me correct the error

Thank you. Its helping me :)

@FrightBeatZ uhmm sorry what do you mean by the "real" database?.

hi you have possibility to add add/edit/delete button? i'm is very interested. best regards

hi I want to add picture in my program which is quick search. I am trying to add pic assigning OLE. But i want the image to be visible in ms table (datasheet view). could you pls help me with this?

Sir. Pwebe ba Mamili ng kung anong access database gusto mong e load? like for example may phonebook 2018 and phonebook2019 ako pipili po ako sa dalawa using combobox kung ano pong phonebook ang e vview ko sa datagridview

salamat kuya ^_^ mas naintindhan ko to kesa sa prof ko ^_^

I got "you cannot add or change a record because a related record is required in table" this error. Can you solve this one.

Galing naman Kuya Dan!! magagamit ko toh sa hands-on-exam namin mameya ^__^ tnx talaga!!

Error 1 Overload resolution failed because no accessible 'New' can be called without a narrowing conversion: 'Public Sub New(selectCommandText As String, selectConnection As System.Data.OleDb.OleDbConnection)': Argument matching parameter 'selectConnection' narrows from 'Object' to 'System.Data.OleDb.OleDbConnection'. 'Public Sub New(selectCommandText As String, selectConnectionString As String)': Argument matching parameter 'selectConnectionString' narrows from 'Object' to 'String'. c:\users\albert\documents\visual studio 2013\Projects\TeamBWeek3\TeamBWeek3\Form1.vb 19 14 TeamBWeek3 I get this error it does not work

Thanks

Buhay ka pa po ba ? Parehas lang po ba ang tables and datagridviewer bayan

It doesn't work for me. I did everything like you said here, but when i compile, nothing is happening. Datagridview appears empty. Please help me!

Can you help me If we want to insert or delete something like Mr... in the table of database.. how can we do?

Legend!! Thank you so much

How do I create a relative path? I have this: con.ConnectionString = "Provider = microsoft.jet.oledb.4.0; Data Source=J:/College/AS_DSFinalDatabase1.accdb" Also, how do I use an Access database that uses the .accdb extension instead of the .mdb extension. This is the error I'm getting: Unrecognized database format 'J:\College\AS_DSFinalDatabase1.accdb'.

thank you v much

very well explained bro! thanks.

Buena explicación

What is the provider for 2013? Please help

Nice tutorial, helped me a lot.. Thanks!

thanks dude really helps

@qwerty1111able Hello, Try adding a button to your form and double the button to open the button click event. Copy the code of this video in the form load event and paste it inside the click event. If you want to another database to display be sure to change the select query because it all depends on the select what records it will display. Hope it helps you :)

could you try to use ODBC ???

pano kung yung gusto mo lang na fields ang ididisplay mo?

Hi sir dan! I hope you can help me in this case ... I have a table named tblEmployee and the fields in the table is Employee_Num and Employee_Position.. I want to display in a datagridview control... but i want to display only the employee that has a position of manager... I know your search tutorial may help, but although if I already displayed the employee that has a position of manager, i still want to use the search form ... kindly help me in this case sir dan please! thanks!

kuya dan pwede ka po b mag post ng video tungkol po sa pag backup and restore ng ms access database using vb.net ty po

Salamat par. you saved my thesis hahaha

thank you so much for your tutorial , it helped me a lot :)))))))))))))

sir pa help again ito di ko talaga kaya na type ko na po lahat ng dapat e type nung ni run ko ok po yng datagrid lumabas ung column kaso walang laman pero sa access meron anu po problema nun?

@xBLukiyx Happy Holidays Hello, not sure but the code is quite working perfectly to others, Some reason it may not be working is your database. Your database must be in different location,table column have a reserved words etc. If you want message me your program including the database and I will try to fix it for you.

Sir dan paano po kapag naglagay ulet ako ng bagong information automatic na makikita na po ba yon?

Thank you so much! You've been a great help :)

Welcome, pero :) friendly advised tol baka magulat if ever pero mejo magkaiba yung pagcontrol sa asp.net ng gridview

What if pag ang gusto kong header is hindi same ng nasa database? I mean, isinama kasi sa program mo yung mga headers. Pero paano pag may naka fixed ng pangalan sa header ng data grid? Thanks

oh my god! thank you! this was so helpful

Thanks!

sir dan.. pede po ba pahingi ng TUT pag update or modify po ng records or data pagkatapos mo ma view

Sir how to display Ms Access data in datagrid using module by just calling it in form 1

Thanks kuya dan!

sir can me save 1 valeur in variable don't datagridView.datasource

ayaw po mag run sir dahil sa error na to: An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll Additional information: Could not find installable ISAM.😟😟😟

Hi fellow pinoy :D im a CS student at C.C.P ^_^ i just want to ask if i could edit the DB table being displayed at the datagrid view by simply typing on the cell and saving the changes through a button? If so, how? Please help me. PS this is for my thesis i'll include your channel in the "i couldn't have done this w/o you" part of my documentation :D

@fanam5 Gracias por apreciar el video

bridge between database and program ^_^

sir paano mo mailalagay ung info ng database sa textbox? how to insert the information in database to textbox? im having a thesis xD by the way THANK YOU VERY MUCH!

@DragDenDFO np :)

Ms Access 2007 have different provider try this one " Provider=Microsoft.ACE.OLEDB.12.0 "

salamat kuya working siya :)

kuya paano po mag transfer ng data from database access table to table via datagridview sa vb?

Salamat :)

thanks youuuuuuuuuuuuuu !!!

Thank you :)

sir how to display the ms access data base report in asp.net

It has Syntax error in from clause pointing to da.Fill(dt)

ty Dan Hahaha 30min ko kinakalkal ito lng pla dapat provider"Microsoft.ACE.OLEDB.12.0" pag ka MsAccess 2013

@jiodjflak Glad to know it helps you :)

gg sir

Great! :))

lodi kita

pa help nmn sa thesis namin,, enrollment system,, thnks

@akosiDAN123 Thank you for a quick answer! Ok, I'll check it. If it wouldn't work I'll message you :D. And yeah Happy holidays for you too!!!

How to search textbox value in datagrirdview in vb.net . Database: Ms Access

@manikandans2112 Glad to know I can help others even in a simple way :)

it doesn't work! Can you please provide the source code. :)

nice video pre :) salamat haha

pde makahingi ng software copy installer ng VB.net,,, thanks

may error po ung conn.open()

sorry but don't work for me !!!!!!

hi sir

your voice is totally hot!

@FrightBeatZ would you mine sending me your program so that I can check it and I might fix it also and kindly include your database also. Send it to electricfan23@yahoo.com just in case.

Thanks!!!