title
MySQL VB.NET Tutorial 16 : How to Link Chart /Graph with Database

description
Creating graph in Windows Forms Application Mysql vb.net Data Binding a Chart to a Database visual basic Line chart in c# using data from database - Graph database for vb.NET How to Create Excel graphs using vb Program Creating graphs using visual studio Graph And Sql Data - C# Programming Using Chart Control in Visual Studio 2010 C beginners Creating graph in Windows Forms Application Charts in SQL Server Reporting Mysql Threaded plotting in Visual Studio visual basic with Windows Forms vb.net Windows Forms application How to reload a fastline chart using Windows.Forms Windows Charting Application Learn the Windows Forms Chart Control How do I plot data on a Chart in a CLR Form in C#?‎ Mysql how to draw line graph in .net?‎ Mysql Plot with visual studio C# express‎ Mysql

detail
{'title': 'MySQL VB.NET Tutorial 16 : How to Link Chart /Graph with Database', 'heatmap': [{'end': 314.788, 'start': 288.35, 'weight': 0.956}, {'end': 751.434, 'start': 713.769, 'weight': 0.733}, {'end': 867.423, 'start': 751.434, 'weight': 0.785}, {'end': 1060.574, 'start': 968.056, 'weight': 0.748}], 'summary': 'This tutorial series on mysql and vb.net demonstrates how to connect chart controls to a mysql database, customize charts by changing series name and properties, establish a mysql database connection, fetch and load data to a chart control, and customize the x versus y axis chart by setting interval property to 1, rotating x-axis label to -90 degrees, and aligning and labeling chart with database values.', 'chapters': [{'end': 556.01, 'segs': [{'end': 31.751, 'src': 'embed', 'start': 0.71, 'weight': 0, 'content': [{'end': 2.271, 'text': 'hello, guys, welcome once again.', 'start': 0.71, 'duration': 1.561}, {'end': 14.321, 'text': "in this video, I'm going to show you how to add charts or graph with your visual basic windows form application in connection with MySQL database.", 'start': 2.271, 'duration': 12.05}, {'end': 21.947, 'text': "basically, in this video, I'm going to show you how to connect your chart controls in visual basic to your MySQL database.", 'start': 14.321, 'duration': 7.626}, {'end': 24.008, 'text': "So let's get started.", 'start': 22.947, 'duration': 1.061}, {'end': 31.751, 'text': 'First of all I will go to my toolbox and I will search for the control called chart.', 'start': 24.448, 'duration': 7.303}], 'summary': 'Demonstrating how to connect chart controls in visual basic to mysql database.', 'duration': 31.041, 'max_score': 0.71, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/h3nHrZxDub8/pics/h3nHrZxDub8710.jpg'}, {'end': 231.843, 'src': 'embed', 'start': 190.926, 'weight': 2, 'content': [{'end': 209.423, 'text': 'I will select the property called series and I will click this and I will change the name of the series by going here and I can change the name of the series as name versus age.', 'start': 190.926, 'duration': 18.497}, {'end': 224.054, 'text': 'so I will say name vs age, for example, And I can change other properties like what kind of chart I want.', 'start': 209.423, 'duration': 14.631}, {'end': 229.38, 'text': 'I want column chart or I want line chart or other kind of chart.', 'start': 224.154, 'duration': 5.226}, {'end': 231.843, 'text': 'So right now I want column chart.', 'start': 229.481, 'duration': 2.362}], 'summary': "Select series property, change name to 'name vs age', and choose column chart.", 'duration': 40.917, 'max_score': 190.926, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/h3nHrZxDub8/pics/h3nHrZxDub8190926.jpg'}, {'end': 314.788, 'src': 'heatmap', 'start': 288.35, 'weight': 0.956, 'content': [{'end': 298.992, 'text': 'Now in here I will just double click this button and in here what I will do is first of all I need to make connection with the database right.', 'start': 288.35, 'duration': 10.642}, {'end': 301.253, 'text': 'So what I will do here is.', 'start': 299.792, 'duration': 1.461}, {'end': 314.788, 'text': 'I will copy and paste the skeleton which I have been showing you in many of the last videos,', 'start': 304.58, 'duration': 10.208}], 'summary': 'Demonstrating database connection process using code.', 'duration': 26.438, 'max_score': 288.35, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/h3nHrZxDub8/pics/h3nHrZxDub8288350.jpg'}, {'end': 463.537, 'src': 'embed', 'start': 369.835, 'weight': 1, 'content': [{'end': 380.382, 'text': 'so i will write mysqlcon dot connection string is equal to whatever my server credentials are, which is server is equal to localhost,', 'start': 369.835, 'duration': 10.547}, {'end': 389.747, 'text': 'my user ID for my server and password for my server and the database name of the database right.', 'start': 381.222, 'duration': 8.525}, {'end': 398.732, 'text': 'and then I have declared a MySQL data reader variable, which is dim reader as MySQL data reader.', 'start': 389.747, 'duration': 8.985}, {'end': 403.016, 'text': 'and And then I have declared a try catch block here.', 'start': 398.732, 'duration': 4.284}, {'end': 411.045, 'text': "Right So this try catch block I'm using to catch any exception while executing the query.", 'start': 403.657, 'duration': 7.388}, {'end': 416.771, 'text': "Okay So here I'm catching the exception which is a MySQL exception.", 'start': 412.006, 'duration': 4.765}, {'end': 425.635, 'text': 'Right, finally, when my query is executed perfectly or it throws any exception.', 'start': 416.831, 'duration': 8.804}, {'end': 434.298, 'text': "finally, what I'm doing is I'm disposing my connection so I MySQL can be ready for the next connection.", 'start': 425.635, 'duration': 8.663}, {'end': 437.14, 'text': "and finally I'm ending my tries.", 'start': 434.298, 'duration': 2.842}, {'end': 439.22, 'text': 'so just add this try,', 'start': 437.14, 'duration': 2.08}, {'end': 452.049, 'text': 'catch block in the strike edge block my code start from opening the connection to the database and ends with closing the connection to the database.', 'start': 439.22, 'duration': 12.829}, {'end': 463.537, 'text': 'right. so just write mycon.open, which opens the connection with the database, and mycon.close, which closes the connection with the database.', 'start': 452.049, 'duration': 11.488}], 'summary': 'Code connects to mysql database, handles exceptions, and manages connections.', 'duration': 93.702, 'max_score': 369.835, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/h3nHrZxDub8/pics/h3nHrZxDub8369835.jpg'}], 'start': 0.71, 'title': 'Visual basic, mysql, and chart customization', 'summary': 'Covers connecting chart controls in visual basic to a mysql database, adding charts to a windows form application, customizing charts by changing series name and properties, and plotting data from a database table. it also explains the process of establishing a mysql database connection, including declaring the connection instance, constructing the connection string, executing queries, and handling exceptions.', 'chapters': [{'end': 96.938, 'start': 0.71, 'title': 'Visual basic: adding charts with mysql', 'summary': 'Demonstrates how to connect chart controls in visual basic to mysql database and add charts to a windows form application, along with mentioning the availability of additional tutorials on the topic.', 'duration': 96.228, 'highlights': ['The video focuses on adding charts or graphs to a Visual Basic Windows form application in connection with a MySQL database.', 'It explains how to connect chart controls in Visual Basic to a MySQL database and demonstrates the process of adding a chart control to the form.', 'The tutorial also references additional resources for learning about using chart controls with Visual Basic, available in a separate playlist on the channel.']}, {'end': 301.253, 'start': 96.938, 'title': 'Customizing chart and plotting data', 'summary': 'Demonstrates customizing a chart by changing the series name and properties, and plotting a bar chart for name versus age from a database table.', 'duration': 204.315, 'highlights': ["The process involves changing the series name of the chart to 'name versus age' and customizing properties like chart type, background color, and border.", "Demonstrating how to plot a bar chart for name versus age by making a connection with the database and referencing the chart name 'chart 1'."]}, {'end': 556.01, 'start': 304.58, 'title': 'Mysql database connection', 'summary': 'Explains the process of establishing a mysql database connection, including declaring the connection instance, constructing the connection string, executing queries, and handling exceptions.', 'duration': 251.43, 'highlights': ['The process of establishing a MySQL database connection, including declaring the connection instance, constructing the connection string, executing queries, and handling exceptions.', 'Declaring the connection instance of mysql connection and explaining the code for the connection string which helps to connect to the mysql server.', 'Demonstrating the use of try-catch block to catch any exceptions while executing the query.', 'Explaining the process of opening and closing the connection with the database using mycon.open and mycon.close.']}], 'duration': 555.3, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/h3nHrZxDub8/pics/h3nHrZxDub8710.jpg', 'highlights': ['The video focuses on adding charts or graphs to a Visual Basic Windows form application in connection with a MySQL database.', 'The process of establishing a MySQL database connection, including declaring the connection instance, constructing the connection string, executing queries, and handling exceptions.', "The process involves changing the series name of the chart to 'name versus age' and customizing properties like chart type, background color, and border.", 'Demonstrating the use of try-catch block to catch any exceptions while executing the query.', 'Explaining the process of opening and closing the connection with the database using mycon.open and mycon.close.']}, {'end': 813.202, 'segs': [{'end': 597.801, 'src': 'embed', 'start': 556.01, 'weight': 0, 'content': [{'end': 566.478, 'text': 'execute reader and then i will fetch my data using while loop one by one.', 'start': 556.01, 'duration': 10.468}, {'end': 570.924, 'text': 'so it will fetch row by row data and this while loop.', 'start': 566.478, 'duration': 4.446}, {'end': 581.953, 'text': 'in this while loop i will Fetch my data and I will Write some code which will load my data to the chart control right.', 'start': 570.924, 'duration': 11.029}, {'end': 587.596, 'text': 'so just write while reader dot read and And the while loop.', 'start': 581.953, 'duration': 5.643}, {'end': 597.801, 'text': 'and in between this while loop we will write a code to load age and name to the chart.', 'start': 587.596, 'duration': 10.205}], 'summary': 'Using a while loop, data is fetched row by row and loaded into a chart control.', 'duration': 41.791, 'max_score': 556.01, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/h3nHrZxDub8/pics/h3nHrZxDub8556010.jpg'}, {'end': 780.166, 'src': 'heatmap', 'start': 713.769, 'weight': 1, 'content': [{'end': 721.154, 'text': 'just copy this reader variable and paste it here dot, not here.', 'start': 713.769, 'duration': 7.385}, {'end': 733.662, 'text': "but i'll write dot, here dot, get string, and in the bracket i will write the name of my name.", 'start': 721.154, 'duration': 12.508}, {'end': 734.363, 'text': 'column right.', 'start': 733.662, 'duration': 0.701}, {'end': 740.407, 'text': 'so the column I want to show on the x-axis, which is name.', 'start': 735.043, 'duration': 5.364}, {'end': 745.29, 'text': 'the column of my name is name itself.', 'start': 740.407, 'duration': 4.883}, {'end': 751.434, 'text': 'so just copy the title of the column and just paste it here.', 'start': 745.29, 'duration': 6.144}, {'end': 758.339, 'text': 'and as a second argument I want to add the age right.', 'start': 751.434, 'duration': 6.905}, {'end': 771.002, 'text': 'so I will write reader dot, get int 32, because age is the integer data type right.', 'start': 758.339, 'duration': 12.663}, {'end': 780.166, 'text': 'so if you can see my declaration of the column age, age is my integer data type.', 'start': 771.002, 'duration': 9.164}], 'summary': 'Using reader.getstring() and reader.getint32() to display name and age columns on x-axis.', 'duration': 133.105, 'max_score': 713.769, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/h3nHrZxDub8/pics/h3nHrZxDub8713769.jpg'}], 'start': 556.01, 'title': 'Chart data loading process and fetching data for x and y axes', 'summary': "Discusses the process of fetching and loading data to a chart control using a while loop and executing reader, with a focus on loading name versus age chart data in the x and y-axis. it also covers fetching data from the 'name' column for the x-axis and the 'age' column for the y-axis by using 'reader.getstring' and 'reader.getint32', emphasizing the data types and column names.", 'chapters': [{'end': 688.564, 'start': 556.01, 'title': 'Chart data loading process', 'summary': 'Discusses the process of fetching and loading data to a chart control using a while loop and executing reader, with a focus on loading name versus age chart data in the x and y-axis.', 'duration': 132.554, 'highlights': ['The process involves executing a reader to fetch data row by row using a while loop.', 'The code involves loading name versus age chart data by assigning name data to the x-axis and age data to the y-axis.']}, {'end': 813.202, 'start': 688.564, 'title': 'Fetching data for x and y axes', 'summary': "Discusses fetching data from the 'name' column for the x-axis and the 'age' column for the y-axis by using 'reader.getstring' and 'reader.getint32', emphasizing the data types and column names.", 'duration': 124.638, 'highlights': ["Using 'reader.getString' to fetch data for the x-axis from the 'name' column.", "Using 'reader.getInt32' to fetch data for the y-axis from the 'age' column.", "Emphasizing the data type of the 'age' column as integer."]}], 'duration': 257.192, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/h3nHrZxDub8/pics/h3nHrZxDub8556010.jpg', 'highlights': ['The process involves executing a reader to fetch data row by row using a while loop.', 'The code involves loading name versus age chart data by assigning name data to the x-axis and age data to the y-axis.', "Using 'reader.getInt32' to fetch data for the y-axis from the 'age' column.", "Using 'reader.getString' to fetch data for the x-axis from the 'name' column.", "Emphasizing the data type of the 'age' column as integer."]}, {'end': 1138.302, 'segs': [{'end': 920.292, 'src': 'embed', 'start': 813.422, 'weight': 0, 'content': [{'end': 829.719, 'text': 'So you just need to write one extra line in your MySQL code skeleton to load the data for bar chart which is X versus Y chart you can say.', 'start': 813.422, 'duration': 16.297}, {'end': 832.502, 'text': "Now I'm going to run my program.", 'start': 830.76, 'duration': 1.742}, {'end': 846.534, 'text': 'and I will give username and password It is correct.', 'start': 840.285, 'duration': 6.249}, {'end': 858.239, 'text': 'And when I click this load chart button, my name versus age chart must be plotted in this chart control.', 'start': 848.355, 'duration': 9.884}, {'end': 861.26, 'text': "So let's press this load chart button.", 'start': 858.259, 'duration': 3.001}, {'end': 867.423, 'text': 'And you can see the name versus age chart is here.', 'start': 862.281, 'duration': 5.142}, {'end': 870.044, 'text': "So let's verify.", 'start': 868.403, 'duration': 1.641}, {'end': 881.218, 'text': 'So you can see here the ages are here and the names are here.', 'start': 874.116, 'duration': 7.102}, {'end': 893.121, 'text': 'But the problem is my chart is too big as compared to the size I have assigned to my chart right.', 'start': 882.098, 'duration': 11.023}, {'end': 895.062, 'text': 'So what can I do is.', 'start': 893.881, 'duration': 1.181}, {'end': 905.22, 'text': 'For now I am going to make my form bigger so that it can show all the data in the chart.', 'start': 898.274, 'duration': 6.946}, {'end': 911.585, 'text': 'So I have made this chart little bit wider.', 'start': 906.12, 'duration': 5.465}, {'end': 920.292, 'text': 'Okay Okay.', 'start': 911.605, 'duration': 8.687}], 'summary': 'Mysql code loads x versus y chart for name versus age. chart control displays data but chart size needs adjustment.', 'duration': 106.87, 'max_score': 813.422, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/h3nHrZxDub8/pics/h3nHrZxDub8813422.jpg'}, {'end': 1082.615, 'src': 'heatmap', 'start': 968.056, 'weight': 3, 'content': [{'end': 980.222, 'text': 'so I will go to the property called chart area and just click this collection button here and I will go to the property in here,', 'start': 968.056, 'duration': 12.166}, {'end': 986.686, 'text': 'which is for let me see the interval property.', 'start': 980.222, 'duration': 6.464}, {'end': 990.828, 'text': "I'm searching for the interval property.", 'start': 986.686, 'duration': 4.142}, {'end': 1001.549, 'text': "so first what I'm going to do is I will go to the property called access.", 'start': 990.828, 'duration': 10.721}, {'end': 1013.172, 'text': 'so just select this access collection here and once again click this button, and in here I will search for the property called interval.', 'start': 1001.549, 'duration': 11.623}, {'end': 1016.993, 'text': 'by default, this property is auto instead of auto.', 'start': 1013.172, 'duration': 3.821}, {'end': 1019.174, 'text': 'just make this as one.', 'start': 1016.993, 'duration': 2.181}, {'end': 1029.358, 'text': 'This 1 means for every x value you will have the y value.', 'start': 1020.094, 'duration': 9.264}, {'end': 1034.382, 'text': 'So you will see what I mean by giving 1 here.', 'start': 1029.878, 'duration': 4.504}, {'end': 1041.365, 'text': 'what next you may want to do is the label style.', 'start': 1036.162, 'duration': 5.203}, {'end': 1052.27, 'text': 'so just select this label style and select this triangle button here and just set this angle as minus 90 degree.', 'start': 1041.365, 'duration': 10.905}, {'end': 1060.574, 'text': 'what this minus 90 degree will do is it will rotate your x-axis label to minus 90 degree.', 'start': 1052.27, 'duration': 8.304}, {'end': 1076.81, 'text': 'now i will click ok and click ok once again, and when i run the program once again now and when I load my X versus Y axis chart,', 'start': 1061.434, 'duration': 15.376}, {'end': 1082.615, 'text': 'you can see all the names versus age correctly now.', 'start': 1076.81, 'duration': 5.805}], 'summary': 'Configured chart properties: interval to 1, label style to -90 degree, now displays names vs. age correctly.', 'duration': 81.066, 'max_score': 968.056, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/h3nHrZxDub8/pics/h3nHrZxDub8968056.jpg'}, {'end': 1138.302, 'src': 'embed', 'start': 1120.478, 'weight': 5, 'content': [{'end': 1126.86, 'text': 'So you can match the values and you can see here all the values are correct here.', 'start': 1120.478, 'duration': 6.382}, {'end': 1134.421, 'text': 'So in this way you can load your chart with the database value using your Visual Basic Windows Form application.', 'start': 1127.48, 'duration': 6.941}, {'end': 1136.502, 'text': 'I hope you have enjoyed this video.', 'start': 1135.141, 'duration': 1.361}, {'end': 1138.302, 'text': 'Please rate, comment and subscribe and bye for now.', 'start': 1136.522, 'duration': 1.78}], 'summary': 'Load database values into chart using visual basic windows form application.', 'duration': 17.824, 'max_score': 1120.478, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/h3nHrZxDub8/pics/h3nHrZxDub81120478.jpg'}], 'start': 813.422, 'title': 'Mysql & chart customization', 'summary': 'Covers loading x versus y chart data into a mysql program, adjusting chart size, addressing display issues, customizing x versus y axis chart by setting interval property to 1, rotating x-axis label to -90 degrees, and correctly aligning and labeling chart with database values.', 'chapters': [{'end': 966.656, 'start': 813.422, 'title': 'Mysql chart data loading', 'summary': 'Demonstrates the process of loading x versus y chart data into a mysql program, adjusting chart size, and addressing issues with data display and form size.', 'duration': 153.234, 'highlights': ['The chapter demonstrates the process of loading X versus Y chart data into a MySQL program', 'Adjusting chart size to fit the data', 'Addressing issues with data display and form size']}, {'end': 1138.302, 'start': 968.056, 'title': 'Customizing x versus y axis chart', 'summary': 'Demonstrates how to customize the x versus y axis chart by setting the interval property to 1, rotating the x-axis label to -90 degrees, and loading the chart with database values, resulting in correctly aligned and labeled chart with database values.', 'duration': 170.246, 'highlights': ['By setting the interval property to 1, every x value will have the corresponding y value, ensuring correct alignment and labeling of the chart with database values.', 'Rotating the x-axis label to -90 degrees ensures the correct vertical alignment of the labels on the chart.', 'Loading the chart with database values allows for verification and validation of the correctness of the displayed data, ensuring accurate representation of the database values.']}], 'duration': 324.88, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/h3nHrZxDub8/pics/h3nHrZxDub8813422.jpg', 'highlights': ['Loading X versus Y chart data into a MySQL program', 'Adjusting chart size to fit the data', 'Addressing issues with data display and form size', 'Setting the interval property to 1 for correct alignment and labeling', 'Rotating x-axis label to -90 degrees for vertical alignment', 'Loading the chart with database values for verification and validation']}], 'highlights': ['The video focuses on adding charts or graphs to a Visual Basic Windows form application in connection with a MySQL database.', 'The process of establishing a MySQL database connection, including declaring the connection instance, constructing the connection string, executing queries, and handling exceptions.', "The process involves changing the series name of the chart to 'name versus age' and customizing properties like chart type, background color, and border.", 'The process involves executing a reader to fetch data row by row using a while loop.', 'The code involves loading name versus age chart data by assigning name data to the x-axis and age data to the y-axis.', 'Loading X versus Y chart data into a MySQL program', "Using 'reader.getInt32' to fetch data for the y-axis from the 'age' column.", "Using 'reader.getString' to fetch data for the x-axis from the 'name' column.", 'Setting the interval property to 1 for correct alignment and labeling', 'Rotating x-axis label to -90 degrees for vertical alignment', 'Explaining the process of opening and closing the connection with the database using mycon.open and mycon.close.', 'Demonstrating the use of try-catch block to catch any exceptions while executing the query.', 'Addressing issues with data display and form size', 'Loading the chart with database values for verification and validation', "Emphasizing the data type of the 'age' column as integer."]}