Hi,
How do i perform like sql subquery in vb.net ?
i tried
("SELECT petName FROM faculty where petName LIKE %'@teacherN'% ", connection)
command.parameter.add("@teacherN",textbox1.text)
but it doesn't return anything to me even though it should .. any idea?
hmm no replies :(
the ultimate objective is to check if the dataset contain no more rows in there
Dim i as Integer = 0
Dim timeofuse() As integer
While result1.Tables("Facility").Rows(i).Items("TimeOfUse")
timeofuse(i) = result1.Tables("Facility").Rows(i).Items("TimeOfUse")
after...
To further elaborate my situation, from the data extracted from the dataset I want to check to see whether either of them is 900,1000,1100,1200
sorry for being long winded :(
hi there,
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...
Hi there, thanks for enlightening me, was too stressed out yesterday.
How do I actually store all the labels in 1 line via array?
I have like 10 labels spreading them out in 10 lines will be too long.
thanks.
I'm sorry for my poor command of english
I have those labels inside a table therefore I cannot combine them.
Those labels are called lbl1, lbl2, lbl3 and lbl4
I have a dataset containing some data I found
my loop looks like this
Dim starttime as Integer
Dim i As interger
Dim count as...
lol1, lol2 , lol3 and lol4 are labels
i wanted to change the text acordingly to the loop
take it as I have 4 labels
for count 1 to 4
if (count = 1)
i want lbl+1/2/3/4.text = lol2;
elseif
i want lbl+1/2/3/4.text = lol2;
say if I have these few labels
lbl1
lbl2
lbl3
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
Thanks, that help was useful.
I know about
Date.Today.AddDays(1) means add 1 days to the current date
but how do i subtract 1 day from the current date?
I understand
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.