Click here to Skip to main content
15,906,285 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: check all checkbox in datagrid window form Pin
User 27100927-Feb-08 15:20
User 27100927-Feb-08 15:20 
GeneralCombobox in datagrid Pin
indian14327-Feb-08 10:44
indian14327-Feb-08 10:44 
GeneralRe: Combobox in datagrid Pin
RCoate27-Feb-08 14:03
RCoate27-Feb-08 14:03 
Questioncalling C++ from Visual Basic code Pin
mesho27-Feb-08 7:55
mesho27-Feb-08 7:55 
GeneralRe: calling C++ from Visual Basic code Pin
Dave Kreskowiak27-Feb-08 8:04
mveDave Kreskowiak27-Feb-08 8:04 
GeneralRe: calling C++ from Visual Basic code Pin
Eytukan28-Feb-08 5:37
Eytukan28-Feb-08 5:37 
GeneralRe: calling C++ from Visual Basic code Pin
AndrewVos28-Feb-08 14:24
AndrewVos28-Feb-08 14:24 
QuestionDataset problem Pin
IvanIT27-Feb-08 7:38
IvanIT27-Feb-08 7:38 
I am trying to determine if a EmployeeNumb exits in the Access table below. The function I am using is outlined below, buy I get an exception error that there is not data in Row(0). can anyone help me out with identifying the problem? TIA

Sub TimeAlloc()

Dim strSelectNum As String
Dim sda As OleDb.OleDbDataAdapter
Dim dsEmployeeTime As DataSet
Dim cmdDatabase As OleDb.OleDbCommand
Dim conDatabase As OleDb.OleDbConnection

'need to determine if this is a new allcation WHERE EmployeeNumber exists in tblTimeAllocation
strSelectNum = _
"SELECT * FROM tblEmployeeAllocation WHERE EmployeeNumber = '" & _
txtEmployeeNumber.Text & "'"

' establish database connection
conDatabase = New OleDb.OleDbConnection( _
"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=C:\devELOPMENT\WINTur\TurN.mdb")

cmdDatabase = New OleDb.OleDbCommand(strSelectNum, conDatabase)
dsEmployeeTime = New DataSet
sda = New OleDb.OleDbDataAdapter

sda.SelectCommand = cmdDatabase
sda.Fill(dsEmployeeTime)

'Try
Dim recEmployee As DataRow = dsEmployeeTime.Tables(0).Rows(0)

If recEmployee.IsNull("EmployeeNumber") Then
bNewTimeAllocation = True

Else
bNewTimeAllocation = False
End If
'Catch exc As IndexOutOfRangeException

' End Try
End Sub


ID EmpNumb TimeAllocationCode
1 88024 880242008020039
2 20410 204102008020039
3 25711 257112008020054
4 34873 348732008020015
5 200920 2009202008020041
6 91272 912722008020022
7 62062 620622008020050
8 63474 63474200802002
9 24277 242772008020026
12 771214 7712142008020040
13 773115 7731152008020030
14 200866 200866200802009
GeneralRe: Dataset problem Pin
Dave Kreskowiak27-Feb-08 8:03
mveDave Kreskowiak27-Feb-08 8:03 
GeneralRe: Dataset problem Pin
IvanIT27-Feb-08 8:15
IvanIT27-Feb-08 8:15 
GeneralRe: Dataset problem Pin
Dave Kreskowiak27-Feb-08 9:11
mveDave Kreskowiak27-Feb-08 9:11 
GeneralRe: Dataset problem Pin
Vimalsoft(Pty) Ltd27-Feb-08 19:48
professionalVimalsoft(Pty) Ltd27-Feb-08 19:48 
Generalsearching for: VBS for uninstalling symantec antivirus and liveupdate as well Pin
mishiago27-Feb-08 7:02
mishiago27-Feb-08 7:02 
GeneralRe: searching for: VBS for uninstalling symantec antivirus and liveupdate as well Pin
Dave Kreskowiak27-Feb-08 7:31
mveDave Kreskowiak27-Feb-08 7:31 
GeneralRe: searching for: VBS for uninstalling symantec antivirus and liveupdate as well Pin
mishiago27-Feb-08 7:49
mishiago27-Feb-08 7:49 
GeneralRe: searching for: VBS for uninstalling symantec antivirus and liveupdate as well Pin
Mycroft Holmes27-Feb-08 18:02
professionalMycroft Holmes27-Feb-08 18:02 
QuestionProblem converting c# to vb.net [modified] Pin
Jan Sommer27-Feb-08 7:01
Jan Sommer27-Feb-08 7:01 
GeneralRe: Problem converting c# to vb.net Pin
Christian Graus27-Feb-08 9:00
protectorChristian Graus27-Feb-08 9:00 
GeneralRe: Problem converting c# to vb.net Pin
Jan Sommer28-Feb-08 4:51
Jan Sommer28-Feb-08 4:51 
QuestionHow to identifying the VB powerpacks controls in panel Pin
VB 8.027-Feb-08 3:15
VB 8.027-Feb-08 3:15 
AnswerRe: How to identifying the VB powerpacks controls in panel Pin
Dave Kreskowiak27-Feb-08 6:27
mveDave Kreskowiak27-Feb-08 6:27 
GeneralAny one can help me Pin
suresh v.p27-Feb-08 2:42
suresh v.p27-Feb-08 2:42 
GeneralRe: Any one can help me Pin
Dave Kreskowiak27-Feb-08 6:30
mveDave Kreskowiak27-Feb-08 6:30 
GeneralThreading event control question Pin
cstrader23227-Feb-08 2:36
cstrader23227-Feb-08 2:36 
GeneralRe: Threading event control question Pin
Dave Kreskowiak27-Feb-08 6:17
mveDave Kreskowiak27-Feb-08 6:17 

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.