File manager - Edit - G:/PleskVhosts/indiaminerals.in/vgm.INFOFIXDEVELOPERS.COM/admin/Observation_list.aspx.cs
Back
using System; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.Services; using System.Web.Script.Services; using WebApp.LIBS; using System.Globalization; namespace VGM.admin { public partial class Observation_list : BasePageClass { static string cs = ConfigurationManager.ConnectionStrings["gav"].ConnectionString; SqlDataAdapter da1; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // Define your SQL query with a JOIN statement string query = "SELECT DISTINCT o.S_no, o.Tag_no, o.Date, r.animal_category " + "FROM observation o " + "LEFT JOIN registration r ON o.Tag_no = r.Tag_no"; da1 = new SqlDataAdapter(query, cs); DataTable dt1 = new DataTable(); da1.Fill(dt1); Gridview1.DataSource = dt1; Gridview1.DataBind(); } } protected void Gridview1_RowCommand(object sender, GridViewCommandEventArgs e) { } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Xml)] public static string PopupValueFillabc() { return "ramlala"; } [WebMethod] public static string PopupValueFill(string observationId) { using (SqlConnection con = new SqlConnection(cs)) { con.Open(); using (SqlCommand cmd = new SqlCommand("SELECT O.*, M.Medicine_name FROM observation AS O INNER JOIN medicine AS M ON O.Medicine_id = M.ID WHERE O.S_no = " + observationId + "", con)) { DataSet ds = new DataSet(); using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { sda.Fill(ds); } ds.Tables[0].TableName = "Data"; return ds.GetXml(); } } } protected void show_Click(object sender, EventArgs e) { try { DateTime startDate; DateTime endDate; if (DateTime.TryParse(From.Text, out startDate) && DateTime.TryParse(To.Text, out endDate)) { // Construct the SQL query to fetch the data with a join on "medicine" table string query = "SELECT DISTINCT o.S_no, o.Tag_no, o.Date, r.animal_category " + "FROM observation o " + "LEFT JOIN registration r ON o.Tag_no = r.Tag_no " + "WHERE o.Date >= @StartDate AND o.Date <= @EndDate"; using (SqlConnection con = new SqlConnection(cs)) using (SqlCommand cmd = new SqlCommand(query, con)) { cmd.Parameters.Add(new SqlParameter("@StartDate", startDate)); cmd.Parameters.Add(new SqlParameter("@EndDate", endDate)); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); Gridview1.DataSource = dt; Gridview1.DataBind(); } } } catch (Exception ex) { Response.Write("<script>alert('An error occurred: " + ex.Message + "')</script>"); } } } }
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.08 |
proxy
|
phpinfo
|
Settings