15,897,187 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by donaldliaw87 (Top 27 by date)
donaldliaw87
22-Jun-14 21:11pm
View
hi Kschuler! i'm a little bit understand what you explained, so the first thing i have to do is to loop particular column's rows instead of for each loop) and [after first checkeditem been loop, i have to wrote something to allow it loop trough the next checkeditem]. Please guide me am i in right-path!?
donaldliaw87
28-Apr-14 3:41am
View
my case is like this: the checked items were users id, and will generate datetime.days(30 or 31) for each checked userid and insert into temporary table.
donaldliaw87
8-Apr-14 21:36pm
View
Tq Peter!!!!, your clear guidance reminded me "must understand and check the datatype" before coding!
donaldliaw87
8-Apr-14 4:46am
View
hi Peter Leow thx for the guides!
i still got another issue: when i change the declaration of datetime to (dim startdate as DateTime = new DateTime (DateTimePicker1.value) its gave me an error stated "value of type date cannot convert to long"
i try to pass the both datetimepickers.value to variable string still face the same error!
donaldliaw87
7-Apr-14 22:22pm
View
sorry, am asking the wrong way, to faster the asking... how to show ranged dates picked from datetimepickers and show results like this? (01/01/2014
02/01/2014
03/01/2014
04/01/2014
05/01/2014
06/01/2014
07/01/2014
08/01/2014
09/01/2014)
donaldliaw87
25-Nov-13 21:34pm
View
i was getting values from a device and this device's sdk (datetime) designed to get date and time separately, therefore i have to declare and get the values separately as well!
donaldliaw87
22-Nov-13 3:37am
View
this is what i want actually although i got my own solution will switch to use yours thx man another good answer~!
donaldliaw87
22-Nov-13 3:12am
View
thx for your opinion, ok insert don't have where clause, i got it.
> the id i already set to uniqe key
> i think i have to do a select statement to do compare, because i download and insert the id from certain machines
donaldliaw87
22-Nov-13 0:06am
View
thx Abhinav S, it works now ^^
donaldliaw87
23-Sep-13 1:19am
View
i try your advice but still the errors come out~!
donaldliaw87
23-Sep-13 1:18am
View
sorry maybe i did not ask my question clear! as i stated i'm new to sql and i'm very sure i must use TCP method to connect to my hosted database in another computer, i'm just lack of experience on such errors so need guides from you all thx for the help 1st
donaldliaw87
28-Aug-13 20:33pm
View
Hi Johnny J,
i was appreciate your given solution!!! you were good in sql server rite? may i ask a small help form you?
>i had installed sql server but how to host my application's database?, so my other computer able to access! i have no idea on this!
> any guides or links can recommend?
donaldliaw87
9-Jul-13 19:39pm
View
ok zzzz why i did not think of put that converter when load out==", thx very much OriginalGriff i will try!!!
donaldliaw87
8-Jul-13 20:51pm
View
i change to datetimepicker1.value that you had advised but still the same, can you help me again have a look on my codes presented to user ?
donaldliaw87
8-Jul-13 20:46pm
View
ok i try your advice!!
donaldliaw87
8-Jul-13 6:36am
View
HI originalfriff, my datatype in db is date i'm just get date from datetimepicker and store datevalue into date field. what if i don't want the 00:00:00, is it possible can be done?
cmd.Parameters.AddWithValue("@StartDate", DateTimePicker1.Value.ToShortDateString)
but why still time still exist~!?
donaldliaw87
17-Jun-13 2:09am
View
i found out what's wrong edy!!! i did not change my column name i only changed the text header that's why i can't get my requirement ==" sorry was my mistake haiz............. sorry!
donaldliaw87
17-Jun-13 1:57am
View
i got this error="Column named Status cannot be found.
Parameter name: columnName" how to solve this?? pls help me!!
donaldliaw87
16-Jun-13 21:14pm
View
Did you mean my load event sub?? ofcourse i got handles clause it in my formload just only i did not post up my handle clause because of unnecessary, my main problem was on changing color!!!
donaldliaw87
16-Jun-13 21:11pm
View
hi yourfriendaks, the add of (.tostring) can't help me.....
donaldliaw87
16-Jun-13 21:07pm
View
CHill60, you mean you pasted which sub? the load event sub or the cellformatting sub?? i tried the solution you all gave me (trim().tostring.cells(""), but still can't get what i want T.T"!!!
donaldliaw87
14-Jun-13 8:03am
View
will try soon.... thx shifu.....! Got question to ask!!, e.g. if inserting a line of words into a data field char(100), will that line of words bit different with what we key in? will it be? sorry ask this kind of question, i'm new to programming!!!
donaldliaw87
14-Jun-13 7:51am
View
yes! i checked for few times edy, in the field "status" only content 3 types of char(20) value (Pending,In Progress, & Close) but weird can't change at all....
donaldliaw87
14-Jun-13 7:46am
View
sorry unclear explanation~! actually i want to change row colour based on cell value, but i fail to achieve, therefore i try to change my cell(10)'str' to cell(0)'int' to see whether it change or not and my datarow could change the colour with cell(0) with 'int' value, but when i change back to cell(10) with str value it unable to change my datarow colour~!
donaldliaw87
12-Jun-13 2:23am
View
erm my parameter which past values, i try what you taught still getting the same error msg....
donaldliaw87
12-Jun-13 2:05am
View
hi damian s you mean i have to code like this e.g: UPDATE table SET CreateBy=@CreateBy, ?? sorry i'm new to vb.net please guide me if i'm wrong....
donaldliaw87
12-Jun-13 2:02am
View
i try your advice... and give you what i get.... thx 1st!
Show More