Click here to Skip to main content
12,696,920 members (28,484 online)

Visual Basic

 
GeneralRe: Search criteria - classic asp not working Pin
Eddy Vluggen7-Feb-13 9:13
mvpEddy Vluggen7-Feb-13 9:13 
AnswerRe: Search criteria - classic asp not working Pin
Eddy Vluggen8-Feb-13 12:04
mvpEddy Vluggen8-Feb-13 12:04 
QuestionWebBrowser Dock covers up statusstrip Pin
NSoft Studios30-Jan-13 16:46
memberNSoft Studios30-Jan-13 16:46 
AnswerRe: WebBrowser Dock covers up statusstrip Pin
Richard MacCutchan30-Jan-13 23:13
mvpRichard MacCutchan30-Jan-13 23:13 
AnswerRe: WebBrowser Dock covers up statusstrip Pin
Eddy Vluggen30-Jan-13 23:36
mvpEddy Vluggen30-Jan-13 23:36 
GeneralRe: WebBrowser Dock covers up statusstrip Pin
Dave Kreskowiak31-Jan-13 4:35
mvpDave Kreskowiak31-Jan-13 4:35 
SuggestionRe: WebBrowser Dock covers up statusstrip Pin
Eddy Vluggen31-Jan-13 4:38
mvpEddy Vluggen31-Jan-13 4:38 
GeneralRe: WebBrowser Dock covers up statusstrip Pin
Dave Kreskowiak31-Jan-13 7:52
mvpDave Kreskowiak31-Jan-13 7:52 
GeneralRe: WebBrowser Dock covers up statusstrip Pin
Eddy Vluggen31-Jan-13 11:12
mvpEddy Vluggen31-Jan-13 11:12 
GeneralRe: WebBrowser Dock covers up statusstrip Pin
NSoft Studios3-Feb-13 13:58
memberNSoft Studios3-Feb-13 13:58 
AnswerRe: WebBrowser Dock covers up statusstrip Pin
rohitvermasrt31-Jan-13 19:28
memberrohitvermasrt31-Jan-13 19:28 
QuestionQuery dataTable with .Compute Pin
mebjen30-Jan-13 10:05
membermebjen30-Jan-13 10:05 
AnswerRe: Query dataTable with .Compute Pin
Dave Kreskowiak30-Jan-13 11:20
mvpDave Kreskowiak30-Jan-13 11:20 
GeneralRe: Query dataTable with .Compute Pin
mebjen30-Jan-13 11:45
membermebjen30-Jan-13 11:45 
Hi Dave,

Thanks for the feedback - I have made the following changes:

Dim salesTable As DataTable
salesTable = New DataTable

Dim col_invNo As DataColumn = New DataColumn("invNo")
        col_invNo.DataType = System.Type.GetType("System.String")
        salesTable.Columns.Add(col_invNo)

        Dim col_custId As DataColumn = New DataColumn("custId")
        col_custId.DataType = System.Type.GetType("System.String")
        salesTable.Columns.Add(col_custId)

        Dim col_custName As DataColumn = New DataColumn("custName")
        col_custName.DataType = System.Type.GetType("System.String")
        salesTable.Columns.Add(col_custName)

        Dim col_shipToId As DataColumn = New DataColumn("shipToId")
        col_shipToId.DataType = System.Type.GetType("System.String")
        salesTable.Columns.Add(col_shipToId)

        Dim col_shipToName As DataColumn = New DataColumn("shipToName")
        col_shipToName.DataType = System.Type.GetType("System.String")
        salesTable.Columns.Add(col_shipToName)

        Dim col_shipToCity As DataColumn = New DataColumn("shipToCity")
        col_shipToCity.DataType = System.Type.GetType("System.String")
        salesTable.Columns.Add(col_shipToCity)

        Dim col_shipToState As DataColumn = New DataColumn("shipToState")
        col_shipToState.DataType = System.Type.GetType("System.String")
        salesTable.Columns.Add(col_shipToState)

        Dim col_invDate As DataColumn = New DataColumn("invDate")
        col_invDate.DataType = System.Type.GetType("System.DateTime")
        salesTable.Columns.Add(col_invDate)

        Dim col_category As DataColumn = New DataColumn("category")
        col_category.DataType = System.Type.GetType("System.String")
        salesTable.Columns.Add(col_category)

        Dim col_itemId As DataColumn = New DataColumn("itemId")
        col_itemId.DataType = System.Type.GetType("System.String")
        salesTable.Columns.Add(col_itemId)

        Dim col_desc As DataColumn = New DataColumn("desc")
        col_desc.DataType = System.Type.GetType("System.String")
        salesTable.Columns.Add(col_desc)

        Dim col_shipQty As DataColumn = New DataColumn("shipQty")
        col_shipQty.DataType = System.Type.GetType("System.Int32")
        salesTable.Columns.Add(col_shipQty)

        Dim col_extPrice As DataColumn = New DataColumn("extPrice")
        col_extPrice.DataType = System.Type.GetType("System.Decimal")
        salesTable.Columns.Add(col_extPrice)



Public getYrSales(ByVal stn as String)
Dim begDate as Date
Dim endDate as Date
Dim yrSales = salesTable
Dim x0 As Object
begDate = "01/01/2009"
endDate = "12/31/2009"


x0 = yrSales.Compute("SUM(extPrice)", "shipToName = '" & stn & "'" & "AND invDate >" & begDate & "AND invDate <" & endDate)
End Sub

Unforturnately - I'm still getting the error / what am I missing?
Thanks,

MB

