C# Tutorial – How to Connect and Use Local Database in Visual Studio 2019 | FoxLearn

C# Tutorial – How to Connect and Use Local Database in Visual Studio 2019 | FoxLearn

Welcome to FoxLearn In this tutorial, I’ll show you how to connect and use local database in visual studio 2019 To play the demo, you should create a new windows forms application, then add the service based database to your project Next, You need to connect to the local database from the visual studio, then add a simple customer table to the local database You need to add new data sources to your project, then enter the connection string name and select the table you want to add to your DataSet After you have defined a data type as a data source in a project you can create forms that display model data by dragging items from the Data Sources window into your winform These items become controls on the form that are bound to the data source As you can see, the Binding Source component will automatically add to your form when dragging items from the data source window into your form The BindingSource component serves two purposes First, it provides a layer of indirection when binding the controls on a form to data This is accomplished by binding the BindingSource component to your data source, and then binding the controls on your form to the BindingSource component All further interaction with the data, including navigating, sorting, filtering, and updating, is accomplished with calls to the BindingSource component Second, the BindingSource component can act as a strongly typed data source You can easily modify your layout after dragging items from the data source window into your winform You can add CheckedChanged event handlers to the GenderCheckBox control allows you to change text to male or female based on gender value To fix the error, you need to open the DataSet Next, set the automatic increase value for the ID field You can find your local database in the debug folder remember that each time you rebuild your project, all data in the debug folder will be deleted Thank you for watching this video and don’t forget to subscribe to my channel

Daniel Ostrander

Related Posts

13 thoughts on “C# Tutorial – How to Connect and Use Local Database in Visual Studio 2019 | FoxLearn

  1. Karl AtWork says:

    Another excellent video. Thanks and keep up the quality work.

  2. SAND STUDIO says:

    how to do auto increment start 1 entity framework? edmx diagram

  3. Diego Buenaño says:

    Great video 😁
    I have a little question.
    Years ago you made a video to send whatsapp messages from c#, could you update it? Or there is not posible to send messages like that anymore

  4. bojidar kamenski says:

    Nice video thank you!!!
    Can I ask if someone of you know how to solve this problem I am using ssms 2017 express server on my application it is working properly on my pc but when I am using another pc (aka client machine) it doesn't working – error 26. It is not important I am student who is creating something like school project. I researched in stack or github but no result. Thank you again for this video!

  5. hoc lap trinh C# says:

    Please guide xamarin form c # topic, thanks

  6. alireza abedi says:


  7. Passing CS says:

    How you publish that app with database?

  8. Mamadou Mouctar DIALLO says:

    Hi fox learn in fact I need a tutorial on how to create a login and authorization system with different selectable roles via Treelist based on my Devexpress ribbon menu. Thank you.

  9. Deekshaa singh says:

    Hello, can you tell me How to add reference of microsoft.offic in 2019

  10. deiost says:

    Very good video, but ModelDataSet contents shown on 3:50 not moving for me so easy with mouse

  11. Zamrin Jameel says:

    can we prevent data lose on rebuilding the project while using this db method?

  12. Subham Ghosh says:

    I have one question
    I have to create an database application for offline data entry for my client, So can I use this method?
    So do I need to install sql in my cluent pc or just provide him project setup?

  13. challengerrr 47 says:

    hello thanks for the video. in some vdeos there are both (local database option and service based option) in their visual studio …but in my visual studio 2013 there is only service based database just like in this video..is there any difference and why i cant see localdb option ?

Leave a Reply

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