Cannot insert data in mysql database from windows form application in c++
sir, I'm Using vs2017 and MySql 8.0 and I am trying to insert data from windows form application in c++, the project was run properly, but the query is not correct. I guess, when I insert data and click the save button I created, it says: enter image description here
"you have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near " at line 1"
But I can insert data from the code manually (you can see the comment in the code which work), but i can not insert from the form! I done everything according to this video tutorial
Now how can I do that? please anybody help me, my code is here:
private: System::Void button5_Click(System::Object^ sender, System::EventArgs^ e) {
String^ constring = L"datasource= 127.0.0.1; port= 3306;username=root;password=12712";
MySqlConnection^ conDataBase = gcnew MySqlConnection(constring);
MySqlCommand^ cmdDataBase = gcnew MySqlCommand("INSERT INTO `university`.`student` (`id`,`name`,`password`) values('"+this->id_txt->Text+"','"+this->name_txt->Text+"','"+this->password_txt->Text+"' ;", conDataBase);
//MySqlCommand^ cmdDataBase = gcnew MySqlCommand("INSERT INTO `university`.`student` (`id`, `name`, `password`) VALUES ('7', 'ah', '77'); ", conDataBase);
c++ mysql visual-studio-2017
asked Nov 21 '18 at 22:40
SazzadSazzad
11
add a comment |
sir, I'm Using vs2017 and MySql 8.0 and I am trying to insert data from windows form application in c++, the project was run properly, but the query is not correct. I guess, when I insert data and click the save button I created, it says: enter image description here
"you have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near " at line 1"
But I can insert data from the code manually (you can see the comment in the code which work), but i can not insert from the form! I done everything according to this video tutorial
Now how can I do that? please anybody help me, my code is here:
private: System::Void button5_Click(System::Object^ sender, System::EventArgs^ e) {
String^ constring = L"datasource= 127.0.0.1; port= 3306;username=root;password=12712";
MySqlConnection^ conDataBase = gcnew MySqlConnection(constring);
MySqlCommand^ cmdDataBase = gcnew MySqlCommand("INSERT INTO `university`.`student` (`id`,`name`,`password`) values('"+this->id_txt->Text+"','"+this->name_txt->Text+"','"+this->password_txt->Text+"' ;", conDataBase);
//MySqlCommand^ cmdDataBase = gcnew MySqlCommand("INSERT INTO `university`.`student` (`id`, `name`, `password`) VALUES ('7', 'ah', '77'); ", conDataBase);
c++ mysql visual-studio-2017
asked Nov 21 '18 at 22:40
SazzadSazzad
11
Show the SQL error, and format the code. Show the table structure tooSHOW CREATE TABLE university.student.
– danblack
Nov 21 '18 at 22:54
Sir, I have edited my post? Is it okey now? Do I also attach the screenshot of the sql error?
– Sazzad
Nov 21 '18 at 23:08
Sir, I also have attach the database table and sql error in the screenshot
– Sazzad
Nov 21 '18 at 23:16
@Sazzad Print and share formated query. Guess you have problem(s) with formating the query.
– SilvioCro
Nov 21 '18 at 23:18
I also think, the problem is with the query, But I'm surprised same code worked in the tutorial I've share here, he done that in vs10, and I've check and recheck the code that I've done all the same as the tutorial. Now I don't understand why the same come should not work for me..
– Sazzad
Nov 21 '18 at 23:29
add a comment |
sir, I'm Using vs2017 and MySql 8.0 and I am trying to insert data from windows form application in c++, the project was run properly, but the query is not correct. I guess, when I insert data and click the save button I created, it says: enter image description here
"you have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near " at line 1"
But I can insert data from the code manually (you can see the comment in the code which work), but i can not insert from the form! I done everything according to this video tutorial
Now how can I do that? please anybody help me, my code is here:
private: System::Void button5_Click(System::Object^ sender, System::EventArgs^ e) {
String^ constring = L"datasource= 127.0.0.1; port= 3306;username=root;password=12712";
MySqlConnection^ conDataBase = gcnew MySqlConnection(constring);
MySqlCommand^ cmdDataBase = gcnew MySqlCommand("INSERT INTO `university`.`student` (`id`,`name`,`password`) values('"+this->id_txt->Text+"','"+this->name_txt->Text+"','"+this->password_txt->Text+"' ;", conDataBase);
//MySqlCommand^ cmdDataBase = gcnew MySqlCommand("INSERT INTO `university`.`student` (`id`, `name`, `password`) VALUES ('7', 'ah', '77'); ", conDataBase);
c++ mysql visual-studio-2017
asked Nov 21 '18 at 22:40
SazzadSazzad
11
sir, I'm Using vs2017 and MySql 8.0 and I am trying to insert data from windows form application in c++, the project was run properly, but the query is not correct. I guess, when I insert data and click the save button I created, it says: enter image description here
"you have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near " at line 1"
But I can insert data from the code manually (you can see the comment in the code which work), but i can not insert from the form! I done everything according to this video tutorial
Now how can I do that? please anybody help me, my code is here:
private: System::Void button5_Click(System::Object^ sender, System::EventArgs^ e) {
String^ constring = L"datasource= 127.0.0.1; port= 3306;username=root;password=12712";
MySqlConnection^ conDataBase = gcnew MySqlConnection(constring);
MySqlCommand^ cmdDataBase = gcnew MySqlCommand("INSERT INTO `university`.`student` (`id`,`name`,`password`) values('"+this->id_txt->Text+"','"+this->name_txt->Text+"','"+this->password_txt->Text+"' ;", conDataBase);
//MySqlCommand^ cmdDataBase = gcnew MySqlCommand("INSERT INTO `university`.`student` (`id`, `name`, `password`) VALUES ('7', 'ah', '77'); ", conDataBase);
c++ mysql visual-studio-2017
c++ mysql visual-studio-2017
asked Nov 21 '18 at 22:40
SazzadSazzad
11
asked Nov 21 '18 at 22:40
SazzadSazzad
11
edited Nov 21 '18 at 23:20
Sazzad
asked Nov 21 '18 at 22:40
SazzadSazzad
11
asked Nov 21 '18 at 22:40
SazzadSazzad
11
asked Nov 21 '18 at 22:40
SazzadSazzad
11
11
Show the SQL error, and format the code. Show the table structure tooSHOW CREATE TABLE university.student.
– danblack
Nov 21 '18 at 22:54
Sir, I have edited my post? Is it okey now? Do I also attach the screenshot of the sql error?
– Sazzad
Nov 21 '18 at 23:08
Sir, I also have attach the database table and sql error in the screenshot
– Sazzad
Nov 21 '18 at 23:16
@Sazzad Print and share formated query. Guess you have problem(s) with formating the query.
– SilvioCro
Nov 21 '18 at 23:18
I also think, the problem is with the query, But I'm surprised same code worked in the tutorial I've share here, he done that in vs10, and I've check and recheck the code that I've done all the same as the tutorial. Now I don't understand why the same come should not work for me..
– Sazzad
Nov 21 '18 at 23:29
add a comment |
Show the SQL error, and format the code. Show the table structure tooSHOW CREATE TABLE university.student.
– danblack
Nov 21 '18 at 22:54
Sir, I have edited my post? Is it okey now? Do I also attach the screenshot of the sql error?
– Sazzad
Nov 21 '18 at 23:08
Sir, I also have attach the database table and sql error in the screenshot
– Sazzad
Nov 21 '18 at 23:16
@Sazzad Print and share formated query. Guess you have problem(s) with formating the query.
– SilvioCro
Nov 21 '18 at 23:18
I also think, the problem is with the query, But I'm surprised same code worked in the tutorial I've share here, he done that in vs10, and I've check and recheck the code that I've done all the same as the tutorial. Now I don't understand why the same come should not work for me..
– Sazzad
Nov 21 '18 at 23:29
Show the SQL error, and format the code. Show the table structure too
SHOW CREATE TABLE university.student.– danblack
Nov 21 '18 at 22:54
Show the SQL error, and format the code. Show the table structure too
SHOW CREATE TABLE university.student.– danblack
Nov 21 '18 at 22:54
Sir, I have edited my post? Is it okey now? Do I also attach the screenshot of the sql error?
– Sazzad
Nov 21 '18 at 23:08
Sir, I have edited my post? Is it okey now? Do I also attach the screenshot of the sql error?
– Sazzad
Nov 21 '18 at 23:08
Sir, I also have attach the database table and sql error in the screenshot
– Sazzad
Nov 21 '18 at 23:16
Sir, I also have attach the database table and sql error in the screenshot
– Sazzad
Nov 21 '18 at 23:16
@Sazzad Print and share formated query. Guess you have problem(s) with formating the query.
– SilvioCro
Nov 21 '18 at 23:18
@Sazzad Print and share formated query. Guess you have problem(s) with formating the query.
– SilvioCro
Nov 21 '18 at 23:18
I also think, the problem is with the query, But I'm surprised same code worked in the tutorial I've share here, he done that in vs10, and I've check and recheck the code that I've done all the same as the tutorial. Now I don't understand why the same come should not work for me..
– Sazzad
Nov 21 '18 at 23:29
I also think, the problem is with the query, But I'm surprised same code worked in the tutorial I've share here, he done that in vs10, and I've check and recheck the code that I've done all the same as the tutorial. Now I don't understand why the same come should not work for me..
– Sazzad
Nov 21 '18 at 23:29
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53421429%2fcannot-insert-data-in-mysql-database-from-windows-form-application-in-c%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53421429%2fcannot-insert-data-in-mysql-database-from-windows-form-application-in-c%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Show the SQL error, and format the code. Show the table structure too
SHOW CREATE TABLE university.student.– danblack
Nov 21 '18 at 22:54
Sir, I have edited my post? Is it okey now? Do I also attach the screenshot of the sql error?
– Sazzad
Nov 21 '18 at 23:08
Sir, I also have attach the database table and sql error in the screenshot
– Sazzad
Nov 21 '18 at 23:16
@Sazzad Print and share formated query. Guess you have problem(s) with formating the query.
– SilvioCro
Nov 21 '18 at 23:18
I also think, the problem is with the query, But I'm surprised same code worked in the tutorial I've share here, he done that in vs10, and I've check and recheck the code that I've done all the same as the tutorial. Now I don't understand why the same come should not work for me..
– Sazzad
Nov 21 '18 at 23:29