asp.net recordcount

<i><b>Originally posted by : simon (scht80@hotmail.com)</b></i><br /><br />hiye... does any know how to do a recordcount from asp.net using vb.net?<br />can some one plz some me some examples..<br /><br />thanks in advance..<br /><br />simon

<i><b>Originally posted by : Doug Hagerman (DougH@Usbs-Panels.com)</b></i><br />So you mean Like this?<br /><br /> 'Do the Recordcount<br /> intAmount=DS2.Tables(0).Rows.Count <br /><br />-----------------------------------------<br /><br /><br /><%@ Import Namespace="System.Data" %><br /><%@ Import Namespace="System.Data.SqlClient" %><br /><br /><br /><script language="VB" runat="server" ><br /><br /> Sub Page_Load(Src As Object, E As EventArgs)<br /><br /> If Not (Page.IsPostBack)<br /><br /> 'Find Distinct Categories to Load into Drop Down<br /> Dim DS2 As DataSet<br /> Dim MyConnection2 As SqlConnection<br /> Dim MyCommand2 As SqlDataAdapter<br /> Dim Sql2 as String<br /> Sql2="SELECT Distinct Book_Type FROM USBS.DBO.BOOKS "<br /> MyConnection2 = New SqlConnection("server=YOURSERVER;database=YOURDATABASE;Trusted_Co nnection=yes")<br /> MyCommand2 = New SqlDataAdapter(Sql2, MyConnection2)<br /> DS2 = New DataSet()<br /> MyCommand2.Fill(DS2, "Book_Types")<br /><br /> 'Fill Book Type<br /> Dim intAmount as Integer<br /> 'Do the Recordcount<br /> intAmount=DS2.Tables(0).Rows.Count <br /> Dim I as Integer<br /> Category.Items.Clear()<br /> for i=0 to intAmount-1<br /> Category.Items.Insert(i,DS2.Tables(0).Rows(i).Item ("Book_Type").ToString)<br /> Next i<br /><br />End Sub<br /></script><br /><br /><br />------------<br />simon at 4/22/2002 4:16:32 AM<br /><br /><br />hiye... does any know how to do a recordcount from asp.net using vb.net?<br />can some one plz some me some examples..<br /><br />thanks in advance..<br /><br />simon