How do i perform like sql subquery in vb.net ?
("SELECT petName FROM faculty where petName LIKE %'@teacherN'% ", connection)
but it doesn't return anything to me even though it should .. any idea?
sorry this is the third thread I created :(
based on the last 2 thread help I managed to store the labels into array and figured out about the date
how do I actually extracted all the data from 1 colum out? my select query is to abstract few rows of interger depending on what...
say if I have these few labels
inside the loop
for count from 1 to 3
how do I change the lbl1 and lbl2 and lbl3.text accordingly inside the loop?
I tried lbl[i] doesn't work as well.
Many help appreciated :D
date.today will give me the date
how do I get what day is it? Example Tuesday or so for today date?
my database has a date value in there, may I know how do I compare the value of date.today along with the value after executing the sql command to extract the data. say I put...