these videos are so helpful man thanks... im at uni and the idiots gave us the programming module half way through semester one and its due 2 weeks from know. All the resources don't show us what we need to do. Also we haven't even had time to finish off all learning weeks so out of 8 we have only done 3 and been told to do project...Your a life saver man!
+Sanjeev Dhillon I have a group coursework project to hand in 2 weeks from now and they have just said to use ASP.net and C# without teaching us anything. Lecturer just said "welcome to the real world" and handed us this massive project.
If you get confused using "," + textObject , etc... you previously create a string var using string.Format with the way: string preCmdText = String.Format(“insert into MyDB ([Name], [Age]) values ({0}, {1})”, tboxName.Text, tboxAge.Text); command.CommandText = preCmdText;
Thank you very much for your videos! I like that they are simplistic and to the point, and that you do a great job of explaining why you are doing each step. You make it very easy to create good working programs and still be a newb. Thank you!
Hi ProgrammingKnowledge , How can I add more some data to a database? I tried to add 2 more Textboxt such as Address and age but I cannot make it. It shows an error once I hit the "SAVE DATA" button. Can you help me fix it? Is there somebody can help me there?
All you have to do is put brackets around ([FirstName], [Lastname], [Pay]) so you get---> command.CommandText = "insert into EmployeeData ([FirstName], [LastName], [Pay]) values('" + txt_fname.Text + "','" + txt_lname.Text + ",'"+txt_pay.Text+"')"; If this helped please subscribe to my channel :) I will be coming out with a huge C# tutorial series with simplicity and clarity. Thank you!
Hello, i tried to insert into an exclusively locked access database. And i always getting an error Is there any special command-text for the exclusively locked access database?
Like many other users I got a SQL syntax error using the SQL syntax as shown ( "insert into EmployeeData(Firstname,Lastname,Pay]) values('" + txt_fname.Text + "','" + txt_pword.Text + "','" + txt_pay.Text + "')";). Then I found Findle Fins's comment, and added square brackets, and now it works! But why? StakOverflow says that VisuaStudio needs square brackets stackoverflow.com/questions/52898/what-is-the-use-of-the-square-brackets-in-sql-statements and indeed it works. I still can't understand why the orignal version without brackets. Maybe he was using an older VisuaStudio version with a different behaviour.
it's working perfect,but how can i set that i can display a messagebox when i try to add a person who is already added so i won't get persons double? thank you very much!
Thx for the tutorial :) But I got a Problem: How can i show a checked Checkbox into the MS Access database? All the textboxes, Dates and even combobox values can be saved.... but not the checked state of a Checkbox. Any suggests?
What if do you have multiple tables? I need to manage more than 1 Access table, how can I switch between them? Do I need a different form for every table, right?
what if the textbox is empty?? in the register form to insert database? i need a code for the error message on it when the field is empty. PLEASE HELP :(
Hello, The tutorial is very good! What i have to change if i want to fill up a text box with date like birthdate? Can you make a tutorial video about it? Thx!
I've lost the connection is successful label. I ended renaming the form after i did that so maybe that might be the problem but i don't know how to get it back
I have figured out error but now I had problems in saving data it's saving data over and over again if I click save button how can I able to fixed that plz help me thx
I successfully save the data in my ms access but when i insert another data i get an exception says that they would create duplicate values in the index, primary key, or relation. when i check my database the primary key of the first data that i inserted is 0. I think that when you add another data, the primary key will not increment. how to fix?
in access database go to design view > change your primary key's data type into auto increment > save your database > run your program. oh im 1 year late^^ eheheh
ErrorSystem.Data.oleDb.oleDbException(0x80040E14):Syntax error in INSERT INTO statement.(Error show to save button click please sent me some other code
+Putra Wahyu S @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + database + ";Persist Security Info=False;"; If this gives an error, try to install www.microsoft.com/en-us/download/confirmation.aspx?id=23734. If this does not work either, install the 2010 version (just google it)
Hello my Login and Password form its work but i have create 2nd form in connect to employee table but he not save any data please check your code b/c i have right your code
Other than his out dated connection string his code is correct, check that there are no spaces in your table names or column names. The error is somewhere is your code
check if the connection string is correct! Or table and its field names are correctly written in query. And also check if the connections are opened and closed correctly given right sequence.
Hours spend learning and you explained in minutes. Ay caramba . Thanks
these videos are so helpful man thanks... im at uni and the idiots gave us the programming module half way through semester one and its due 2 weeks from know. All the resources don't show us what we need to do. Also we haven't even had time to finish off all learning weeks so out of 8 we have only done 3 and been told to do project...Your a life saver man!
+Sanjeev Dhillon I have a group coursework project to hand in 2 weeks from now and they have just said to use ASP.net and C# without teaching us anything. Lecturer just said "welcome to the real world" and handed us this massive project.
Sanjeev Dhillon
Yeah he is only doing it to us because thats what happened to him years ago. :P
If you get confused using "," + textObject , etc... you previously create a string var using string.Format with the way:
string preCmdText = String.Format(“insert into MyDB ([Name], [Age]) values ({0}, {1})”, tboxName.Text, tboxAge.Text);
command.CommandText = preCmdText;
Thank you very much for your videos! I like that they are simplistic and to the point, and that you do a great job of explaining why you are doing each step. You make it very easy to create good working programs and still be a newb. Thank you!
For the insert into error, put "[ ]" between column names just as +Findle Fins has done!
+pyrexo what do u mean i got this error
Yes this solution worked.. thanks
Thank you!
Thanks a lot, worked for me
I got errror into system.data.oledbexception : syntax error into statement
Excellent teacher, I'm learning a lot !!
Can you use if statements to check if correct length values where inputted into the textboxes then display a message if not?
Hi ProgrammingKnowledge , How can I add more some data to a database? I tried to add 2 more Textboxt such as Address and age but I cannot make it. It shows an error once I hit the "SAVE DATA" button. Can you help me fix it? Is there somebody can help me there?
Thank you for this sir!, i understand you best than my professors T^T
Error
INSERT INTO SYNTAX ERROR
You are a Guinness! from Nepal!
I found this video to most helpful. I know have a better understanding for how Visual Studio works and inserting other data to it.
Good Job you have taken so much effort.
im getting error on the insert into, how to solve it? please help
All you have to do is put brackets around ([FirstName], [Lastname], [Pay]) so you get--->
command.CommandText = "insert into EmployeeData ([FirstName], [LastName], [Pay]) values('" + txt_fname.Text + "','" + txt_lname.Text + ",'"+txt_pay.Text+"')";
If this helped please subscribe to my channel :) I will be coming out with a huge C# tutorial series with simplicity and clarity. Thank you!
got an error on command.ExecuteNonquery();
command.Connection = connection; that was line that i missed after OleDbCommand command = new OleDbCommand();
I learned so much with you videos :) , thanks for upload video like this.
Thanks a lot, worked for me.
Hello, i tried to insert into an exclusively locked access database. And i always getting an error
Is there any special command-text for the exclusively locked access database?
Like many other users I got a SQL syntax error using the SQL syntax as shown ( "insert into EmployeeData(Firstname,Lastname,Pay]) values('" + txt_fname.Text + "','" + txt_pword.Text + "','" + txt_pay.Text + "')";).
Then I found Findle Fins's comment, and added square brackets, and now it works!
But why?
StakOverflow says that VisuaStudio needs square brackets
stackoverflow.com/questions/52898/what-is-the-use-of-the-square-brackets-in-sql-statements
and indeed it works.
I still can't understand why the orignal version without brackets. Maybe he was using an older VisuaStudio version with a different behaviour.
Thank you so much, you did a great job :)
You saved me Man !! Thank you so much :D
it's working perfect,but how can i set that i can display a messagebox when i try to add a person who is already added so i won't get persons double? thank you very much!
In my case i have a ton of text boxes & combo boxes that i need to do this on multiple lines which creates a problem when you are using concatenation.
Thx for the tutorial :)
But I got a Problem: How can i show a checked Checkbox into the MS Access database?
All the textboxes, Dates and even combobox values can be saved.... but not the checked state of a Checkbox.
Any suggests?
excellent tutorial that helped me alot, thanks.
What if do you have multiple tables? I need to manage more than 1 Access table, how can I switch between them? Do I need a different form for every table, right?
Sir i give primary key in id Feild it's error occurs :values are not match what to do please help me
data saved but not record into database..
how to fix that?
what if the textbox is empty?? in the register form to insert database? i need a code for the error message on it when the field is empty. PLEASE HELP :(
I have one question.
Database connection is closed in try block. What if some exception occurs in try block?
The connection would never close.
Helped a lot thank you so much...
help why it says not registered on local machine ? . im using visual studio 2013 and access 2013
Hi,
How to search records between two dates using ms access database in c#?
Hello,
The tutorial is very good! What i have to change if i want to fill up a text box with date like birthdate? Can you make a tutorial video about it? Thx!
how can i solve multy user opning the accessdatabase?
Im getting an error with the INSERT INTO statement - please could you help!
Thank you, very good tutorial, but it will be better if you write a link to code, too lazy to write a code ))
can you tell me how to insert a new record as the last row. I dont why it dont follow any rules?
Why you keep open Access Table in Design mode while retrieving data???? Its not true that access not allowed multiple connection to be opened. .....
Can you make one video for how to save data with image?
I've lost the connection is successful label. I ended renaming the form after i did that so maybe that might be the problem but i don't know how to get it back
it doesn't insert in my database, when I click "save" nothing happens
+Mariel Salem same
@@Justin-BroskiMode did find the solution?
did you find the solution?
Thank you soooo much 💗💗💗💗
Can you help with the code for inserting date???
I have figured out error but now I had problems in saving data it's saving data over and over again if I click save button how can I able to fixed that plz help me thx
Why after i save data but my access database wont update the data i save? pls help...
It shows me that Data is already saved but nothing is really added in my Access db table ! Help me please
I hve the same issue. Whats wrong?
what we have to do for data already save message
the insert button works but the data is not saved in my database
enjoyable and useful
syntax error, insert into statement
how do you fix that?
you forgot word INTO between insert and table name
@@sivk4501 No, it means there's an error in the "input Into" statement.
error insert into syntax error
I successfully save the data in my ms access but when i insert another data i get an exception says that they would create duplicate values in the index, primary key, or relation. when i check my database the primary key of the first data that i inserted is 0. I think that when you add another data, the primary key will not increment. how to fix?
in access database
go to design view > change your primary key's data type into auto increment > save your database > run your program.
oh im 1 year late^^ eheheh
my data does not affected the access file
ErrorSystem.Data.oleDb.oleDbException(0x80040E14):Syntax error in INSERT INTO statement.(Error show to save button click please sent me some other code
i get the error "Could not find installable ISAM."
sorry which is the connection string for access 2016?
+FreeZy i have the same problem! did u figure it out?
+Putra Wahyu S @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + database + ";Persist Security Info=False;"; If this gives an error, try to install www.microsoft.com/en-us/download/confirmation.aspx?id=23734. If this does not work either, install the 2010 version (just google it)
Thankyou
How to get date from datepicker
Hello my Login and Password form its work but i have create 2nd form in connect to employee table but he not save any data please check your code b/c i have right your code
Other than his out dated connection string his code is correct, check that there are no spaces in your table names or column names. The error is somewhere is your code
Did exactly what you did and it's not putting the data in the database.
same it's showing the error whenever I click the save button.
You need to write the Names in Square Brackets, like this:
EmployeeData([Firstname],[Lastname],[Pay])
check if the connection string is correct!
Or table and its field names are correctly written in query.
And also check if the connections are opened and closed correctly given right sequence.
dont work for me
Thanks a lot !!!!!!!!!!
helppppp ?!!!
my Data is not inserted(saved) in MS access database but it is shown in datagrid ?!! why tho ?!
thanks dude ,I appreciate your work !!
SAME PROBLEM HERE
Hi,Im getting an error with the INSERT INTO statement
How I can Fix ?? ///Thank
Did you solve it?
@@adamsgier9049 same problem here how did u fix it?
@@christiangamayot1345 I didn't 😂😅
@@adamsgier9049 i've fixed it, you should put brackets [] outside the fieldname like this [fieldname] hahaha
Oooooooohhhhhhh!!!!!!😂😂😂😂
same error as Naveen MEnon. Error in insert syntax.
Me too - did you find a fix?
it cannot save the data
got an error at connection.Open();
Error line 30 🙄🙄
tnz this one is very use ful for me tnank you soooo much