Translation please

[tyson]

Hi!

I need some help...

I have just begun to use .NET and now i need som translations between ASP and ASP.NET VB

In the old fashion way you could use

Set rst=Con.Execute(SQL)

Do until rst.EOF


rst .MoveNext
loop.

What is the oposit code for the do part in ASP.NET

and this code i ASP

If rst.EOF then
    ' some code
else
   ' some code
end if

and finally

[CODE]
IF rst("IDnumer") = 15 then
' some code
end if


I will be greatful for any help, but i am new at .NET som i need simple explenations

/tyson

[MasterBlaster]

Originally posted by tyson

Set rst=Con.Execute(SQL)

Do until rst.EOF


rst .MoveNext
loop.

foreach(DataRow myrow in mytable)
{
       // todo
}

What is the oposit code for the do part in ASP.NET

and this code i ASP

If rst.EOF then
    ' some code
else
   ' some code
end if

No such thing , don't need to worry about eof any more



and finally

IF rst("IDnumer") = 15 then
    ' some code
end if

if(myrow["IDNumber"] == 15)
{
       //todo
}

I will be greatful for any help, but i am new at .NET som i need simple explenations

/tyson

[tyson]

ok... but if i want to use a similar function as

If rst.EoF then

else

end if

/Tyson

[MasterBlaster]

There is no such thing as EOF.

[MasterBlaster]

http://www.codeproject.com/dotnet/adonet_datareader.asp

Look over this sample. It is pretty simple.

[alex_read]

Here I'm using a datareader object to illustrate one way of doing this...

drSQL = .ExecuteReader(CommandBehavior.CloseConnection)
 
Do While drSQL.read = true
     ' Code Here
Loop

[tyson]

Ok... I shall try it and then i will get back..

thanks for now


/Tyson