Click here to Skip to main content
15,901,853 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Datagrid Colour Based on the Records in the table Pin
Dave Kreskowiak17-Apr-08 3:42
mveDave Kreskowiak17-Apr-08 3:42 
GeneralDatabase connection using Vb.net 2003 and MySQL 4.1 Pin
magesh2117-Apr-08 2:27
magesh2117-Apr-08 2:27 
GeneralRe: Database connection using Vb.net 2003 and MySQL 4.1 Pin
Dave Kreskowiak17-Apr-08 3:34
mveDave Kreskowiak17-Apr-08 3:34 
Generalcombo box invalid property array index Pin
kankeyan17-Apr-08 0:20
kankeyan17-Apr-08 0:20 
GeneralRe: combo box invalid property array index Pin
Luc Pattyn17-Apr-08 0:37
sitebuilderLuc Pattyn17-Apr-08 0:37 
GeneralRe: combo box invalid property array index Pin
kankeyan17-Apr-08 2:18
kankeyan17-Apr-08 2:18 
GeneralRe: combo box invalid property array index Pin
Luc Pattyn17-Apr-08 2:46
sitebuilderLuc Pattyn17-Apr-08 2:46 
QuestionSQL Timeout repeating a query Pin
Paul DAmbra16-Apr-08 22:51
Paul DAmbra16-Apr-08 22:51 
Hi All,

I'm teaching myself as I go as we can't afford to outsource a few "simple" requirements to a real programmer. I'm running a form which has 5 rows (Monday to Friday) when the user clicks submit it checks if data has been entered on a row, if it has it looks in the db to see if there is already data and then chooses insert or update.

This works fine for the first row and then times-out on the second row while checking if there is data. The query runs fine in query analyzer.

I call the select that looks for existence of data as a function with

sqlCheckResponse = flexi_actions.CheckInsUpd(userID, txtDate2.Text)

and....

Function CheckInsUpd(ByVal userID As Integer, ByVal inputDate As String) As Integer
Try

Dim sqlCheckConn As New SqlConnection(strConn)
Dim strcheckSQL As String = "select count(detailID) from flexiDetail where userID = @uID and flexiDate = @fDate"
sqlCheckConn.Open()
Dim checkCmd1 As New SqlCommand(strcheckSQL, sqlCheckConn)
checkCmd1.Parameters.AddWithValue("@uID", userID)
checkCmd1.Parameters.AddWithValue("@fDate", inputDate)

CheckInsUpd = checkCmd1.ExecuteScalar 'timesout on this line...

sqlCheckConn.Close()

Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Function

Any help appreciated!

Thanks
Paul
GeneralRe: SQL Timeout repeating a query Pin
Dave Kreskowiak17-Apr-08 3:30
mveDave Kreskowiak17-Apr-08 3:30 
GeneralRe: SQL Timeout repeating a query Pin
Vimalsoft(Pty) Ltd17-Apr-08 3:54
professionalVimalsoft(Pty) Ltd17-Apr-08 3:54 
Questionabout TableLayoutPanel control in vb.net 2.0 Pin
vijaylumar16-Apr-08 22:11
vijaylumar16-Apr-08 22:11 
GeneralRe: about TableLayoutPanel control in vb.net 2.0 Pin
Ajay.k_Singh17-Apr-08 1:10
Ajay.k_Singh17-Apr-08 1:10 
Question[Message Deleted] Pin
r_williams_8416-Apr-08 21:33
r_williams_8416-Apr-08 21:33 
GeneralRe: DLL Registration Pin
Dave Kreskowiak17-Apr-08 3:24
mveDave Kreskowiak17-Apr-08 3:24 
GeneralRe: DLL Registration Pin
r_williams_8417-Apr-08 13:00
r_williams_8417-Apr-08 13:00 
QuestionSecurity Policy Pin
Tauseef A16-Apr-08 19:25
Tauseef A16-Apr-08 19:25 
GeneralRe: Security Policy Pin
Dave Kreskowiak17-Apr-08 3:22
mveDave Kreskowiak17-Apr-08 3:22 
GeneralProblems updating database Pin
AAGTHosting16-Apr-08 9:49
AAGTHosting16-Apr-08 9:49 
GeneralRe: Problems updating database Pin
Dave Kreskowiak16-Apr-08 11:15
mveDave Kreskowiak16-Apr-08 11:15 
GeneralUsing SelectedItem to have pre select item in combo box Pin
AAGTHosting16-Apr-08 8:10
AAGTHosting16-Apr-08 8:10 
GeneralRe: Using SelectedItem to have pre select item in combo box Pin
Dave Kreskowiak16-Apr-08 8:38
mveDave Kreskowiak16-Apr-08 8:38 
QuestionModifying XML Nodes Pin
CocaColaBoy16-Apr-08 6:46
CocaColaBoy16-Apr-08 6:46 
GeneralRe: Modifying XML Nodes Pin
Dave Kreskowiak16-Apr-08 8:41
mveDave Kreskowiak16-Apr-08 8:41 
GeneralRe: Modifying XML Nodes Pin
CocaColaBoy16-Apr-08 8:52
CocaColaBoy16-Apr-08 8:52 
GeneralRe: Modifying XML Nodes Pin
Dave Kreskowiak16-Apr-08 9:23
mveDave Kreskowiak16-Apr-08 9:23 

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.