Hi paradap,
this is the code
---------------------
------------------------
total = m1 + m2 + m3 + m4 + m5 + m6 + m7 + m8 + m9 + m10 + m11 + m12
percent = total / ct.Text
Dim from, gradeto, name, desc As String
Dim con As New SqlConnection(constr)
con.Open()
Dim cmd As SqlCommand
cmd =
New SqlCommand("select * from grade where UserName ='" & Session(
"CURRENTUSER") & "'and SchoolName='" & lblSchool.Text & "'", con)
Dim sdr As SqlDataReader = cmd.ExecuteReader
Try
While (sdr.Read())
from = sdr(
"gradefrom")
gradeto = sdr(
"gradeto")
name = sdr(
"gradename")
desc = sdr(
"description")
*If (percent >= from) And** (percent <= gradeto*) Then *//not hitting*
txtgrade.Text = name
txtremark.Text = desc
'Exit While
End If
End While
Catch ex As Exception
err.Text = ex.Message
End Try
txttot.Text = total
txtpercent.Text = percent
'txtgrade.Text = gradename
'txtremark.Text = remark
Dim username, schoolname, sname, sid, clas, ename As String
username = lblusername.Text
schoolname = lblSchool.Text
sname = txtsname.Text
clas = ddlclass.SelectedItem.Text
sid = txtid.Text
ename = ddlexamname.SelectedItem.Text
hope this is enough....
Thanks in Advance
On Wed, Mar 18, 2009 at 7:13 PM, Pradap A <[email protected]> wrote:
> hi jeena,
>
> can you give me the expand of your code . then only i will give the
> solution perfectly . thanks
>
> regards
> A.Paradap
>
>
>
> On Wed, Mar 18, 2009 at 7:11 PM, Jeena Ajiesh <[email protected]> wrote:
>
>> Hi all,
>> this may be a small error,
>> anyway the problem is even though the condition is true, its not hitting.
>> I'm retrieving some values from database and storing it in variable.
>> Along with that,I'm comparing the retrieved value with another variable.
>> Even if its true, its not going inside if loop.
>> Can anyone find out that small error.
>>
>> My Code is as follows
>>
>> while sdr.Read()
>> from=sdr(0)
>> to=sdr(1)
>> name=sdr(2)
>> desc=sdr(3)
>> if (percent>=from) And (percent<=to)
>> txtname.text=name //These r not executed.....
>> txtdesc.text=desc
>> End If
>> End While
>> Im doing it in Asp.net,vs2005
>> --
>> ****************
>> Regards,
>> ♪♥♫♥Ĵєєήǎ ♫♥♪♥
>> Email: [email protected]
>> [email protected]
>> [email protected]
>>
>>
>
--
****************
Regards,
♪♥♫♥Ĵєєήǎ ♫♥♪♥
Email: [email protected]
[email protected]
[email protected]
Sent from: Dubayy United Arab Emirates.
