File manager - Edit - G:/PleskVhosts/indiaminerals.in/vgm.INFOFIXDEVELOPERS.COM/admin/Issue_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 WebApp.LIBS; using System.Web.Services; using System.Web.Script.Services; namespace VGM.admin { public partial class Issue_list : BasePageClass { string cs = ConfigurationManager.ConnectionStrings["gav"].ConnectionString; SqlDataAdapter da1; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { da1 = new SqlDataAdapter("select distinct Issue_id, Issue_date, Issue_time,Issue_from,Issue_to from issue", 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 issueId) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["gav"].ConnectionString)) { con.Open(); using (SqlCommand cmd = new SqlCommand("SELECT I.*, M.Medicine_name FROM issue AS I INNER JOIN medicine AS M ON I.Medicine_id = M.ID WHERE I.Issue_id = @IssueId", con)) { cmd.Parameters.AddWithValue("@IssueId", issueId); DataSet ds = new DataSet(); using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { sda.Fill(ds); } // Convert Time to a string representation in a format JavaScript can interpret foreach (DataRow row in ds.Tables[0].Rows) { TimeSpan issueTime = ((TimeSpan)row["Issue_time"]).Duration(); row["Issue_time"] = issueTime.ToString(); // or issueTime.ToString("hh\\:mm\\:ss"); for a specific format } ds.Tables[0].TableName = "Data"; return ds.GetXml(); } } } } }
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.08 |
proxy
|
phpinfo
|
Settings