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

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

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

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.

Thanks but this actually doesn't store the data in the actual database. It only saves the data in the dataset temporarily. So, after closing the application, the data will be deleted and cannot be found in the database. A piece of code is missing in order to physically store the data into the database.

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

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

Last min revision...Thanks a lot mam

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

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

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.

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

*If someone can't find Data Sources:* In my case it was in View > Other windows > Data Sources

thanku brother in this video i have cleared my database doutss

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!

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?

the most helpful one ! thank you so much

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?

Does anyone knows how to change the gender using an edit button?

is it possible to migrate ms access database to the cloud and still be able to connect using c#?

Very good, worked. Thank you!

Thank you very much

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

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

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.

Awesome! Easy to follow =D

Excellent video. Thanks a ton.

This error shows when I try to save an item Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

Incredibly useful - thank you.

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 ?

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?

When I put FullName, Email, Phone, Gender, Adress for first user it doesn't appear, it starts appearing only from second user, someone know solution? Also Gender in Gridview is just showing check ON/ OFF its not right solution, as you can see in 9:07minutes.

thank you for this video !! it easy to understand and make me clearly to do it>>>>

Is there a way to save the database even when you close the program?

If i copy this program to another computer will i have saved database ?

Nothing displays in the grid view. How can i fix this?

Thanks a lot.

oh my gosh I needed this soo much

do you have this for 2012 version of visual studio

PLS HELP i do everything in this video but now i want to add search button to this code pls help me

This is fantastic

do i need internet to access this type of database?

How to add buttons one by one for save, delete, add, and same design like there?

according to i create a form and insert value data and show in same form gridview but when i check in folder data not show

Hai please update a video to select multiple database by using combobox method in C# along with with external data base exe setup. I will be very help full for beginners.

hey , i dont have the add new, cancel, save button on top after running the program, what should i do?

OMG. IT WAS THAT EASY!!! FML

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#

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

Thnku

Is this only for one pc? How can it connect to other PC's? Thank you

thanks

Even after all there years I still can't remember where I heard this ost you are using XD

can you please do money lending project in visual studio C#

This is fri good

Omg! Thanks

excellent

Nc video 😍😍😍😍 🇧🇩🇧🇩🇧🇩🇧🇩

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!

The most important part is missing: how can I create that mdf file?

i can't create new table ... why ?

Is the procedure the same in asp net?

data binding does work WTF

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

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

ok. now how do I host the database on a server :gun:

How to insert photos

is Local DB require Sql Server installation on client machine? Thanks:)

How you publish that app with database?

working bro! Thanks a lot, +sub +like

cant find my data sources

This kind of Tutorials began in 2005. it's very old trick. we need the connection code not wizard..

Please guide xamarin form c # topic, thanks

Music name?

like

im a zhee

Nowdays gender needs to be stored as a bigint

The "gender = bit" is a hot take in today's reality lol

This don't save any data, useless, a waste of time.

wayy to fast lmao

simple way for connection using MySql.Data.MySqlClient; using System.Data.SqlClient; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace mudi_13_10_databse_trainings { public partial class Form1 : Form { SqlConnection con = new SqlConnection(@"Data Source = LAPTOP-2A5CNVC3\SQLEXPRESS; Initial Catalog = Countries; Integrated Security = True"); SqlCommand cmd = new SqlCommand(); public Form1() { InitializeComponent(); } private void btnClear_Click(object sender, EventArgs e) { dgvShowData.DataSource = null; } private void btnExit_Click_1(object sender, EventArgs e) { Application.Exit(); } private void btnShow_Click_1(object sender, EventArgs e) { try { con.Open(); cmd = new SqlCommand("Select * from Coutnry", con); cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dtable = new DataTable(); da.Fill(dtable); dgvShowData.DataSource = dtable; con.Close(); } catch { MessageBox.Show("Error 404"); } } private void dgvShowData_CellContentClick(object sender, DataGridViewCellEventArgs e) { } } }

Thanks a lot

It is good this is not a tutorial on good database or UI design because both are atrocious in the video.

I'm subcrubesd. Ncie videos.

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

Hi there, when i run my project, the local database loses connection which makes impossible to save data from the form to the DB. Do you guys have an idea on how to solve that issue?