GeneralRe: Query dataTable with .Compute Pin
Dave Kreskowiak30-Jan-13 15:28
mvpDave Kreskowiak30-Jan-13 15:28 
QuestionWindows admin mode mistries Pin
solankinkdpr30-Jan-13 2:11
membersolankinkdpr30-Jan-13 2:11 
AnswerRe: Windows admin mode mistries Pin
Eddy Vluggen30-Jan-13 8:51
mvpEddy Vluggen30-Jan-13 8:51 
GeneralRe: Windows admin mode mistries Pin
solankinkdpr30-Jan-13 20:07
membersolankinkdpr30-Jan-13 20:07 
AnswerRe: Windows admin mode mistries Pin
Eddy Vluggen30-Jan-13 23:35
mvpEddy Vluggen30-Jan-13 23:35 
GeneralRe: Windows admin mode mistries Pin
solankinkdpr31-Jan-13 3:29
membersolankinkdpr31-Jan-13 3:29 
GeneralRe: Windows admin mode mistries Pin
Eddy Vluggen31-Jan-13 4:21
mvpEddy Vluggen31-Jan-13 4:21 
AnswerRe: Windows admin mode mistries Pin
Dave Kreskowiak30-Jan-13 9:26
mvpDave Kreskowiak30-Jan-13 9:26 
Questionserial number with project Pin
olivertechy29-Jan-13 16:33
memberolivertechy29-Jan-13 16:33 
AnswerRe: serial number with project Pin
Eddy Vluggen30-Jan-13 9:17
mvpEddy Vluggen30-Jan-13 9:17 
QuestionParse XML Response String And Get Usable Variables Pin
pjgoodis29-Jan-13 5:46
memberpjgoodis29-Jan-13 5:46 
AnswerRe: Parse XML Response String And Get Usable Variables Pin
Alan N29-Jan-13 7:05
memberAlan N29-Jan-13 7:05 
GeneralRe: Parse XML Response String And Get Usable Variables Pin
pjgoodis29-Jan-13 23:05
memberpjgoodis29-Jan-13 23:05 
GeneralRe: Parse XML Response String And Get Usable Variables Pin
StyleTech Solutions Ltd4-Feb-13 7:28
groupStyleTech Solutions Ltd4-Feb-13 7:28 
QuestionMicrosoft ReportViewer Pin
IgaBaro28-Jan-13 17:30
memberIgaBaro28-Jan-13 17:30 
AnswerRe: Microsoft ReportViewer Pin
IgaBaro29-Jan-13 16:28
memberIgaBaro29-Jan-13 16:28 
QuestionHow to detect a Mobile device name Pin
MoDy kareem28-Jan-13 4:55
memberMoDy kareem28-Jan-13 4:55 
QuestionPLZ any one tell me the program to open an exe file with parallel port using visual basic Pin
kspcr26-Jan-13 1:20
memberkspcr26-Jan-13 1:20 
SuggestionRe: PLZ any one tell me the program to open an exe file with parallel port using visual basic Pin
Richard MacCutchan26-Jan-13 2:25
mvpRichard MacCutchan26-Jan-13 2:25 
Questiondeveloping an software Pin
liltil1024-Jan-13 2:28
memberliltil1024-Jan-13 2:28 
AnswerRe: developing an software Pin
Richard MacCutchan24-Jan-13 2:52
mvpRichard MacCutchan24-Jan-13 2:52 
AnswerRe: developing an software Pin
Dave Kreskowiak24-Jan-13 4:38
mvpDave Kreskowiak24-Jan-13 4:38 
Questioninsert data in single column of table in database fom difftern txtbox Pin
supriya93123-Jan-13 20:48
membersupriya93123-Jan-13 20:48 
QuestionRe: insert data in single column of table in database fom difftern txtbox Pin
Eddy Vluggen24-Jan-13 1:49
mvpEddy Vluggen24-Jan-13 1:49 
AnswerRe: insert data in single column of table in database fom difftern txtbox Pin
Abhinav S24-Jan-13 2:19
mvpAbhinav S24-Jan-13 2:19 
AnswerRe: insert data in single column of table in database fom difftern txtbox Pin
ujju.129-Jan-13 21:21
memberujju.129-Jan-13 21:21 
QuestionEvents Pin
Member 962135423-Jan-13 19:02
memberMember 962135423-Jan-13 19:02 
AnswerRe: Events Pin
Richard MacCutchan24-Jan-13 0:12
mvpRichard MacCutchan24-Jan-13 0:12 
AnswerRe: Events Pin
ProgramFOX26-Jan-13 4:52
member ProgramFOX26-Jan-13 4:52 
QuestionText Box Pin
Member 962135423-Jan-13 18:56
memberMember 962135423-Jan-13 18:56 
AnswerRe: Text Box Pin
Eddy Vluggen24-Jan-13 1:48
mvpEddy Vluggen24-Jan-13 1:48 
AnswerRe: Text Box Pin
Richard Deeming24-Jan-13 2:42
memberRichard Deeming24-Jan-13 2:42 
QuestionMasked Textbox Pin
Member 962135423-Jan-13 18:50
memberMember 962135423-Jan-13 18:50 
AnswerRe: Masked Textbox Pin
Richard MacCutchan24-Jan-13 0:09
mvpRichard MacCutchan24-Jan-13 0:09 
QuestionVb 6.0 youtube video downloader Pin
Nassimch23-Jan-13 9:24
memberNassimch23-Jan-13 9:24 
AnswerRe: Vb 6.0 youtube video downloader Pin
Dave Kreskowiak23-Jan-13 12:17
mvpDave Kreskowiak23-Jan-13 12: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.


Advertise | Privacy | Mobile
Web01 | 2.8.170118.1 | Last Updated 20 Jan 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid