Ah.. coming from a C background this is where I can lament on the sloppy programming practices of writing in visual basic.
On Sat, Mar 21, 2009 at 7:06 AM, Jeena Ajiesh <[email protected]> wrote: > Hi paradap, > this is the code > > --------------------- > ------------------------ > total = m1 + m2 + m3 + m4 + m5 + m6 + m7 + m8 + m9 + m10 + m11 + m12 > > percent = total / ct.Text > What is the value of percent at this point break. > Dim from, gradeto, name, desc As String > > here you are Dim these vars as string. from and gradeto are better off as floats. > 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* > here you're comparing a numeric versus a string. > txtgrade.Text = name > > txtremark.Text = desc > > 'Exit While > > End If > Here you're saying the while statement ends in the if loop. THat's like saying ( { ) }. Which mathematically is just plain wrong (nested loops). > 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. > -- Charles A. Lopez [email protected] Bachelor of Arts - Computer Science New York University Registered Microsoft Partner New York City, NY
