Private Sub SubmitButton_Click(sender As Object, e As EventArgs) Handlesĭim command As New MySqlCommand("SELECT * FROM Employees WHERE EmployeeDate BETWEEN And MySqlDbType.Date).Value = MySqlDbType.Date).Value = DateTimePicker2.Valueĭim adapter As New MySqlDataAdapter(command) The source code is the following: - Imports ĭim connection As New MySqlConnection("server=localhost Port=3306 username=root Password=mypassword") I have managed to load/view the data, from the MySql database, into the DataGridView. One should ensure that the DataSource is MySQL Database in order to connect to the MySQL database. I had to install the following extensions: - MySQL for Visual Studio 1.2.7 and MySQL ConnectorNet 8.0.11. I am using a MySql Database which is connected to Visual Studio 2017 Professional (Community Edition) software with the project being written in VB.net. I tried to search stack overflow and I found a post but the solution did not work for me.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |