protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { if (!string.IsNullOrEmpty(Session["Name"] as string)) { db = new LotteryWebService.DBService(); Ticketsds = db.GetTicketsInfo(); if (Ticketsds.Tables["Response"].Rows[0][0].ToString() == "1") { DataTable dt = Ticketsds.Tables["TicketsInfo"]; StringBuilder sb = new StringBuilder(); //Table start. sb.Append("<table>"); //Adding HeaderRow. sb.Append("<tr>"); foreach (DataColumn column in dt.Columns) { sb.Append("<th>" + column.ColumnName + "</th>"); } sb.Append("</tr>"); //Adding DataRow. foreach (DataRow row in dt.Rows) { sb.Append("<tr>"); foreach (DataColumn column in dt.Columns) { sb.Append("<td>" + row[column.ColumnName].ToString() + "</td>"); } sb.Append("</tr>"); } //Table end. //sb.Append("</table>"); //TicketsTable.Text = sb.ToString(); } else if (Ticketsds.Tables["Response"].Rows[0][0].ToString() == "0") { ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + Ticketsds.Tables["Response"].Rows[0][1].ToString() + "');", true); } } else { Response.Redirect("Home.aspx", false); Context.ApplicationInstance.CompleteRequest(); } } } catch (Exception ex) { ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + ex.Message.Replace("\'", " ") + "');", true); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { if (!string.IsNullOrEmpty(Session["Name"] as string)) { db = new LotteryWebService.DBService(); Ticketsds = db.GetTicketsInfo(); if (Ticketsds.Tables["Response"].Rows[0][0].ToString() == "1") { GridView1.DataSource = Ticketsds.Tables["TicketsInfo"]; GridView1.DataBind(); Ticketsds.Dispose(); } else if (Ticketsds.Tables["Response"].Rows[0][0].ToString() == "0") { ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + Ticketsds.Tables["Response"].Rows[0][1].ToString() + "');", true); } else { Response.Redirect("Home.aspx", false); Context.ApplicationInstance.CompleteRequest(); } } else { Response.Redirect("Home.aspx", false); Context.ApplicationInstance.CompleteRequest(); } } } catch (Exception ex) { ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + ex.Message.Replace("\'", " ") + "');", true); } }