C#

Teuz wrote:

(I noticed the problem with the progress bar because I needed to add a progress bar dynamically to the form, dunno if there are other scenarios where this happens)

using System;
using System.Diagnostics;
using System.Net;
using System.Threading;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        public void CheckUpdate(object arg)
        {
            // This simulates my update process
            DownloadFile();
            Thread.Sleep(5000);
            Debug.WriteLine("Update completed");
        }

        public void DownloadFile()
        {
            var webClient = new WebClient();

            var progressBar = new ProgressBar(); 
            AddControl(progressBar);

            webClient.DownloadProgressChanged += (o, e) =>
                                                     {
                                                         Debug.WriteLine(e.ProgressPercentage);
                                                         progressBar.Value = e.ProgressPercentage;
                                                     };
            webClient.DownloadFileCompleted += (o, e) => Debug.WriteLine("Download completed.");

            Debug.WriteLine("Starting download...");
            webClient.DownloadFileAsync(new Uri("http://cdimage.debian.org/debian-cd/5.0.4/i386/iso-cd/debian-504-i386-netinst.iso"), "debian-504-i386-netinst.iso");
        }

        private void button1_Click(object sender, EventArgs e)
        {
            ThreadPool.QueueUserWorkItem(CheckUpdate);
        }

        private void AddControl(Control control)
        {
            if (flowLayoutPanel1.InvokeRequired)
                flowLayoutPanel1.BeginInvoke(new MethodInvoker(() => AddControl(control)));
            else
                flowLayoutPanel1.Controls.Add(control);
        }

    }
}

string Invqurey = "INSERT INTO invoice (id, date, gpno, product, customer, qty, carton, rate, amount, bilty, expdate)" +
                  " VALUES (@inid, @dt, @gpno, @prod, @cust, @qty, @carton, @rate, @amount, @bilty, @expdate)";
                  OdbcCommand cmd = new OdbcCommand(Invqurey, conn);
                  cmd.AddWithValue("@inid", inid.Text);
                  cmd.AddWithValue("@gpno", gpno.Text);
                  ...

OriginalGriff wrote:

Oh - and the standard is to use UPPERCASE for SQL keywords.

sampath-padamatinti wrote:

How to create shortcut on each desktop.