ilyas bai aslamoalikum
i try my best to understand ur code .but fail the reason may be is
that i dont like VB or not much familar with it.i could,nt
understand
how u assign recordset values [ cdbl(asRS("Sal")) +
cdbl(asRS("Comm")) ] to a [ amt] variable.
i use lessDSN connection and sending u code which i m useing .and i
want to assign record set values [(rsResult("Marks")) ] to a
variable
[ttnm ].
please tell simle modification. in my code .also should kept in mind
that i am also feeling difficulty in use VB loops.and control
statments
which i think are more difficult than other language. i want easy
control .
<%
Dim adoCon,rsResult,strSQL,ttnm,amt
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
Server.MapPath("Resultbook.mdb")
Set rsResult = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblmarks.Subject, tblmarks.Marks FROM tblMarks;"
rsResult.Open strSQL, adoCon
Do While not rsResult.EOF
ttnm = rsResult("Marks")
amt = ttnm + ttnm
Response.Write ("<br>")
Response.Write (rsResult("Subject"))
Response.Write ("<br>")
Response.Write <i>(rsResult("Marks")) </i>
Response.Write ("<br>")
Response.Write ("Total Marks")
Response.Write ("<br>")
Response.Write "ttnm"
Response.Write ("<br>")
rsResult.MoveNext
Loop
rsResult.Close
Set rsResult = Nothing
Set adoCon = Nothing
%>
On Sep 22, 5:31 pm, shani <[EMAIL PROTECTED]> wrote:
> thank u bai , i will must use this code and then tell u result.
>
> On Sep 21, 6:58 pm, "mushtaq ilyas" <[EMAIL PROTECTED]> wrote:
>
>
>
> > look shani if u want to get the average or sum of the data u can don in this
> > way for eg u can copy this code and paste in notepad or microsoft front page
> > foraspapplications usually i like to comment what i am doing in my code it
> > is a good coding practice for you
> > to remember what you done in the code for future upgradations
>
> > <%@ Language="vbscript"%>
>
> > <%
> > 'decalre some variables here
> > '-------------------------------------------------
> > dim amt
>
> > 'declare connections and recordset objects
> > '-------------------------------------------------
> > set ASConn = Server.CreateObject("ADODB.Connection")
> > Set asRS = Server.CreateObject("ADODB.Recordset")
>
> > '--------open connections-----------------------------
> > ASConn.Open = "DSN=Your Dsn Name;Uid=rocky;Pwd=abcXYZ"
> > ASConn.CommandTimeout = 0
>
> > strSQL = "SELECT * FROM Emp"
>
> > asRS.Open strSQL,ASConn
>
> > Do While Not asRS.EOF
>
> > If asRS("Cnty") = "USD" Then
>
> > amt = cdbl(asRS("Sal")) + cdbl(asRS("Comm"))
>
> > asRS.MoveNext
> > else
>
> > amt = cdbl(asRS("Sal"))
> > Loop
>
> > Response.Write "Records Inserted Successfully.."
>
> > '--------Close connections---------------
>
> > ASConn.Close
> > asRS.close
> > set asRS = Nothing
>
> > %>
>
> > I hope this is what uneedalways declare some varialbe and do ur operations
> > accordingly .if uneedfurther assistance just reply me back
>
> > Bye and Take Care
>
> > Mohammed Mushtaq Ilyas
>
> > Software Developer
>
> > Dubai.U.A.E
>
> > On Sun, Sep 21, 2008 at 7:03 AM, shani <[EMAIL PROTECTED]> wrote:
>
> > > thank u mushtaq bhai , my problem is that when i get any data from
> > > database through recordset ,i only can display it on web page .for
> > > example that was numaric data .and i want to get the total or average
> > > of that data ..etc i mean how can i apply such opperrations on that
> > > data. ( i m not expert person so please describe in easy manner )
> > > thank u.
>
> > > On Sep 18, 11:33 pm, "mushtaq ilyas" <[EMAIL PROTECTED]> wrote:
> > > > Hi shani
> > > > Can you be a little bit more precise what exactly you want to know so
> > > that i
> > > > canhelpyou
>
> > > > On Thu, Sep 18, 2008 at4:36 PM, shani <[EMAIL PROTECTED]> wrote:
>
> > > > > i m new person .i m making a web page wich can show result card .but i
> > > > > can not manage valus of variables . can i work with recordset as
> > > > > variable and control statments .please tell me .how can i do . thank
> > > > > you.- Hide quoted text -
>
> > > > - Show quoted text -- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
