C#

George_George wrote:

Why modify the content? To facilitate what?

George_George wrote:

You mean keep backend servers transparent to outside? Better to deployment?

George_George wrote:

I am just wondering whether this error could be caused by missong some Http header fields or some Http body fields from client side? Or just a server side issue?

sunilwise wrote:

string sql = "select CONVERT(varchar ,[dateregistered],103) Dates,[user],[client facility],sum([payroll score])LC from [sheet1$] group by [user],[client facility], CONVERT(varchar ,[dateregistered],103) order by [user]";

Rajesh_K_Sharma wrote:

void GetStatus()
{
ManagementObjectSearcher printJobsSeacher = new ManagementObjectSearcher(@"SELECT * FROM Win32_PrintJob");
ManagementObjectCollection printJobs = printJobsSeacher.Get();
foreach (ManagementObject item in printJobs)
{
// Print JobStatus
}
}
}

<br />
using System;<br />
using System.Management;<br />
using System.Windows.Forms;<br />
<br />
namespace WMISample<br />
{<br />
    public class MyWMIQuery<br />
    {<br />
        public static void Main()<br />
        {<br />
            try<br />
            {<br />
                ManagementObjectSearcher searcher = <br />
                    new ManagementObjectSearcher("root\\CIMV2", <br />
                    "SELECT * FROM Win32_PrintJob"); <br />
<br />
                foreach (ManagementObject queryObj in searcher.Get())<br />
                {<br />
                    Console.WriteLine("-----------------------------------");<br />
                    Console.WriteLine("Win32_PrintJob instance");<br />
                    Console.WriteLine("-----------------------------------");<br />
                    Console.WriteLine("JobStatus: {0}", queryObj["JobStatus"]);<br />
                }<br />
            }<br />
            catch (ManagementException e)<br />
            {<br />
                MessageBox.Show("An error occurred while querying for WMI data: " + e.Message);<br />
            }<br />
        }<br />
    }<br />
}<br />