Only f fileds are imported!!
Posted by: KHALID AL OTHMAN
Date: December 19, 2004 05:15AM

am connecting to mysql db using VB.Net code, whenever i quiry, only 5 fileds are imported... the 6th field never imported to the dataset I built...

my code is:

Public Function GetCountryCode()

Try
Dim Conn As MySqlConnection
Dim Str As String
Dim Adp As MySqlDataAdapter
Dim Ds As DataSet
Dim Str1 As String
Ds2 = New DataSet

Str = context.GetConfig("appSettings")("DSN2")
Str1 = "Select ID from countries where NAME_AR='" & Trim(Dropdownlist5.SelectedItem.Text) & "'"
Conn = New MySqlConnection(Str)
Adp = New MySqlDataAdapter(Str12, Conn)
Adp.Fill(Ds, "CountriesCodes")
Dim DV As New DataView
DV.Table = Ds.Tables("CountriesCodes")
Adp.Dispose()
TextBox1.Text = Trim((DV(0).Item("field_number_6")))

Conn2.Close()

Catch ex As Exception
TextBox2.Text = ex.Message
End Try
End Function

Options: ReplyQuote


Subject
Written By
Posted
Only f fileds are imported!!
December 19, 2004 05:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.