Click here to Skip to main content
       

Visual Basic

 
GeneralRe: Search criteria - classic asp not working PinmvpEddy Vluggen7-Feb-13 8:13 
AnswerRe: Search criteria - classic asp not working PinmvpEddy Vluggen8-Feb-13 11:04 
QuestionWebBrowser Dock covers up statusstrip PinmemberNSoft Studios30-Jan-13 15:46 
AnswerRe: WebBrowser Dock covers up statusstrip PinmvpRichard MacCutchan30-Jan-13 22:13 
AnswerRe: WebBrowser Dock covers up statusstrip PinmvpEddy Vluggen30-Jan-13 22:36 
GeneralRe: WebBrowser Dock covers up statusstrip PinmvpDave Kreskowiak31-Jan-13 3:35 
SuggestionRe: WebBrowser Dock covers up statusstrip PinmvpEddy Vluggen31-Jan-13 3:38 
GeneralRe: WebBrowser Dock covers up statusstrip PinmvpDave Kreskowiak31-Jan-13 6:52 
GeneralRe: WebBrowser Dock covers up statusstrip PinmvpEddy Vluggen31-Jan-13 10:12 
GeneralRe: WebBrowser Dock covers up statusstrip PinmemberNSoft Studios3-Feb-13 12:58 
AnswerRe: WebBrowser Dock covers up statusstrip Pinmemberrohitvermasrt31-Jan-13 18:28 
QuestionQuery dataTable with .Compute Pinmembermebjen30-Jan-13 9:05 
AnswerRe: Query dataTable with .Compute PinmvpDave Kreskowiak30-Jan-13 10:20 
GeneralRe: Query dataTable with .Compute Pinmembermebjen30-Jan-13 10: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 PinmvpDave Kreskowiak30-Jan-13 14:28 
QuestionWindows admin mode mistries Pinmembersolankinkdpr30-Jan-13 1:11 
AnswerRe: Windows admin mode mistries PinmvpEddy Vluggen30-Jan-13 7:51 
GeneralRe: Windows admin mode mistries Pinmembersolankinkdpr30-Jan-13 19:07 
AnswerRe: Windows admin mode mistries PinmvpEddy Vluggen30-Jan-13 22:35 
GeneralRe: Windows admin mode mistries Pinmembersolankinkdpr31-Jan-13 2:29 
GeneralRe: Windows admin mode mistries PinmvpEddy Vluggen31-Jan-13 3:21 
AnswerRe: Windows admin mode mistries PinmvpDave Kreskowiak30-Jan-13 8:26 
Questionserial number with project Pinmemberolivertechy29-Jan-13 15:33 
AnswerRe: serial number with project PinmvpEddy Vluggen30-Jan-13 8:17 
QuestionParse XML Response String And Get Usable Variables Pinmemberpjgoodis29-Jan-13 4:46 
AnswerRe: Parse XML Response String And Get Usable Variables PinmemberAlan N29-Jan-13 6:05 
GeneralRe: Parse XML Response String And Get Usable Variables Pinmemberpjgoodis29-Jan-13 22:05 
GeneralRe: Parse XML Response String And Get Usable Variables [modified] PingroupStyleTech Solutions Ltd4-Feb-13 6:28 
QuestionMicrosoft ReportViewer PinmemberIgaBaro28-Jan-13 16:30 
AnswerRe: Microsoft ReportViewer PinmemberIgaBaro29-Jan-13 15:28 
QuestionHow to detect a Mobile device name PinmemberMoDy kareem28-Jan-13 3:55 
QuestionPLZ any one tell me the program to open an exe file with parallel port using visual basic Pinmemberkspcr26-Jan-13 0:20 
SuggestionRe: PLZ any one tell me the program to open an exe file with parallel port using visual basic PinmvpRichard MacCutchan26-Jan-13 1:25 
Questiondeveloping an software Pinmemberliltil1024-Jan-13 1:28 
AnswerRe: developing an software PinmvpRichard MacCutchan24-Jan-13 1:52 
AnswerRe: developing an software PinmvpDave Kreskowiak24-Jan-13 3:38 
Questioninsert data in single column of table in database fom difftern txtbox Pinmembersupriya93123-Jan-13 19:48 
QuestionRe: insert data in single column of table in database fom difftern txtbox PinmvpEddy Vluggen24-Jan-13 0:49 
AnswerRe: insert data in single column of table in database fom difftern txtbox PinmvpAbhinav S24-Jan-13 1:19 
AnswerRe: insert data in single column of table in database fom difftern txtbox Pinmemberujju.129-Jan-13 20:21 
QuestionEvents PinmemberMember 962135423-Jan-13 18:02 
AnswerRe: Events PinmvpRichard MacCutchan23-Jan-13 23:12 
AnswerRe: Events Pinmember ProgramFOX26-Jan-13 3:52 
QuestionText Box PinmemberMember 962135423-Jan-13 17:56 
AnswerRe: Text Box PinmvpEddy Vluggen24-Jan-13 0:48 
AnswerRe: Text Box PinmemberRichard Deeming24-Jan-13 1:42 
QuestionMasked Textbox PinmemberMember 962135423-Jan-13 17:50 
AnswerRe: Masked Textbox PinmvpRichard MacCutchan23-Jan-13 23:09 
QuestionVb 6.0 youtube video downloader PinmemberNassimch23-Jan-13 8:24 
AnswerRe: Vb 6.0 youtube video downloader PinmvpDave Kreskowiak23-Jan-13 11:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web03 | 2.8.140902.1 | Last Updated 1 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid