Contare i record presenti in una tabella
<%@ 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>
Scarica il Codice...
Stampa la pagina