C# Application - Insert Delete Update Select in MS Access Database | FoxLearn

[@JoaoSilva-gs5jb]

How to load the data that have been saved in the db every time you open the app again? Otherwise, what's the point?

[@allhaillelouchvibritannia7494]

it's a bit hussle working with access as your back-end and I encounter this problem too, you can't save your data in access permanently If you trying to reload your project your data will permanently lost, thankfully I figure out the solution for this and the code for new, cancel, and edit button is bit complicated, by the way I learn somthing new thanks foxlearn! 😊

[@foxlearn]

You should change your path ms access database. Each time rebuild your project all data in debug directory will be deleted. You can't see your data save to ms access database. Thank you so much my friend !

[@agnieszkap8888]

Hi, I have a problem. It doesn't matter whether I click yes or no in deleting box, records disappear but they stay in data base. Inserting works fine, they appear in data base. Can you please tell me what may be the reason?

[@booney440]

did you use datagrid_downPress?

[@Jr-ry7jv]

Hi, I am also exactly with this same problem, does anyone have any tips?

[@davidtomasek7148]

Hi, i know its too late :D but u have to put: employeesBindingSource.EndEdit(); employeesTableAdapter.Update(this.appData.Employees); into your delete metod.

[@ivodonckers8936]

@@Jr-ry7jv Same here

[@siliciatuner8849]

Thank you again for the tutorials :) Hopefully my system will be done before saturday

[@kotakadanski8515]

Great! This is what I call a helpful tutorial! It is one of the very few ones on KZbin without code mistakes. Keep on making videos like this. They are essential for amateurs like me! Suggestion: I noticed the countless comments asking for the code, and sending it by emails must be really tiring. Why don't you upload the code on a website ( there are a few reliable ones on the web) and paste a link in the description? It will save you time and inconvenience. Also, if you consider doing this, be aware of the bug in M.V. Studio - if you send the files of the already built program, V. Studio can Debug, but can't show the code in the .cs file, so a text file would be a better choice. Thank you once again.

[@foxlearn]

Thank you for your suggestion :)

[@kotakadanski8515]

Fox Learn You're welcome! ;-)

[@varadarajan4181]

Nice training approach to explain when it needs.

[@foxlearn]

Thank you !

[@msanand7]

Really Useful. Thanks a lot.

[@foxlearn]

Thank you !

[@ivodonckers8936]

Thanks, it works fine, and you have the best Tuto's !!! Just like to know how to do it with multiple tables who are related...,so if i pick a person, the other tables shown all other info in a datagridview from the table related to that person, and the tables can be added new info, delete info, update info, etc...

[@bvsingh4357]

Nice tutorial Sir

[@foxlearn]

Thank you so much :)

[@fankahr899]

Nice explanation i subscribed

[@foxlearn]

Thank you so much !

[@adrianocelio5974]

Very Good.

[@foxlearn]

Thanks

[@homoserebrus4463]

You never disapoin me, bst c# tutorial :) :) :)

[@foxlearn]

+Homo Serebrus Thank you ^_^

[@tasarimciolcam]

Thanx for tutorial.

[@foxlearn]

+Umit Koc Thank you ^_^

[@BustaJunix]

Thank you for this great tutorial. How to validate and existing record in dataGridView in order to eliminate duplication of record.

[@foxlearn]

OK. Thank you for your suggestion. I'll upload soon !

[@lord_of_schallowland5845]

Thanks for lesson, but, i don't get something: what is "o" letter in (16:28), e.g "where o.Fullname.Contains(txtSearch...". Is this variable or what? I can't compile this in VS Community 2015.

[@foxlearn]

+Lord_of Schallowland Hi, o letter is a variable. You need select your .net framework version is >= 4.0. Thanks

[@lord_of_schallowland5845]

+Fox Learn, Ok, thats halped, but there is enother problem in 17:15 " is ...query.ToList()".There is not shown ".ToList()" before ''query.'' in Intellisense or whatewer it named after dot. I sought for it but didn't find answer how I can turn on to use ''Tolist()''. And I didn't find in this video where you describe 'query' and 'o' variables.

