Click here to Skip to main content
       

Visual Basic

 
SuggestionRe: WebBrowser Dock covers up statusstrip PinmvpEddy Vluggen31-Jan-13 4:38 
GeneralRe: WebBrowser Dock covers up statusstrip PinmvpDave Kreskowiak31-Jan-13 7:52 
GeneralRe: WebBrowser Dock covers up statusstrip PinmvpEddy Vluggen31-Jan-13 11:12 
GeneralRe: WebBrowser Dock covers up statusstrip PinmemberNSoft Studios3-Feb-13 13:58 
AnswerRe: WebBrowser Dock covers up statusstrip Pinmemberrohitvermasrt31-Jan-13 19:28 
QuestionQuery dataTable with .Compute Pinmembermebjen30-Jan-13 10:05 
AnswerRe: Query dataTable with .Compute PinmvpDave Kreskowiak30-Jan-13 11:20 
GeneralRe: Query dataTable with .Compute Pinmembermebjen30-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 PinmvpDave Kreskowiak30-Jan-13 15:28 
QuestionWindows admin mode mistries Pinmembersolankinkdpr30-Jan-13 2:11 
AnswerRe: Windows admin mode mistries PinmvpEddy Vluggen30-Jan-13 8:51 
GeneralRe: Windows admin mode mistries Pinmembersolankinkdpr30-Jan-13 20:07 
AnswerRe: Windows admin mode mistries PinmvpEddy Vluggen30-Jan-13 23:35 
GeneralRe: Windows admin mode mistries Pinmembersolankinkdpr31-Jan-13 3:29 
GeneralRe: Windows admin mode mistries PinmvpEddy Vluggen31-Jan-13 4:21 
AnswerRe: Windows admin mode mistries PinmvpDave Kreskowiak30-Jan-13 9:26 
Questionserial number with project Pinmemberolivertechy29-Jan-13 16:33 
AnswerRe: serial number with project PinmvpEddy Vluggen30-Jan-13 9:17 
QuestionParse XML Response String And Get Usable Variables Pinmemberpjgoodis29-Jan-13 5:46 
AnswerRe: Parse XML Response String And Get Usable Variables PinmemberAlan N29-Jan-13 7:05 
GeneralRe: Parse XML Response String And Get Usable Variables Pinmemberpjgoodis29-Jan-13 23:05 
GeneralRe: Parse XML Response String And Get Usable Variables [modified] PingroupStyleTech Solutions Ltd4-Feb-13 7:28 
QuestionMicrosoft ReportViewer PinmemberIgaBaro28-Jan-13 17:30 
AnswerRe: Microsoft ReportViewer PinmemberIgaBaro29-Jan-13 16:28 
QuestionHow to detect a Mobile device name PinmemberMoDy kareem28-Jan-13 4:55 

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
Web01 | 2.8.141223.1 | Last Updated 26 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid