Click here to Skip to main content
15,905,612 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Need help with a project, I am really stumped! Pin
Chinners29-May-08 3:14
Chinners29-May-08 3:14 
GeneralRe: Need help with a project, I am really stumped! Pin
Ogre72229-May-08 4:26
Ogre72229-May-08 4:26 
GeneralRe: Need help with a project, I am really stumped! Pin
Chinners29-May-08 4:57
Chinners29-May-08 4:57 
GeneralRe: Need help with a project, I am really stumped! Pin
Ogre72229-May-08 5:22
Ogre72229-May-08 5:22 
GeneralRe: Need help with a project, I am really stumped! Pin
Ogre72229-May-08 15:47
Ogre72229-May-08 15:47 
GeneralRe: Need help with a project, I am really stumped! Pin
Chinners29-May-08 22:35
Chinners29-May-08 22:35 
GeneralRe: Need help with a project, I am really stumped! Pin
Steven J Jowett29-May-08 4:07
Steven J Jowett29-May-08 4:07 
QuestionCheck tinytext column in MySQL Database with VB.NET Pin
drexler_kk28-May-08 15:17
drexler_kk28-May-08 15:17 
Hello all,I am wondering anyone can guide me how to read tiny text column for MySQL using VB.NET Datareader.

The following are the code I used to read the column:

Public Function StartupData(ByVal strKeySet as String)
Dim test as string
Dim MyTinyText as string

Try
 ObjComm = New OdbcCommand("SELECT SettingValue FROM pos_setting WHERE LocationCode='KK' AND SettingKey='ADD_BINLOG'", ObjConn)
 ObjConn.Open()
 ObjRead = ObjComm.ExecuteReader()
            If ObjRead.Read Then
                test = ObjRead.Item(0)
                MessageBox.Show("This is " & test & "")
            Else
                MessageBox.Show("No value")
            End If
            ObjConn.Close()

Catch ex As Exception

Finally
Objconn.Close
End Try

And my database table as follow:
/*Column Information For - test.pos_setting*/
---------------------------------------------

Field         Type         Collation          Null    Key     Default  Extra   Privileges                       Comment
------------  -----------  -----------------  ------  ------  -------  ------  -------------------------------  -------
LocationCode  varchar(10)  latin1_swedish_ci  NO      PRI                      select,insert,update,references         
SettingKey    varchar(10)  latin1_swedish_ci  NO      PRI                      select,insert,update,references         
SettingValue  tinytext     latin1_swedish_ci  YES             (NULL)           select,insert,update,references  

I'm wondering why its keep showing there is no data read inside the datareader? Actually there is a '0' inside the SettingValue for that row of data but I'm wondering why it doesn't read it? Anyone can give me a solution for this?

Thanks for reading~!
AnswerRe: Check tinytext column in MySQL Database with VB.NET Pin
jzonthemtn29-May-08 2:36
jzonthemtn29-May-08 2:36 
QuestionTrouble with VB.NET and XPath Pin
Dominick Marciano28-May-08 9:45
professionalDominick Marciano28-May-08 9:45 
AnswerRe: Trouble with VB.NET and XPath Pin
MidwestLimey28-May-08 13:26
professionalMidwestLimey28-May-08 13:26 
GeneralRe: Trouble with VB.NET and XPath Pin
Dominick Marciano29-May-08 6:43
professionalDominick Marciano29-May-08 6:43 
GeneralRe: Trouble with VB.NET and XPath Pin
MidwestLimey29-May-08 8:19
professionalMidwestLimey29-May-08 8:19 
QuestionbackgroundWorker Help Pin
Cory Kimble28-May-08 7:35
Cory Kimble28-May-08 7:35 
AnswerRe: backgroundWorker Help Pin
Kschuler28-May-08 8:30
Kschuler28-May-08 8:30 
GeneralRe: backgroundWorker Help Pin
Cory Kimble28-May-08 10:47
Cory Kimble28-May-08 10:47 
GeneralRe: backgroundWorker Help Pin
Kschuler28-May-08 10:57
Kschuler28-May-08 10:57 
AnswerRe: backgroundWorker Help Pin
Chinners28-May-08 23:05
Chinners28-May-08 23:05 
QuestionGraphics question Pin
sa_runner28-May-08 5:27
sa_runner28-May-08 5:27 
AnswerRe: Graphics question Pin
Chinners28-May-08 5:57
Chinners28-May-08 5:57 
GeneralRe: Graphics question Pin
sa_runner28-May-08 11:41
sa_runner28-May-08 11:41 
QuestionTurning a functional (not object-oriented) program into a .dll Pin
Eric Burns28-May-08 4:52
Eric Burns28-May-08 4:52 
AnswerRe: Turning a functional (not object-oriented) program into a .dll Pin
Steven J Jowett28-May-08 5:54
Steven J Jowett28-May-08 5:54 
GeneralRe: Turning a functional (not object-oriented) program into a .dll Pin
Eric Burns28-May-08 9:36
Eric Burns28-May-08 9:36 
Questionhow to apply style for anchor tag by using vb.net? Pin
subbu.sk28-May-08 3:24
subbu.sk28-May-08 3:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.