Search results for query: *

  1. S

    System.IndexOutOfRangeException Error?

    thanks cjard, you are right :D I used .rows.count and managed to calculate how many rows whereby I can proceed to use a loop
  2. S

    LIKE subquery

    even though i tried ("SELECT petName FROM faculty where petName LIKE '%@teacherN%' ", connection) it cannot be done as well
  3. S

    LIKE subquery

    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?
  4. S

    System.IndexOutOfRangeException Error?

    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...
  5. S

    System.IndexOutOfRangeException Error?

    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 :(
  6. S

    System.IndexOutOfRangeException Error?

    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...
  7. S

    Question regarding date time

    hi cjard You mentioned about IDE where can I find it? It will be good if I have something to refer to :D
  8. S

    loops controls

    thanks a lot cjard appreciate that :)
  9. S

    loops controls

    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.
  10. S

    loops controls

    anyone can help me ?
  11. S

    loops controls

    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...
  12. S

    loops controls

    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;
  13. S

    loops controls

    any suggestion in java its like lbl+i = ...
  14. S

    loops controls

    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
  15. S

    Question regarding date time

    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?
  16. S

    Question regarding date time

    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...
Back
Top