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

How to Connect and Use Local Database in Visual Studio 2019 step by step create sql local database

Through this tutorial you will learn:

create local database in visual studio 2019, then connect and use local sql database in visual studio 2019 include operations
insert update delete in c#.net
insert update delete and view data from database in c#.net
datagridview to database update
datagridview to database insert
insert data into database using c#

how to create sql server database in visual studio 2019
how to connect sql server with visual studio 2019

[chrysanthemum]

Good Lord thank you. This answered like a third of the questions I had about the use of database in VS2019.

[mypettaco]

Hello. First, thanks for the video it saved me a lot of work/research.

I'm having a separate issue that I think you might be able to help me with. I have two solutions, one similar to this that edits a database (for testing purposes), and another which is reading the database and doing stuff with the data.

What I want to do is deploy these two projects together, so if anyone clones the repo they have full functionality. For my other project, I have manually configured the connection string to read the database from the executing folder and that solution copies the database to the executing folder. So I maintain a "virgin" copy of the db in the original location, and then edit the one in the runtime folder.

I've included the same db in the db editing program. However, when I compile it, it connects to the "virgin" db as I can see that is where the connection string is pointing. I've played around with the connection string and keep getting an error "An attempt to attach an auto-named database for file ... failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."

I'm hoping you can tell me how to get it to point to the db in the runtime directory, rather than the original one.

Thanks!

[Predo]

Great video, thank you. I do have a problem though and would be very grateful for any help. When I run the data configuration wizard, after I have selected the table and click finish I keep getting an error. Could not find file dbo.Purchase, Purchase being the table name.

[xyrusdos]

THANK U SO MUCH YOU SAVED ME FOR GETTING A 75 GRADE!!

[LeeKobe]

Excellent tutorial! Many of us who followed these steps, and then ran the form, could not save the data inspite of clicking on the Save icon. Thoughts? I do have one other question...I have included a line in the table with 'image' selected as type of input. I'd like to upload an image on that line and into the form/app. Can you point me in the right direction? Thank you! (Bonus question: during the video, just after dragging the dataset to the form, it shows a quick move (step) in making the ID field disappear. It was so quick that even after rewinding several times, I couldn't catch the step. Can anyone shed some light on that?) Thanks.

[mohamadrezaghadami]

the most helpful one ! thank you so much

[karlatwork]

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

[matthewalexander]

God bless this tutor so much abegggg. This was sooo sooo helpful

[borisndong]

He made it so simple and easy to understand ...

[hansen_docked_in]

Hi! Great video. However I have one question: I followed your steps but my first input is not shown. Second row is fine and so on (so ID 2 is in row2/first row beneath header row). Any idea why? And how can I save the data to the table after closing the (compiled) program and also load data when opening it?

[diegobuenano]

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

[kentabillon]

This error shows when I try to save an item


Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

[swerytv]

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.

[haydar]

Hi fox learn Thanks for all videos, i need help : how to create master details application and insert data into master table and datails table in c#

[cuadraramonvincent]

do you have this for 2012 version of visual studio

[ybmprod]

It's fast
But one of best Tut so far
Thank U❤️

[AKMROBLEH]

Excellent tutorial! Many of us who followed these steps, and then ran the form, could not save the data inspite of clicking on the Save icon. Thoughts? I do have one other question...I have included a line in the table with 'image' selected as type of input. I'd like to upload an image on that line and into the form/app. Can you point me in the right direction? Thank you! (Bonus

[spiritretro]

i have an issue: i created a setup project to "install"the program (changed to release mdoe), and when i launch the installed program it says it either cannot connect to the db or a db with the same name already exists, whats going on?

[ehsanabbasi]

hello !
I've created a database project like this.
It works well on my computer but when I move debuged folder on another computer it doesn't work well.
What Prerequisites needed to be install on that computer to run sql base projects.
Thank you

[utsavgohel]

thanku brother
in this video i have cleared my database doutss