Click here to Skip to main content
12,065,888 members (27,563 online)

Visual Basic

 
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 

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
Web02 | 2.8.160207.1 | Last Updated 7 Feb 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid