2 Replies - 717 Views - Last Post: 03 May 2010 - 09:29 AM

#1 hemo   User is offline

  • D.I.C Head

Reputation: 2
  • View blog
  • Posts: 70
  • Joined: 02-January 07

Recording individual field values From MySQL Database

Posted 03 May 2010 - 04:52 AM

I am using a simple Login function and need to record individual field values from MySQL database to compare with inputs.

My connection code:
Dim myConnection  As MySqlConnection
Dim myDataAdapter As MySqlDataAdapter
 Dim strSQL As String
 myConnection = New MySqlConnection("Database=mydatabase;Data Source=xx.xxx.xx.2;port=3362;UId=myID;Password=1234;")
    strSQL = "SELECT username,password FROM Login WHERE ID = '" & 1 & "'"
    myDataAdapter = New MySqlDataAdapter(strSQL, myConnection)
   myDataSet = New Dataset()
    myDataAdapter.Fill(myDataSet,"Login")


I have confirmed it is connecting by adding the following GridView.
GridView1.DataSource = myDataSet
GridView1.DataBind()


My problem is isolating the individual field values.

This post has been edited by hemo: 03 May 2010 - 04:54 AM


Is This A Good Question/Topic? 0
  • +

Replies To: Recording individual field values From MySQL Database

#2 nkasei28   User is offline

  • D.I.C Head

Reputation: 7
  • View blog
  • Posts: 93
  • Joined: 10-May 09

Re: Recording individual field values From MySQL Database

Posted 03 May 2010 - 05:30 AM

Please send it to the VB.NET forum. I'm sure u can find a quick help there.
Was This Post Helpful? 0
  • +
  • -

#3 hemo   User is offline

  • D.I.C Head

Reputation: 2
  • View blog
  • Posts: 70
  • Joined: 02-January 07

Re: Recording individual field values From MySQL Database

Posted 03 May 2010 - 09:29 AM

I have managed to resolve problem
myDataSet.Tables(“Login”).Rows(0) (“username”)


Was This Post Helpful? 0
  • +
  • -

Page 1 of 1