title
MySQL VB.NET Tutorial 6 : Insert/Save data to database

description
★★★Top Online Courses From ProgrammingKnowledge ★★★ Python Programming Course ➡️ http://bit.ly/2vsuMaS ⚫️ http://bit.ly/2GOaeQB Java Programming Course ➡️ http://bit.ly/2GEfQMf ⚫️ http://bit.ly/2Vvjy4a Bash Shell Scripting Course ➡️ http://bit.ly/2DBVF0C ⚫️ http://bit.ly/2UM06vF Linux Command Line Tutorials ➡️ http://bit.ly/2IXuil0 ⚫️ http://bit.ly/2IXukt8 C Programming Course ➡️ http://bit.ly/2GQCiD1 ⚫️ http://bit.ly/2ZGN6ej C++ Programming Course ➡️ http://bit.ly/2V4oEVJ ⚫️ http://bit.ly/2XMvqMs PHP Programming Course ➡️ http://bit.ly/2XP71WH ⚫️ http://bit.ly/2vs3od6 Android Development Course ➡️ http://bit.ly/2UHih5H ⚫️ http://bit.ly/2IMhVci C# Programming Course ➡️ http://bit.ly/2Vr7HEl ⚫️ http://bit.ly/2W6RXTU JavaFx Programming Course ➡️ http://bit.ly/2XMvZWA ⚫️ http://bit.ly/2V2CoAi NodeJs Programming Course ➡️ http://bit.ly/2GPg7gA ⚫️ http://bit.ly/2GQYTQ2 Jenkins Course For Developers and DevOps ➡️ http://bit.ly/2Wd4l4W ⚫️ http://bit.ly/2J1B1ug Scala Programming Tutorial Course ➡️ http://bit.ly/2PysyA4 ⚫️ http://bit.ly/2PCaVj2 Bootstrap Responsive Web Design Tutorial ➡️ http://bit.ly/2DFQ2yC ⚫️ http://bit.ly/2VoJWwH MongoDB Tutorial Course ➡️ http://bit.ly/2LaCJfP ⚫️ http://bit.ly/2WaI7Ap QT C++ GUI Tutorial For Beginners ➡️ http://bit.ly/2vwqHSZ ★★★ Online Courses to learn ★★★ Get 2 FREE Months of Unlimited Classes from skillshare - https://skillshare.eqcm.net/r1KEj Data Science - http://bit.ly/2lD9h5L | http://bit.ly/2lI8wIl Machine Learning - http://bit.ly/2WGGQpb | http://bit.ly/2GghLXX Artificial Intelligence - http://bit.ly/2lYqaYx | http://bit.ly/2NmaPya MERN Stack E-Degree Program - http://bit.ly/2kx2NFe | http://bit.ly/2lWj4no DevOps E-degree - http://bit.ly/2k1PwUQ | http://bit.ly/2k8Ypfy Data Analytics with R - http://bit.ly/2lBKqz8 | http://bit.ly/2lAjos3 AWS Certification Training - http://bit.ly/2kmLtTu | http://bit.ly/2lAkQL1 Projects in Java - http://bit.ly/2kzn25d | http://bit.ly/2lBMffs Machine Learning With TensorFlow - http://bit.ly/2m1z3AF | http://bit.ly/2lBMhnA Angular 8 - Complete Essential Guide - http://bit.ly/2lYvYRP Kotlin Android Development Masterclass - http://bit.ly/2GcblsI Learn iOS Programming Building Advance Projects - http://bit.ly/2kyX7ue ★★★ Follow ★★★ My Website - http://www.codebind.com DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This help support the channel and allows us to continue to make videos like this. Thank you for the support! How to: Insert New Records into a Database Database Access with Visual VB.NET.NET sql server - Insert Data into database in VB.NET How to insert Data to Ms SQL server 2008 using VB.NET.net .net - VB.NET insert data into SQL table Using Visual VB.NET and SQL cannot insert data into table..‎ VB.NET import data from text file into sql databse line by line‎ store xml in SQL Server 2008 from VB.NET‎ Using SQL in VB.NET - Cannot insert data into SQL table visual VB.NET - Could not Insert the data using V VB.NET in MYSQl Add, save & retrieve data in SQL insert data in sql 2005 from excel file through VB.NET asp.net‎ insert data into SQL table from pre filled boxes in VB.NET 4.0‎ insert into database unsing ado.net and VB.NET Visual Basic Insert DateTime into SQL Server using VB.NET Visual Basic Searches related to VB.NET insert data into sql Visual Basic VB.NET insert data into sql table Visual Basic VB.NET insert data into sql server Visual Basic inserting data into sql table Visual Basic insert query VB.NET sql insert statement from another table

