File manager - Edit - G:/PleskVhosts/indiaminerals.in/vgm.INFOFIXDEVELOPERS.COM/admin/Animal_Report.aspx.cs
Back
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data; using System.Configuration; using WebApp.LIBS; namespace VGM.admin { public partial class Animal_Report : BasePageClass { SqlDataAdapter da; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string cs = ConfigurationManager.ConnectionStrings["gav"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { string query = "SELECT am.id, am.animal_name, COUNT(r.id) as RegistrationCount " + "FROM animal_master am " + "LEFT JOIN registration r ON am.animal_name = r.animal_category " + "WHERE r.status IN ('Own', 'Admitted') " + "GROUP BY am.id, am.animal_name"; using (SqlCommand cmd = new SqlCommand(query, con)) { con.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { DataTable dt = new DataTable(); da.Fill(dt); Gridview1.DataSource = dt; Gridview1.DataBind(); } } } } } } }
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.04 |
proxy
|
phpinfo
|
Settings