C#

for (int c = 0; c < listBox1.Items.Count; c++)
           {
               listBox1.SelectedItem = c;
               int length;
               byte[] bt = new byte[1024];
               FileStream input = new FileStream(listBox1.Text, FileMode.Open);

               FileStream output = new FileStream(listBox1.Text + ".new", FileMode.Create);

               BinaryReader rd = new BinaryReader(input);
               BinaryWriter rw = new BinaryWriter(output);

               rd.Read(bt, 0, 55);

               while (true)
               {
                   length = rd.Read(bt, 0, 1024);
                   if (length == 0) break;
                   rw.Write(bt);
               }
               rd.Close();
               rw.Close();

               input.Close();
               output.Close();
           }

btn_Start_Click(object sender, EventArgs e)
{
   Thread th = new Thread(new ThraedStart(Download));
   th.Start();

   if (th.ThreadState == ThreadState.Running) // Here i am Disabling
   btn_Start.Enabled = false;
}

public void Download()
{
   // Here i wrote logic for downloading files.
   this.Invoke((MethodInvoker)delegate
   {
       btn_Start.Enabled = true;
   });

}

sekhar.k wrote:

But its giving Cross thread eroor.

string query = @"CREATE PROCEDURE SampleProcedure
                             AS
                             BEGIN
	                            SELECT 'From Sample Procedure'
                            END";
using (SqlConnection connection = new SqlConnection(@"YourConnectionString"))
using (SqlCommand command = new SqlCommand(query,connection))
{
     connection.Open();
     command.ExecuteNonQuery();
}

N a v a n e e t h wrote:

But why you need to create a SP run time? That doesn't make any sense.