[@tabanmehrnabizadeh8015]

thanks this video was the easiest video in net for the database. if u say how to connect a string to our database it is very good because I made hide label and connect that to database

[@ivodonckers25]

Love your Tutorials !! Just want to learn it with more tables How to with 2 tables, example, a table with patients, and a table with date's of visit and prescriptions for medication, so the prescription table has to be related to each individual patient, and needs new-update-delete etc etc...... So if i select a patient, i can see all visits with medication from that patient, and able to make a new, delete, update that table ( Search is not needed.

[@foxlearn]

+Ivo Donckers Hi, I'll update soon in this week . Thank you :)

[@ivodonckers25]

Thanks !! Is there a way to support you ? such as donation etc...?

[@leonard-gabrielbuduleanu5641]

Thank you!!!The best tutorial!!

[@foxlearn]

+Sniper Lord Thank you :)

[@shahabhossen6579]

thank you , actually it is so useful well done .

[@foxlearn]

+shahab hossen Thank you :)

[@avidiuscassiusivanovitch7149]

Please , can i use this methode when i want to develop my ERP? Without Oriented object

[@ckhemantha2174]

thank you very much

[@rachidbekle7646]

Thank you very much sir

[@foxlearn]

You're welcome. thank you !

[@unknow8780]

thankyou so muchhhhh!

[@devsharma8038]

i want to select my ms access database at runtime. what should i choose local database or service based database to create datasource

[@optc8005]

Really that you for this tutorial! I need help though. How will I make the search case insensitive?

[@foxlearn]

Hi, You can use string title = "Your title";bool contains = title.IndexOf("word", StringComparison.OrdinalIgnoreCase) >= 0; Thanks

[@optc8005]

Thank you! I have another question, though. How will make the Employee ID (of the Employee Table) be the contents of a combo box and pass the value to the Employee ID of the TransactionTable?

[@namelessone1811]

When I make a setup to install a app using the MS Access Database Engine 2010 Redistributable will the installer install it for the end user or will the end user have to download the MS Access Database Engine 2010 Redistributable and install it after installing the app? Thank you in advanced

[@foxlearn]

+Lynn Phillips Hi, You need to install Microsoft Access Engine for all users install your application. Thank you :D

[@namelessone1811]

+Fox Learn Thank you for the help

[@rjurinofies7034]

What if in the String.IsNullOrEmpty , the data type used is int ? How it is supposed to coded as ?

[@mohammeddhillshaardthd2122]

👌👏👏👏✌

[@foxlearn]

Thank you !

[@BRodTutorials]

If you are looking for more C# tutorials I am your guy!

[@foxlearn]

Thank you

[@ivanovivan2150]

hi! help please!!! The "==" operator can not be applied to an operand of type "int" and "string"

[@randellsarmiento3812]

@Fox Learn What should I do with the Parameter ?_4 has no default value. Reply asap. Thank you :) I follow the instructions and codes carefully.

[@foxlearn]

Can you describe more details? I'm not clear your mean

[@Tarkarra]

Hi i try the program and almostly working for me. I really don't like the programming but with this is more easy. I have two problem for my version. I wrote stuff in the database and not save the data, and i choose a picture but not save that and not show when i run the program.

[@varshatavade9271]

very usefull and very well explained ..but mam I have one problem my data is not getting saved to database. It's showing only in grid.

[@techqueen6233]

Nice coice

[@ivodonckers8936]

I use the moethodes from your sample, but with more fields, and get a error QUERRY TOO COMPLEX, can you help me out with that ?

[@tabanmehrnabizadeh8015]

I have a problem. when it saves all data it 's work and I see(in Datagrid in this form) but when I go on another form I can't see any data on my another Datagrid and when i come out and agian i start program i dont see any data of before

[@tabanmehrnabizadeh8015]

someone help me pls

[@nelsonskmz]

help...when i open the database(ms access file) it's not updated,and everytime closed program it's started with blank database,and when the second,third... data Save,it show the error message even the data saved private void btnSave_Click(object sender, EventArgs e) { try { employeeBindingSource.EndEdit(); employeeTableAdapter.Update(this.appData.Employee); panel.Enabled = false; } catch(Exception ex) { MessageBox.Show(ex.Message, "Message",MessageBoxButtons.OK, MessageBoxIcon.Error); employeeBindingSource.ResetBindings(false); } }

