readonly

[MikeJ]

hi i can't seem to find the readonly
for sql
How to set when reading Recordset from Sql
as Readonly

Tia
MikeJ

 

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

hi i can't seem to find the readonly
for sql
How to set when reading Recordset from Sql
as Readonly

Tia
MikeJ

You specify the cursor type and lock type when you open the recordset.
That decides how you can use the recordset.

 

[Mike J]

Right....i am having problems finding it on msdn...
i'll look again

 

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

Right....i am having problems finding it on msdn...
i'll look again

You specify the cursor type and lock type when you open the recordset.
That decides how you can use the recordset.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthrstopen.asp

 

[Mike J]

your link is Ado 2.8 not net
how is this implemented in net 2.0

MJ

 

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

your link is Ado 2.8 not net
how is this implemented in net 2.0

MJ

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthrstopen.asp

There is no Recordset object in the .NET framework, that's why I assumed
that you meant the ADO Recordset.

The DataReader classes in .NET are always read-only.