Ad:

VB.NET Discussion Thread
Unsolved
Views: 3868

Jul 18th, 2009

Retrieve data from MYSQL using VB.NET

Expand Post »

Hi ALL,

Plz tell me how to retrieve data from mysql using vb.net as frontend.
I created database in mysql and able to insert data from vb.net but i dont know how to retrieve data from mysql. Plz help me to perform this action. Plz post your reply for my question....

Regards,
Karthikeyan.

Similar Threads

retrieve data by VB.Net in VB.NET
Store and retrieve image from mysql db with JSP in JSP
Transfer data between 2 mySQL servers in VB.NET
How to retrieve data from one form to another/ through Data Base in VB.NET
retrieve data from MySQL in Visual Basic 4 / 5 / 6

cee_karthi

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Jun 2009

Permalink

Jul 18th, 2009

Re: Retrieve data from MYSQL using VB.NET

cee_karthi,
Which database product are using MYSQL or MSSQL? Post code if you have. Your source must be surrounded with bb code tags.

[code=vb.net]
.. statements..
[/code]

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

Jul 18th, 2009

Re: Retrieve data from MYSQL using VB.NET

Click to Expand / Collapse Quote originally posted by adatapost ...

cee_karthi,
Which database product are using MYSQL or MSSQL? Post code if you have. Your source must be surrounded with bb code tags.

[code=vb.net]
.. statements..
[/code]

Im using MYSQL. I indicated correctly in the first thread itself.

cee_karthi

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Jun 2009

Permalink

Jul 18th, 2009

Re: Retrieve data from MYSQL using VB.NET

Show us your code work.

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

Jul 18th, 2009

Re: Retrieve data from MYSQL using VB.NET

Check my blog post- http://dotnet.tekyt.info/?p=27

If you still have any doubts, feel free to ask

tuse

Reputation Points: 32

Solved Threads: 14

Junior Poster

Offline

173 posts
since Jul 2007

Permalink

Jul 18th, 2009

-1

Re: Retrieve data from MYSQL using VB.NET

Use SqlDataReader
and then ExecuteReader

Piya27

Reputation Points: 22

Solved Threads: 9

Junior Poster

Offline

112 posts
since Jun 2009

Permalink

Jul 20th, 2009

-1

Re: Retrieve data from MYSQL using VB.NET

hi cee_karthi,
if you hv been able to solved your problem..then please mark this thread as solved...

Piya27

Reputation Points: 22

Solved Threads: 9

Junior Poster

Offline

112 posts
since Jun 2009

Permalink

Sep 11th, 2009

-1

Re: Retrieve data from MYSQL using VB.NET

Click to Expand / Collapse Quote originally posted by cee_karthi ...

Hi ALL,

Plz tell me how to retrieve data from mysql using vb.net as frontend.
I created database in mysql and able to insert data from vb.net but i dont know how to retrieve data from mysql. Plz help me to perform this action. Plz post your reply for my question....

Regards,
Karthikeyan.

Hey cee_kathi,

Have u solved your problem in retriving data.. By the way i have my code here check it out:

Imports MySql.Data.MySqlClient
Imports System.Data
Public Class Form1
'Write your own Database code in VB .NET Tutorial using MySQL
'The Connection Object
'Dim objConn As MySqlConnection
'Dim objDataAdapter As MySqlDataAdapter
'Dim objDataset As DataSet

Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoad.Click
Dim objConn As MySqlConnection
Dim objDataset As New DataSet
Dim objDataAdapter As MySqlDataAdapter
Dim sqlConn As String

objConn = New MySqlConnection("server=localhost;userid=root;password=password;database=mydatabase")

objConn.Open()
sqlConn = "select * from movie"
objDataAdapter = New MySqlDataAdapter(sqlConn, objConn)
objDataAdapter.Fill(objDataset, "tblMovie")

MsgBox("The Connection is Now 'OPEN'")

objConn.Close()
MsgBox("The Connection is Now 'CLOSE'")

txtTitle.Text = objDataset.Tables("tblMovie").Rows(1).Item(1)
txtYear.Text = objDataset.Tables("tblMovie").Rows(1).Item(2)

End Sub

this is my references...
http://www.homeandlearn.co.uk/NET/nets12p5.html

hope this one would help you.

By the way can you help me can you give your source code for add data in mysql database.

Thnx..

Carl

acidcool

Reputation Points: 7

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Sep 2009

Permalink

Mar 23rd, 2011

