goo.gl/RFY5C2 : Subscribe to CodAffection goo.gl/ejEvDb : MS SQL CRUD Operations in SQL Server goo.gl/NhNQeZ :Export Excel in C# Applications goo.gl/WsgPbp :C# User Registration With DB
I found this to be an excellent , step-by-step guide to creating a CRUD application using c# in Visual Studio and mySql. I particularly liked the fact that you took the time to show the actual steps involved in setting up a new database and stored procedures in MySql and showed the C# code required to link things together. Thank you very much!
Thank you for the tutorial! I've searched lots of video already concerning this topic but yours is the first one I've seen where most of the codes were explained, so, it's really easy to follow.
Great video!! Really helped me to understand how to connect vs code to mysql. This video earned you a subscriber. Again Thanks. And I'm looking forward for more projects like this.
Can you make a video where you have to tabels with a relationship, one to many etc. and how you can show a entryfield in the GUI. Thanks a lot for this video, its GREAT ! :)
Bro your tutorials are so good easy to understand I request you to make a tutorial on like how to give product discount like 5%, 10%, 12%, etc depends customers visit to my medical retail pharmacy I hope you will help me
your tutorial is really great but I need to make the published program not project can you make a new tutorial for that (like for transferring our application to another computer)
I have an error like this , please tell me how to fix this : 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll The host localhost does not support SSL connections.
you teach so clearly, but i tried doing this and when i click the save button, i encountered unhandled MySqlException. it says "Access denied for user 'root'@'localhost' (using password: YES)" but i did exactly as you did yours :(
The connection string is this one: string connectionString = @"Server=localhost;Database=bookdb;Uid=root;Pwd=root;"; However when I test the program in Visual Studio 2017, I always get the same error after clicking the 'Search' button: i.postimg.cc/SNk9Vmfg/visualstudio-bookdb.png On the left you can see I successfully connected from Visual Studio to the bookdb from MySQL Workbench, but I'm unable to correctly connect from the project itself to the bookdb, even when the connectionstring seems to be all right Any ideas? Thanks
In the line mysqlCon.Open(); I get the error: System.NullReferenceException: 'Object reference not set to an instance of an object.' And I cannot find anything wrong in my connectionstring.
can someone please assist me i have followed the tutorial exactly how he did it but i keep getting this error....... An unhandled exception of type 'System.ArgumentException' occurred in System.Data.dll
goo.gl/RFY5C2 : Subscribe to CodAffection
goo.gl/ejEvDb : MS SQL CRUD Operations in SQL Server
goo.gl/NhNQeZ :Export Excel in C# Applications
goo.gl/WsgPbp :C# User Registration With DB
help me workbench dowload link
CodAffection, Can you do this again but this time it's on Postgresql.
I found this to be an excellent , step-by-step guide to creating a CRUD application using c# in Visual Studio and mySql. I particularly liked the fact that you took the time to show the actual steps involved in setting up a new database and stored procedures in MySql and showed the C# code required to link things together. Thank you very much!
My pleasure :)
YOU. SAVED. MY. LAZY. ASS. STUDENT. LIFE.
Ty sooo much dude...
HAHAHAHAHAHAAHHAHAHA
@@vekyy120 Daj me nemoj jebat, kolke su sanse 😂😂😂
Thank you for the tutorial! I've searched lots of video already concerning this topic but yours is the first one I've seen where most of the codes were explained, so, it's really easy to follow.
Thanks for your kind words.
Thank you so much. I've been looking for a straightforward tutorial on the subject that's easy to follow. You're awesome!
Glad you found the video helpful.
@@CodAffection Now I practice for exam. I learn to use the datagridview almost based on your videos. Thank you!
useful!
THANK YOU VERY MUCH !!! Fantastic example given by a fantastic tutor. Greetings from Greece.
Thank you.
Great video!! Really helped me to understand how to connect vs code to mysql. This video earned you a subscriber. Again Thanks. And I'm looking forward for more projects like this.
Beautiful.. Very informative and easy to understand.....
Really great tutorial, great explanations thank you
cool video keep up the amazing content
Excellent. Great. Thanks.
This really helped me out.
Thank you and I hope u keep doing videos like these.
This is an excellent tutorial. Thank you!
great video :3 thanks man
Thank you, My project needed to be portable só I used MySql in Xampp, and you helped me a lot.
Glad you found the video helpful.
hi, can u use this application in other pc without mysql ?? i mean do you have to install mysql in every system you want this on ?
This tutorial is fantastic. Thank you!
Pretty neat tutorial. Precise and right to the point. Thank's friend.
thhanks this helped me :)
THANK YOU SOOOOOO MUCH!!!!!!!
Thanks, man! Helped a lot :D, keep doing what you're doing :))
nice video, thank you
your tutorial is helping me, can u do the tutorial how to delete multiple data in data grid view thank you
That's Great. I already watched. I guess for MySQL you just use MySqlconnection instead
Can you make a video where you have to tabels with a relationship, one to many etc. and how you can show a entryfield in the GUI. Thanks a lot for this video, its GREAT ! :)
how about this video : ua-cam.com/video/1kT3KaZcNn8/v-deo.html
Very Nice!! Thank You so much. I learned a lot.
Glad you found the video helpful.
hello how did you get your Connection String. thank you so much.
Thank you so much! Was looking for video like this for a long time. Thanks, man
glad you found the video useful.
Thank you very much!
thank you for your good lecture!! it's really helpful!!!
you are welcome.
Great Tutorial Man :)
Muy buen tutorial!!
Gracias.
you're awesome
thank you
Super Video !
Bro your tutorials are so good easy to understand I request you to make a tutorial on like how to give product discount like 5%, 10%, 12%, etc depends customers visit to my medical retail pharmacy I hope you will help me
I LOVE YOU MY INDIAN BOY, THANK YOU SO MUCH MY FRIEND!!!!!!!
Thank alot
Very useful, tks!
I am glad you the video helpful
very awesome
thank you
you are welocme
Hello. It's fine example, but why don't you do it through classes?
Thank you very very very much for you kindness. Someday, when I become a software billionare I will remember you and reward you for this class.
That's very kind of you. keep learning and sharing.
Thanks for this tutorial can you do same in WPF .
your tutorial is really great but I need to make the published program not project can you make a new tutorial for that (like for transferring our application to another computer)
sure.
Excellent tutorial. It´s possible to do the same tutorial using dapper?
sure, here it is : ua-cam.com/video/4GJOKEG5PpA/v-deo.html
Hehe, I probably should have added my first comment to your other video here it seems like :)
Btw, do you think a login system could be created using the methods you used in this tutorial?
for login-logout you can try this : ua-cam.com/video/NX8-LhgFnUU/v-deo.html
So hard to understand with this accent but helpful...
I need to do this, but with WPF in a user control. Any insight on how that works?
try this : ua-cam.com/video/72366X1-heg/v-deo.html
Do you have login tutorial using mysql workbench?
yes. ua-cam.com/video/v283Kb80RjE/v-deo.html
Subscribed
I appreciate that :)
Show thanks
I don't have that mysql folder in my drive C do I need to download something so I can have that dll that needs to be added on the references part?
Yes, just install mySQL and you will be given a lot of tools (optional) Including the MySql connection net (the dll)
What did you do with datagridview, mine is breaking program, and displaying empty form, also cant connect with mysql?
I have an error like this , please tell me how to fix this : 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll
The host localhost does not support SSL connections.
you teach so clearly, but i tried doing this and when i click the save button, i encountered unhandled MySqlException. it says "Access denied for user 'root'@'localhost' (using password: YES)" but i did exactly as you did yours :(
The connection string is this one:
string connectionString = @"Server=localhost;Database=bookdb;Uid=root;Pwd=root;";
However when I test the program in Visual Studio 2017, I always get the same error after clicking the 'Search' button:
i.postimg.cc/SNk9Vmfg/visualstudio-bookdb.png
On the left you can see I successfully connected from Visual Studio
to the bookdb from MySQL Workbench, but I'm unable to correctly connect
from the project itself to the bookdb, even when the connectionstring
seems to be all right
Any ideas?
Thanks
In the line mysqlCon.Open(); I get the error: System.NullReferenceException: 'Object reference not set to an instance of an object.' And I cannot find anything wrong in my connectionstring.
video top recomendo a todos. do you know the way?
Dear sir, my search and delete button do not work. I just download your project, nothing is different
I'm having error but followed your video very close its on executionNoNQuary;
Error 1054 it says unknown column bookID in field list
Hey did you find the solution, I'm having the same problem.
GridFill(); is being mistake what to do plz suggest
Does it work on Visual Studio 2010?
how to fix the error when txtBookName shows an error " txtBookName doesnot exist in the current context" ....can anyone please help me.
how did you find this local server @"Server=localhost;Database=book;Uid=root;Pwd=123456;"; ???
please I would appreciate your help
it's configured while installing sql server instance.
i love you man, no homo
wait, how can u use that "txtBookName" and other txt. U dont even initialize it
I need to know too! My app doesnt work!
nevermind. I figure it out already
You should rename the name of textbox in your form dude :)
mysql workbench close when i click apply BookAddOrEdit procedures :/
I think I had the same problem before. try to reinstall workbench.
It did not help
:/
use different installer.
btw what's up with the search function? :v
What is the purpose of cancel
Can you give me the source code, because I can't open the project in my visual studio 2010... please..
I should have given the source code link in description. please check.
dgvbook.CurrentRow.Index is not coming up in VS 2017
can someone please assist me i have followed the tutorial exactly how he did it but i keep getting this error.......
An unhandled exception of type 'System.ArgumentException' occurred in System.Data.dll
pls check your db connection string.
it is exactly like yours
{
string connectionString = @"Server=localhost;Database=traveldb;Uid=root;Pwd="1234qqq";";
int bookID = 0;
public Form1()
{
InitializeComponent();
}
private void btnSave_Click(object sender, EventArgs e)
{
using (MySqlConnection mysqlCon = new MySqlConnection(connectionString))
{
mysqlCon.Open();
MySqlCommand mysqlCmd = new MySqlCommand("BookAddOrEdit", mysqlCon);
mysqlCmd.CommandType = CommandType.StoredProcedure;
mysqlCmd.Parameters.AddWithValue("BookID", bookID);
mysqlCmd.Parameters.AddWithValue("_BookName", txtBookName.Text.Trim());
mysqlCmd.Parameters.AddWithValue("_Author", txtAuthor.Text.Trim());
mysqlCmd.Parameters.AddWithValue("_Description", txtDescription.Text.Trim());
mysqlCmd.ExecuteNonQuery();
MessageBox.Show("submitted successfully");
}
}
pls watch this video to correct your connection string : ua-cam.com/video/WJ-CdeTGxp8/v-deo.html
does this work if the database is use is sql2014
yes
can you send me this code
Bro its not Skema its schema [pronounciation]
Schema is pronounced with a hard K sound
Please provide asp.net crud operation
here is asp.net mvc crud : ua-cam.com/video/_qIYBgWTlTo/v-deo.html
we also have tutorial on crud with web form and .net core.
how did you set the password
for sql server ?
Method name error in 149