Heres my scenario:
i have a textbox with a point value for example is 225:
I have a table that looks like the table below. What i want to have is to beable to look at the textbox that has 225 value in it and look at the range in the table below and have the 1st column values 1-10 to show up in a textbox called txtGrade which would be a value of 2 for my example of using 225, im struggling on how to do this.
The below table is my data i have in my sql table. 3 fields called JobGrade LowPoint HighPoint
1 110 170
2 171 230
3 231 290
4 291 350
5 351 410
6 411 480
7 481 540
8 541 600
9 601 660
10 661 720
this is my sql statement i have now. in SSMS i can run this and i get the result i need but how can i get that into my vb studio and into the textbox i want it in
"select jobgrade from mgrdb.dbo.tblGradePointValues" & _
"where " & txtFinal.Text & " between LowPoint and HighPoint"
My issue is im not getting a number 1-10 based on the range to show in my textbox txtJGrade.txt.
so if my txtFinal.text is 225 i should get a 2 in the txtJgrade.txt and for another example if my txtfinal.txt was 530 i should get a 7 in the txtJgrade.txt
Any Ideas how to accomplish what im trying to do?
i have a textbox with a point value for example is 225:
I have a table that looks like the table below. What i want to have is to beable to look at the textbox that has 225 value in it and look at the range in the table below and have the 1st column values 1-10 to show up in a textbox called txtGrade which would be a value of 2 for my example of using 225, im struggling on how to do this.
The below table is my data i have in my sql table. 3 fields called JobGrade LowPoint HighPoint
1 110 170
2 171 230
3 231 290
4 291 350
5 351 410
6 411 480
7 481 540
8 541 600
9 601 660
10 661 720
this is my sql statement i have now. in SSMS i can run this and i get the result i need but how can i get that into my vb studio and into the textbox i want it in
"select jobgrade from mgrdb.dbo.tblGradePointValues" & _
"where " & txtFinal.Text & " between LowPoint and HighPoint"
My issue is im not getting a number 1-10 based on the range to show in my textbox txtJGrade.txt.
so if my txtFinal.text is 225 i should get a 2 in the txtJgrade.txt and for another example if my txtfinal.txt was 530 i should get a 7 in the txtJgrade.txt
Any Ideas how to accomplish what im trying to do?