Click here to Skip to main content
15,913,361 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Clipboard functionality in application like VB GUI Pin
for12064-Feb-10 22:17
for12064-Feb-10 22:17 
GeneralRe: Clipboard functionality in application like VB GUI Pin
Dalek Dave4-Feb-10 22:32
professionalDalek Dave4-Feb-10 22:32 
AnswerRe: Clipboard functionality in application like VB GUI Pin
Richard MacCutchan4-Feb-10 22:22
mveRichard MacCutchan4-Feb-10 22:22 
AnswerRe: Clipboard functionality in application like VB GUI Pin
Luc Pattyn4-Feb-10 23:52
sitebuilderLuc Pattyn4-Feb-10 23:52 
QuestionApplying Scrolling to Image Box Pin
Lakshmana Kumar Vepuri4-Feb-10 19:25
Lakshmana Kumar Vepuri4-Feb-10 19:25 
AnswerRe: Applying Scrolling to Image Box Pin
Nuri Ismail4-Feb-10 21:58
Nuri Ismail4-Feb-10 21:58 
AnswerRe: Applying Scrolling to Image Box Pin
Luc Pattyn4-Feb-10 23:54
sitebuilderLuc Pattyn4-Feb-10 23:54 
QuestionApplication is not responding Pin
GSS_imran4-Feb-10 2:17
GSS_imran4-Feb-10 2:17 
I am working on an application in which month and year is selected through combobox.
On selection on both, a checklistbox is filled with data for the selected month and year.
When I select the month and then year in application that is connecting to remote server, the system hangs. But the same when I do on a machine that connects to another remote server works fine.

What could be the possible reason for this?


I call a sub procedure on the selectedindexchange event of the combobox
Code in the sub proc is as below:

Private Sub FillClients()

Dim sqlComIns As SqlCommand
Dim iRec As Integer
Dim sSQL_Temp As String

If CboMonth.Text = "" Or cboYear.Text = "" Then Exit Sub

Call DisposeAllObjects()

sSQL_Temp = "DELETE FROM GlobCustNonZeros_Cust"

sSQL = "INSERT INTO GlobCustNonZeros_Cust(Global_Cust)SELECT DISTINCT GLOBALCUST FROM tbMain WHERE FeesAmt<>0" & _
" AND UpMonth='" & CboMonth.Text & "' and UpYear='" & cboYear.Text & "' AND GlobalCust NOT IN (SELECT Global_Cust from GlobCustZeros_Cust)"


LstClient.Items.Clear()

Try
objDB = New ClsConnection
sqlcon = New SqlConnection(objDB.conStr)
sqlcon.Open()
sqlComIns = New SqlCommand(sSQL_Temp, sqlcon)
sqlComIns.CommandTimeout = CMDTimeOutFirst
sqlComIns.CommandTimeout = CMDTimeOutSec
iRec = sqlComIns.ExecuteNonQuery
sqlComIns = Nothing
sqlComIns = New SqlCommand(sSQL, sqlcon)
sqlComIns.CommandTimeout = CMDTimeOutFirst
sqlComIns.CommandTimeout = CMDTimeOutSec
iRec = sqlComIns.ExecuteNonQuery
sSQL = "SELECT Global_Cust FROM GlobCustNonZeros_Cust ORDER BY Global_Cust"
sqlComm = New SqlCommand(sSQL, sqlcon)
sqlComm.CommandTimeout = CMDTimeOutFirst
sqlComm.CommandTimeout = CMDTimeOutSec
sqlRead = sqlComm.ExecuteReader
Do While sqlRead.Read
LstClient.Items.Add(sqlRead("GLOBAL_CUST"))
Loop
sqlRead.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try

End Sub

Any help will be highly appreciated as its very urgent.
thanks in advance
Regards
Imran
AnswerRe: Application is not responding Pin
Abhinav S4-Feb-10 2:34
Abhinav S4-Feb-10 2:34 
AnswerRe: Application is not responding Pin
William Winner4-Feb-10 7:52
William Winner4-Feb-10 7:52 
QuestionTesting if a varible is null Pin
RachelSo3-Feb-10 18:51
RachelSo3-Feb-10 18:51 
AnswerRe: Testing if a varible is null Pin
jtpaa3-Feb-10 19:37
jtpaa3-Feb-10 19:37 
AnswerRe: Testing if a varible is null Pin
DaveAuld3-Feb-10 19:47
professionalDaveAuld3-Feb-10 19:47 
GeneralRe: Testing if a varible is null Pin
David Skelly3-Feb-10 22:19
David Skelly3-Feb-10 22:19 
AnswerRe: Testing if a varible is null Pin
David Skelly3-Feb-10 22:32
David Skelly3-Feb-10 22:32 
GeneralRe: Testing if a varible is null Pin
David Skelly3-Feb-10 22:55
David Skelly3-Feb-10 22:55 
GeneralRe: Testing if a varible is null Pin
DaveAuld4-Feb-10 5:15
professionalDaveAuld4-Feb-10 5:15 
GeneralRe: Testing if a varible is null Pin
Luc Pattyn4-Feb-10 5:36
sitebuilderLuc Pattyn4-Feb-10 5:36 
GeneralRe: Testing if a varible is null Pin
DaveAuld4-Feb-10 6:14
professionalDaveAuld4-Feb-10 6:14 
GeneralRe: Testing if a varible is null Pin
Luc Pattyn4-Feb-10 6:18
sitebuilderLuc Pattyn4-Feb-10 6:18 
GeneralRe: Testing if a varible is null Pin
EliottA4-Feb-10 7:26
EliottA4-Feb-10 7:26 
AnswerRe: Testing if a varible is null Pin
RachelSo4-Feb-10 8:08
RachelSo4-Feb-10 8:08 
GeneralRe: Testing if a varible is null Pin
Thomas Krojer4-Feb-10 21:47
Thomas Krojer4-Feb-10 21:47 
QuestionHow do I update a progress bar that I create at runtime. Pin
castingflame3-Feb-10 7:16
castingflame3-Feb-10 7:16 
AnswerRe: How do I update a progress bar that I create at runtime. Pin
Luc Pattyn3-Feb-10 7:37
sitebuilderLuc Pattyn3-Feb-10 7:37 

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.