<body> <div id="emailform"> <form action="email-thankyou.php" method="post" name="contactForm" onsubmit="return validateForm(this);"> <p><strong>Name:</strong>
if (gvTicket.DataSource == null)
//{if (GridView1.DataSource == null)
<asp:DropDownList ID="ddlIssue" runat="server" AutoPostBack="True"
Height="24px" onselectedindexchanged="DropDownList2_SelectedIndexChanged"
style="font-family: 'Arial'; font-size:
DateTime funTime = (DateTime) reader["FunTime"];
Time1.Text = funTime.ToString("hh:mm ss tt");
Date1.Text = Convert.ToString(reader["FunDateTime"], (MMMM d, yyyy)); //"MMMM d, yyyy", Time1.Text = Convert.ToString(reader["FunTime"], (HH:mm ss
select Ticowner, count(TicStatus)as "resolved" From Ticket where Ticstatus = 'resolved' Group by Ticowner Union select Ticowner, count(TicStatus)as "UNresolved" From Ticket where Ticstatus <> 'resolved'
RESOLVED select Ticowner, count(TicStatus)as "resolved" From Ticket where Ticstatus = 'resolved' Group by Ticowner UNRESOLVED select Ticowner, count(TicStatus)as
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="_Default" %> <%@ Register TagName="Ticket"
SqlConnection conn = new SqlConnection("Data Source=MIS_HP;Initial Catalog=DBhelpdesk;User ID=sa;Password=sapassword");
conn.Open();
SqlCommand comm = new SqlCommand("SelectUserByStaffID",
protected void btnUpdate_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=DBhelpdesk; Integrated Security=SSPI;");
conn.Open();
Leave a comment: