<div>
You would be much better off with ADO.NET as it is managed code and highly integrated with the rest of the .Net languages.<br />
<br />
ADO.Net has many changes from ADO. &nbsp;There is a good tutorial here:<br />
<br />
<a href="http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1169&lngWId=10" rel="ugc">http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1169&lngWId=10</a><br />
<br />
As far as the count, you can get this from the .count property of your data adapter object once you get that far in your code. &nbsp;BTW: use a data adapter if you need a count, not a data reader which is forward only and does not support counts/updates.<br />
<br />
Good luck.<br />
<br />

</div>


You would be much better off with ADO.NET as it is managed code and highly integrated with the rest of the .Net languages.

ADO.Net has many changes from ADO.  There is a good tutorial here:

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1169&lngWId=10 [http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1169&lngWId=10]

As far as the count, you can get this from the .count property of your data adapter object once you get that far in your code.  BTW: use a data adapter if you need a count, not a data reader which is forward only and does not support counts/updates.

Good luck.



<div>
Oops, I meant to say &quot;.RecordCount&quot; not &quot;.Count&quot; for the data adapters property.
</div>


Oops, I meant to say ".RecordCount" not ".Count" for the data adapters property.

<div>
leavitt76,<br />
I actaully needed for RecordCount only. But ur info abt ADO.NET was very useful though pictures are not available in that downloaded material :-(<br />
Thanks<br />
Maha
</div>


leavitt76,
I actaully needed for RecordCount only. But ur info abt ADO.NET was very useful though pictures are not available in that downloaded material :-(
Thanks
Maha

<div>
<div class="content wysiwyg-content">
Hi,<br />
what is the equivalent of rs.recordcount of VB6.0 in VB.NET ? <br />
Dim connstr = &quot;server=s07\mumford;uid=gd<wbr />buser;pwd=<wbr />gdbuser;da<wbr />tabase=NyS<wbr />ample&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim sqlConn3 As New SqlConnection(connstr)<br />
&nbsp; &nbsp; &nbsp; &nbsp; sqlConn3.Open()<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim rsNickNames_sqlcomm As New SqlCommand(&quot;SELECT * from tabNickName&quot;, sqlConn3) <br />
<br />
Can we use like this or is it wise to use ADO ? Pls help,<br />
Maha
</div>
</div>


Hi,
what is the equivalent of rs.recordcount of VB6.0 in VB.NET ? 
Dim connstr = "server=s07\mumford;uid=gdbuser;pwd=gdbuser;database=NySample"
        Dim sqlConn3 As New SqlConnection(connstr)
        sqlConn3.Open()
        Dim rsNickNames_sqlcomm As New SqlCommand("SELECT * from tabNickName", sqlConn3) 

Can we use like this or is it wise to use ADO ? Pls help,
Maha

record count in vb.net

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.