C#

SledgeHammer01 wrote:

only keep the last group

SledgeHammer01 wrote:

not what you really want

foreach (var job in LocalPrintServer.GetDefaultPrintQueue().GetPrintJobInfoCollection())
{
   UpdateText("Job Name : " + job.JobName.ToString());
   UpdateText("Submitter :" + job.Submitter.ToString() + job.TimeJobSubmitted.ToString());
   UpdateText("Hosted Server :" + job.HostingPrintServer.Name.ToString());
   UpdateText("No of Pages :" + job.NumberOfPages.ToString());
}

gonzaloleon wrote:

with int32 column my datagridview

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Member 2458467 wrote:

nothing is hunting download my code because I want to share them with people like me that is the case

public static void ImportToSql(string excelfilepath)
        {
            string ssqltable = "TABHD";
            string myexceldataquery = "SELECT * FROM [dbo_TABHD]";
            try
            {
                string sexcelconnectionstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" + excelfilepath + "; Extended Properties=\"Excel 12.0; HDR=Yes; IMEX=2\"";
                string ssqlconnectionstring = @"server = itfriend;Database=HD;integrated security = true";

                //execute a query to erase any previous data from our destination table
                string sclearsql = "delete " + ssqltable;
                INSERTING IT.INSTEAD I WANT TO UPDATE TABLE DATA"
                SqlConnection sqlconn = new SqlConnection(ssqlconnectionstring);                

                OleDbConnection oledbconn = new OleDbConnection(sexcelconnectionstring);
                OleDbCommand oledbcmd = new OleDbCommand(myexceldataquery, oledbconn);
                oledbconn.Open();
                OleDbDataReader dr = oledbcmd.ExecuteReader();
                SqlBulkCopy bulkcopy = new SqlBulkCopy(ssqlconnectionstring);
                bulkcopy.DestinationTableName = ssqltable;

                bulkcopy.WriteToServer(dr);

                Console.WriteLine(".xlsx file imported succssessfully into database.", bulkcopy.NotifyAfter);
                oledbconn.Close();
            }
            catch (Exception ex)
            {
                //handle exception
                MessageBox.Show(ex.Message.ToString(), "Warning !");
            }
        }