Click here to Skip to main content
14,694,717 members
Home » Discussions » C#
   

C#

 
QuestionResize and move a drawn rectangle in win forms Pin
Member 1223285027-Apr-20 13:23
MemberMember 1223285027-Apr-20 13:23 
AnswerRe: Resize and move a drawn rectangle in win forms Pin
Luc Pattyn27-Apr-20 14:17
sitebuilderLuc Pattyn27-Apr-20 14:17 
GeneralRe: Resize and move a drawn rectangle in win forms Pin
Member 1223285027-Apr-20 20:38
MemberMember 1223285027-Apr-20 20:38 
GeneralRe: Resize and move a drawn rectangle in win forms Pin
Luc Pattyn28-Apr-20 5:50
sitebuilderLuc Pattyn28-Apr-20 5:50 
GeneralRe: Resize and move a drawn rectangle in win forms Pin
Member 1223285028-Apr-20 18:56
MemberMember 1223285028-Apr-20 18:56 
GeneralRe: Resize and move a drawn rectangle in win forms Pin
Luc Pattyn29-Apr-20 3:30
sitebuilderLuc Pattyn29-Apr-20 3:30 
QuestionDate compare Pin
Carlos5827-Apr-20 11:42
MemberCarlos5827-Apr-20 11:42 
AnswerRe: Date compare Pin
Luc Pattyn27-Apr-20 12:00
sitebuilderLuc Pattyn27-Apr-20 12:00 
Hi,

you are using a mix of parameter substitution (which is good) and direct string concatenation (which is bad).

When concatenating (which is bad) SQL expects dates or datetimes in a specific format and inside quotes.

Why don't you use AddWithValue() for the date as well?

Some examples[^]

Smile | :)
Luc Pattyn [My Articles] Nil Volentibus Arduum

GeneralRe: Date compare Pin
Carlos5827-Apr-20 13:31
MemberCarlos5827-Apr-20 13:31 
GeneralRe: Date compare Pin
Luc Pattyn27-Apr-20 13:48
sitebuilderLuc Pattyn27-Apr-20 13:48 
GeneralRe: Date compare Pin
Carlos5828-Apr-20 3:19
MemberCarlos5828-Apr-20 3:19 
GeneralRe: Date compare Pin
Luc Pattyn28-Apr-20 3:24
sitebuilderLuc Pattyn28-Apr-20 3:24 
SuggestionRe: Date compare Pin
Richard Deeming28-Apr-20 1:40
mveRichard Deeming28-Apr-20 1:40 
AnswerRe: Date compare Pin
Carlos5828-Apr-20 3:23
MemberCarlos5828-Apr-20 3:23 
QuestionRename files in WinScp Directory using C# Pin
Sriram Valluri27-Apr-20 2:13
MemberSriram Valluri27-Apr-20 2:13 
AnswerRe: Rename files in WinScp Directory using C# Pin
ZurdoDev27-Apr-20 2:21
mveZurdoDev27-Apr-20 2:21 
GeneralRe: Rename files in WinScp Directory using C# Pin
Sriram Valluri27-Apr-20 3:15
MemberSriram Valluri27-Apr-20 3:15 
GeneralRe: Rename files in WinScp Directory using C# Pin
ZurdoDev27-Apr-20 3:27
mveZurdoDev27-Apr-20 3:27 
AnswerRe: Rename files in WinScp Directory using C# Pin
Jin Vincent Necesario27-Apr-20 3:36
professionalJin Vincent Necesario27-Apr-20 3:36 
GeneralRe: Rename files in WinScp Directory using C# Pin
Sriram Valluri27-Apr-20 9:07
MemberSriram Valluri27-Apr-20 9:07 
AnswerRe: Rename files in WinScp Directory using C# Pin
Luc Pattyn27-Apr-20 9:21
sitebuilderLuc Pattyn27-Apr-20 9:21 
GeneralRe: Rename files in WinScp Directory using C# Pin
Sriram Valluri27-Apr-20 22:21
MemberSriram Valluri27-Apr-20 22:21 
QuestionMulticombobox in datagridview c# Pin
Member 1347974626-Apr-20 17:12
MemberMember 1347974626-Apr-20 17:12 
AnswerRe: Multicombobox in datagridview c# Pin
OriginalGriff26-Apr-20 20:25
mveOriginalGriff26-Apr-20 20:25 
QuestionAccess Rights Management Pin
Member 1481258225-Apr-20 14:13
MemberMember 1481258225-Apr-20 14:13 

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.