Comments by donaldliaw87

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!

Comments by donaldliaw87 (Top 27 by date)