[@foxlearn]

Hi, You need to copy your database to another folder, each time you rebuild your project all data in debug folder will be deleted. thanks

[@NanayaGC]

What do you use for a date type of value? Thanks.

[@foxlearn]

DateTime type

[@erkancankurt4327]

hi, I found an error on your form at search.If a textbox was left empty ( for example address or email address) when we try to searc a record, it gives a Dbnull error.please let me know how it can be solved. so, at some forms, we dont have to fill all the fields...

[@foxlearn]

Hi, You need to set column allow null value in dataset. please check again. thanks

[@erkancankurt4327]

Fox Learn hi, thanks but where and how may I find that cloumn to fill it as Null.I cant find how to change it in dataset.

[@TA-tb4nb]

Hello, what is the best way to go about doing this?

[@kursadgulereem]

i also checked your suggestion,but problem still same, can you give any answer like a video and tutorial ?

[@SamixPhotography]

Please one video to add other data sources.

[@muhammedkoka2079]

useful

[@foxlearn]

Thank you !

[@cymonsVitriago]

sorry a question, How do I reset the automatic counter ? I.E: if I delete a record and add a new user to the counter continues to increase and does not match the number on the list. Thank you

[@foxlearn]

Hi, You can view this link support.microsoft.com/en-us/kb/812718 . thanks

[@haqobatil9832]

sir i want to make a copy a table row in access database and update one record (actual record is kept original) from text boxes in c# how can i kindly guide me

[@foxlearn]

OK. Thank you for your suggestion !

[@Lou12323]

Hi ,I would like to ask something, I try to add a new record in my database using your codes then after I reopen my project the saved database will be gone badly needed your feedback thanks!

[@foxlearn]

+Louis Bier Hi, What's your problem ?

[@kornelmarkus3860]

I have an error message with save button: An INSERT INTO query cannot contain a multi-valued field. ????

[@foxlearn]

Hi, You need to set id column is auto increment, then try again, thanks

[@anthonywoods2550]

Thank you, now how to install it with Database? I have tried but get message that says the Microsoft.ACE.OLEDB.12 provider is not registered on the local machine.

[@foxlearn]

+Anthony Woods (SME) Hi, You need to install Microsoft Access Engine. Select your CPU target based on the package installed (x86 or x64). Thanks

[@anthonywoods2550]

Thank you. I did this on my computer but how to install app on other machine without doing this. How to package this type of app with database and implement it correctly.

[@foxlearn]

+Anthony Woods (SME) Microsoft Access Database Engine 2010 Redistributable: www.microsoft.com/en-us/download/details.aspx?id=13255 Microsoft Access 2013 Runtime: www.microsoft.com/en-us/download/details.aspx?id=39358 You need to install the package above based on your Microsoft Access installed

[@anthonywoods2550]

Thank you, but I did this already. When I publish the app on my desktop, it does not work with the database. Only in VS when I execute the app.

[@foxlearn]

+Anthony Woods (SME) Hi, You need to select your CPU target when you publish (x86 or x64). Copy your database to the application folder, install Microsoft Access Engine (x86 or x64) on your client machine. Thanks

[@hemoagha8303]

thank you

[@swabbie6150]

Hi, I have a problem, the data i were previously updated doesnt save on my database. For example, I update a name in my database, when i went to the database to check it out, it doesnt save what I have updated through my program(the procedure you taught). How can I fix this? or am i just doing something wrong or doesnt understand?. Plss Help!

[@foxlearn]

I think you should copy your database to another folder. Each time you rebuild the project all data in debug folder will be deleted, so you can't see data

[@lazyhl1994]

I'm also getting the same error about the first column that does not allow nulls. I checked my access database file and the primary key is set to the first row.

[@foxlearn]

+lazyhl1994 Hi, You should set auto number for primary key, thanks

[@lazyhl1994]

+Fox Learn How would you do that?

[@foxlearn]

