C#

string Message = String.Format("Number of rows affected {0}", result);
MessageBox.Show(Message);

string save = "Insert into ShippingCompany ([ShippingCompanyCode], [ShippingCompanyName], [CurenccyCode], [ActiveStatus], [CreateBy], [CreateDate], [modifiedBy], [modifiedDate]) "
                                 + "values (@ShippingCompanyCode, @ShippingCompanyName, @CurenccyCode, @ActiveStatus, @CreateBy, @CreateDate, @modifiedBy, @modifiedDate)";

using (SqlConnection con = new SqlConnection(dikonek))
using (SqlCommand cmd = new SqlCommand(save, con))
{
   cmd.Parameters.AddWithValue("@ShippingCompanyCode", t1.Text);
   cmd.Parameters.AddWithValue("@ShippingCompanyName", t2.Text);
   cmd.Parameters.AddWithValue("@CurenccyCode", t3.Text);
   cmd.Parameters.AddWithValue("@ActiveStatus", t4.Text);
   cmd.Parameters.AddWithValue("@CreateBy", t5.Text);
   cmd.Parameters.AddWithValue("@CreateDate", DateTime.Now);
   cmd.Parameters.AddWithValue("@modifiedBy", t7.Text);
   cmd.Parameters.AddWithValue("@modifiedDate", DateTime.Now);
   
   con.Open();
   int rowsAffected = cmd.ExecuteNonQuery();
   MessageBox.Show(string.Format("{0} rows affected.", rowsAffected));
}

xml_document.Root.Add(event_node);

xml_document = new XDocument();
xml_document.Declaration = new XDeclaration("1.0", "utf-8", "true");
XElement rootEle = new XElement("EventLog")
xml_document.Add(rootEle);

XElement event_node = new XElement("Event", new XAttribute("ID", Guid.NewGuid().ToString()));
XElement event_date = new XElement("DateTime", DateTime.UtcNow.ToString("ddd dd MMM yyyy HH:mm:ss"));
XElement event_details = new XElement("Description", event_description);
event_node.Add(event_date);
event_node.Add(event_details);
 
// Append element to root
rootEle.Add(event_node);
 
xml_document.Save("eventlog.xml");

Jassim Rahma wrote:

how can I determine if Google Drive is installed

Jassim Rahma wrote:

and what's the drive folder?

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

//required
using System.Diagnostics;

private bool IsGDriveRunning()
{
    return Process.GetProcessesByName("googledrivesync").Length > 0;
}

Process[] gDrive = Process.GetProcessesByName("googledrivesync");

if (gDrive.Length > 0)
{
    Console.WriteLine(gDrive[0].Modules[0].FileName);
}

sjs4u wrote:

I have to process this file within 3 hrs.

sjs4u wrote:

How I can improve the performance of the reading and writing to csv file.

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

sjs4u wrote:

1 million records and ...and execute the url so