ASP-Mujeeb

We might want to run two or more independent tasks simultaneously rather than running them synchronously. If you talk about asynchronous programming threads concept is the first one to come in our mind. Well its true but Microsoft has given us extra bit of abstraction through background worker. Background worker runs on a different thread and performs tasks asynchronously.

We will show you coding part now.
1. Add reference to System.ComponentModel name space in order to access background worker class.


2. Now declare a variable of type Background worker and instantiate it in page_load event of the page as shown below. In addition to that register two events of background worker namely DoWork and RunWorkerCompleted. We will discuss them later in this post.


3. Now we will write two simple methods namely Task1() and Task2(). We will execute these two methods asynchronously using background worker in later steps.


4. Now we want these two methods to be called in page_load. Hence we would change our page_load event as shown below.


5. Please notice the above code carefully. We made two changes one is we are directly calling Task1(), the second one is we are calling RunWorkerAsync() method of background worker. This RunWorkerAsync() will raise DoWork event of the background worker where we have to call Task2().


6. We are almost done. You might be having questions regarding RunWorkerCompleted event of the background worker. It is useful to perform operations once after background worker completes processing. For instance hiding the loading popup dialog or some other operations.

7. To sum up everything:

using System.Diagnostics;


ProcessStartInfo psi = new ProcessStartInfo
{
Arguments = batchFile+ " >log.log",
FileName = "C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\powershell.exe"
};
psi.WorkingDirectory = Path.GetDirectoryName(batchFile);

Process p = new Process();
p.StartInfo = psi;
p.Start();

public static int RunBatch(string batchFile, int timeOut = 10000)
{
ProcessStartInfo psi = new ProcessStartInfo
{
Arguments = batchFile+ " >log.log",
FileName = "C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\powershell.exe"
};
psi.WorkingDirectory = Path.GetDirectoryName(batchFile);
psi.UseShellExecute = false;
Process p = new Process();
p.StartInfo = psi;
p.Start();
p.WaitForExit(timeOut); //or p.WaitForExit() to wait until batch completes processing completely.
return p.ExitCode;
}

psi.UseShellExecute = false;
psi.RedirectStandardError = true;
psi.RedirectStandardOutput = true;
string error=p.StandardError.ReadToEnd();
string output=p.StandardOutput.ReadToEnd();

Today i want to show you how to execute excel macros using asp.net.

First of all we have to add reference to Mirosoft.Office.Interop.Excel dll in Visual studio.
Call the below method to execute macro.

Hello All, Today I want do discuss about an intersting conept Extension Methods introduced in .Net version 3.5. Extension methods are typical static methods but can be called as instance methods. These methods are great because they can reduce our code to a large extent and can be easily re-used.

I would write a simple extension method which will convert an object to string. In other words I am going to write an equivalent method of ToString().


Please note "this" keyword is appended to the first parameter in order to call it on that type. In the above example we can call the extension method on any type because the first parameter is of type obj.

Here is the code to call the above method.