lazyhl1994 Go to table in database and set auto number for primary key, then add table to dataset again, thanks

[@lazyhl1994]

+Fox Learn Okay but where in access would you set the auto number for the primary key? Is it in the table designer view?

[@foxlearn]

lazyhl1994 Yes, Table designer, Do exactly what I do in the tutorial, you can fix your problem, thanks

[@diyhub2986]

is it possible to change or edit the picture in a database? or can it change the picture in a database with the edit button ?

[@foxlearn]

Hi, You can edit picture then save back to the database. thanks

[@diyhub2986]

thanks for the fast reply ;) can i ask you one more question? how can i add deleted items from datagridview1/table1 to datagridview2/table2 in short how can i record deleted items.

[@foxlearn]

Hi, You can set update, delete cascade or you can set transaction delete multiple table (table 2, table 1). thanks

[@diyhub2986]

thanks for the reply ;) thanks to your help :) i already finish my program so its time to say goodbye :) thankyouuuu for help

[@RobertoRamirez-em3yi]

Hi. I need some help. When you have many records and you search one to delete it, you can't do it because the actual data source wouldn't be the binding source, but the query variable. How can I fix this?

[@foxlearn]

Hi, You should set the data source to the search results, when you click on a row, you will get a current value, then you can update or delete row data.

[@shigekigiosenfao9027]

Hello. I need help. Everytime i click the "Save" button, it does not save to the database at all and it does not show up in the grid. Any ideas why its like that?

[@foxlearn]

I think you should copy database to another folder, each time you rebuild your project all data in debug folder will be deleted

[@shigekigiosenfao9027]

@@foxlearn Thank you for the reply. I do need help on how will i do the "Search" button if there is a 'date' needed. As far as i can see all your database program only contains "text" and not "number and date" so im clueless how to code it when it comes to "date" in the "Search" button.

[@shigekigiosenfao9027]

@@foxlearn hello again. I do wanna know how do i actually save the data i inputted in the program and not be remove everytime i run it. Its like when the program is running, the data i put is there but when i rerun the program, its not saved into the database itself so i have to redo inputting the whole data. You have an idea how to do it?

[@ash322]

thank you but there is a problem when i run it and try to add new record it tells me that primary key can't be null and it don't save data even if i add new data

[@joseferminescalona8392]

Nice tutorial, i've tried to do the same but when i press 'New' button shows me a message that says: 'id' column doesn't allow null values. The difference is that i made 'id' a non-autonumerical variable (i wanted id to be String or Short Text). Can u tell me what's the mistake that i'm making?

[@joseferminescalona8392]

i'm trying to do some records about food providers, so that is the reason why i created an id.

[@kaddouraouachria5768]

thank you 1000/1000

[@foxlearn]

Thank you :)

[@digimikeh]

Can't find Data Sources on Visual Studio 2017 .... has it changed its name?

[@mharguiruela9026]

Thank you bro how about adding a datetimepicker can you show it to me please :)

[@foxlearn]

OK. Thank you for your suggestion

[@shalindakshina5165]

I created form like this first one was working but i created same form same project again but second form is not working. not working means when i press new button textboxes were not reset it has details which i entered before. And I pressed save button new data not display. why is it ????? please help me .....!!!!!

[@foxlearn]

Please check your code again. i think you miss something

[@andrejstojanov1733]

Please define the button Cancel. When I click button New and then button Cancel the record writes to the database.

[@muhammadabdulrahim7843]

hello, thank for your code it really helpful... but i got problem where the data we save is only available on the windows form.. in the ms access is no data.. and when we close the form the data is loss...

[@ivodonckers25]

+Muhammad Abdul Rahim you have to re-watch the end of the video !!! He makes a copy outside de DEBUG folder, and each time you run the code, it will be rebuild with a empty database !!! ( see settings of your project ) and than afterwards he copy the outside DEBUG database copy again in the DEBUG folder, so it will work than with the build EXE file in the DEBUG folder !!

[@muhammadabdulrahim7843]

+Ivo Donckers thanks... sory my bad..... now it can be save.... actually i have another question.. now im doing a system where i need to save image with it description. After saving the image, i can search the image using the description. Like the google image, how to show multiple image thumbnail only which have the same description from the database at the datagrid like in the video where it show the full table at the datagrid

