Translation please

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

Code:

---

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

Code:

---


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

Quote:

---

Originally posted by tyson

Code:

---

Set rst=Con.Execute(SQL)

Do until rst.EOF


rst .MoveNext
loop.

---

Code:

---


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

---

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

and this code i ASP

Code:

---


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

Code:

---

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

---

Code:

---

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

---

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

/tyson

---

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

If rst.EoF then

else

end if

/Tyson

There is no such thing as EOF.

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

Look over this sample. It is pretty simple.

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

VB Code:

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

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

thanks for now


/Tyson