Accessing MySQL Database in VB.NET

hi there...

u mentioned in ur article : "To test this code, create a Windows application and add a DataGrid control to the form and write code listed in Listing 11-2 on the form load."

but i can only see Listing 1. so where can i find the Lingting 11 and 12?

thank you...

It supposed to be Listing1. I fixed it. Thanks.

how about... ADo.net and msql in to VB2005? & ADO.net and/or msql in to VCpp.net

the article is useful.....

this article really is reliable. thanks !

i was trying your code in listing 1 and i have this error on my vb.net code OdbcConnection not define what seems to be the problem?

hi mahesh I'm mehrdad from Iran Please tell me a reference for VB.net Database Sql server 2005 and asp.net thak you

Click on ADO.NET link in the left side bar on the home page of this site. ADO.NET section has many articles on database accessing using ADO.NET and VB.NET. Post your questions on the forums if you can't find your answer.

Dear Sir my name is samiullah im student of computer science in afhanistan. Dear sir i know some basic thing about vb.net and i have developed some small databases like for shops and schools. dear sir i wanna to learn vb.net more here in afghanistan are not smart teachers that i learn something new,if you dont mind would you please send some lecture that i learn something from your notes i wil be very glad best regard samiullah

This site and C# Corner are all filled with lot of tutorials and articles. Start with beginner section at the top and post your questions on the forums.

dear sir i forgot something to tell you that im make connectiveties with sqlserver2000 toward that send me lectures please sir bye

Mahesh, I notice that the codes for connecting to an access database are not as they were with VB6. I am trying to connect to an access database in ado.net. How is that done? That was a good article by the way!

Here is an article in C#. Conversion to VB.NET should be pretty straight forward:
http://www.c-sharpcorner.com/UploadFile/mimrantaj/Database102102008130743PM/Database1.aspx

Hi,
Any idea how to use the Chart forms and Mysql in VB .Net 2008-Express?
I’m referring to this library:
http://code.msdn.microsoft.com/mschart
I’m having trouble to bind the chart to my data, would be great if you can help


Here is my code writen in the form containing the chart form:
————————————————
Imports MySql.Data.MySqlClient
Imports MySql.Data
Imports System.Data

Public Class frmIVvsRLZ
Private Sub cmdChart_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdChart.Click
Dim rdr As MySqlDataReader
Dim conn As New MySqlConnection
Dim cmd As New MySqlCommand
Dim myAdapter As New MySqlDataAdapter
Dim SQL1 As String

conn.ConnectionString = My.Settings.connectionString

SQL1 = “SELECT CLOSINGDATE, HISTO10D FROM TBLHISTOVOLBBG WHERE EQUITY_ID=1845 ORDER BY CLOSINGDATE DESC”

Try
conn.Open()

Try

cmd.CommandText = SQL1
cmd.Connection = conn
rdr = cmd.ExecuteReader

chartHistoIVvsRLZ.DataSource = rdr

chartHistoIVvsRLZ.DataBind()

Catch myerror As MySqlException
MsgBox(“There was an error reading from the database: ” & myerror.Message)
End Try
Catch myerror As MySqlException
MessageBox.Show(“Error connecting to the database: ” & myerror.Message)
Finally
If conn.State ConnectionState.Closed Then conn.Close()
End Try
End Sub

End Class

--------------------------------

As well I teid this

------------------------------------------

Imports MySql.Data.MySqlClient
Imports MySql.Data
Imports System.Data
Public Class Form1

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
Dim query As String = “SELECT CLOSINGDATE, HISTO10D FROM TBLHISTOVOLBBG WHERE EQUITY_ID=1845 ORDER BY CLOSINGDATE DESC”
Dim connection As New MySqlConnection(My.Settings.connectionString)
Dim da As New MySqlDataAdapter(query, connection)
Dim ds As New DataSet()

If da.Fill(ds) Then
Chart1.DataSource = ds.Tables(0)
Chart1.DataBind()
End If
connection.Close()

Catch ex As Exception
Console.WriteLine(ex.Message)

End Try
End Sub
End Class

I have this code, and whenever i try it to RUN, I always get an error and it's like this........

ODBCEXCEPTION WAS UNHANDLED
ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.51b-community-nt]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 'char VALUES('101','noodles')' at line 1


How can i solve this..? below is my complete codes.... and by the way i can't see
MySql Odbc in my data source and if i try to add data source mysql doesn't appear..
I'm using VB2008 express edition... tnx

--------------------------------------------------------------------------------------------------------------------

