Click here to Skip to main content
15,920,596 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralNavigating through menu of another appilcation Pin
Abhishek Karnik21-Jun-05 11:05
Abhishek Karnik21-Jun-05 11:05 
QuestionHow to access a TextBox control if given its Name as a variable? Pin
VB_Novice0121-Jun-05 10:37
sussVB_Novice0121-Jun-05 10:37 
AnswerRe: How to access a TextBox control if given its Name as a variable? Pin
Mitch F.21-Jun-05 11:01
Mitch F.21-Jun-05 11:01 
AnswerRe: How to access a TextBox control if given its Name as a variable? Pin
lespaul3621-Jun-05 11:05
lespaul3621-Jun-05 11:05 
GeneralAnother 'String.Split' question. Pin
Brad Fackrell21-Jun-05 9:04
Brad Fackrell21-Jun-05 9:04 
GeneralRe: Another 'String.Split' question. Pin
Dave Kreskowiak21-Jun-05 9:47
mveDave Kreskowiak21-Jun-05 9:47 
GeneralRe: Another 'String.Split' question. Pin
Brad Fackrell21-Jun-05 9:51
Brad Fackrell21-Jun-05 9:51 
GeneralDataReader only finding one row Pin
SignMan35921-Jun-05 8:02
SignMan35921-Jun-05 8:02 
I'm in the process of migrating an app from VB6 to VB.NET. I'm not at a point where I'm trying to pull data from an Informix database using ODBC and datareaders. The problem I'm having is that it's only coming back with one row. When I execute the exact same SQL statement on the server, I get 127 rows.

Here's what I've got:

================================================================================================
GetAccounts = New Collection
rs = RunSQLReturnRS(sqlReader, "select unique name from edipro_send_recv where name not matches '997*'")

Do While rs.HasRows()
GetAccounts.Add(CType(rs.Item(0), String))
rs.NextResult()
Loop
================================================================================================
Public Function RunSQLReturnRS(ByRef sqlReader As OdbcDataReader, ByRef strSP As String, ByVal ParamArray params() As Object) As OdbcDataReader
Dim cmdSql As OdbcCommand

Try
cmdSql = New OdbcCommand(strSP, DbConnection)
cmdSql.CommandType = CommandType.Text
RunSQLReturnRS = cmdSql.ExecuteReader(CommandBehavior.Default)
Catch ex As Exception
MsgBox("An exception has been thrown in the the Database.RunSQLReturnRS function." * NewLine() & ex.Message, MsgBoxStyle.OKOnly, "Error: Exception Thrown")
End Try
End Function
===============================================================================================

I would greatly appreciate any assistance with this. For the life of me I can't figure out what to do next. BTW... the connection is opened and closed in different Sub's under the identity of DbConnection.

--In a world without fences, who needs Gates?
GeneralRe: DataReader only finding one row Pin
Colin Angus Mackay21-Jun-05 9:06
Colin Angus Mackay21-Jun-05 9:06 
GeneralRe: DataReader only finding one row Pin
Dave Kreskowiak21-Jun-05 9:37
mveDave Kreskowiak21-Jun-05 9:37 
GeneralCode Access Security Policy Tool Pin
Jason Weibel21-Jun-05 6:48
Jason Weibel21-Jun-05 6:48 
GeneralRe: Code Access Security Policy Tool Pin
Dave Kreskowiak21-Jun-05 7:06
mveDave Kreskowiak21-Jun-05 7:06 
GeneralRe: Code Access Security Policy Tool Pin
Dave Kreskowiak21-Jun-05 9:33
mveDave Kreskowiak21-Jun-05 9:33 
GeneralCollection / Property Grid Pin
THEMYTH21-Jun-05 4:36
THEMYTH21-Jun-05 4:36 
QuestionHow do i run an app. like paint from a macro button in excel? Pin
Anthony Mushrow21-Jun-05 4:11
professionalAnthony Mushrow21-Jun-05 4:11 
AnswerRe: How do i run an app. like paint from a macro button in excel? Pin
Dave Kreskowiak21-Jun-05 5:42
mveDave Kreskowiak21-Jun-05 5:42 
GeneralSelf-Uninstalling ActiveX Component Pin
Michel Robert 200421-Jun-05 3:23
Michel Robert 200421-Jun-05 3:23 
GeneralRe: Self-Uninstalling ActiveX Component Pin
Dave Kreskowiak21-Jun-05 5:34
mveDave Kreskowiak21-Jun-05 5:34 
GeneralRe: Self-Uninstalling ActiveX Component Pin
Michel Robert 200421-Jun-05 15:37
Michel Robert 200421-Jun-05 15:37 
GeneralRe: Self-Uninstalling ActiveX Component Pin
Dave Kreskowiak22-Jun-05 1:03
mveDave Kreskowiak22-Jun-05 1:03 
GeneralRe: Self-Uninstalling ActiveX Component Pin
Michel Robert 200422-Jun-05 3:35
Michel Robert 200422-Jun-05 3:35 
QuestionHow to send mail only to matched id in vb.net through smtp Pin
manojmmj21-Jun-05 0:41
manojmmj21-Jun-05 0:41 
AnswerRe: How to send mail only to matched id in vb.net through smtp Pin
Het210921-Jun-05 1:56
Het210921-Jun-05 1:56 
GeneralCrystal Report Section - Flexibility Position Pin
LordLothar21-Jun-05 0:36
LordLothar21-Jun-05 0:36 
GeneralDataGrid Queries Pin
directred21-Jun-05 0:32
directred21-Jun-05 0:32 

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.