-1

Re: Retrieve data from MYSQL using VB.NET

VB.NET Syntax (Toggle Plain Text)
sqlCom = New SqlCommand("prc_InsertUniversities", sqlCon)
        sqlCom.CommandType = CommandType.StoredProcedure
        sqlCom.Parameters.Add("@Code", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Name", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Type", SqlDbType.VarChar, 30)
        sqlCom.Parameters.Add("@Address", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Email", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Web", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Location", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Period", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Certification", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Approved", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Exparing", SqlDbType.VarChar, 20)
 
        sqlCom.Parameters("@Code").Value = TextBox1.Text
        sqlCom.Parameters("@Name").Value = TextBox2.Text
        sqlCom.Parameters("@Type").Value = TextBox16.Text
        sqlCom.Parameters("@Address").Value = TextBox3.Text
        sqlCom.Parameters("@Email").Value = TextBox4.Text
        sqlCom.Parameters("@Web").Value = TextBox5.Text
        sqlCom.Parameters("@Location").Value = TextBox6.Text
        sqlCom.Parameters("@Period").Value = TextBox7.Text
        sqlCom.Parameters("@Certification").Value = TextBox13.Text
        sqlCom.Parameters("@Approved").Value = TextBox14.Text
        sqlCom.Parameters("@Exparing").Value = TextBox15.Text
 
        Try
            sqlCom.ExecuteNonQuery()
            MessageBox.Show("Data Inserted Successfully", "hi", MessageBoxButtons.OK, MessageBoxIcon.Information)
            TextBox1.Text = ""
            TextBox2.Text = ""
            TextBox16.Text = ""
            TextBox3.Text = ""
            TextBox4.Text = ""
            TextBox5.Text = ""
            TextBox6.Text = ""
            TextBox7.Text = ""
            TextBox13.Text = ""
            TextBox14.Text = ""
            TextBox15.Text = ""
        Catch ex As Exception
            MessageBox.Show("Data Insertion Error", "hi", MessageBoxButtons.OK, MessageBoxIcon.Error)
        End Try
    End Sub
sqlCom = New SqlCommand("prc_InsertUniversities", sqlCon)
        sqlCom.CommandType = CommandType.StoredProcedure
        sqlCom.Parameters.Add("@Code", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Name", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Type", SqlDbType.VarChar, 30)
        sqlCom.Parameters.Add("@Address", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Email", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Web", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Location", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Period", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Certification", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Approved", SqlDbType.VarChar, 20)
        sqlCom.Parameters.Add("@Exparing", SqlDbType.VarChar, 20)

        sqlCom.Parameters("@Code").Value = TextBox1.Text
        sqlCom.Parameters("@Name").Value = TextBox2.Text
        sqlCom.Parameters("@Type").Value = TextBox16.Text
        sqlCom.Parameters("@Address").Value = TextBox3.Text
        sqlCom.Parameters("@Email").Value = TextBox4.Text
        sqlCom.Parameters("@Web").Value = TextBox5.Text
        sqlCom.Parameters("@Location").Value = TextBox6.Text
        sqlCom.Parameters("@Period").Value = TextBox7.Text
        sqlCom.Parameters("@Certification").Value = TextBox13.Text
        sqlCom.Parameters("@Approved").Value = TextBox14.Text
        sqlCom.Parameters("@Exparing").Value = TextBox15.Text

        Try
            sqlCom.ExecuteNonQuery()
            MessageBox.Show("Data Inserted Successfully", "hi", MessageBoxButtons.OK, MessageBoxIcon.Information)
            TextBox1.Text = ""
            TextBox2.Text = ""
            TextBox16.Text = ""
            TextBox3.Text = ""
            TextBox4.Text = ""
            TextBox5.Text = ""
            TextBox6.Text = ""
            TextBox7.Text = ""
            TextBox13.Text = ""
            TextBox14.Text = ""
            TextBox15.Text = ""
        Catch ex As Exception
            MessageBox.Show("Data Insertion Error", "hi", MessageBoxButtons.OK, MessageBoxIcon.Error)
        End Try
    End Sub

Last edited by Ezzaral; Mar 23rd, 2011 at 3:00 pm. Reason: Added code tags. Please use them to format any code that you post.

Kenny12

Reputation Points: 8

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Mar 2011

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Value changed previous value

Next Thread in VB.NET Forum Timeline: Search Box in streamreader in visual basic

DaniWeb Message

Cancel Changes

User Name
Password