detail
{'title': 'MySQL VB.NET Tutorial 6 : Insert/Save data to database', 'heatmap': [{'end': 242.755, 'start': 218.012, 'weight': 0.796}, {'end': 588.276, 'start': 547.844, 'weight': 0.779}, {'end': 616.612, 'start': 590.898, 'weight': 0.727}, {'end': 898.597, 'start': 868.2, 'weight': 0.749}, {'end': 1012.273, 'start': 948.69, 'weight': 0.704}], 'summary': 'The tutorial covers saving data in a mysql database through a visual basic windows form application, connecting to the database, reusing code for mysql connection, handling a mysql data reader in c#, and constructing sql queries for data insertion, along with details on saving data in a vb.net application connected to mysql, adding a total of 16 employee ids.', 'chapters': [{'end': 310.346, 'segs': [{'end': 68.419, 'src': 'embed', 'start': 1.089, 'weight': 0, 'content': [{'end': 2.252, 'text': 'Hello guys, welcome once again.', 'start': 1.089, 'duration': 1.163}, {'end': 9.532, 'text': 'In the last few videos I have been showing you how to create a login page using your Visual Basic Windows Form application.', 'start': 2.333, 'duration': 7.199}, {'end': 12.656, 'text': 'mysql database.', 'start': 10.915, 'duration': 1.741}, {'end': 21.463, 'text': 'so till now I have shown you how to check connection with the database and it shows the message successful connection.', 'start': 12.656, 'duration': 8.807}, {'end': 33.412, 'text': 'if our visual basic project is connected to the database and validate username and password with the database as a username and password,', 'start': 21.463, 'duration': 11.949}, {'end': 41.802, 'text': 'and when I click login button, and if the username and password matches the username and password in the database, it opens the second form.', 'start': 33.412, 'duration': 8.39}, {'end': 51.608, 'text': 'Now, in this video, I am going to show you how to save your data in the database using these text boxes and this button.', 'start': 42.502, 'duration': 9.106}, {'end': 59.493, 'text': 'So, suppose you want to add some data in the database using your Visual Basic Windows Form application.', 'start': 52.368, 'duration': 7.125}, {'end': 62.935, 'text': 'In this video, I will show you exactly that.', 'start': 60.073, 'duration': 2.862}, {'end': 64.796, 'text': "So, let's get started.", 'start': 63.795, 'duration': 1.001}, {'end': 68.419, 'text': 'so, in the last video itself,', 'start': 66.537, 'duration': 1.882}], 'summary': 'Demonstrating creating a login page using visual basic, connecting to mysql database, and saving data using text boxes and buttons.', 'duration': 67.33, 'max_score': 1.089, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg1089.jpg'}, {'end': 135.485, 'src': 'embed', 'start': 104.873, 'weight': 1, 'content': [{'end': 116.409, 'text': 'I have the database and I have the table in the database called eData and I have this column eID, name, surname and age and other username, password,', 'start': 104.873, 'duration': 11.536}, {'end': 118.572, 'text': 'gender, date of birth and other things.', 'start': 116.409, 'duration': 2.163}, {'end': 127.278, 'text': 'Suppose I want to enter some new data for EID, name, surname and age.', 'start': 119.451, 'duration': 7.827}, {'end': 135.485, 'text': 'So till now I have 14 entries in the database till employee ID 14.', 'start': 128.258, 'duration': 7.227}], 'summary': 'Database contains edata table with 14 entries for employee id, name, surname, and age.', 'duration': 30.612, 'max_score': 104.873, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg104873.jpg'}, {'end': 310.346, 'src': 'heatmap', 'start': 218.012, 'weight': 4, 'content': [{'end': 225.375, 'text': 'now just double click this button and in here we are going to write the code to save the data in the database.', 'start': 218.012, 'duration': 7.363}, {'end': 242.755, 'text': 'but first, as we have imported this mysqldata.mysqlclient, we need to once again import this to our second form.', 'start': 225.375, 'duration': 17.38}, {'end': 261.081, 'text': 'so just add this line or add this import to the second form import mysql.data.mysqlclient, and we need to declare these two variables.', 'start': 242.755, 'duration': 18.326}, {'end': 269.397, 'text': 'so I will just copy it and explain them at the top of your class.', 'start': 261.081, 'duration': 8.316}, {'end': 276.401, 'text': 'so after the declaration of public class form 2, you can declare these variables.', 'start': 269.397, 'duration': 7.004}, {'end': 289.268, 'text': 'first variable is dim mysqlcon as mysql connection, which is the connection to the database which will accomplish the connection to the database,', 'start': 276.401, 'duration': 12.867}, {'end': 299.722, 'text': 'and this is dim command as mysql command, which will help you to execute a query to the database.', 'start': 289.268, 'duration': 10.454}, {'end': 305.564, 'text': 'okay, so just add these two lines, as you have done in the form 1.', 'start': 299.722, 'duration': 5.842}, {'end': 310.346, 'text': "if you don't know how I have added these things and how I've used these things,", 'start': 305.564, 'duration': 4.782}], 'summary': 'Import mysql data, declare variables, and add code to save data in database.', 'duration': 84.971, 'max_score': 218.012, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg218012.jpg'}], 'start': 1.089, 'title': 'Saving data in visual basic using mysql and visual basic windows form application database entry', 'summary': 'Demonstrates saving data in a mysql database through a visual basic windows form application, adding labels and text boxes, and successfully connecting to the database. it also explains the process of adding a new entry up to employee id 14 and the necessary steps for adding employee id 15, detailing the creation of labels and text boxes for data entry, and the importation of libraries and declaration of variables for executing queries.', 'chapters': [{'end': 103.732, 'start': 1.089, 'title': 'Saving data in visual basic using mysql', 'summary': 'Demonstrates how to save data in a mysql database using visual basic windows form application, including the process of adding labels and text boxes and clicking the save button to add data. it also mentions the successful connection to the database and validating username and password.', 'duration': 102.643, 'highlights': ['The chapter demonstrates how to save data in a MySQL database using Visual Basic Windows Form application, including the process of adding labels and text boxes and clicking the save button to add data.', 'It also mentions the successful connection to the database and validating username and password.', 'The video shows how to create a login page using Visual Basic Windows Form application and MySQL database, and the successful connection message is displayed.', 'It illustrates the process of checking the connection with the database and validating username and password, ensuring that the username and password match the database entries.']}, {'end': 310.346, 'start': 104.873, 'title': 'Visual basic windows form application database entry', 'summary': 'Explains the process of adding a new entry to a database using a visual basic windows form application, which currently contains 14 entries, up to employee id 14, and requires the addition of employee id 15. it details the creation of labels and text boxes for entering data, the importation of the necessary libraries, and the declaration of variables for connection and executing queries.', 'duration': 205.473, 'highlights': ['Labels and text boxes are created for entering data such as EID, name, surname, and age, for the purpose of adding a new entry to the database, up to employee ID 15. (Relevance: 5)', "The process involves the importation of the 'mysql.data.mysqlclient' library, along with the declaration of variables 'mysqlcon as mysql connection' and 'command as mysql command' for establishing database connection and executing queries. (Relevance: 4)", "The form 2 requires the re-importation of 'mysql.data.mysqlclient' library and the declaration of variables 'mysqlcon as mysql connection' and 'command as mysql command' for database connection and query execution. (Relevance: 3)"]}], 'duration': 309.257, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg1089.jpg', 'highlights': ['The chapter demonstrates how to save data in a MySQL database using Visual Basic Windows Form application, including the process of adding labels and text boxes and clicking the save button to add data.', 'Labels and text boxes are created for entering data such as EID, name, surname, and age, for the purpose of adding a new entry to the database, up to employee ID 15.', 'It also mentions the successful connection to the database and validating username and password.', 'The video shows how to create a login page using Visual Basic Windows Form application and MySQL database, and the successful connection message is displayed.', "The process involves the importation of the 'mysql.data.mysqlclient' library, along with the declaration of variables 'mysqlcon as mysql connection' and 'command as mysql command' for establishing database connection and executing queries.", "The form 2 requires the re-importation of 'mysql.data.mysqlclient' library and the declaration of variables 'mysqlcon as mysql connection' and 'command as mysql command' for database connection and query execution.", 'It illustrates the process of checking the connection with the database and validating username and password, ensuring that the username and password match the database entries.']}, {'end': 520.394, 'segs': [{'end': 344.904, 'src': 'embed', 'start': 310.346, 'weight': 1, 'content': [{'end': 317.028, 'text': 'you can watch my last videos and you will be able to understand what I have done here.', 'start': 310.346, 'duration': 6.682}, {'end': 325.35, 'text': 'now, once again, in this button, click event, I want to write the code.', 'start': 317.028, 'duration': 8.322}, {'end': 335.828, 'text': "so what I am going to do is I'm going to copy the code which I have written in the login button action perform.", 'start': 325.35, 'duration': 10.478}, {'end': 344.904, 'text': 'this is the code I have shown you when I have shown you how to create a login page right.', 'start': 335.828, 'duration': 9.076}], 'summary': 'The speaker explains reusing code for a button click event and references previous login page creation.', 'duration': 34.558, 'max_score': 310.346, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg310346.jpg'}, {'end': 416.656, 'src': 'embed', 'start': 387.509, 'weight': 0, 'content': [{'end': 397.359, 'text': 'and while loop and now I will go to through the code and I will show you how to write the code.', 'start': 387.509, 'duration': 9.85}, {'end': 405.168, 'text': 'so in this button, click event, just create a new instance of your MySQL connection.', 'start': 397.359, 'duration': 7.809}, {'end': 411.973, 'text': 'so this is the variable which we have declared for MySQL connection.', 'start': 405.168, 'duration': 6.805}, {'end': 416.656, 'text': 'and in here you are creating the new instance of MySQL connection.', 'start': 411.973, 'duration': 4.683}], 'summary': 'Demonstrates creating a new instance of a mysql connection in a button click event.', 'duration': 29.147, 'max_score': 387.509, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg387509.jpg'}, {'end': 520.394, 'src': 'embed', 'start': 451.38, 'weight': 2, 'content': [{'end': 457.186, 'text': 'declare a variable called dim reader as mysql data reader.', 'start': 451.38, 'duration': 5.806}, {'end': 460.47, 'text': 'this will read the data from the database.', 'start': 457.186, 'duration': 3.284}, {'end': 464.974, 'text': 'so declare this here and in the try catch block.', 'start': 460.47, 'duration': 4.504}, {'end': 469.219, 'text': 'so just write a try and a catch block.', 'start': 464.974, 'duration': 4.245}, {'end': 481.886, 'text': 'So just write this skeleton here, which what basically do is, if any exception occurs while executing your query,', 'start': 470.7, 'duration': 11.186}, {'end': 489.25, 'text': 'it catches the exception and shows the message and once the query is executed,', 'start': 481.886, 'duration': 7.364}, {'end': 495.534, 'text': 'it disposes the connection so that you are ready to use it for the another connections.', 'start': 489.25, 'duration': 6.284}, {'end': 502.617, 'text': 'so just write this code and this try to catch the exception.', 'start': 496.134, 'duration': 6.483}, {'end': 512.74, 'text': 'so if you can copy and so you can pause the video and copy this code and this try block from here.', 'start': 502.617, 'duration': 10.123}, {'end': 516.041, 'text': 'now, in the try block, what we are going.', 'start': 512.74, 'duration': 3.301}, {'end': 520.394, 'text': 'what we are doing is we are opening the connection with the database.', 'start': 516.041, 'duration': 4.353}], 'summary': 'Declare mysql data reader variable, implement try-catch block, and open connection in try block to handle exceptions and dispose connection after query execution.', 'duration': 69.014, 'max_score': 451.38, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg451380.jpg'}], 'start': 310.346, 'title': 'Mysql connection and data reader in c#', 'summary': 'Discusses creating a mysql connection in a button click event, emphasizing reusing code and simplifying commands, along with handling a mysql data reader in c#, including exception handling and connection disposal.', 'chapters': [{'end': 447.975, 'start': 310.346, 'title': 'Creating mysql connection in button click event', 'summary': 'Discusses creating a mysql connection in a button click event, emphasizing the process of reusing code and simplifying commands to establish a connection with the mysql server.', 'duration': 137.629, 'highlights': ['The process involves reusing code from the login button action perform, with the focus on eliminating repeated commands and the while loop.', 'Creating a new instance of the MySQL connection in the button click event is demonstrated, with the explanation of setting the connection string to establish a connection with the MySQL server.']}, {'end': 520.394, 'start': 451.38, 'title': 'Handling mysql data reader in c#', 'summary': 'Explains the process of declaring and utilizing a mysql data reader variable in c#, including handling exceptions and connection disposal.', 'duration': 69.014, 'highlights': ['The chapter emphasizes declaring a variable called dim reader as mysql data reader to read data from the database.', 'The chapter instructs to write a try and catch block to handle exceptions while executing queries, ensuring that the connection is disposed after the query execution for reuse in another connection.']}], 'duration': 210.048, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg310346.jpg', 'highlights': ['Creating a new instance of the MySQL connection in the button click event with a connection string setup.', 'Emphasizing reusing code from the login button action perform to eliminate repeated commands and while loop.', 'Declaring a variable called dim reader as mysql data reader to read data from the database.', 'Instructing to write a try and catch block to handle exceptions while executing queries and ensuring connection disposal.']}, {'end': 878.386, 'segs': [{'end': 616.612, 'src': 'heatmap', 'start': 547.844, 'weight': 0, 'content': [{'end': 563.373, 'text': 'so I will delete my old query and I will write a new query here and I will say insert into database.edata.', 'start': 547.844, 'duration': 15.529}, {'end': 573.187, 'text': 'so this database is the name of my database, which is this database, and eData is my table name.', 'start': 565.382, 'duration': 7.805}, {'end': 575.188, 'text': 'so database.eData.', 'start': 573.187, 'duration': 2.001}, {'end': 588.276, 'text': 'right, insert into database.eData and then I will provide the column names in which I want to add my data.', 'start': 575.188, 'duration': 13.088}, {'end': 590.898, 'text': 'so first column name is eid.', 'start': 588.276, 'duration': 2.622}, {'end': 593.019, 'text': 'second column name is name.', 'start': 590.898, 'duration': 2.121}, {'end': 601.399, 'text': '3rd column name is surname and 4th column name is age right.', 'start': 594.193, 'duration': 7.206}, {'end': 616.612, 'text': 'so if you see my column names eid, name, surname and age and if you are wondering why I have written all these things in small letters.', 'start': 601.399, 'duration': 15.213}], 'summary': 'Creating a new query to insert data into database.edata with columns eid, name, surname, and age.', 'duration': 45.175, 'max_score': 547.844, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg547844.jpg'}, {'end': 669.602, 'src': 'embed', 'start': 631.979, 'weight': 4, 'content': [{'end': 637.121, 'text': 'so you can write this eid as capital also and small also.', 'start': 631.979, 'duration': 5.142}, {'end': 652.415, 'text': 'okay. so my query till now is insert into database dot e data and in the bracket i have enter the name of the column EID, name, surname and age.', 'start': 637.121, 'duration': 15.294}, {'end': 664.8, 'text': 'then I will write values and in the bracket I will pass the values which I will enter in the text box.', 'start': 652.415, 'duration': 12.385}, {'end': 669.602, 'text': 'so first value will be the name of the EID text box.', 'start': 664.8, 'duration': 4.802}], 'summary': 'Query to insert data into database with eid, name, surname, and age.', 'duration': 37.623, 'max_score': 631.979, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg631979.jpg'}, {'end': 851.152, 'src': 'embed', 'start': 820.154, 'weight': 2, 'content': [{'end': 827.92, 'text': 'and then in the bracket just write the name of the column in which you want to enter the data or save the data.', 'start': 820.154, 'duration': 7.766}, {'end': 834.384, 'text': 'so eid name, surname and age, which are the name of my column in my edata table.', 'start': 827.92, 'duration': 6.464}, {'end': 837.647, 'text': 'then write values.', 'start': 834.384, 'duration': 3.263}, {'end': 842.588, 'text': 'so i had some spelling mistakes.', 'start': 839.847, 'duration': 2.741}, {'end': 851.152, 'text': 'i have corrected values and in the bracket just write the name of your text box dot text.', 'start': 842.588, 'duration': 8.564}], 'summary': 'Explanation of entering data into columns, correcting spelling mistakes, and specifying text box input', 'duration': 30.998, 'max_score': 820.154, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg820154.jpg'}], 'start': 520.394, 'title': 'Inserting data into mysql database using vb.net and constructing sql query for data insertion', 'summary': 'Covers the process of inserting data into a mysql database using vb.net, including declaring a query, specifying column names, and providing values for insertion. it also provides a detailed guide for constructing an sql query to insert data into a table, with a focus on specifying the table name, column names, and values, as well as the correct syntax for text box names and their corresponding data input, emphasizing the importance of precision and accuracy in constructing the query.', 'chapters': [{'end': 766.501, 'start': 520.394, 'title': 'Insert data into mysql database using vb.net', 'summary': 'Covers the process of inserting data into a mysql database using vb.net, including declaring a query, specifying column names, and providing values for insertion.', 'duration': 246.107, 'highlights': ['The process begins by opening the connection to the MySQL database using mysqlcon.open, followed by declaring a string variable to hold the query.', "The query is structured to insert data into the 'eData' table within the specified database, with columns for 'eid', 'name', 'surname', and 'age'. The case insensitivity of SQL queries is highlighted as well.", 'The values to be inserted into the database are specified by referencing the respective text boxes and formatting them appropriately, emphasizing the use of single and double quotes.']}, {'end': 878.386, 'start': 766.501, 'title': 'Query for inserting data into table', 'summary': 'Provides a detailed guide for constructing an sql query to insert data into a table, with a focus on specifying the table name, column names, and values, as well as the correct syntax for text box names and their corresponding data input, emphasizing the importance of precision and accuracy in constructing the query.', 'duration': 111.885, 'highlights': ['The chapter provides a detailed guide for constructing an SQL query to insert data into a table, with a focus on specifying the table name, column names, and values.', 'Emphasizing the importance of precision and accuracy in constructing the query by specifying the correct syntax for text box names and their corresponding data input.', 'Clarifying the specific format for writing the SQL query, including the correct placement of table name, column names, and values, with a demonstration of the correct syntax for text box names and their corresponding data input.']}], 'duration': 357.992, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg520394.jpg', 'highlights': ['The process begins by opening the connection to the MySQL database using mysqlcon.open, followed by declaring a string variable to hold the query.', "The query is structured to insert data into the 'eData' table within the specified database, with columns for 'eid', 'name', 'surname', and 'age'. The case insensitivity of SQL queries is highlighted as well.", 'The chapter provides a detailed guide for constructing an SQL query to insert data into a table, with a focus on specifying the table name, column names, and values.', 'Emphasizing the importance of precision and accuracy in constructing the query by specifying the correct syntax for text box names and their corresponding data input.', 'The values to be inserted into the database are specified by referencing the respective text boxes and formatting them appropriately, emphasizing the use of single and double quotes.', 'Clarifying the specific format for writing the SQL query, including the correct placement of table name, column names, and values, with a demonstration of the correct syntax for text box names and their corresponding data input.']}, {'end': 1115.618, 'segs': [{'end': 905.28, 'src': 'embed', 'start': 878.386, 'weight': 0, 'content': [{'end': 892.215, 'text': 'then just write command is equal to new mysql command, which is this command variable which we have declared above right dim command as mysql command.', 'start': 878.386, 'duration': 13.829}, {'end': 898.597, 'text': 'so just write command is equal to new mysql command and in the bracket we pass two arguments.', 'start': 893.095, 'duration': 5.502}, {'end': 903.219, 'text': 'first is the query which we have written here this one copy and paste it here.', 'start': 898.597, 'duration': 4.622}, {'end': 905.28, 'text': 'and second is the connection with the database.', 'start': 903.219, 'duration': 2.061}], 'summary': 'Creating a new mysql command with two arguments: query and database connection.', 'duration': 26.894, 'max_score': 878.386, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg878386.jpg'}, {'end': 983.716, 'src': 'embed', 'start': 948.69, 'weight': 2, 'content': [{'end': 960.178, 'text': 'okay, so if your data is saved, then this message will be shown and if some exception occurs in saving the database,', 'start': 948.69, 'duration': 11.488}, {'end': 966.243, 'text': 'it will catch the exception here and it will show the error message from here.', 'start': 960.178, 'duration': 6.065}, {'end': 974.613, 'text': 'okay, so this is the code to save the data in the database.', 'start': 966.243, 'duration': 8.37}, {'end': 980.515, 'text': 'so if you want, you can pause the video and just copy this code from here.', 'start': 974.613, 'duration': 5.902}, {'end': 983.716, 'text': "okay, now I'm going to run my program.", 'start': 980.515, 'duration': 3.201}], 'summary': 'Code saves data in database, handles exceptions, and runs program.', 'duration': 35.026, 'max_score': 948.69, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg948690.jpg'}, {'end': 1012.273, 'src': 'heatmap', 'start': 948.69, 'weight': 0.704, 'content': [{'end': 960.178, 'text': 'okay, so if your data is saved, then this message will be shown and if some exception occurs in saving the database,', 'start': 948.69, 'duration': 11.488}, {'end': 966.243, 'text': 'it will catch the exception here and it will show the error message from here.', 'start': 960.178, 'duration': 6.065}, {'end': 974.613, 'text': 'okay, so this is the code to save the data in the database.', 'start': 966.243, 'duration': 8.37}, {'end': 980.515, 'text': 'so if you want, you can pause the video and just copy this code from here.', 'start': 974.613, 'duration': 5.902}, {'end': 983.716, 'text': "okay, now I'm going to run my program.", 'start': 980.515, 'duration': 3.201}, {'end': 987.537, 'text': 'it will open my first form, which is login form.', 'start': 983.716, 'duration': 3.821}, {'end': 994.599, 'text': 'I provide my username and password, which is correct, and it opens the second form.', 'start': 987.537, 'duration': 7.062}, {'end': 1008.751, 'text': 'now I will open my database, which is here, and till now I have employee id 14, so I have 14 employee ids already there.', 'start': 994.599, 'duration': 14.152}, {'end': 1012.273, 'text': 'now I want to enter the 15th employee id.', 'start': 1008.751, 'duration': 3.522}], 'summary': 'The program successfully saves data, opens forms, and manages 14 employee ids.', 'duration': 63.583, 'max_score': 948.69, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg948690.jpg'}, {'end': 1115.618, 'src': 'embed', 'start': 1044.54, 'weight': 1, 'content': [{'end': 1061.117, 'text': 'So just click this refresh button and now you can see whatever data you have entered here 15 mark and the surname Heinz and the age 34 is entered into the database.', 'start': 1044.54, 'duration': 16.577}, {'end': 1066.481, 'text': 'now, for example, I want to enter or add or save some more data.', 'start': 1061.117, 'duration': 5.364}, {'end': 1079.803, 'text': 'employee id 16 name is some name and surname is some.', 'start': 1066.481, 'duration': 13.322}, {'end': 1087.927, 'text': 'surname and age is, for example, 45 and I say save and data is saved.', 'start': 1079.803, 'duration': 8.124}, {'end': 1106.252, 'text': 'if you see this message data saved and once again I refresh my database and you can see here employee is 16 and name is Julie and surname is Peters and age is 45.', 'start': 1087.927, 'duration': 18.325}, {'end': 1113.937, 'text': 'So in this way, you can save the data into the database using your Visual Basic, Windows Form application and MySQL database.', 'start': 1106.252, 'duration': 7.685}, {'end': 1115.618, 'text': 'I hope you have enjoyed this video.', 'start': 1114.457, 'duration': 1.161}], 'summary': 'Data entry of 15 and 34, then 16 and 45 saved in mysql database.', 'duration': 71.078, 'max_score': 1044.54, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg1044540.jpg'}], 'start': 878.386, 'title': 'Saving data in mysql with vb.net', 'summary': 'Explains the process of saving data in a mysql database using a mysql command in vb.net, including writing the command, passing arguments, executing the command, and handling exceptions. it also demonstrates the process of entering and saving data in a visual basic application connected to a mysql database, adding employee ids, names, surnames, and ages, with a total of 16 employee ids currently in the database.', 'chapters': [{'end': 983.716, 'start': 878.386, 'title': 'Saving data in database with mysql command', 'summary': 'Explains the process of saving data in a database using a mysql command in vb.net, including writing the command, passing arguments, executing the command, and handling exceptions.', 'duration': 105.33, 'highlights': ['The process involves writing a command variable as new mysql command and passing two arguments: the query and the database connection.', "After executing the command, the message 'data saved' is shown, and exceptions are caught to display error messages.", 'The code demonstrates the process of saving data in a database using VB.NET and MySQL command.']}, {'end': 1115.618, 'start': 983.716, 'title': 'Data entry and saving in visual basic application', 'summary': 'Demonstrates the process of entering and saving data in a visual basic application connected to a mysql database, including adding employee ids, names, surnames, and ages, with a total of 16 employee ids currently in the database.', 'duration': 131.902, 'highlights': ['The process involves entering and saving data in a Visual Basic application connected to a MySQL database, with a total of 16 employee IDs currently in the database.', 'Upon entering and saving the data, a message confirming the successful data saving process is displayed.', 'The example demonstrates adding the 15th and 16th employee IDs, including their respective names, surnames, and ages, with the successful saving of the data.', 'The demonstration emphasizes the capability of the Visual Basic application to save data into the connected MySQL database, providing a practical illustration of the data entry and saving process.']}], 'duration': 237.232, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3lGLxo1jXjg/pics/3lGLxo1jXjg878386.jpg', 'highlights': ['The process involves writing a command variable as new mysql command and passing two arguments: the query and the database connection.', 'The process involves entering and saving data in a Visual Basic application connected to a MySQL database, with a total of 16 employee IDs currently in the database.', "After executing the command, the message 'data saved' is shown, and exceptions are caught to display error messages.", 'The example demonstrates adding the 15th and 16th employee IDs, including their respective names, surnames, and ages, with the successful saving of the data.', 'The code demonstrates the process of saving data in a database using VB.NET and MySQL command.']}], 'highlights': ['The tutorial covers saving data in a MySQL database using Visual Basic Windows Form application, including adding labels and text boxes.', 'The process involves writing a command variable as new mysql command and passing two arguments: the query and the database connection.', 'Creating a new instance of the MySQL connection in the button click event with a connection string setup.', 'The process begins by opening the connection to the MySQL database using mysqlcon.open, followed by declaring a string variable to hold the query.', 'Emphasizing reusing code from the login button action perform to eliminate repeated commands and while loop.', 'The chapter provides a detailed guide for constructing an SQL query to insert data into a table, with a focus on specifying the table name, column names, and values.', 'The example demonstrates adding the 15th and 16th employee IDs, including their respective names, surnames, and ages, with the successful saving of the data.', 'The process involves entering and saving data in a Visual Basic application connected to a MySQL database, with a total of 16 employee IDs currently in the database.', 'The video shows how to create a login page using Visual Basic Windows Form application and MySQL database, and the successful connection message is displayed.', "The process involves the importation of the 'mysql.data.mysqlclient' library, along with the declaration of variables 'mysqlcon as mysql connection' and 'command as mysql command' for establishing database connection and executing queries."]}