[@ivodonckers25]

can you send me a screenshot ?? So it will be more clearly for me !! The tutors from fox learn are really the best way to learn it, so i hade a question to fox learn about the same project, but with more related tables, and he will make a update for it, can hardly wait for it ;-)

[@muhammadabdulrahim7843]

+Ivo Donckers can i have your email?

[@ivodonckers25]

[e-mail]

[@thepreviewchannel6398]

why when i exiting the program all i inserted in database lost and it is not record in my database? pls help....

[@otmaniabdelhadi4967]

thanks

[@TecnoGeeksv]

Lo máximo, gracias

[@vagamers733]

hi i got an problem hope if u can help me in code Keypress there i got and Quantity so its is in number in ms access so after applying your code i got and error Error CS0019 Operator '==' cannot be applied to operands of type 'int' and 'string' Loginpage

[@hykh6459]

Plz help me how can I reset the Id (auto number) when I delete and add new one but the number are not change like ( 123567) I delete 4 but the five should start from 4

[@KratterDK]

Hello FoxLearn. When i do the changes in the code from 24:00 to the end of the video, i got errors. Se picture for errors: i66.tinypic.com/33w33es.jpg - How to fix?

[@foxlearn]

Check your connection string

[@KratterDK]

@@foxlearn Thanks for answering buddy, but didn't seems to fix it. Will you please send me a mail to me: [e-mail]? So i can send you my applikation, i think it's a little problem you can fix for me, in 30 seconds, but it dosen't seens like, i c

[@KratterDK]

All my textboxes works, but only my picturebox binding, i have problem with now. If i remove my binding to my picturebox, and launch the applikation, it works perfectley. But do i turn on binding to the picturebox again, then i got error. I really dont know how to fix it.

[@DeeWeDD]

When I try to add a new data source in ms visual studio, it says unrecognized database format. I have downloaded the Microsoft access engine and I have access so I do not know the issue.

[@foxlearn]

Hi, You need to set your cpu target is x86, please try again. thanks

[@SamixPhotography]

i cant see other data sources in data bindings. mark on 10:00

[@leeyw8913]

did the data store into m.access? because i can't find my data in m.access

[@foxlearn]

Hi, You can find your database in debug folder, you should copy database to another folder, each time you rebuild your project, all data in debug folder will be deleted

[@migeruyama4606]

When I delete the data... the ID number will remove to... why when i add another employee the ID number continue counting...? plsss Help sorry for my bad English

[@SanctuaryofPeaceful]

hi ! thanks for tutorial , i just have problem in (( textSearch_KeyPress when i try to write "key char" in "" if "" like you i cant see it ; can you help me about it and thanks !

[@foxlearn]

+bacha19 bacha Hi, What's your problem ? Thank you !

[@nicholaswolfwood1300]

0 on first number of phonenumber is unavalable. it will automatically delete it. also, i cant put up to 11 digit number even though i change the length. searching name doesnt work on mine. good application btw

[@foxlearn]

You should set your phonenumber type is text

[@learningcomputerscience1169]

Can you please explain how to login using C# & MS Access?

[@foxlearn]

Sent. Thanks

[@vagamers733]

sir i made software with this video but igot an problem with image inserting it saying no proper filter provide

[@snaqvi009]

Everything working fine but same problem like you image is not save properly. Please give any suggest. Thanks

[@MuhammadAdnan-uq2pd]

Thankuu Shoo Muccccccch

[@nechirawan_]

thank u

[@foxlearn]

+Nechirawan K. Hassan Thank you ^_^

[@kuraibrianrambo5015]

good tutorial, I'm a beginner could u please help me with the source code.Thank u

[@studentivullnetar2768]

I wrote the code but got the error CS1061- "'object does not contain a definition for Text". I am new in c#. pls help! thanks!

[@foxlearn]

Hi, What's your email? i can send to you demo source code. thanks

[@studentivullnetar2768]

[e-mail] thanks! ☺

[@studentivullnetar2768]

I wrote the code but got the error CS1061- object does not contain a definition for Text

[@arbertguanzon9391]

why is that when i click new its says "column ID does not allow does not allow nulls", ID number is my primary key

[@foxlearn]

That's right, ID is a primary key, you can not set null

[@DeepBlacksea]

hello, I have a problem when I save my data by clicking on the save button it doesn't work. even when I click new it is adding the rows. if anybody here could provide solution must be appreciated.

[@foxlearn]

What error are you getting?

[@tahaali3792]

im getting "panel" error in "'panel.Enabled = true;'" ..... why is tht ??

[@haqobatil9832]

sir i made a simple project in this i want to enter 14 digit code in access database via a textbox in C# and i tried but Error 0x80040E07 appears plz resolve my this error

[@foxlearn]

What's filed datatype?

[@haqobatil9832]

it's national id card number it has 14 digit just simple numeric only

[@ansaa17]

my entry dosn't stay in the database can you please help me thank you

[@FAHDDAABAN]

i got this error operator cannot be applied to operands of type bool and string

[@FAHDDAABAN]

help me please

[@foxlearn]

Hi. Can you describe more details about the error. thanks

[@FAHDDAABAN]

I got this error in txtSearch_KeyPress code: where o.fullName.Contains(txtSearch.Text) || o.phoneNumber == txtSearch.Text || o.Email = txtSearch.Text || o.Adderss.Contains(txtSearch.Text) the error is : Error 1 Operator '||' cannot be applied to operands of type 'bool' and 'string' Error 2 Operator '||' cannot be applied to operands of type 'string' and 'bool'

[@foxlearn]

It should: where o.fullName.Contains(txtSearch.Text) || o.phoneNumber == txtSearch.Text || o.Email == txtSearch.Text || o.Adderss.Contains(txtSearch.Text). You're missing '='. thanks

[@FAHDDAABAN]

+Fox Learn thank you very much

[@novato9537]

I do not accept me or problem change to put the (BNT) :u

[@HandoSonic]

how can we change some column value? pls help

[@sora-senpai]

How do you duplicate controls without copy & past?

[@luismanuelsegura5868]

I make a mistake in the New button sends a message that does not allow nulls

[@foxlearn]

+Guicho Cruz Guicho Hi, Do you have set primary key auto increment in the dataset ?

[@luismanuelsegura5868]

Not because I do not have the database in the autonumber

[@alshezawi2010]

+Fox Learn Same Error

[@TheGlendriv]

+Fox Learn Can u make non autonumber tutorial?

[@techmanojmishra3597]

Please help me this error The method or operation is not implemented

[@eddiejackson4227]

Like.

[@foxlearn]

Thank you

[@optc8005]

My datagrid won't update its values. How to fix it?

[@foxlearn]

What's error are you getting?

[@aamirknaam]

Can u plz send me the code. Thanks in advance.

[@ahmedel-nakib4473]

why inserted data dose not save in Access ?

[@Ibro123451]

am i missing something because where does keycode come from on datagrid

[@foxlearn]

Hi, Please check the keypress event handler, make sure it's correct

[@Ibro123451]

Fox Learn could you possibly send me the file. please at [e-mail]. Also is there away on visual studios that rather then having the database display the data. like have the database output to a customer profile so I search the name and it will have a profile containing the data rather then jus5 seeing the database.

[@foxlearn]

Sent. Thank you

[@n.zhumagaliyev838]

why not save the combobox I do for the interest combobox

[@foxlearn]

What do you mean? can you describe more details. thank you !

[@n.zhumagaliyev838]

@@foxlearn you saved the textbox. I will save the combobox. I have a combobox prompt. How to save combobox on base

[@foxlearn]

OK. I'll make the tutorial combine with combobox as soon as possible. thank you !

[@mrhassu588]

What do i do with office 2016 access

[@foxlearn]

Hi, You can do similar, Thanks

[@haboliw]

this.txtSearch.TextChanged += new System.EventHandler(this.txtSearch_KeyPress); help me

[@shinduo2624]

why it does not save in my data base

[@sheikhshuaib8451]

hi can anyone help me paging in datagridview using acess