Search results for query: *

tx kulrom! it work, thanks for the guided and help! regards; charlotte

thanks, jmcilhinney. if i write a.APP_CAT As APP_CAT_A, b.APP_CAT As APP_CAT_B then my datagrid will become:- APP_CAT_A ssss APP_CAT_B TRAINEE sssssssssssTRAINEE STAFF sssssssssssssSTAFF but i want my datagrid to be:- APP_CAT TRAINEE STAFF So how? actually what i want to do is...

hi, help needed! below are my coding, i have a datagrid. and i want the records display in the datagrid are select from two table. Dim SQL_Cat, SQL_Dept, SQL_Yr, SQL_Cat1, SQL_Dept1, SQL_Yr1 As String ' For ESC_APPLICANT If ddlCat.SelectedItem.Text <> "" Then SQL_Cat = "And APP_CAT LIKE...

thanks dashley! i try to use MySql = "Select * from ESC_APPLY where valid_to < TO_DATE('" & Now & "','MM/DD/YYYY')" i change my data type for valid_to to Date in my database already! but an error occur! ORA-01830: date format picture ends before converting entire input string...

tx kulrom. i try to delete the # and using Ctype(a.APP_VDATE_TO, Date) < '" & DateTime.Now.ToString() & "' it display another error for me! One or more errors occurred during processing of command. ORA-00936: missing expression Description: An unhandled exception occurred...

tx juggaloBrotha! it really only work with the MS Acess! i dunno what is going wrong! besides, i still wan maintain the data type of the valid_date as VARCHAR. i dun wan it to change to the Date type! any others suggestion? anyway thanks a lot! regards; charlotte

hi, help needed! i'm doing a vb.net project! i use MS Access as my database at the beginning. so i use:- CDate(valid_date) < # " & DateTime.Now.ToString("dd/MM/yyyy") & "# to get some record that the valid_date is < than today date! it work well when using MS Access. (NOTE: data type...

hi, help needed! i'm doing a vb.net project! i use MS Access as my database at the beginning. so i use:- CDate(valid_date) < # " & DateTime.Now.ToString("dd/MM/yyyy") & "# to get some record that the valid_date is < than today date! it work well when using MS Access. (NOTE: data type...

hi,a help needed! i wanna ask some Qs regarding the datareader? i have a select statement that select all the email add (for the badge that overdue.) then i use datareader to read it row by row(it contain 1 column but many row! as below) how am i going to write it coding...