Click here to Skip to main content
15,898,945 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Form resize : controls alignment and size Pin
Dave Kreskowiak28-Oct-07 4:30
mveDave Kreskowiak28-Oct-07 4:30 
GeneralRe: Form resize : controls alignment and size Pin
nishkarsh_k28-Oct-07 6:20
nishkarsh_k28-Oct-07 6:20 
GeneralRe: Form resize : controls alignment and size Pin
Dave Kreskowiak28-Oct-07 12:26
mveDave Kreskowiak28-Oct-07 12:26 
QuestionSave as Excel spreadsheet Pin
Dave McCool28-Oct-07 3:22
Dave McCool28-Oct-07 3:22 
AnswerRe: Save as Excel spreadsheet Pin
Paul Conrad28-Oct-07 7:19
professionalPaul Conrad28-Oct-07 7:19 
QuestionGet information from text file Pin
Dave McCool28-Oct-07 3:09
Dave McCool28-Oct-07 3:09 
AnswerRe: Get information from text file Pin
C1AllenS28-Oct-07 5:28
C1AllenS28-Oct-07 5:28 
Questiondate vb.net2005 & sqlserver 2005 Pin
nilam1128-Oct-07 2:51
nilam1128-Oct-07 2:51 
hi guys

maskedtextbox1.mask = "##/##/####"
mskedtextbox2.mask = "##/##/####"

i am using maskedtextbox for getting i/p of date. i have taken mask properties short datetime. my data is stored in sql server 2005 where i have taken data type is varchar(10) in dd/mm/yyyy format (28/08/2007 & 31/08/2007).

my problem is that when i execute the sql query for the selected period in maskedtextbox it does not show correct data.

e.g.

sql_str = "insert mdate into xyz (select mdate from abc where " & _

"mdate between" & " '" &maskedtextbox1.text& "' and '"&mskedtextbox2.text&"'"
"and flag= '" & mflag & "')"

or using where condition it is not executing correct data.

can i get where i am wrong ? if is there any more suggestion for me suggest me.



Thanks
bye

AnswerRe: date vb.net2005 & sqlserver 2005 Pin
Guffa28-Oct-07 3:15
Guffa28-Oct-07 3:15 
GeneralRe: date vb.net2005 & sqlserver 2005 Pin
nilam1128-Oct-07 3:26
nilam1128-Oct-07 3:26 
GeneralRe: date vb.net2005 & sqlserver 2005 Pin
Dave Kreskowiak28-Oct-07 4:22
mveDave Kreskowiak28-Oct-07 4:22 
GeneralRe: date vb.net2005 & sqlserver 2005 Pin
Salman Sheikh29-Oct-07 22:36
Salman Sheikh29-Oct-07 22:36 
GeneralRe: date vb.net2005 & sqlserver 2005 Pin
Dave Kreskowiak30-Oct-07 2:04
mveDave Kreskowiak30-Oct-07 2:04 
Questionshow currency with 3 decimal places Pin
SamRST27-Oct-07 22:21
SamRST27-Oct-07 22:21 
AnswerRe: show currency with 3 decimal places Pin
Muhammad Shahid Farooq28-Oct-07 8:37
professionalMuhammad Shahid Farooq28-Oct-07 8:37 
GeneralRe: show currency with 3 decimal places Pin
SamRST28-Oct-07 22:39
SamRST28-Oct-07 22:39 
QuestionVB.Net on MacOSX with Mono Pin
ryan11727-Oct-07 18:45
ryan11727-Oct-07 18:45 
AnswerRe: VB.Net on MacOSX with Mono Pin
Dave Kreskowiak28-Oct-07 4:18
mveDave Kreskowiak28-Oct-07 4:18 
AnswerRe: VB.Net on MacOSX with Mono Pin
DaveX8628-Oct-07 5:54
DaveX8628-Oct-07 5:54 
AnswerRe: VB.Net on MacOSX with Mono Pin
ryan11728-Oct-07 22:13
ryan11728-Oct-07 22:13 
GeneralSQL Express Backup Automated Pin
Darcy J Williamson27-Oct-07 9:33
Darcy J Williamson27-Oct-07 9:33 
GeneralRe: SQL Express Backup Automated Pin
Hesham Amin27-Oct-07 10:26
Hesham Amin27-Oct-07 10:26 
GeneralRe: SQL Express Backup Automated Pin
Paul Conrad27-Oct-07 13:04
professionalPaul Conrad27-Oct-07 13:04 
GeneralRe: SQL Express Backup Automated Pin
Darcy J Williamson27-Oct-07 14:11
Darcy J Williamson27-Oct-07 14:11 
QuestionBeginner needs help with VB6 / VB.NET Pin
a youda27-Oct-07 9:21
a youda27-Oct-07 9:21 

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.