C#

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.