'Imports System.ServiceProcess
Imports System
Imports Microsoft.Data.Odbc
Imports System.Data.SqlClient
Imports System.Data.SqlClient.SqlCommand
Imports MySql.Data.MySqlClient
Imports MySql.Data
Imports System.Data


Public Class Form1

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load



     


        Dim MyConString As String = "DRIVER={MySQL ODBC 5.1 Driver};" & _
                                    "SERVER=localhost;" & _
                                    "DATABASE=char;" & _
                                    "UID=root;" & _
                                    "PASSWORD=;" & _
                                    "OPTION=0;"
        Dim da As New OdbcDataAdapter

        Dim MyConnection As New OdbcConnection(MyConString)

        Dim MyCommand As New OdbcCommand

        MyConnection.Open()

        MyCommand.Connection = MyConnection
        MyCommand.CommandText = ("INSERT INTO char VALUES('101','1002')")
    
        MyCommand.ExecuteNonQuery()
     

        MyConnection.Close()
        MyConnection.Dispose()
        MyCommand.Dispose()

    End Sub
End Class

i hav vb.net 2005 and MySql as my database..
if anyone could share there code and sample appilcation on how to create a report Pls send me At tisoygyudko@yahoo.com
Or post it in here..

thanks..

Hi Mahesh Sir, i need help urgently on this please. “how to fetch time field values from mysql database through vb.net code??” i need to get those values and calculate running time for the day. +————-+————–+——+—–+————+——-+ here is the piece of code im currently working on. +————-+————–+——+—–+————+——-+ strQuery = “select IMEI,Pos_Date,Pos_Time,CountryCode,NetC,LAC,Cellid,SigStr,BattStr,Fuel_Level,ign,AI1,AI2,AI3,DI1,DG2,DG3,status from gensetfuel where imei=’” & imei & “‘ and Pos_Date=’” & dateSelected & “‘ Order by Pos_Time” +————-+————–+——+—–+————+——-+ sqlcomm = New MySqlCommand(strQuery, sqlcon) sqlreader = sqlcomm.ExecuteReader sqlcomm = New MySqlCommand(strQuery, sqlcon) sqlreader = sqlcomm.ExecuteReader +————-+————–+——+—–+————+——-+ If sqlreader.HasRows Then While sqlreader.Read() +————-+————–+——+—–+————+——-+ posDate = sqlreader.GetDateTime(1).ToString(“dd-MMM-yy”) If (firstreading) Then prevtime = sqlreader.GetDateTime(2) prevMovtime = prevtime firstreading = False End If +————-+————–+——+—–+————+——-+ time = sqlreader.GetDateTime(2) ignstate = sqlreader.GetValue(17) TimeDuration = DateDiff(DateInterval.Minute, prevtime, time) If TimeDuration > 10 Then ‘some code…. +————-+————–+——+—–+————+——-+ +————-+————–+——+—–+————+——-+ the values i am getttin for time and prevtime variables in vb.net code is 12:00:00AM and when i use datediff function i get the result as 0 database description of the table used is as: +————-+————–+——+—–+————+——-+ | Field | Type | Null | Key | Default | Extra | +————-+————–+——+—–+————+——-+ | IMEI | varchar(100) | NO | PRI | | | | Pos_Date | date | NO | PRI | 0000-00-00 | | | Pos_Time | time | NO | PRI | 00:00:00 | | | CountryCode | varchar(100) | YES | | NULL | | | NetC | varchar(100) | YES | | NULL | | | LAC | varchar(100) | YES | | NULL | | | Cellid | varchar(100) | YES | | NULL | | | SigStr | varchar(100) | YES | | NULL | | | BattStr | varchar(100) | YES | | NULL | | | Fuel_Level | varchar(100) | YES | | NULL | | | ign | varchar(100) | YES | | NULL | | | AI1 | varchar(100) | YES | | NULL | | | AI2 | varchar(100) | YES | | NULL | | | AI3 | varchar(100) | YES | | NULL | | | DI1 | varchar(100) | YES | | NULL | | | DG2 | varchar(100) | YES | | NULL | | | DG3 | varchar(100) | YES | | NULL | | | ser_inp | varchar(100) | YES | | NULL | | | status | varchar(100) | YES | | NULL | | +————-+————–+——+—–+————+——-+ +————-+————–+——+—–+————+——-+ the query mention above in the comment, strQuery=”select….” fetches me the correct set of records when fired on mysql command line client….........but its not giving the correct result through vb.net code…............. please help asap…............... thanks a tons in advance…...........vl b really obliged :o)

Hi, I want to use wampserver as our database for vb.net. Our project is all about library system. How can I do this? Can someone help me to do this for me. Thanks. Best Regards, jenie aranas