Morpheusweb.it - Risorse per webmaster: script, ASP.NET, C#, Visual Basic .Net, tutorial, asp, javascript, css, php, html, java, ADO, VBScript, forms, frames, Active Server Pages, Dynamic HTML, database, gratis per webmaster e webdesigner

Record count - << VB.NET VERSION >>

Count table records


<%@ Page language="c#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="c#" runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
  SqlConnection cnn = new SqlConnection("server=DBSERVER;User id=USER;password=PASSWORD;database=DB");
  SqlCommand cmd = new SqlCommand("Select count(*) from tabella", cnn);
  cnn.Open();
  Response.Write(cmd.ExecuteScalar().ToString());
}
</script>



Download Code...


Print Page


 


Page top

risorse per webmaster