C#

public static void Logging(string logMessage, string user)
        {
            using (Writer)
            {
                Writer.Write("\r\nLog Entry : ");
                Writer.Write(
                    "{0} {1}\r\n user: {2}",
                    DateTime.Now.ToLongTimeString(),
                    DateTime.Now.ToLongDateString(),
                    user);
                Writer.WriteLine(": {0}", logMessage);
                Writer.WriteLine("-------------------------------");
            }
        }

//Open Connection
            cmd.Connection.Open();
            //con.Open();


            foreach (ListViewItem item in lstViewXML.Items)
            {

                cmd.Parameters.Add("@No", item.Text);

                cmd.Parameters.Add("@ItemNo", item.SubItems[1].Text);

                cmd.Parameters.Add("@Qty", item.SubItems[2].Text);

                cmd.CommandText = "Insert into xml (No,ItemNo,Qty) VALUES  (@No,@ItemNo,@Qty)";

                cmd.ExecuteNonQuery();

            }

            cmd.Connection.Close();

            cmd.Dispose();