Click here to Skip to main content
12,698,366 members (24,319 online)

Visual Basic

 
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 
GeneralRe: Query dataTable with .Compute Pin
Dave Kreskowiak30-Jan-13 15:28
mvpDave Kreskowiak30-Jan-13 15:28 
You don't need to specify System. The System namespace is automatically imported in VB.NET. You also don't need to specify System.Type.GetType... GetType alone is sufficient.
Dim col_invDate As DataColumn = New DataColumn("invDate")
    col_invDate.DataType = System.Type.GetType("System.DateTime")
    salesTable.Columns.Add(col_invDate)

should become this:
Dim col_invDate As DataColumn = New DataColumn("invDate")
    col_invDate.DataType = GetType(DateTime)
    salesTable.Columns.Add(col_invDate)


Next, according to the documentation on DataTable.Compute and DataColumn.Expression, a DateTime value should be enclosed in single quotes or the # sign, depending on the underlying data provider.

...and to make things MUCH easier to read, don't use string concatentation:
x0 = yrSales.Compute("SUM(extPrice)", String.Format("shipToName = '{0}' AND invDate > #{1}# AND invDate < #{2}#", stn, begDate, endDate))


BTW: x0 is a terrible variable name. By looking at the variable name alone, what does it contain?? There is no way to tell.

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 
QuestionHow to convert vb.net application to work online Pin
napolewn22-Jan-13 1:54
membernapolewn22-Jan-13 1:54 

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.170118.1 | Last Updated 21 Jan 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid