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! 😊
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 !
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?
Hi, i know its too late :D but u have to put: employeesBindingSource.EndEdit(); employeesTableAdapter.Update(this.appData.Employees); into your delete metod.
Great! This is what I call a helpful tutorial! It is one of the very few ones on TH-cam 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.
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...
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
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.
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.
+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.
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?
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.
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
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
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
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...
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); } }
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
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?
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
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?
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.
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!
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
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
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
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.
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 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.
@@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?
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!
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 .....!!!!!
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...
+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 !!
+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
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 ;-)
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.
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
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.
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.
+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
+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
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
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.
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 !
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
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'
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.
Fox Learn could you possibly send me the file. please at ijhanji1@gmail.com. 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.
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
We use table adapter to save data (it's auto execute command base on you action (insert-update-delete). You can view more details msdn.microsoft.com/en-us/library/ms171919.aspx. Thanks
How to load the data that have been saved in the db every time you open the app again? Otherwise, what's the point?
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! 😊
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 !
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?
did you use datagrid_downPress?
Hi, I am also exactly with this same problem, does anyone have any tips?
Hi, i know its too late :D but u have to put:
employeesBindingSource.EndEdit();
employeesTableAdapter.Update(this.appData.Employees);
into your delete metod.
@@Jr-ry7jv Same here
Great! This is what I call a helpful tutorial! It is one of the very few ones on TH-cam 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.
Thank you for your suggestion :)
Fox Learn You're welcome! ;-)
Thank you again for the tutorials :)
Hopefully my system will be done before saturday
Nice training approach to explain when it needs.
Thank you !
Nice explanation i subscribed
Thank you so much !
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...
Really Useful. Thanks a lot.
Thank you !
You never disapoin me, bst c# tutorial :) :) :)
+Homo Serebrus Thank you ^_^
Thank you for this great tutorial. How to validate and existing record in dataGridView in order to eliminate duplication of record.
OK. Thank you for your suggestion. I'll upload soon !
Nice tutorial Sir
Thank you so much :)
thank you very much
Thanx for tutorial.
+Umit Koc Thank you ^_^
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
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.
+Ivo Donckers Hi, I'll update soon in this week . Thank you :)
Thanks !!
Is there a way to support you ? such as donation etc...?
Please , can i use this methode when i want to develop my ERP? Without Oriented object
Very Good.
Thanks
Thank you!!!The best tutorial!!
+Sniper Lord Thank you :)
Please one video to add other data sources.
thank you ,
actually it is so useful well done .
+shahab hossen Thank you :)
What if in the String.IsNullOrEmpty , the data type used is int ? How it is supposed to coded as ?
Thank you very much sir
You're welcome. thank you !
thankyou so muchhhhh!
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.
i want to select my ms access database at runtime. what should i choose local database or service based database to create datasource
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.
+Lord_of Schallowland Hi, o letter is a variable. You need select your .net framework version is >= 4.0. Thanks
+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.
Really that you for this tutorial! I need help though. How will I make the search case insensitive?
Hi, You can use string title = "Your title";bool contains = title.IndexOf("word", StringComparison.OrdinalIgnoreCase) >= 0; Thanks
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?
hi!
help please!!!
The "==" operator can not be applied to an operand of type "int" and "string"
@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.
Can you describe more details? I'm not clear your mean
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.
Nice coice
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 ?
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
someone help me pls
What do you use for a date type of value? Thanks.
DateTime type
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
+Lynn Phillips Hi, You need to install Microsoft Access Engine for all users install your application. Thank you :D
+Fox Learn Thank you for the help
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
Hi, You can view this link support.microsoft.com/en-us/kb/812718 . thanks
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...
Hi, You need to set column allow null value in dataset. please check again. thanks
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.
Hello, what is the best way to go about doing this?
i also checked your suggestion,but problem still same, can you give any answer like a video and tutorial ?
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);
}
}
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
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
OK. Thank you for your suggestion !
thank you
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?
i'm trying to do some records about food providers, so that is the reason why i created an id.
I have an error message with save button:
An INSERT INTO query cannot contain a multi-valued field.
????
Hi, You need to set id column is auto increment, then try again, thanks
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
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?
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.
useful
Thank you !
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!
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
Thank you bro how about adding a datetimepicker can you show it to me please :)
OK. Thank you for your suggestion
If you are looking for more C# tutorials I am your guy!
Thank you
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
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
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 ?
Hi, You can edit picture then save back to the database. thanks
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.
Hi, You can set update, delete cascade or you can set transaction delete multiple table (table 2, table 1). thanks
thanks for the reply ;) thanks to your help :) i already finish my program so its time to say goodbye :) thankyouuuu for help
thank you 1000/1000
Thank you :)
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?
I think you should copy database to another folder, each time you rebuild your project all data in debug folder will be deleted
@@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.
@@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?
why when i exiting the program all i inserted in database lost and it is not record in my database? pls help....
Please define the button Cancel. When I click button New and then button Cancel the record writes to the database.
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!
+Louis Bier Hi, What's your problem ?
Can you please explain how to login using C# & MS Access?
Sent. Thanks
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 .....!!!!!
Please check your code again. i think you miss something
Can't find Data Sources on Visual Studio 2017 .... has it changed its name?
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...
+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 !!
+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
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 ;-)
+Ivo Donckers
can i have your email?
ivo.donckers@gmail.com
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.
Hi, You need to set your cpu target is x86, please try again. thanks
👌👏👏👏✌
Thank you !
thanks
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
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.
+Anthony Woods (SME) Hi, You need to install Microsoft Access Engine. Select your CPU target based on the package installed (x86 or x64). Thanks
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.
+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
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.
+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
sir
i made software with this video but igot an problem with image inserting
it saying no proper filter provide
Everything working fine but same problem like you image is not save properly. Please give any suggest.
Thanks
did the data store into m.access? because i can't find my data in m.access
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
my entry dosn't stay in the database can you please help me thank you
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.
+lazyhl1994 Hi, You should set auto number for primary key, thanks
+Fox Learn How would you do that?
lazyhl1994 Go to table in database and set auto number for primary key, then add table to dataset again, thanks
+Fox Learn Okay but where in access would you set the auto number for the primary key? Is it in the table designer view?
lazyhl1994 Yes, Table designer, Do exactly what I do in the tutorial, you can fix your problem, thanks
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 !
+bacha19 bacha Hi, What's your problem ? Thank you !
i cant see other data sources in data bindings. mark on 10:00
how can we change some column value? pls help
I wrote the code but got the error CS1061- object does not contain a definition for Text
good tutorial, I'm a beginner could u please help me with the source code.Thank u
How do you duplicate controls without copy & past?
Please help me this error
The method or operation is not implemented
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
You should set your phonenumber type is text
Lo máximo, gracias
im getting "panel" error in "'panel.Enabled = true;'" ..... why is tht ??
why is that when i click new its says "column ID does not allow does not allow nulls", ID number is my primary key
That's right, ID is a primary key, you can not set null
I do not accept me or problem change to put the (BNT) :u
why inserted data dose not save in Access ?
What do i do with office 2016 access
Hi, You can do similar, Thanks
why not save the combobox I do for the interest combobox
What do you mean? can you describe more details. thank you !
@@foxlearn you saved the textbox. I will save the combobox. I have a combobox prompt. How to save combobox on base
OK. I'll make the tutorial combine with combobox as soon as possible. thank you !
thank u
+Nechirawan K. Hassan Thank you ^_^
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!
Hi, What's your email? i can send to you demo source code. thanks
studenti.vullnetar@gmail.com thanks! ☺
Can u plz send me the code. Thanks in advance.
why it does not save in my data base
i got this error operator cannot be applied to operands of type bool and string
help me please
Hi. Can you describe more details about the error. thanks
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'
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
+Fox Learn thank you very much
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.
What error are you getting?
My datagrid won't update its values. How to fix it?
What's error are you getting?
what is that problem in save data
am i missing something because where does keycode come from on datagrid
Hi, Please check the keypress event handler, make sure it's correct
Fox Learn could you possibly send me the file. please at ijhanji1@gmail.com. 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.
Sent. Thank you
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
What's filed datatype?
it's national id card number it has 14 digit just simple numeric only
I make a mistake in the New button sends a message that does not allow nulls
+Guicho Cruz Guicho Hi, Do you have set primary key auto increment in the dataset ?
Not because I do not have the database in the autonumber
+Fox Learn Same Error
+Fox Learn Can u make non autonumber tutorial?
I couldn't understand how to delete, can you please explain?
We use table adapter to save data (it's auto execute command base on you action (insert-update-delete). You can view more details msdn.microsoft.com/en-us/library/ms171919.aspx. Thanks
my search box is not working..
column does not allow nulls c#
You can open your dataset designer, then set the columns is null
how to delete the record?