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

Visual Basic

 
AnswerRe: How to update listview ONLY when new data is avilable in vb6? Pin
Dave Kreskowiak10-May-07 3:17
mveDave Kreskowiak10-May-07 3:17 
GeneralRe: How to update listview ONLY when new data is avilable in vb6? Pin
method00710-May-07 6:59
method00710-May-07 6:59 
GeneralRe: How to update listview ONLY when new data is avilable in vb6? Pin
Dave Kreskowiak10-May-07 12:40
mveDave Kreskowiak10-May-07 12:40 
QuestionHow do I keep track of what Line the cursor is on in a Rich Text Box? Pin
josh04769-May-07 14:03
josh04769-May-07 14:03 
AnswerRe: How do I keep track of what Line the cursor is on in a Rich Text Box? Pin
Vivek Narayanan9-May-07 17:21
Vivek Narayanan9-May-07 17:21 
QuestionSearch for text in file with wildcard Pin
al9689-May-07 12:32
al9689-May-07 12:32 
AnswerRe: Search for text in file with wildcard Pin
Christian Graus9-May-07 14:52
protectorChristian Graus9-May-07 14:52 
Questionsyntax error executescalar Pin
Hansduncan9-May-07 11:35
Hansduncan9-May-07 11:35 
I'm getting a syntax error when debugging the code on the following line.

disc1ID = CType(mycmd.ExecuteScalar(), Integer) in the below code. All the error give me to go on is syntax error. ???

Any idea what the problem could be?

   Private Sub NewToolStripButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NewToolStripButton.Click<br />
<br />
        Dim mycmd As New SqlCommand("SELECT MAX(DiscountId) AS discID FROM(Discountstructure)", MDIParent1.Conn)<br />
        mycmd.CommandType = CommandType.Text<br />
<br />
        Dim disc1ID As Integer<br />
<br />
        MDIParent1.Conn.Open()<br />
        disc1ID = CType(mycmd.ExecuteScalar(), Integer)<br />
        MDIParent1.Conn.Close()<br />
<br />
        MsgBox(disc1ID.ToString)<br />
    End Sub

AnswerRe: syntax error executescalar Pin
Guffa9-May-07 12:37
Guffa9-May-07 12:37 
QuestionCombo box assign a value CF 2.0 Pin
steve_rm9-May-07 10:00
steve_rm9-May-07 10:00 
QuestionHow to open new form from a datagridview row? Pin
Rashar9-May-07 8:52
Rashar9-May-07 8:52 
AnswerRe: How to open new form from a datagridview row? Pin
Hansduncan9-May-07 23:28
Hansduncan9-May-07 23:28 
GeneralRe: How to open new form from a datagridview row? Pin
Rashar10-May-07 2:23
Rashar10-May-07 2:23 
GeneralRe: How to open new form from a datagridview row? Pin
Hansduncan10-May-07 4:05
Hansduncan10-May-07 4:05 
GeneralRe: How to open new form from a datagridview row? [modified] Pin
Rashar10-May-07 5:43
Rashar10-May-07 5:43 
GeneralRe: How to open new form from a datagridview row? Pin
Hansduncan10-May-07 8:21
Hansduncan10-May-07 8:21 
Questionsystem shutdown Pin
M269-May-07 7:13
M269-May-07 7:13 
AnswerRe: system shutdown Pin
Dave Kreskowiak9-May-07 7:20
mveDave Kreskowiak9-May-07 7:20 
Generalok ... this is my code Pin
M2610-May-07 6:19
M2610-May-07 6:19 
GeneralRe: ok ... this is my code Pin
Dave Kreskowiak10-May-07 12:37
mveDave Kreskowiak10-May-07 12:37 
QuestionPlay Midi File/MP3 from Application Pin
RichardBerry9-May-07 4:33
RichardBerry9-May-07 4:33 
AnswerRe: Play Midi File/MP3 from Application Pin
Dave Kreskowiak9-May-07 6:24
mveDave Kreskowiak9-May-07 6:24 
GeneralRe: Play Midi File/MP3 from Application Pin
RichardBerry9-May-07 22:47
RichardBerry9-May-07 22:47 
GeneralPrint DataSet (DataGrid) Pin
moiid639-May-07 4:10
moiid639-May-07 4:10 
GeneralRe: Print DataSet (DataGrid) Pin
Dave Kreskowiak9-May-07 4:48
mveDave Kreskowiak9-May-07 4:48 

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.