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);
}
}