dotnetstep

Set Account As SharePoint System Account

2010-08-14T21:23:00.000+05:30

In my previous two post related to SharePoint System Account i explain how to display you custom “DOMAIN/<<UserName>>” instead of “System Account”. But in this post i am going to explain different thing opposite to previous post.

Previous Posts : Post1 Post2

There are two way to achieve this thing.

1. Go To Central Admin Site
2. Security –> Configure Service Accounts

3. Select your application pool
4. then Select an account for this component (Select your account)

If your account is not already register as manage account then click on “Register new managed account”.

Another way to do same thing is

1. Go To Central Administration.
2. Click Application Management
3. Click Manage Web Application
4. Choose your web application

5. Click on “User Policy”
6. When “Policy for Web Application” popup open click on “Add User”

7. Click next

8. In this add users for which you want to display that account as “System Account”. Make sure you have “Account operates as system” checkbox selected.

Let me know your comment and view on this.

SharePoint/System Account Settings

2010-08-14T20:54:00.000+05:30

In my previous post about SharePoint system account, i explain that how to configure account so that you can see your DOMAIN/<<UserName>> account as System Account.

But to do so you need SharePoint Central Administrator site permission. There is another way to do same thing using coding. ( Little bit trick :))

There is hidden List called “User Information List” in SharePoint site.You can find system account and update that listitem for “System Account”.

1. (Before Update Item)

2. Custom code to update item.

3. In above code you can replace “your name” with your desired name.
4. After you can see in profile and Upper Right corner of your site.

You can customize any account using above code. Sometime you want friendly name instead DOMAIN\<<UserName>>

Let me know your comment on this.

SharePoint System Account Issue

2010-08-14T09:57:00.000+05:30

SharePoint\System account is special account. Sometime it happens that when you login using DOMAIN/<<UserName>> is display as “System Account”. (Following image)

This is because of when application created or extended, during that time which account specify for application pool identity that consider as “SharePoint/System” account.

But if you want to display your username instead of “System Account” following are the solutions for that.

1. Go to Central Administration Site
2. Go to Security –> Configure Service Account

3. Next page you can see that “Credential Management”.

4. Select your application pool.
5. Select different account. (Other than your account). Which ever account you specify over here for that you can see “SharePoint/System” account.
6. If you still want that your application pool identity should be your name then manually set using IIS Manager.

Let me know if you still have any question about it.

ASP.net MVC Routing - Part1

2010-07-18T14:59:00.001+05:30

In ASP.net MVC Routing works following way and need to register in Application_Start of Global.asax

Default Route when ASP.net MVC Application created

routes.MapRoute(
   "Default", // Route name
   "{controller}/{action}/{id}", // URL with parameters
   new { controller = "Default", action = "Index", id = UrlParameter.Optional });

Default route has placeholder that done most of work.

For example :

if request is made for http://<<yoursite>//Home/Index.
This will call HomeController’s Index method.

if request is made for http://<<yousite>//Home/Index/1
This will call HomeController’s Index method with argument value “1”.

Sample Controller:
public class HomeController : Controller
    {
        public ActionResult Index(string id)
        {
            return new ContentResult() { Content = "This is Index" };
        }
    }

Next Part will going to give you detail about “Slugish Url”.

ASP.net 4.0 Url Routing

2010-07-18T13:14:00.001+05:30

In ASP.net 4.0 , New functionality included for URL Routing.

For Example : ( Application_Start)
RouteTable.Routes.MapPageRoute("Default","Home","~/Default.aspx");

When Browser request for http://<<your site>>/Home, It will route to page Default.aspx

And Page has some property that allow you to get route data, Page.RouteData

Even generic route is also possible.

RouteTable.Routes.MapPageRoute("Default","{Home}","~/{Home}.aspx");

Now When request made for Url : http://<<yoursite>/Test It automatically route to Test.aspx

One more thing true about ASP.net 4.0 routing is even though routing is done, there is still possible that direct request for “ASPX” pages.

To disable that

1. from UI (IIS 7.0 or later)
       - Go to inetmgr
       - In Feature View go to “Request Filtering”

       - Click Deny FileName Extension


2. Using main web.config file of your application

 <system.webServer>
     <modules runAllManagedModulesForAllRequests="true" />
        <security>
            <requestFiltering>
                <fileExtensions>
                    <add fileExtension=".aspx" allowed="false" />
                </fileExtensions>
            </requestFiltering>
        </security>
  </system.webServer>

- Add Module tag with runAllManagedModulesForAllRequests = “true”
- Add requestfiltering with fileextension=”.aspx” and “allowed=false”.

Let me know your comment on this.

Process Bitmap Faster In .NET

2010-06-20T23:18:00.001+05:30

In .NET (C# or VB.net) you can process Bitmap pixel by pixel.

Here is the example of simple code. ( Use Example of Gray Scale)

System.Drawing.Image img = System.Drawing.Bitmap.FromFile(@"C:\Test.jpg");
Bitmap bmp = (Bitmap)img;
         for (int x = 0; x < bmp.Width; x++)
         {
             for (int y = 0; y < bmp.Height; y++)
             {
                Color c = bmp.GetPixel(x, y);
                int gray = (int)((c.R + c.G + c.B)/3);
                bmp.SetPixel(x,y,Color.FromArgb(gray,gray,gray));
             }
         }

Above code works fine but it takes to much time to process.In order to process Bitmap Image Faster “BitmapData” is powerful class in .NET. Here is the example of that class.

System.Drawing.Image img = System.Drawing.Bitmap.FromFile(@"C:\Test.jpg");
Bitmap bmp = (Bitmap)img;
System.Drawing.Imaging.BitmapData data = bmp.LockBits(new Rectangle() { X = 0, Y = 0, Width = bmp.Width, Height = bmp.Height }, System.Drawing.Imaging.ImageLockMode.ReadWrite, System.Drawing.Imaging.PixelFormat.Format24bppRgb);
IntPtr ptr = data.Scan0;
int bytes =data.Stride * bmp.Height;
byte[] rgbValues = new byte[bytes];
System.Runtime.InteropServices.Marshal.Copy(ptr, rgbValues, 0, bytes);
int val = 0;
for (int counter = 0; counter < rgbValues.Length; counter += 3)
{
    val = rgbValues[counter + 0] + rgbValues[counter + 1] + rgbValues[counter + 2];
    rgbValues[counter+0] = (byte)(val/3);
    rgbValues[counter+1] = (byte)(val/3);
    rgbValues[counter+2] = (byte)(val/3);
}
System.Runtime.InteropServices.Marshal.Copy(rgbValues, 0, ptr, bytes);
bmp.UnlockBits(data);

This code works must faster than previous code. Test it with PictureBox Control and See the effect… :)

Translate content using Bing Service In ASP.net MVC

2010-06-20T14:39:00.001+05:30

I used Translate Bing Service API in SharePoint Translate Web Part. Same API can be used with ASP.net MVC. Here i am writing small extension method for HtmlHelper.

public static class HtmlHelperExtention
    {
        public static string Tranlate(this System.Web.Mvc.HtmlHelper objHelper,string inputContent,string sourceLanguage,string targetLanguage)
        {
            string apikey = System.Configuration.ConfigurationManager.AppSettings["BingAPI"];
            Soap s = new Soap();
            string frenchoutputtext = s.Translate(apikey, inputContent, sourceLanguage, targetLanguage);
            return frenchoutputtext;
        }
    }

In View Of ASP.net MVC you should write this.

<body>
    <div>
    <%= Html.Tranlate("<div>This is Translation test.</div>","en","fr") %>
    </div>
</body>

Requirement:
1. Valid API key required.
2. Need to Add Proxy Class to user “Bing Translate Service”.

Hope this will help…….

Custom GroupBox Control for Silverlight 3

2010-01-31T17:24:00.001+05:30

In previous post i put xaml that allow to create GroupBox using XAML.

Here i am adding custom groupbox control.

Download link : GroupBox control for Silverlight 3

Codeplex Link : Silverlight3 GroupBox

GroupBox control for Silverlight3

2010-01-31T16:45:00.001+05:30

GroupBox control is not available in Silverlight 3, but you can create GroupBox control using following XAML.

<Border CornerRadius="10" Background="AliceBlue" BorderBrush="Black" BorderThickness="1" Margin="10,10,10,10" Width="400" x:Name="Test">
            <StackPanel>
                <Border Margin="20,-10,0,0" Background="AliceBlue" HorizontalAlignment="Left">
                    <TextBlock Text="User Setting" Margin="10,0,10,0" FontWeight="Bold"></TextBlock>
                </Border>
              
            </StackPanel>
        </Border>
In above XAML you can replace <!-- Put your content –> with your data inside groupbox .

For Example :

Let me know your comment on this.

Silverlight 3: Programmatically Validate Textbox

2010-01-16T14:31:00.004+05:30

In previous post about validation in Silverlight, I explained the How binding is used to validate data ? .

Here i am going to explain how to validate Textbox ( Any control that has validation states group).

There are three validation states. 1. Valid 2. InvalidFocused 3. InvalidUnfocused. Now use VisualStateManager to change the state of control. Here is common method.

public void SetState(Control c, string message,string state)     
      {      
          if (state == "Invalid")      
          {      
              if (c.Focus())      
                  VisualStateManager.GoToState(c, "InvalidFocused", false);      
              else      
                  VisualStateManager.GoToState(c, "InvalidUnfocused", false);       ToolTip tp = ((Grid)VisualTreeHelper.GetChild(c, 0)).FindName("validationTooltip") as ToolTip;     
              tp.DataContext = message;              
              tp.Template = LayoutRoot.Resources["ValidationToolTipTemplate"] as ControlTemplate;      
          }      
          else      
          {      
              VisualStateManager.GoToState(c, "Valid", false);      
          }           
      }

In XAML Page you have to specify control template.

This control template is used for validation tooltip.

Control like Textbox,listbox ,combobox,checkbox has validation states so you can use this method.

Example:

if(txtFirstName.Text == “”)
{
SetState(txtFirstName , “Invalid”, “Please enter first name”);
}

Let me know you comment on this.

Silverlight 3 : Enable and Disable Validation For Control.

2009-12-09T23:12:00.001+05:30

Please check previous post about validation with silverlight.

Enable and Disable Validation or you can say manually adding and remove binding for control.

In previous post i bound myName TextBox to Name property of Customer, But some case you do not want to validate that control and to do so you need to clear binding. ( Simplest way as per my thinking).

1. Remove Binding in Silverlight or Disable Validation

// Clear all errors from validation summary. ( Review previous post XAML)

valida.Errors.Clear();

// Set Text to clear ( As per your need )
myName.Text = String.Empty;

//This call will cleae binding for TextProperty( Take any dependency property)
myName.SetValue(TextBox.TextProperty, DependencyProperty.UnsetValue);
myName.ClearValue(TextBox.TextProperty);

2. Adding Binding in Silverlight or Enable Validation.

Binding binding = new Binding("Name");
           binding.ValidatesOnExceptions = true;
           binding.NotifyOnValidationError = true;
           binding.Mode = BindingMode.TwoWay;
           myName.SetBinding(TextBox.TextProperty, binding);

Let me know your comment on this.

Silverlight 3 : Validation

2009-12-09T23:04:00.001+05:30

To do validation in silverlight 3 , need to use dataannotation. In my previous post i discussed about binding and resource file.

1. Sample XAML File.

2. CS File.

public partial class MainPage : UserControl
    {
        Customer c = new Customer();
        private int _errorCount = 0;
        public MainPage()
        {
            InitializeComponent();
            MyDataForm.DataContext = c;
        }

        private void MyDataForm_BindingValidationError(object sender, ValidationErrorEventArgs e)
        {
            if (e.Action == ValidationErrorEventAction.Added)
                _errorCount++;
            else if (e.Action == ValidationErrorEventAction.Removed)
                _errorCount--;
        }

        private void Button_Click(object sender, RoutedEventArgs e)
        {
            _errorCount = 0;

            // Need to do for validating control.
            // If you do not do this then untill you make any change in control no validation will work.
            // Like form first time open and you prees submit then it will not validate . To do so this is required.
            BindingExpression exp = myName.GetBindingExpression(TextBox.TextProperty);
            if (exp != null)
            exp.UpdateSource();

            if (_errorCount ==0)
            {
                //Success
            }
            else
            {
                //Error
            }
        }

}

3. Enjoy Validation………… :)

Let me know your comment.

Silverlight 3 and Resource File

2009-12-06T22:43:00.001+05:30

In silverlight you can access resource file to customize label and other data that need to be localize.

1. Create class that use DataAnnotation attributes.

public class Customer
   {
       private string _name = string.Empty;
       [Display(ResourceType=typeof(SilverlightApplication2.Resourses.Strings),Name="CustomerLabel")]
       [Required(ErrorMessageResourceType = typeof(SilverlightApplication2.Resourses.Strings), ErrorMessageResourceName = "CustomerNameError")]
       public string Name
       {
           get
           {
               return _name;
           }
           set
           {
               Validator.ValidateProperty(value, new ValidationContext(this, null, null) { MemberName = "Name" });
               _name = value;
           }
       }
   }

In above class you can see that for Display and Required attribute , ResourceType and ErrorMessageResourceType set. This will point to resource file. Also in setter of property you have to validate the value.

2. Add resource file as per your need. For example here i added Strings.Resx file.

Step 3 is very very important in order to access resource in .xap file.

3. Specially for Silverlight open Strings.Resx.cs file. Change access modifier from internal to public. Also set public for each resource string. ( See below images.)

Generate another resource file for different culture. For example fr-CA culture you need to generate Strings.fr-CA.resx.

4. Now in silverlight application if you use DataForm then just need to do following.This will automatic use label from display resource.

dfCustomer.CurrentItem = new Customer();

5. To access resource in XAML.

In cs file.

public MainPage()
{

           InitializeComponent();
           Customer c = new Customer();
           c.Name = "TEST";
           MyDataForm.DataContext = c;
       }

6. Last step but very important. You have to edit .csproject file in notepad. Add supportedcultures.

Let me know update or any other idea about resource file.

ASP.net MVC 2 : Client-side Validation and Resource file

2009-12-06T11:50:00.001+05:30

In my previous post i gave example of client side validation. Also you need to localize error message. To do this you need to add resource file.Add resource file following way.

During creation of Student model you need to specify the resource.

public class Student
   {
       [Required(ErrorMessageResourceType = typeof(StudentResourse), ErrorMessageResourceName = "FirstNameError")]
       [DisplayName("User name")]
       public string FirstName { get; set; }

       [Required(ErrorMessageResourceType = typeof(StudentResourse), ErrorMessageResourceName = "EmailError")]
       [DisplayName("Email address")]
       public string Email { get; set; }

       [Required(ErrorMessageResourceType = typeof(StudentResourse), ErrorMessageResourceName = "PriceError")]
       [DisplayName("Fees")]
       public double Fees { get; set; }
   }

Here you can see that ErrorMessageResourceType and ErrorMessageResourceName. This is used to identify resource file and resource name.

you need to create resource file for each culture you need. For example fr-FR.

As per the CurrentUICulture message is displayed.

ASP.net MVC 2 : Client-side Validation

2009-12-06T11:49:00.001+05:30

In ASP.net MVC 2 Beta, DataAnnontation supports for validation . While creating model you can give attribute that use to support validation.

public class Student
   {
     [Required(ErrorMessage="Firstname is required field.")]
       [DisplayName("User name")]
       public string FirstName { get; set; }

      [Required(ErrorMessage = "Email is required field.")]
       [DisplayName("Email address")]
       public string Email { get; set; }

      [Required(ErrorMessage = "Fees is required field.")]
       [DisplayName("Fees")]
       public double Fees { get; set; }
   }

Now use this model class to create view.

<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage<MvcApplication12.Models.Student>" %>

<asp:Content ID="Content1" ContentPlaceHolderID="TitleContent" runat="server">
ViewPage2
</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
<script src="/Scripts/MicrosoftAjax.js" type="text/javascript"></script>
<script src="/Scripts/MicrosoftMvcAjax.js" type="text/javascript"></script>
<h2>ViewPage2</h2>
<% Html.EnableClientValidation(); %>

<% using (Html.BeginForm()) {%>

        <fieldset>
            <legend>Fields</legend>
            <p>
                <%= Html.LabelFor(model => model.FirstName) %>
                <%= Html.TextBoxFor(model => model.FirstName) %>
                <%= Html.ValidationMessageFor(model => model.FirstName) %>
            </p>
            <p>
                <%= Html.LabelFor(model => model.Email) %>
                <%= Html.TextBoxFor(model => model.Email) %>
                <%= Html.ValidationMessageFor(model => model.Email) %>
            </p>
            <p>
                <%= Html.LabelFor(model => model.Fees) %>
                <%= Html.TextBoxFor(model => model.Fees) %>
                <%= Html.ValidationMessageFor(model => model.Fees) %>
            </p>
            <p>
                <input type="submit" value="Create" />
            </p>
        </fieldset>

<% } %>

</asp:Content>

To enable client side validation need to add javascript and <% Html.EnableClientValidation(); %>.

Let me know your comment on this.

Translation WebPart using Bing Service

2009-11-17T06:29:00.002+05:30

This is my first project that i added to codeplex. That contain source code as well as binary with PDF document.

Translation WebPart

As mention in codeplex you can use webpart with WSS/MOSS . But even you can use this with Simple ASP.net WebSite.

Let me know your comment on this.

Cross-thread operation not valid.

2009-09-20T14:37:00.000+05:30

In window application , when you need to use Threading and access control inside that thread, then you get this error “Cross-thread operation not valid.” The reason behind this control is working under main thread and you create another thread in which you are trying to access control.

There are two ways to solve this error.

1. Set property in Form constructor.
You need to set static property CheckForIllegalCrossThreadCalls of control class to false value. This will disable cross thread checking.

       public Form1()
       {
         InitializeComponent();
           Control.CheckForIllegalCrossThreadCalls = false;
       }

Sample Code (C#):

public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            Control.CheckForIllegalCrossThreadCalls = false;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            System.Threading.Thread th = new System.Threading.Thread(new System.Threading.ParameterizedThreadStart(Test));
            th.Start(1000);
        }

        public void Test(object o)
        {
            for (int i = 0; i < 10; i++)
            {
                label1.Text = System.Threading.Thread.CurrentThread.ManagedThreadId.ToString() + " --- " + i.ToString();
                System.Threading.Thread.Sleep(int.Parse(o.ToString()));
            }
        }
    }

2. Use delegate and event.

Sample Code (C#) :

public partial class Form1 : Form
    {
        delegate void SetLabelText(string str);
        SetLabelText setLabel1Text = null;
        public Form1()
        {
            InitializeComponent();
            setLabel1Text = new SetLabelText(Label1Text);
        }

        public void Test(object o)
        {
            for (int i = 0; i < 10; i++)
            {
                if (this.InvokeRequired)
                {
                    this.Invoke(setLabel1Text, System.Threading.Thread.CurrentThread.ManagedThreadId.ToString() + " --- " + i.ToString());
                }
                System.Threading.Thread.Sleep(int.Parse(o.ToString()));
            }
        }

        public void Label1Text(string str)
        {
            label1.Text = str;
        }
    }

Please give your comment on this.

Remove Focus Rectangle From Button

2009-06-14T09:17:00.000+05:30

Article is about to remove focus rectangle or say cues from Button in window form application.

First let discuss what default focus rectangle. Please look at following image , in that image OK button has default focus so it display cues rectangle.

(FlatStyle == System)

When we want to set background image of button to make button attractive in that case this default rectangle create problem with look and feel.

(FlatStyle = Standard)

(FlatStyle = Flat)

In above two image need to set FlatApperance.BorderStyle =0. You can visualize that in all above case default focus rectangle make button look ugly with background image.

To remove this cues ( Default focus rectangle ) you need to set ShowFocusCues property of Button to false but this property does not directly available to Button. This property available in ButtonBase class with protected access specifier. In order to set this property to false we need to create class that inherits from Button or ButtonBase and set this property explicitly false.

class CustomButton : System.Windows.Forms.Button
    {
        protected override bool ShowFocusCues
        {
            get
            {
                return false;
            }
        }
}

Now see that default focus rectangle is removed.

More generic class for Button.

class CustomButton : System.Windows.Forms.Button
   {
       private bool _DisplayFocusCues = true;
       protected override bool ShowFocusCues
       {
           get
           {
               return _DisplayFocusCues;
           }
       }

       public bool DisplayFocusCues
       {
           get
           {
               return _DisplayFocusCues;
           }
           set
           {
               _DisplayFocusCues = value;
           }
       }
   }

Using this class you can set DisplayFocusCues at design time so CustomButton work with any case. ( Want to display focus rectangle or not).

Hope this solution is help you to create button without cues.

Your suggestion is always invited.

Programmatically Install Window Service

2009-06-14T06:13:00.001+05:30

This article is about to install / uninstall window service programmatically from C#. This is useful when you need to install / uninstall window service from some other application.

For this purpose you need to use ServiceProcessInstaller and ServiceInstaller class from another application. These two installer classes are responsible for Installation of service.

C# Example for Programmatically Install Window Service.

ServiceProcessInstaller ProcesServiceInstaller = new ServiceProcessInstaller();
ProcesServiceInstaller.Account = ServiceAccount.User;
ProcesServiceInstaller.Username = "<<username>>";
ProcesServiceInstaller.Password = "<<password>>";

ServiceInstaller ServiceInstallerObj = new ServiceInstaller();
InstallContext Context = new System.Configuration.Install.InstallContext();
String path = String.Format("/assemblypath={0}", @"<<path of executable of window service>>");
String[] cmdline = { path };

Context = new System.Configuration.Install.InstallContext("", cmdline);
ServiceInstallerObj.Context = Context;
ServiceInstallerObj.DisplayName = "MyService";
ServiceInstallerObj.Description = "MyService installer test";
ServiceInstallerObj.ServiceName = "MyService";
ServiceInstallerObj.StartType = ServiceStartMode.Automatic;
ServiceInstallerObj.Parent = ProcesServiceInstaller;

System.Collections.Specialized.ListDictionary state = new System.Collections.Specialized.ListDictionary();
ServiceInstallerObj.Install(state);

C# Example to Programmatically Uninstall Window Service.

ServiceInstaller ServiceInstallerObj = new ServiceInstaller();
InstallContext Context = new InstallContext("<<log file path>>", null);
ServiceInstallerObj.Context = Context;
ServiceInstallerObj.ServiceName = "MyService";
ServiceInstallerObj.Uninstall(null);

other article related to window service.

http://dotnetstep.blogspot.com/2009/06/passing-parameter-to-installutil.html

http://dotnetstep.blogspot.com/2009/06/install-window-service-without-using.html

http://dotnetstep.blogspot.com/2009/06/install-windowservice-using-installutil.html

http://dotnetstep.blogspot.com/2009/06/get-windowservice-executable-path-in.html

Please give your idea about this article.

Passing Parameter to InstallUtil

2009-06-13T18:58:00.001+05:30

When installing window service or any installer ( class inherits from install class) required custom parameter at run time , Need to pass as parameter of installutil.

Crating window service using article (http://dotnetstep.blogspot.com/2009/06/install-windowservice-using-installutil.html). This article suggest you add installer ( ProjectInstaller). Now we use installer class events to configure ServiceProcessInstaller and ServiceInstaller as per parameter pass to installutil.

[RunInstaller(true)]
public partial class ProjectInstaller : Installer
    {
        public ProjectInstaller()
        {
            InitializeComponent();
           this.BeforeInstall += new InstallEventHandler(ProjectInstaller_BeforeInstall);
            this.BeforeUninstall += new InstallEventHandler(ProjectInstaller_BeforeUninstall);
        }

        void ProjectInstaller_BeforeInstall(object sender, InstallEventArgs e)
        {
            // Configure Account for Service Process.
            switch(this.Context.Parameters["Account"])
            {
                case "LocalService":
                    this.serviceProcessInstaller1.Account = System.ServiceProcess.ServiceAccount.LocalService;
                    break;
                case "LocalSystem":
                    this.serviceProcessInstaller1.Account = System.ServiceProcess.ServiceAccount.LocalSystem;
                    break;
                case "NetworkService":
                    this.serviceProcessInstaller1.Account = System.ServiceProcess.ServiceAccount.NetworkService;
                    break;
                case "User":
                    this.serviceProcessInstaller1.Account = System.ServiceProcess.ServiceAccount.User;
                    this.serviceProcessInstaller1.Username = this.Context.Parameters["UserName"];
                    this.serviceProcessInstaller1.Password = this.Context.Parameters["Password"];
                    break;
            }
            // Configure ServiceName
            if(!String.IsNullOrEmpty(this.Context.Parameters["ServiceName"]))
            {
                this.serviceInstaller1.ServiceName = this.Context.Parameters["ServiceName"];
            }
        }

        void ProjectInstaller_BeforeUninstall(object sender, InstallEventArgs e)
        {
            if (!String.IsNullOrEmpty(this.Context.Parameters["ServiceName"]))
            {
                this.serviceInstaller1.ServiceName = this.Context.Parameters["ServiceName"];
            }
        }
    }

Above ProjectInstaller class handle two events : BeforeInstall and BeforeUninstall. BeforeInstall is called just before install method of installer (ProjectInstaller) called via InstallUtil and same way BeforeUninstall called just before Uninstall method of projectinstaller class. After adding that two event handler use following to configure service using installutil.

1. Install
installutil /Account=User /UserName=admin /Password=admin /ServiceName=WinService1 /i WindowService1.exe

2. Uninstall
installutil /ServiceName=WinService1 /u WindowService1.exe

This will also help you configure WindowService1.exe with two different name and different account.installutil /Account=User /UserName=admin /Password=admin /ServiceName=WinService1 /i WindowService1.exe

installutil /Account=LocalSystem /ServiceName=WinService2 /i WindowService1.exe

Install window service without using installutil

2009-06-13T10:49:00.001+05:30

Article is about to install window service without using InstallUtil utility.
Windows XP or Later has command line utility called sc . (This utility talks with service controller and with services from command line).
SC is a window base utility. AS explain in article http://dotnetstep.blogspot.com/2009/06/install-windowservice-using-installutil.html sc does not required ProjectInstaller.

1. Start service using sc
          sc start ServiceName

2. Stop serivce
         sc stop ServiceName

3. Delete window service
        sc delete servicename
        Note : During delete call if service is in running state then service is delete when nexttime service is stop or PC restart.

4. Create window service
       sc create ServiceName binpath= “c:\windowservice1\windowservice1.exe”

       Apart from above many option available . For that just go to command prompt and type sc create /?

For example configure service running account.

sc create servicename binpath= “c:\windowservice1\windowservice1.exe” obj= administrator password= pass

Hope this article will help you .

Please give your comment or idea about this.

In above all case Service ServiceName ( Mark as blue) , don’t use display name.

Install WindowService using installutil.

2009-06-13T10:21:00.001+05:30

This article is about to install to window service using installutil.exe. InstallUtil.exe or simply say installutil utility comes up with .NET Framework 2.0.

Steps.
1. Create new Window Service Project.

2. After that open services1.cs in design mode . It looks like this.

3. Now right click on design window. It open popup menu with installer option.

4. When you click on Add Installer. It will will add new class called projectinstaller.cs. It contain serviceprocessinstaller1 and serviceinstaller component. ServiceProcess installer is used to configure service account and serviceinstaller contain information about service.

5. Apart from above ProjectInstaller.cs contain following code which is used to call from installutil.

In above code RunInstaller attribute marked as true. So InstallUtil take this thing into consideration and use this information to call installer.

To install using installutil open VS 2005/VS 2008 command prompt or go to %windir%\Microsoft.NET\Framework\v2.0.50727.

installutil.exe /i WindowService1.exe ( To Install ).

installutil.exe /u WindowSerivce1.exe ( To uninstall).

Installutil use Installer class (Projectinstaller) to install service.

If you mark RunInstlaller as false then this installutil not work.

If you don’t want to use installutil to install wndow service then go to http://dotnetstep.blogspot.com/2009/06/install-window-service-without-using.html.

Get WindowService Executable Path In .NET

2009-06-09T06:29:00.001+05:30

WindowService has a property called “Path to Executable” . This property contains path of window service that is going to execute. When you need this path in .NET Application there is no direct way to do it . You can not get it either via ServiceControler or any other way.

To get that you need to read Registry. All information about all window service installed on machine storead at following location.
HKLM\SYSTEM\CurrentControlSet\Services.

C# Code to read Service Registry.

RegistryKey services = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(@"SYSTEM\CurrentControlSet\Services");
if (services != null)
{
object pathtoexecutable = services.OpenSubKey(<<ServiceName>>).GetValue("ImagePath");
}

In Above code replace <<ServiceName>> with your service name.

Also this is a registry operation so you need proper permission to read registry and apply any other registry operation at your own risk.

Give your comment or any new idea about this task.

Redirect console application output to another application in .NET

2009-06-07T17:24:00.001+05:30

In .NET sometime it is required to execute system command and capture its result or data in application that execute that command.
For example you want to execute ipconfig command from .NET application and display its result in window application or need to read output of .NET console application.

For this purpose you need to use Process class that belongs to System.Diagnostics namespace.

//Create process class object
System.Diagnostics.Process p = new System.Diagnostics.Process();

// Set StartInfo property.
// Set redirection true for Error and output stream.
p.StartInfo.RedirectStandardError = true;
p.StartInfo.RedirectStandardOutput = true;

// When you set redirection you must set UseShellExecute to false .
p.StartInfo.UseShellExecute = false;

// Set window style
p.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;

// Set Command paramter.
p.StartInfo.FileName = "ipconfig";
p.StartInfo.Arguments = " /all";

// Set CreateNoWindow to true as window is not required here.
p.StartInfo.CreateNoWindow = true;

// Following two events are new in .NET framework 2.0 which allow us to capture data asynchronously.
p.OutputDataReceived += new System.Diagnostics.DataReceivedEventHandler(p_OutputDataReceived);
p.ErrorDataReceived += new System.Diagnostics.DataReceivedEventHandler(p_ErrorDataReceived);

// Start the process.
p.Start();

// Must call following two methods in order to capture data asynchronously.
p.BeginErrorReadLine();
p.BeginOutputReadLine();

// Wait for Process to Exit ( This is not must done ).
p.WaitForExit();

// Event Handler for ErrorStream.
void p_ErrorDataReceived(object sender, System.Diagnostics.DataReceivedEventArgs e)
{
System.Diagnostics.Debug.WriteLine(e.Data);
}

// Event Handler for OutputStream.
void p_OutputDataReceived(object sender, System.Diagnostics.DataReceivedEventArgs e)
{
System.Diagnostics.Debug.WriteLine(e.Data);
}

Even you can use this functionality to make utility like process command background and produce result in window application.

p.StartInfo.FileName = @"%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_compiler.exe";
p.StartInfo.Arguments = @" -v / -f -p C:\Blog\WebSite1 c:\WebSite1Compile";
// Note : Replace %windir% with your window directory. or use p.StartInfo.EnvironmentVariables["windir"]

Above is the one example to compile website application from window application.

Apart from this there is event called Exited associated with Process class object. In order to receive this event you need to set EnableRasingEvents property to true value.

Give your comment and idea on this article.

DateTime operation in .NET Application

2009-06-06T21:49:00.000+05:30

DateTime is a very important datatype and data in terms of realtime application. Some of the application that run timely manner and some of the application that generate data (log file) with time.
To generate such report you need to required store information about date and time.

In .NET there is datatype called DateTime. This contain all information about datetime but sometime problem with this too.

For example:

DateTime dt = DateTime.Now; // 6/6/2009 09:35:00 PM.
This is used to get current current time of system. If you store this time in file or in a database and later you retrieve then you get that time. So at last “6/6/2009 09:35:00 PM” this is going to store in a file.

Problem occur when you retrieve this later to display information and by some reason you make changes to current time zone of system or sometime timezone of application. So then also you get “6/6/2009 09:35:00 PM.” as data , which is not right.

So best way to store date is UTC format.

DateTime dt = DateTime.UtcNow and after retrieval convert it to LocalTime but for that also you have to confirm that stored DateTime is in Utc format.

DateTime structure contains methods called ToBinary() and FromBinary().

long binaryDate = DateTime.Now.ToBinary() ;

Now store ‘binaryDate’ value in database or text file. So later when you get this value.

DateTime dt = DateTime.FromBinary(binaryDate). This will generate correct Date and Time even after timezone changed. This is because of binaryDate( Long ) value contain information about TimeZone too. So it automatically adjust as per system timezone.

Apart from this DateTime structure contain one field called ‘Kind’. which contain current DateTime format kind and that is Utc , Local or Unspecified. Many of case when you store simple way DateTime and later you retrieve kind is unspecified. But when you store binary date and later you retrieve you get either Utc or Local.

Please give your comment or any new idea about storing datetime.

Usage of aspnet_compiler.exe and aspnet_merge.exe

2009-06-06T10:46:00.001+05:30

Whenever asp.net website or webapplication publish,aspnet_compiler.exe is used for compilation.

Example :

WebSite : c:\myProject\TestSite

1 . Go to Visual Studio Tool from program menu and start Visual studio command prompt.
                                     or
     If you do not have visual studio installed on your machine and just .NET Framework 2.0 installed on your machine then also you can use aspnet_compiler tool.
- Start > run and type cmd.
- set path=%windir%\Microsoft.NET\Framework\v2.0.50727
- aspnet_compiler –v / –p c:\myproject\testsite c:\testcompile

   It will compile c:\myproject\testsite and put published site in c:\testcompile.
- When you compile site using above command site is not updatable after publish.
- If you want to site updatable after publish add –u option to it.
- It is good to add –f option in order to override existing published site.
- Fore more help just type aspnet_compiler /?

Now let discuss about aspnet_merge.exe tool. This tool is introduce later and it is used to merge all assemblies that is located in bin directory of published site. When you published website project many assemblies are in bin directories depending upon your option.

- In aspnet_compiler if you add –fixednames option then it will generate single assembles for each page otherwise it is generated per directory (this is default for asp.net website project).

- Main disadvantage of different assembles either way is problem with reflection. You are not able to get control and page information located in another assemblies without assemblies loading programmatically.

- aspnet_merge.exe tool merge all aspnet generated assemblies to single assemblies.

Example :

1. set path=%programfiles%\Microsoft SDKs\Windows\v6.0A\bin
2. aspnet_merge c:\testcompile
This will create single DLL ( assembly ) in bin directory.
3. To set generated assembly name use this.
aspnet_merge –o Single.dll c:\testcompile.

Hope this will help you.

Please give your comment and advice on this.

BuildManager To Get Detail About Dynamic Compiled Assembly

2009-05-28T05:09:00.001+05:30

Here i am going to explain how one can use BuildManager to get detail about dynamic generated Assembly.
In ASP.net 2.0 or ASP.net 3.5 , there are two type of projects. One is ASP.net Web Application and Another one is ASP.net WebSite Project. Significant difference between these two is how they compiled or published.

1. When “ASP.net WebApplication“ project published it create only Single DLL file in Bin for whole application and DLL name is also predetermined. Also when any new item added to the Project ( Either Web Form or Web User Control ) it comes under one namespace.

2. When “ASP.net WebSite“ project published then it create many DLL file in bin directory. No of DLL depend on condition you choose when publish “ASP.net WebSite” project.

- When only first checkbox is checked then it create assembly per directory. In following image you can see one sample solution. So it create one assembly for Top Level directory and their page and control and one assembly for TestControls directory.

- When second checkbox is selected then it creates separate assembly for each page and each controls.

Now main thing “BuildManager” comes into picture.

1. If you have “ASP.net WebApplication” project then you can access of another type in project via namespace. For Example you have two page "Default.aspx” and “Default2.aspx” and you want to just create instance of “Default.aspx” via its type in “Default2.aspx”.

namespace WebApplication3
{
    public partial class _Default : System.Web.UI.Page
    {
        public string GetMessage()
        {
              return “Hello”;
        }
        protected void Page_Load(object sender, EventArgs e)
        {
        }
    }
}

namespace WebApplication3
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            WebApplication3._Default dForm = new _Default();
            Response.Write(dForm.GetMessage());
         }
    }
}
so it is very easy for “ASP.net WebApplication” project.

2. For “ASP.net Web site“ type of project this is not a case. This type of project does not allow you to access another simple way as above. For that you have to use BuildManager Class.

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
// You can not access Default2 class directly.
// Get Type using BuildManager.
// Here i specified virtual path.
Type compiled_o = System.Web.Compilation.BuildManager.GetCompiledType("~/Default2.aspx");
//Detail about assembly. Fully qualified name which contain dynamic assembly name too.
Response.Write(compiled_o.FullName);
// Create instance of Type.
object obj = Activator.CreateInstance(compiled_o);
// GetData is a Method to call.
System.Reflection.MethodInfo info = compiled_o.GetMethod("GetMessage");
// Now Call method . Here Method GetData is a instance method so we need to call
// Invoke method with obj. null as no argument required.
object data = info.Invoke(obj, null);
// Check that data contain value.
if (data != null)
{
Response.Write(data.ToString());
}
}
}
public partial class Default2 : System.Web.UI.Page
{
    public string GetMessage()
    {
              return “Hello”;
    }
    protected void Page_Load(object sender, EventArgs e)
    {
    }
}

BuildManager class has static method GetCompiledType, which required virtual path as a input so you can even give virtual path of user control too.

Please give your comment on this.

SMTP Setting to send outbound email

2009-05-16T14:38:00.001+05:30

Here i am going to explain about steps required to configure SMTP (Local SMTP) to send outbound email.

Steps.
1. Go to run and Type inetmgr. After inetmgr ( Internet information services manager ) open. Right click on Default SMTP virtual server ( As shown in figure 1) . If this is not displayed in your inetmgr then you need to first install SMTP services using Add/ Remove component.

2. After right click on Default SMTP virtual server go for property
menu item. It will display as show in following image.

3. Now go in Access Tab and click on relay. Please select as shown in following image and click ok.

4. After that go for delivery tab. ( Display as follows)

5. Click on outbound security . In that tab select basic authentication. Here i am using by gmail account to send outbound email. AS gmail required TLS (security to transfer credential) , you have to select TLS encryption checkbox too.Then click on ok.

7. Now go for outbound connection button. It will display as follows. Please specify TCP port as 587 for gmail otherwise 25 as default.

8. Click on Advanced . Configure as follows . In case of other SMTP , you have to specify that smtp server.

Click ok and then finally click on apply. Now restart smtp server using inetmgr.
Note : Here i took Gmail smtp setting . For that you need to configure Gmail account from Gmail setting and click on IMAP enable.

DataTable / DataSet and Linq

2009-05-14T11:58:00.001+05:30

1. Querying DataTable using Linq
    Here i am going to explain how you can use linq to get data from DataTable.
    You need to use AsEnumerable() method of DataTable object to query datatable using linq.
Example :
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Name");
DataRow dr = dt.NewRow();
dr["ID"] = "1";
dr["Name"] = "Test1";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = "2";
dr["Name"] = "Test2";
dt.Rows.Add(dr);

var result = from user in dt.AsEnumerable()
where user.Field<string>("ID") == "1"
select user;

2. Join Two DataTable using Linq.
Example : Here i take two datatable.

        DataTable dt = new DataTable();
        dt.Columns.Add("ID");
        dt.Columns.Add("Name");
        DataRow dr = dt.NewRow();
        dr["ID"] = "1";
        dr["Name"] = "Test1";
        dt.Rows.Add(dr);
        dr = dt.NewRow();
        dr["ID"] = "2";
        dr["Name"] = "Test2";
        dt.Rows.Add(dr);

        DataTable dt1 = new DataTable();
        dt1.Columns.Add("ID");
        dt1.Columns.Add("Product");
        dr = dt1.NewRow();
        dr["ID"] = "1";
        dr["Product"] = "Test-Product";
        dt1.Rows.Add(dr);

Linq Query:

var c = from p in dt.AsEnumerable()
join d in dt1.AsEnumerable() on p.Field<string>("ID") equals d.Field<string>("ID")
select new { ID = p.Field<string>("ID"), Name = p.Field<string>("Name"), Product = d.Field<string>("Product") };

3. Except and Intersect operation between two DataTable using Linq .

        DataTable dt = new DataTable();
        dt.Columns.Add("ID");
        dt.Columns.Add("Name");
        DataRow dr = dt.NewRow();
        dr["ID"] = "1";
        dr["Name"] = "Test1";
        dt.Rows.Add(dr);
        dr = dt.NewRow();
        dr["ID"] = "2";
        dr["Name"] = "Test2";
        dt.Rows.Add(dr);

        DataTable dt1 = new DataTable();
        dt1.Columns.Add("ID");
        dt1.Columns.Add("Name");
        dr = dt1.NewRow();
        dr["ID"] = "1";
        dr["Name"] = "Test1";
        dt1.Rows.Add(dr);

var exceptresult = dt.AsEnumerable().Except(dt1.AsEnumerable(), System.Data.DataRowComparer.Default);

var intersectresult = dt.AsEnumerable().Intersect(dt1.AsEnumerable(), System.Data.DataRowComparer.Default);

For both of above operation you need to specify DataRowComparer . System.Data.DataRowComparer is a static sealed class and its static property Default contain comparer reference. You must have to specify comparer for this operation on Reference datatype.

Next blog i will give you CustomDataRow Comparer to make it more efficient.

Important Tool For .NET

2009-05-14T09:02:00.001+05:30

1. Managed Stack Explorer
This tool is used to monitor all managed process and their threads.
You can download that tool at following location DownLoad

2. Process Explorer
This tool is same as Taskmanager but it will give you more detail than taskmanager. Even this tool show you process in parent child relation so it is easy to manager.
You can find more detail and download location at following link Process Explorer.

3. CLRProfiler
This tool is specially designed for CLR ( Common language runtime ) . This tool give you more detail about Heap graph of your application.
For .Net Framework 1.1
For .NET Framework 2.0

GMail SMTP Setting To Send Email From ASP.net Application

2009-04-21T07:48:00.001+05:30

First of all , It is required to configured GMail.

1. Create Gmail account or use existing if you already have it.
2. Log in into Gmail.
3. Go Settings.
4. Go Forwarding and Enable IMAP/POP3
5. In that go to last section and enable IMAP.

Now in your Web Application / Web Site project , open web.config. Add following to web.config.

<system.net>
    <mailSettings>
      <smtp deliveryMethod="Network">
        <network host="smtp.gmail.com" port="587" userName="username@gmail.com" password="password" />
      </smtp>
    </mailSettings>
</system.net>

GMail IMap Service runnig at port 587 so you must required to configured that. Also Gmail required SSL authentication so it is required to enable ssl for SMTPClient.

MailMessage message = new MailMessage();
message.From = new MailAddress(from@gmail.com);
message.To.Add("to@gmail.com");

SmtpClient client = new SmtpClient();
client.EnableSsl = true;
client.Send(message);

Yuo can not enable SSL in web.config so you must required to configure it explicitly.

WebService Authenticate against proxy server.

2009-04-17T06:57:00.001+05:30

When proxy server configured for PC or in a network , if it require authentication to make certain request then you have to use following code.

Error: (407) Proxy Authentication Required.

Here i am taking example of SharePoint List service. I added reference of SharePoint List Service.

ListSerivce lst = new ListSerivce();
//Get Default Proxy Setting
IWebProxy proxy = System.Net.WebRequest.DefaultWebProxy;
// Authenticate using network credential. In My case i need authentication using windows account.
proxy.Credential = new System.Net.NetworkCredential(“username”,”password”,”domain”);
lst.Proxy = proxy;
// Make Call to WebService Method.

You can even find System.Net.WebProxy.GetDefaultProxy() return default proxy setting but it is deprecated to better to use WebRequest.DefaultWebProxy.

You can even configure your own webproxy

Lists lst = new Lists();
System.Net.WebProxy proxy = new WebProxy();
proxy.Address = new Uri("http://proxy:8090");
proxy.Credentials = new NetworkCredential ("username", "password", "domain");
lst.Proxy = proxy;

In both case credential pass as NetworkCredential but you can use CredentialCache to pass other type of credential.

Please give comment on this. Also if you have any better idea please free give your suggestion.

CrystalReport redistribution package

2009-04-09T05:42:00.001+05:30

This is just a small information about Crystal Report redistribution package. You can fine different packages related to Visual Studio at following location

“<system drive>:\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages”

At this location you can different directories that contains .exe or .msi related to Visual Studio 2008 installation.

WSE 3.0 Setting Tool For Visual Studio 2008

2009-04-03T21:41:00.001+05:30

WSE 3.0 Setting Tool not available in VS 2008. Here i am explaining steps required to enable it in Visual Studio 2008.

1 . Download Following Tool
     WSE 3.0 Tools
2. Install that MSI File.
     “Basically that installation is for Visual Studio 2005.”
3. After installation you find one file at following location.
     C:\Documents and Settings\All Users\Application Data\Microsoft\MSEnvShared\Addins
      Here i assumed that your OS is installed at C:\.
4. At that location you find this file “WSESettingsVS3.Addin”.
5. Open file in Notepad , you find following XML content.

<HostApplication>
    <Name>Microsoft Visual Studio Macros</Name>
    <Version>8.0</Version>
</HostApplication>
<HostApplication>
    <Name>Microsoft Visual Studio</Name>
    <Version>8.0</Version>
</HostApplication>

change it to

<HostApplication>
    <Name>Microsoft Visual Studio Macros</Name>
    <Version>9.0</Version>
</HostApplication>
<HostApplication>
    <Name>Microsoft Visual Studio</Name>
    <Version>9.0</Version>
</HostApplication>

save that file.
6. Open Visual Studio , Tools – > Options –> Environments

Add Following
“C:\Documents and Settings\All Users\Application Data\Microsoft\MSEnvShared\Addins”

(Note : In Image it displayed D:\ as my os is on D Drive.)

7. Close all instance of Visual Studio.

8. Open it again , create web service application . Now you can se that WSE 3.0 Setting option enable.

How to get assembly name for registration ?

2009-04-02T04:52:00.001+05:30

When assembly added into global assembly cache and there is need for adding that assembly to web.config assemblies section.

Now there is need to add System.Web.Extensions assembly , for that you need assembly detail with its public key token to register.

Easiest way to get that detail is

1. Go to run and type assembly.

it will open following window.

2. Now select assembly , for example system.web.extensions , then go to edit menu and select option Copy display name as shown in following image.

3. Now paste data.

you get all detail to register assembly. Enjoy… !

Run MSI In Context Of User

2009-03-06T17:53:00.001+05:30

Several times to install program you need administrative or other user privileges. For example you take input from user for username and password and run that program in that particular user context.

I faced problem during installing MSI in particular user context or start IIS in context of another user.

I found this solution using command line argument.

1. Inermgr ( Run following command in Command line)

C:\runas /user:administrator “mmc %sysroot%\system32\inetsrv\iis.msc”
Enter the password for administrator :

2. MSI install
C:\runas /user:administrator “msiexec /i <full path of msi file>”

c:\runas /user:administrator “msiexec /i c:\download\setup.msi”
Enter the password for administrator :

For more information just type runas /? on command line.

Unauthorized (401.1) Exception calling Web Services in SharePoint (.Net Framework 3.5 )

2009-03-05T07:17:00.001+05:30

After installing .NET Framework 3.5 sp1 following error may occur while making call to webservice. This thing mostly happen when you are trying to make webservice call using fully qualified domain name instead of IPAddress or Hostheader is used to map request on single port.

I found one strange thing in IIS Log that , for such request it is not sending authentication information to webservice request even though you pass it in NetworkCredential. One solution is to disable integrated authentication and use basic authentication. This will compromise with security but solve problem. Another solution that need to require registry changes. You can find it at following link with grate explanation.

http://www.crsw.com/mark/Lists/Posts/Post.aspx?ID=44
http://support.microsoft.com/default.aspx?scid=kb;EN-US;896861

SPAlert DynamicRecipient On Custom List

2009-03-05T06:55:00.001+05:30

In SharePoint default. alert functionality available. You can subscribe Alert on List or ListItem using AlertMe action. But in certain situation you need to automize this alert. Like Alert automatically send to particular user even though he/she did not subscribe event.

There are two way to do . Create feature that receive ItemAdded or ItemUpdated Event , Find out user and email address , send email using SendEmail Functionality of SharePoint.

Another way is use DynamicRecipient property of SPAlert.

Sample List :

Here you can see that To Field is type of Person or Group. Send automatic email to user enter ‘To’ Field.

List Entry look Like (Edit View).

Note : UserName must have email id associated with him.SMTP also configured properly for site.

Now run following code against your site. (use console application).

SPSite site = new SPSite("http://yoursite");
SPWeb web = site.OpenWeb();
SPList lst = web.Lists["Alert Test"];
SPAlert alert = web.Alerts.Add();
alert.AlertFrequency = SPAlertFrequency.Immediate;
alert.AlertType = SPAlertType.List;
alert.EventType = SPEventType.All;
alert.DynamicRecipient = "To";
alert.List = lst;
alert.Status = SPAlertStatus.On;
alert.Title = “Auto Email Alert”;
alert.Filter = "<Query><IsNotNull><FieldRef Name='To'></FieldRef></IsNotNull></Query>";
alert.Update();

You can even use FeatureReceiver to install/ Activate / deactivate this thing as a feature.

Global Theme Setting for ASP.net 2.0 or Later.

2009-02-12T21:37:00.001+05:30

In order to set theme globally for application. There are two ways to do that. one is longer and second one shorter way to do that.

1.
Create App_Themes directory for each application. This is special directory. You can copy Theme over here for each application.

2.
Put New theme under Themes directory of aspnet_clientfile directory.

C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727

If themes directory not found then create one. For example if theme name is Green then it should be like

C:\inetpub\wwwroot\aspnet_client\system_web\2_0_50727\Themes\Green

This will work for all website that already created. In IIS6 website can be created afterwards. so for that this clientfile does not map to new site, following location must contain themes directory and required theme folder.

C:\Windows\Microsoft.NET\Framework\v2.0.50727\ASP.NETClientFiles\Themes\Green

After that run following command from studio command prompt
> aspnet_regiis –c

Above setting works for only IIS6 or previous versino of IIS 5.

Kill Process On Remote Machine

2009-02-11T17:22:00.001+05:30

It is not recommended that each and every time abort process this way but sometime it is necessary stop some process from executing on remote machine.

There are few useful command for that.

TaskList
Taskkill or tskill

Run following command on command prompt.
> TaskList ( Current system running process list)

> TaskList /S <system name>
    e.g Remote system name remote1 then
   TaskList /S remote1
   Some of the case you require to pass credential for remote pc in that case use following command.
   TaskList /S remote1 /U <username> /P <Password>
TaskList command is used to get process id that we want to kill.

To Kill process there are two command TaskKill and tskill . I prefer TaskKill over tskill as it gives more command line options.

> TaskKill /PID <process id> ( use to kill perticular process that identified by process id on local machine)

> Taskkill /S <remote pc name or IP Address> /PID <process id> ( kill process that identified by process id on remote machine)

If remote pc require credential than use

> taskkill /S < remote pc name or IP Address> /PID <process id> /U <username> /P <password>

All above command are tested on Windows XP and Windows 2003.
You must require permission to run above command in order to use functionality.

In All Above you can use IP Address instead of remote PC name.

Difference Between Explicit And Implicit Interface Implementation

2009-02-01T18:08:00.001+05:30

Interface can be implemented two ways. Explicitly or Implicitly.
For Example :
public interface IEmployee
{
         string FullName
         {
               get;
               set;
         }
}

Implicit implementation of Interface
public class ImplicitClass : IEmployee
{
     public string FullName
     {
           get ;
           set ;
     }
}

Explicit implementation of Interface.
public class ExplicitClass : IEmployee
{
    string IEmployee.FullName
    {
           get ;
           set ;
    }
}
Here you can see that FullName property does not have access modifier.As this is explicit implementation so it does not allow access modifier.

Now we see what happen when try to create object of both of above class.

ImplicitClass cls = new ImplicitClass();
cls.FullName = “test”;
// Above code works fine

ExplicitClass cls1 = new ExplicitClass();
cls1.FullName = “test”; // error occur

As interface implement explicitly FullName property not available directly to cl1 object b’coz it become private to the Interface type.

By reflection

ImplicitClass cls = new ImplicitClass();
PropertyInfo pinfo = cls.GetType().GetProperty("FullName");
if (pinfo != null)
    {
     pinfo.SetValue(cls, "test",null);
    }

ExplicitClass cls1 = new ExplicitClass();
PropertyInfo pinfo1 = cls1.GetType().GetProperty("FullName");
            if (pinfo1 != null) // pinfo1 is null in this case.
            {
                pinfo1.SetValue(cls1, "test",null);
            }

By reflection way also not able to set property as can no available propertyinfo.

Solution for this is , If interface implemented explicit way then cast to Interface type then set property.

ExplicitClass cls1 = new ExplicitClass();
IEmployee emp = cls1 as IEmployee;
emp.FullName = “test”;

if want to access with use of Reflection
ExplicitClass cls1 = new ExplicitClass();                        PropertyInfo pinfo1 = cls1.GetType().GetInterface("IEmployee").GetProperty("FullName");
if (pinfo1 != null)
{
   pinfo1.SetValue(cls1, "test",null);
}

Note: only choose explicit interface if needed. One such case is if your class previously has property/Event/Method that Interface has also , than to avoid conflict must need of explicit interface implementation.

Please give you further suggestion about this article.

ASP.net MasterPage Advanced

2009-01-29T06:19:00.001+05:30

1. Dynamically Setting MasterPage At Runtime

MasterPage can be set dynamically at runtime in Pre_Init method of Page.

protected void Page_PreInit(object sender, EventArgs e)
    {
        Page.MasterPageFile = “<virtual path of .masterfile>";
    }

2. Strongly Type Access Of MasterPage And Its Properties.

MasterPage.aspx.cs
public partial class MainMaster : System.Web.UI.MasterPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }

    public string PageTitle
    {
        get
        {
            return Page.Title;
        }
        set
        {
            Page.Title = value;
        }
    }
}

Now in Content Page need for access PageTitle Property.

In Content Page use @MasterType directive.

<%@ Page Language="C#" MasterPageFile="~/MainMaster.master" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" Title="Untitled Page" %>
<%@ MasterType VirtualPath="~/MainMaster.master" %>

//Default2.aspx.cs

protected void Page_Load(object sender, EventArgs e)
    {
        Master.PageTitle = "By use of MasterType";
    }
If @MasterType directive is not used than you can not access custom property of MasterPage . You are only limited to access MasterPage class property.
Note: When @MasterType directive used than it is not allowed to set page dynamically. It gives you type cast error as it try to convert object of one type to another type.

3. Access MasterPage Properties Using Reflection.

By use of reflection you can also set property of master page.
For example access PageTitle Property (. It is not neccessary to specify MasterType directive on Page).

System.Reflection.PropertyInfo pinfo = Page.Master.GetType().GetProperty("PageTitle");
        if (pinfo != null)
        {
pinfo.SetValue(Page.Master, "This is test reflection : Default", null);
        }

This approach is good if your requirement is set to masterpage at runtime.

4. By Use Of Common Interface For All MasterPage.

Use this approach when decided that certain property must supported by MasterPage. In such case create one interface and that must be implemented by each of required masterpage.

// App_Code IMasterPageProperties.cs
public interface IMasterPageProperties
{
    string PageTitle
    {
        get;
        set;
    }
}

//SeconMaster.master.cs
public partial class SecondMaster : System.Web.UI.MasterPage , IMasterPageProperties
{
// Interface Implementation
public string PageTitle
    {
        get
        {
            return Page.Title;
        }
        set
        {
            Page.Title = value;
        }
    }
}

// Defalt.aspx.cs (Page_Load event just for example)IMasterPageProperties property = Page.Master as IMasterPageProperties;
if (property != null)
        {
            property.PageTitle = "By use of Interface";
        }

Note : Try to cast Page.Master as Interface Type. This approach is good and cover both explicit and implicit implementation of interface.
5. By Use Of Abstract Base Class For MasterPage.

Create one abstract class . (Possibly in App_Code).

public abstract class BaseMasterPage : MasterPage
{
    public string PageTitle
    {
        get
        {
            return Page.Title;
        }
        set
        {
            Page.Title = value;
        }
    }
}

Now create new MasterPage ( I name it Third.master). In normal case all masterpage inherits from MasterPage Class. Now ThirdMaster class should inherits from BaseMasterPage Class.

This is how Third.master.cs look like.

public partial class Third : BaseMasterPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
       this.PageTitle = "By use of abstarct base class";
    }
}

Batch Update In SharePoint

2009-01-24T18:44:00.001+05:30

SharePoint support batch update in List by webservice and SharePoint object model.

For Example i used sample Custom List (Orders).

1. By Use of Web Service.

SharePoint webservice allows update list items as a batch.At a time only one list can be updated by single webservice call.

CAML That use for Batch Update. Here i update item with ID 2 and create new item in Orders List in one webservice call.

C# Code (Either Add web reference of SharePoint webservice or Create Proxy Class using wsdl.exe and use that class)

Lists lst = new Lists();
lst.Url = “http://<your site>/_vti_bin/lists.asmx”;
lst.Credentials = new System.Net.NetworkCredential ("test", "test");
XmlDocument doc = new XmlDocument();
XmlElement batchElement = doc.CreateElement("Batch");
batchElement.SetAttribute("OnError", "Continue");
batchElement.InnerXml = "<Method ID='1' Cmd='Update'>" +
"<Field Name='ID'>2</Field>" +
"<Field Name='OrderDate'>2009-1-31</Field><Field Name='OrderDateTime'>2009-1-31</Field></Method><Method ID='2' Cmd='New'><Field Name='CustomerID'>1;#Cust_1</Field><Field Name='OrderDate'>2009-1-31</Field><Field Name='OrderDateTime'>2009-1-31</Field></Method>";
XmlNode result = lst.UpdateListItems("Orders", batchElement); // This line of code make webservice call to update lists.

One more thing In CAML displayed above has two bold line for CustomerID field. CustomerID is a LookUp Field. So i mention that date id;#Value (Commom lookup Structure).If you want to choose lookup value only by id then use following CAML for Field.

2. By Use Of SharePoint Object Model. (SPWeb.ProcessBatchData)

SharePoint Object Model has SPWeb class. SPWeb class has ProcessBatchData Method , this method is used to update Batch via object model. Even this method allows you update two list items in Single method call.

Sample CAML .
<?xml version="1.0" encoding="UTF-8"?>
<ows:Batch OnError="Continue">
<Method ID="1">
    <SetList>71a9fac3-2e94-4246-8fec-41e30ea65b06</SetList>
    <SetVar Name="Cmd">Save</SetVar>
    <SetVar Name="ID">New</SetVar>
    <SetVar Name="urn:schemas-microsoft-com:office:office#OrderDate">2009-2-21</SetVar>
    <SetVar Name="urn:schemas-microsoft-com:office:office#OrderDateTime">2009-2-21</SetVar>
    <SetVar Name="urn:schemas-microsoft-com:office:office#CustomerID">1;#Cust_1</SetVar>
</Method>
<Method ID="2">
    <SetList>71a9fac3-2e94-4246-8fec-41e30ea65b06</SetList>
    <SetVar Name="Cmd">Save</SetVar>
    <SetVar Name="ID">3</SetVar>
    <SetVar Name="urn:schemas-microsoft-com:office:office#OrderDate">2009-2-21</SetVar>
    <SetVar Name="urn:schemas-microsoft-com:office:office#OrderDateTime">2009-2-21</SetVar>
    <SetVar Name="urn:schemas-microsoft-com:office:office#CustomerID">1;#Cust_1</SetVar>
</Method>
<Method ID="3">
    <SetList>71a9fac3-2e94-4246-8fec-41e30ea65b06</SetList>
    <SetVar Name="Cmd">Delete</SetVar>
    <SetVar Name="ID">4</SetVar>
    <SetVar Name="urn:schemas-microsoft-com:office:office#OrderDate">2009-2-21</SetVar>
    <SetVar Name="urn:schemas-microsoft-com:office:office#OrderDateTime">2009-2-21</SetVar>
    <SetVar Name="urn:schemas-microsoft-com:office:office#CustomerID">2;#Cust_2</SetVar>
</Method>
</ows:Batch>

In above SetList element set GUID of SPList. Here i only update Orders List but you can set another list id combine it with above by just adding another Method Element.

SetVar element with attribute Name ‘cmd’ used to identify type of functionality. It has mainly two values : Save and Delete . Save is used for either for New Item or in case of update existing item.

SetVar element with attribute Name ‘ID’ used to find out on which item it operate. ID value ‘New’ is for new item and in case of Update and Delete it should have valid id value. (Integer).

SetVar element with Name attribute value urn:schemas-microsoft-com:office:office#<Field_Name> indicate perticular field of ListItem,<Field_Name> should replace by respetive field internal name.

C# Code.

SPSite site = new SPSite("http://avani:45830");
SPWeb web = site.OpenWeb();
SPList lst = web.Lists["Orders"];
string batchFormat = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" +
"<ows:Batch OnError=\"Return\">{0}</ows:Batch>";

string methodFormat = "<Method ID=\"{0}\">" +
             "<SetList>{1}</SetList>" +
             "<SetVar Name=\"Cmd\">{2}</SetVar>" +
             "<SetVar Name=\"ID\">{3}</SetVar>" +
             "<SetVar Name=\"urn:schemas-microsoft-com:office:office#OrderDate\">{4}</SetVar>" +
             "<SetVar Name=\"urn:schemas-microsoft-com:office:office#OrderDateTime\">{5}</SetVar>" +
             "<SetVar Name=\"urn:schemas-microsoft-com:office:office#CustomerID\">{6}</SetVar>" +
             "</Method>";

StringBuilder strmethodFormat = new StringBuilder();
strmethodFormat.AppendFormat(methodFormat, 1, lst.ID.ToString(), "Save", "New", "2009-2-21", "2009-2-21","1;#Cust_1");
strmethodFormat.AppendFormat(methodFormat, 2, lst.ID.ToString(), "Save", "3", "2009-2-21", "2009-2-21","1;#Cust_1");
strmethodFormat.AppendFormat(methodFormat, 3, lst.ID.ToString(), "Save", "4", "2009-2-21", "2009-2-21","2;#Cust_2");
string processtext = String.Format(batchFormat, strmethodFormat.ToString());

web.ProcessBatchData(processtext);

Other usefull post about Batch element creation through XLinq or Linq are
http://dotnetstep.blogspot.com/2009/01/xlinq-to-generate-batch-element-for.html
http://dotnetstep.blogspot.com/2009/01/sharepoint-to-linq.html

ThreadPool Wait For All Thread To Complete

2009-01-21T05:14:00.001+05:30

I already discuss issue related to WaitHandle.WaitAll that it does not support wait for more 64 waithandle. In that article discuss about 64 chunks of thread to be executed parallel.

When you use ThreadPool and you combine it with 64 chunks of thread concept than you can not take advantage of ThreadPool. In ThreadPool all task wait for pool become empty.( Not fully). As ThreadPool have available thread then new task automatically executed.

So wait for more than 64 waithandle is needed, i found solution by following way.

C# Code.

using System;
using System.Collections.Generic;
using System.Threading;
namespace ThreadPoolWaitForAllThread
{
    class Program
    {
        static void Main(string[] args)
        {
            List<ManualResetEvent> events = new List<ManualResetEvent>();
            for (int i = 0; i < 100; i++)
            {
                ThreadPoolObj obj = new ThreadPoolObj();
                obj.ObjectID = i;
                obj.signal = new ManualResetEvent(false);
                events.Add(obj.signal);
                WaitCallback callback = new WaitCallback(ThreadFunction);
                ThreadPool.QueueUserWorkItem(callback,obj);
            }
           WaitForAll(events.ToArray());
           Console.WriteLine("Compelted");
           Console.ReadLine();
        }
        static bool WaitForAll(ManualResetEvent[] events)
        {
            bool result = false;
            try
            {
                if (events != null)
                {
                    for (int i = 0; i < events.Length; i++)
                    {
                        events[i].WaitOne();
                    }
                    result = true;
                }
            }
            catch
            {
                result = false;
            }
            return result;
        }
        static void ThreadFunction(object threadobj)
        {
            ThreadPoolObj obj = threadobj as ThreadPoolObj;
            if (obj != null)
            {
                Console.WriteLine(obj.ObjectID.ToString());
                Thread.Sleep(2000); // Just Wait To Show Syncronization
                obj.signal.Set();
            }
        }
    }
    class ThreadPoolObj
    {
        public int ObjectID;
        public ManualResetEvent signal;
    }
}
By this way you can wait for more than 64 Waithandle.

Same function you can use anywhere even in case of article (WaitHandle.WaitAll Limitation). After use of this function you can avoid logic of 64 chunks, but if your thread consume more resource than it is better to run as chunks of thread instead of starting all thread at once. ThreadPool maintain this thing automatically.

Please give your comment on this.

Find BigNumber Factorial (!)

2009-01-21T04:40:00.001+05:30

Sometime when work with mathematical application , there is need to find out “Big Number” Factorial.

By Use of Simple Factorial Function

C# Code.

using System;
class Program
    {
        static void Main(string[] args)
        {
            for (int i = 1; i < 50; i++)
            {
            Console.WriteLine(i.ToString() + "\t\t" +SimpleFactorial(i).ToString());
            }
            Console.ReadLine();
        }

        static System.Int64 SimpleFactorial(System.Int64 number)
        {
            System.Int64 result = 1;
            for (System.Int64 i = 2; i <= number; i++)
            {
                result = result * i;
            }
            return result;
        }
}
If you are using above code than maximum up to value 20 you can find right answer. (Means 20!). If need is to find out Factorial larger this than you have to use FSharp Library in C#.

You can find F#Sharp Library at DownLoad .

After download , extract it and Add reference of FSharp.Core in C# Project.

using System;
using Microsoft.FSharp.Math;
class Program
    {
        static void Main(string[] args)
        {
            for (int i = 1; i < 50; i++)
            {
           Console.WriteLine(i.ToString() + "\t\t" + FSharpFactorial(i).ToString());
            }
            Console.ReadLine();
        }

        static BigInt FSharpFactorial(System.Int64 number)
        {
            BigInt num = new BigInt(number);
            return BigInt.Factorial(num);
        }
    }

By using FSharp Version of factorial 50! easily calculated. Even i test upto 20000! and It product result.

Connect To Office 2007(Access 2007 , Excel 2007) Without Installing Entire Office 2007

2009-01-18T08:58:00.001+05:30

Deploy application that use office 2007 ( Access 2007 , Excel 2007) and end user machine does not have Office installed on machine. In this case it is not necessary that end user machine must have office 2007 installed on machine.

Just install Data Connectivity driver.
2007 Office System Driver: Data Connectivity Components

Office 2007 Data Connectivity driver

ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”

Driver is around 25mb so it can reduce overhead of office 2007.

XLinq To Generate Batch Element For SharePoint ListService

2009-01-18T06:09:00.001+05:30

In my article (http://dotnetstep.blogspot.com/2009/01/update-datetime-column-using-webservice.html) i used SharePoint List Service to update SharePoint ListItems. In that article i manually set batchElement.InnerXml property with Xml.

When there is to many row and you want to generate it automatically then you can use XLinq.

In following example first select all items from orders List then use item id and update each item orderdate and orderdatetime column with current date and current datetime respectively.

Lists lst = new Lists();
lst.Url = “http://<your site>/_vti_bin/lists.asmx”;
lst.Credentials = new System.Net.NetworkCredential("test", "test"); // Site Administrator username and password
XmlNode resultNode = lst.GetListItems("Orders", String.Empty, null, null, int.MaxValue.ToString(), null, String.Empty);

// Use XElement To Generate Batch Element Automatically

XElement orders = XElement.Parse(resultNode.OuterXml);
XName name = XName.Get("data","urn:schemas-microsoft-com:rowset");
int methodsequence=1;
XElement updatexml =
new XElement("Batch", new XAttribute("OnError","Continue"),
from order in orders.Element(name).Elements()
// you can also use where condition over here
// for eg. where order.Attribure(“ows_ID”).value = “2”
select new XElement("Method",
new XAttribute("ID", (methodsequence++).ToString()),
new XAttribute("Cmd", "Update"),
new XElement("Field", new XAttribute("Name", "ID"), order.Attribute("ows_ID").Value),
new XElement("Field",new XAttribute("Name","OrderDate"),DateTime.Now.SharepointFormatDate()),
new XElement("Field", new XAttribute("Name", "OrderDateTime"), DateTime.Now.SharepointFormatDateTime())));

Now Convert XElement to XmlNode as UpdateListItems only accept XmlNode as parameter.

XmlDocument doc= new XmlDocument();
doc.LoadXml(updatexml.ToString());
lst.UpdateListItems("Orders",doc.FirstChild);

Update DateTime Column Using SharePoint ListService

2009-01-18T05:42:00.001+05:30

SharePoint webservice can be used to update item or items in SharePoint List.When SharePoint List contains “Date And Time” Column with only Date or Date And Time Mode, you have to pass date or datetime in specific format so it can be update by webservice.

UpdateListItems method is used for this purpose.

To format DateTime for SharePoint Webservice, i created following extension methods.

// Extensions Method

public static class DateTimeExtensions
{
    // Only Date Column
    public static string SharepointFormatDate(this DateTime dt)
    {
        return dt.ToString("yyyy-MM-dd");
    }

    // Date And Time column
    public static string SharepointFormatDateTime(this DateTime dt)
    {
        return dt.ToString("yyyy-MM-ddTHH:mm:ssZ");
    }
}

To Update List using webservice.

System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
System.Xml.XmlElement batchElement = doc.CreateElement("Batch");
batchElement.SetAttribute("OnError", "Continue");
batchElement.SetAttribute("ListVersion", "1");
batchElement.InnerXml =”<Method ID='1' Cmd='Update'>" + "<Field Name='ID'>2</Field>" +
"<Field Name='OrderDate'>”+ DateTime.Now.SharepointFormatDate() +”</Field><Field Name='OrderDateTime'>”+ DateTime.Now.SharepointFormatDateTime() +”</Field></Method>";

// List Serivce object (Add web reference for this)
Lists lst = new Lists();
lst.Url = “http://<your site>/_vti_bin/lists.asmx” ;
lst.Credentials = new System.Net.NetworkCredential("test", "test");
lst.UpdateListItems(“Orders”,batchElement);

In above code <Field Name=’ID’>2</Field> is used to identify unique row that need to be update. In Sample only item with id 2 is updated. In order to update multiple items just add another method element. For example, (This update both item with id 2 and 3)

batchElement.InnetXml =

“<Method ID='1' Cmd='Update'>" + "<Field Name='ID'>2</Field>" +
"<Field Name='OrderDate'>”+ DateTime.Now.SharepointFormatDate() +”</Field><Field Name='OrderDateTime'>”+ DateTime.Now.SharepointFormatDateTime() +”</Field></Method>" +
"<Method ID='2' Cmd='Update'>" + "<Field Name='ID'>3</Field>" +
"<Field Name='OrderDate'>”+ DateTime.Now.SharepointFormatDate() +”</Field><Field Name='OrderDateTime'>”+ DateTime.Now.SharepointFormatDateTime() +”</Field></Method>"

Same way you can update another type of columns too.

More information available at following location.

http://msdn.microsoft.com/en-us/library/lists.lists.updatelistitems.aspx
http://msdn.microsoft.com/en-us/library/ms440289.aspx

SharePoint to Linq

2009-01-11T14:08:00.000+05:30

Here specially talking about SharePoint and XLinq. When you choose SharePoint webservice to get data from SharePoint List, data return by web service is in XML format. To read this data as well as filter data XLinq is more powerful.

How to Use SharePoint webservice.
1. Add Web reference or generate proxy using WSDL tool.
then

Lists lst = new Lists();
lst.Url = “http://<your site>/_vti_bin/lists.asmx”;
lst.Credentials = new System.Net.NetworkCredential("test", "test");

Now use GetListItems to retrieve all items from SharePoint List. I would suggest take scenario into consideration. If you require less data to be return from SharePoint List then use Query in GetListItems function. ( Here concentration is on XLinq so it is out of scope for this post).

XmlNode resultNode = lst.GetListItems("Customers", String.Empty, null, null, int.MaxValue.ToString(), null, String.Empty);

XElement (System.Xml.Linq) to read result into XElement
XElement customers = XElement.Parse(resultNode.OuterXml);

XName to read type of Node.
XName name = XName.Get("data","urn:schemas-microsoft-com:rowset");

Read All Node Using Linq
var filtercustomers = from ele in customers.Element(name).Elements()
select new {CustomerID = ele.Attribute("ows_ID").Value , Name = ele.Attribute("ows_CustomerName").Value , City = ele.Attribute("ows_CustomerCity").Value , Country = ele.Attribute("ows_CustomerCountry").Value};

Filtering Node using XLinq
var filtercustomers = from ele in customers.Element(name).Elements()
where ele.Attribute("ows_CustomerCountry").Value == "India" && ele.Attribute("ows_CustomerCity").Value == "Banglore"
select new {CustomerID = ele.Attribute("ows_ID").Value , Name = ele.Attribute("ows_CustomerName").Value , City = ele.Attribute("ows_CustomerCity").Value , Country = ele.Attribute("ows_CustomerCountry").Value};

Join Using XLinq

1. Join Two Result
This is use full case when join in needed on filter data set.
In following code customers and orders represent two sample reslut set.

XmlNode resultNode = lst.GetListItems("Customers", String.Empty, null, null, int.MaxValue.ToString(), null, String.Empty);
XElement customers = XElement.Parse(resultNode.OuterXml);
XName name = XName.Get("data","urn:schemas-microsoft-com:rowset");

var filtercustomers = from ele in customers.Element(name).Elements()
where ele.Attribute("ows_CustomerCountry").Value == "India" && ele.Attribute("ows_CustomerCity").Value == "Banglore"
select new {CustomerID = ele.Attribute("ows_ID").Value , Name = ele.Attribute("ows_CustomerName").Value , City = ele.Attribute("ows_CustomerCity").Value , Country = ele.Attribute("ows_CustomerCountry").Value};

            // Retrive data From Orders
            resultNode = lst.GetListItems("Orders", String.Empty, null, null, int.MaxValue.ToString(), null, String.Empty);
            XElement orders = XElement.Parse(resultNode.OuterXml);
            var filterorders = from ele in orders.Element(name).Elements()
                                  select new { OrderID = ele.Attribute("ows_ID").Value, CustomerID = ele.Attribute("ows_CustomerID").Value.Split(new string[]{";#"},StringSplitOptions.None)[0] , OrderDate = ele.Attribute("ows_OrderDate").Value };

Join Results

var joinresult = from customerele in filtercustomers
join orderele in filterorders on customerele.CustomerID equals orderele.CustomerID
select new { customerele, orderele };

2. Directly Join Two XElement

var directjoin = from customerele in customers.Element(name).Elements()
join orderele in orders.Elements(name).Elements() on customerele.Attribute("ows_ID").Value equals orderele.Attribute("ows_CustomerID").Value.Split(new string[] { ";#" }, StringSplitOptions.None)[0]
select new { CustomerID = customerele.Attribute("ows_ID").Value, Name = customerele.Attribute("ows_CustomerName").Value, City = customerele.Attribute("ows_CustomerCity").Value, Country = customerele.Attribute("ows_CustomerCountry").Value, OrderID = orderele.Attribute("ows_ID").Value, OrderDate = orderele.Attribute("ows_OrderDate").Value };

Note: When working with webservice do care while retrieve data. Whatever data needed from single list for operation try to retrieve in single webservice call instead of making many web service call.For my point of view this will improve the performance.

WaitHandle.WaitAll Limitation

2009-01-07T06:49:00.001+05:30

WaitHanlde.WaitAll function has limitation about no. of WaitHandles it can handle. As it take array of WaitHandles so one can think it can handle any no. of WaitHandles, but it is not true. It can only handle 64 waithandles. When array exceed this value it display following error.

“The number of WaitHandles must be less than or equal to 64.”

Example that cause this error.

using System;
using System.Collections.Generic;
using System.Threading;

namespace WaitHandle_Limitation
{
    class Program
    {
        static void Main(string[] args)
        {
            try
            {
                List<ManualResetEvent> events = new List<ManualResetEvent>();
                for (int i = 0; i < 100; i++)
                {
                    Thread th = new Thread(new ParameterizedThreadStart(ThreadRunner));
                    ThreadParamObj obj = new ThreadParamObj();
                    obj.startval = (i*100);
                    obj.endval = (i*100)+10;
                    obj.eve = new ManualResetEvent(false);
                    events.Add(obj.eve);
                    th.Start(obj);
                }
                WaitHandle.WaitAll(events.ToArray());
/* Cause error when event.ToArray return array larger than 64. Here to cause error i used 100. So it will create array of 100. */
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message + ex.StackTrace);
            }
            Console.ReadLine();
        }

        static void ThreadRunner(object thObj)
        {
            ThreadParamObj obj = (ThreadParamObj)thObj;
            if (obj != null && obj.startval < obj.endval)
            {
                for (int i = obj.startval; i < obj.endval; i++)
                {
                    Console.WriteLine("Thread ID {0} Value : {1}", Thread.CurrentThread.ManagedThreadId, i.ToString());
                }
                obj.eve.Set();
            }

}
}

    class ThreadParamObj
    {
        public int startval;
        public int endval;
        public ManualResetEvent eve;
    }
}

To overcome this error one solution is make chunk of 64 thread first then wait for that all thread complete then start another 64 chunk.

// Possible Solution by use of 64 Chunks.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading;

namespace WaitHandle_Limitation
{
    class Program
    {
        static void Main(string[] args)
        {
            int noofthread = 100;
            int startindex = 0;
            int endindex = 64;
            try
            {
                int noofchunk = (int)Math.Ceiling(((double)noofthread / 64.00));
                if (noofthread < endindex)
                    endindex = noofthread;
                for (int chunk = 0; chunk < noofchunk; chunk++)
                {
                    List<ManualResetEvent> events = new List<ManualResetEvent>();
                    for (int i = startindex; i < endindex; i++)
                    {
                        Thread th = new Thread(new ParameterizedThreadStart(ThreadRunner));
                        ThreadParamObj obj = new ThreadParamObj();
                        obj.startval = (i * 100);
                        obj.endval = (i * 100) + 10;
                        obj.eve = new ManualResetEvent(false);
                        events.Add(obj.eve);
                        th.Start(obj);
                    }
                    WaitHandle.WaitAll(events.ToArray());
                    startindex += 64;
                    endindex += 64;
                    if (endindex > noofthread)
                    {
                        endindex = noofthread;
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message + ex.StackTrace);
            }
            Console.WriteLine("Completed");
            Console.ReadLine();
        }

        }
    }
    class ThreadParamObj
    {
        public int startval;
        public int endval;
        public ManualResetEvent eve;
    }
}

Let me know if you have any other ideas or comment on this.

Another possible solution at http://dotnetstep.blogspot.com/2009/01/threadpool-wait-for-all-thread-to.html.

Flags Attribute For Enum

2009-01-07T05:34:00.001+05:30

Really a very good functionality provided by “Flags Attribute” for Enum. When Enum mark with “Flags“ attribute it will work as bit field.
Here i am going to explain Enum with and without Flags Attribute.

// Enum Without Flags Attribute.
public enum Simple : int
        {
            UserRead =1,
            UserWrite = 2,
            UserExecute = 4,
            GroupRead = 8,
            GroupWrite = 16,
            GroupExecute = 32
        }

//Enum With Flags Attribute
[Flags()]
public enum WithFlagAttrib : int
        {
            UserRead = 1,
            UserWrite = 2,
            UserExecute = 4,
            GroupRead= 8,
            GroupWrite = 16,
            GroupExecute = 32
        }

In Above code Simple Enum is without attribute and in that i explicitly defined value for each of Enum. (That is just for compare both of them in same scenario).

Now Simple Example Test

int result = (int)(Simple.UserRead | Simple.UserWrite | Simple.GroupRead))
Console.WriteLine(result.ToString()); // output 11

Now value to enum

Console.WriteLine(((Simple)result).ToString()); // output 11. It will not converted to enum as none of the value is associated with 11.
In some scenario when Enum converted to value and stored in database and when it retrieve back from database , we want to convert it to Enum. This is where “Flags Attribute” real usage comes into picture.

Now With Flags Attribute Enum

int result = (int)(WithFlagAttrib.UserRead | WithFlagAttrib.UserWrite | WithFlagAttrib.GroupRead)).ToString();
Console.WriteLine(result.ToString()); // output 11

Now value to Enum

Console.WriteLine(((WithFlagAttrib)result).ToString()); // It will produce output UserRead , UserWrite , GroupRead. This is what we needed.

In both of the case when bitwise operation done at first place it produce same output but when convert value to Enum then Enum with “Flags Attribute” show right result b’coz it use bit as usage.

One thing keep into mind that when Enum create with “Flags Attribute” always assign value power of 2 starting from 1. like 1,2,4,8,16,32,64,128. (Actually it shows which bit is used for particular enum operation and it also limit this type of enum with no criteria it contains).

// For Value (11)
11 (32 bit binary value) : 00000000000000000000000000001011

Bit Position	32	16	8	4	2	1
Enum	GroupExecute	GroupWrite	GroupRead	UserExecute	UserWrite	UserRead
Value	0	0	1	0	1	1

Only used few bits in above table to display value 11. Now you get idea that which ever bit is on it produce in result.

For Example :
int val = 12;
Console.WriteLine(((WithFlagAttrib)val).ToString());
// 12 binary number 00000000000000000000000000001100. So output is GroupRead , UserExecute.

Let me know if you have any question or comment on this.

Note : When you search this thing MSDN please make sure that Enum mark with “Flags Attribute “ start with value 1 not by 0.

Custom GridView Field For SharePoint LookUp Column

2009-01-04T06:50:00.001+05:30

In Sharepoint When retrieve data using web service, there is need for customization during display in GridView. There are two ways to do this.

1. First Way

Use Template Column of GridView. Write Inline coding to Format data.

For Example .

In Codebehind file Write Following Function.

To Fetch data using web service.

public DataTable GetData()
{

DataTable dt = new DataTable();
Lists lst = new Lists();
lst.Url = "/_vti_bin/lists.asmx";'>http://<your site>/_vti_bin/lists.asmx";
lst.Credentials = new System.Net.NetworkCredential("test", "test");
XmlNode result =lst.GetListItems("Orders", String.Empty, null, null, int.MaxValue.ToString(), null, string.Empty);
System.IO.StringReader read = new System.IO.StringReader(result.OuterXml);
DataSet dst = new DataSet();
dst.ReadXml(read);
if (dst.Tables.Count == 2 && Convert.ToInt32(dst.Tables[0].Rows[0]["ItemCount"].ToString()) > 0)
        {
            dt = dst.Tables[1];
        }
        else
        {
            dt.Columns.Add(new DataColumn("ows_CustomerID",typeof(string)));
        }
        return dt;

}

// Enum For Display Mode of LookUpField.

public enum Mode
{
        ID,
        Value,
        All
};

// Function that format data (This Fuction must be Public or Proctected)

protected string GetLookupValue(string value,Mode LookUpDisplayMode)
    {
        string returnVal = String.Empty;
        string[] str;
        try
        {
            switch (LookUpDisplayMode)
            {
                case Mode.All:
                    returnVal = value;
                    break;
                case Mode.ID:
                    str = value.Split(new string[] { ";#" }, StringSplitOptions.None);
                    returnVal = str[0];
                    break;
                case Mode.Value:
                    str = value.Split(new string[] { ";#" }, StringSplitOptions.None);
                    returnVal = str[1];
                    break;
            }
        }
        catch
        {
        }
        return returnVal;
    }

And in ASPX Page.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" >
        <Columns>
            <asp:TemplateField>
                <ItemTemplate>
                  <%# GetLookupValue(Eval("ows_CustomerID").ToString(),Mode.ID) %>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField>
                <ItemTemplate>
                  <%# GetLookupValue(Eval("ows_CustomerID").ToString(),Mode.Value) %>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField>
                <ItemTemplate>
                    <%# GetLookupValue(Eval("ows_CustomerID").ToString(),Mode.All) %>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
</asp:GridView>

2. Other Way

This way is create custom DataBoundField that inherits from BoundField.This is required one time coding as well as avoid inline coding.

Put following class in either App_Code or create class library and use it any application you want.

//LookupField Class

public class LookupField : BoundField
{
public enum Mode { ID, Value, All};

public LookupField()
{ }

        public Mode LookUpDisplayMode
        {
            get;
            set;
        }

        protected override string FormatDataValue(object dataValue, bool encode)
        {
            dataValue = GetLookupValue(dataValue.ToString());
            return base.FormatDataValue(dataValue, encode);
        }

        protected override void InitializeDataCell(DataControlFieldCell cell, DataControlRowState rowState)
        {
            if(rowState == DataControlRowState.Normal || rowState == DataControlRowState.Selected || rowState == DataControlRowState.Alternate)
                base.InitializeDataCell(cell, rowState);
            else
            {
                TextBox txt = new TextBox();
                cell.Controls.Add(txt);
                txt.DataBinding += new EventHandler(OnDataBindField);
            }
        }

        protected override DataControlField CreateField()
        {
            return new LookupField();
        }

        protected override void OnDataBindField(object sender, EventArgs e)
        {
            Control c = sender as Control;
            if(c is TableCell)
                base.OnDataBindField(sender, e);
            else if (c is TextBox)
            {
                string val= GetLookupValue(this.GetValue(c.NamingContainer).ToString());
                ((TextBox)c).Text = val;
            }
        }
        private string GetLookupValue(string value)
        {
            string returnVal = String.Empty;
            string[] str;
            try
            {
                switch (LookUpDisplayMode)
                {
                    case Mode.All:
                        returnVal = value;
                        break;
                    case Mode.ID:
                        str = value.Split(new string[] { ";#" }, StringSplitOptions.None);
                        returnVal = str[0];
                        break;
                    case Mode.Value:
                        str = value.Split(new string[] { ";#" }, StringSplitOptions.None);
                        returnVal = str[1];
                        break;
                }
            }
            catch
            {
            }
            return returnVal;
        }
    }

// ASPX Page.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"
            AutoGenerateEditButton="true" onrowediting="GridView1_RowEditing">
        <Columns>
            <CC:LookupField DataField="ows_CustomerID" LookUpDisplayMode="ID" HeaderText="CustomerID"></CC:LookupField>
            <CC:LookupField DataField="ows_CustomerID" LookUpDisplayMode="Value" HeaderText="CustomerValue"></CC:LookupField>
            <CC:LookupField DataField="ows_CustomerID" LookUpDisplayMode="All" HeaderText="Customer"></CC:LookupField>

</asp:GridView>

In above two way use following code to bind GridView.

//ASPX Page

protected void Page_Load(object sender, EventArgs e)
   {
       if (!Page.IsPostBack)
       {
           GridView1.DataSource = GetData();
           GridView1.DataBind();
       }
   }

Note: Implementation of custom LookupField is not complete. You may required to add or override few more function in order to work with diffrent mode of GridView Row. (Row Selection , Editing etc).

Please give me your comment.

InternalsVisibleTo Attribute Usage

2009-01-03T07:42:00.001+05:30

Before going into detail of InternalsVisibalTo attribute usage i would like to clear two access modifier in C#.

Internal : Access limited to current assembly.

Protected Internal : This means that protected or internal. So access limited to all class of current assembly or in other assembly class derive from this class.

In certain situation that is needed when you write your own set of classlibrary that you have to access internal of other assembly.In that case this attribute is usefull.

InternalsVisibalTo attribute applied at assembly level.

For example you have Two Assembly.

One in Library1 and Another one is Library2.

Library1 Contains Following Code.

public class Library1Class
    {
        protected internal void TestProctectedInternal()
        {
            Console.WriteLine("You are in protected internal method");
        }

        internal void TestInternal()
        {
            Console.WriteLine("You are in internal method");
        }

         public void TestPublic()
        {
            Console.WriteLine("You are in public method");
        }

}

Build Library1. That create library1.dll .

Now In Library2 you want to use Library1. So you add reference of Library1.

Library2 sample Code.

public class Library2Class
    {
        public void TestMethod()
        {
            Library1.Library1Class cls = new InterVisibalsToTest.Class1();

cls.TestPublic(); // it’s ok

cls.TestInternal(); // can’t access due to protection level.

           cls.TestProtectedInternal(); // can’t access due to protection level.
        }
    }

When you compile Library2 you can see two errors in build. (Mark as red in above code).

Now in order to avoid this error and give access to Library2 so it can access Internal and Protected Internal member, you have to use InternalsVisibleTo attribute in Library1 assemblyinfo.cs.

You have to add following line in assemlbyinfo.cs

[assembly: InternalsVisibleTo("Library2")]

After apply this attribute again build library1 and update reference in Library2. Now you have access of both method . TestInternal() and TestProtectedInternal();

Also possible to grant access to more than one assembly. For that you just have to add another line in assemlbyinfo.cs with diffrent assembly name.

For Example :

[assembly: InternalsVisibleTo("Library2")] [assembly: InternalsVisibleTo("Library3")].

Please give your comment on this.

Windows Identity Impersonation

2008-12-30T04:06:00.001+05:30

Sometime in window application it is required that it run in context of user account other than current login account.Few condition that required this is

1) Window Application that authenticate and authorize user by his/her user account.

2) SharePoint sometime required this to gain access of resource that is not granted for SharePoint users.

You can use following code to impersonate particular user.

[System.Runtime.InteropServices.DllImport("advapi32.dll", SetLastError = true)]
public static extern bool LogonUser(
String lpszUsername,
String lpszDomain,
        String lpszPassword,
        int dwLogonType,
        int dwLogonProvider,
        ref IntPtr phToken);
        [System.Runtime.InteropServices.DllImport("kernel32.dll", CharSet = CharSet.Auto)]
        public extern static bool CloseHandle(IntPtr handle);

static void Main(string[] args)
{

            IntPtr usertoken = new IntPtr(0);
            bool b = LogonUser("test", "local", "123", 2, 0, ref usertoken);
            if (b == true)
            {
                System.Security.Principal.WindowsIdentity iden = new System.Security.Principal.WindowsIdentity(usertoken);
                System.Security.Principal.WindowsImpersonationContext con = iden.Impersonate();

// You Code that required impersonation

con.undo()

}

Note : Impersonation can be used in any type of application. (Window Application , Web Application , Class Library).

In Web Application web.config contains specific <identity> attribute for impersonation.

Linq to SharePoint List. (Where , Join )

2008-12-30T03:39:00.001+05:30

This article give you information regarding how to use Liinq with SharePoint List to fetch data from SPList.

For Example there are three SharePoint List . Customers , Orders , OrderDetails. (Please See image below). In Orders list CustomerID is lookup field and in OrderDetails list OrderID is lookup field.

Now Get All Customer From Customer List using Linq.

SPSite site = new SPSite("http://localhost:45833");
SPWeb web = site.OpenWeb();
SPList lstCustomer = web.Lists["Customers"];

var customers = from SPListItem customer in lstCustomer.Items
select customer;

by use of SPListItem (As we use select customer in Linq query)
foreach (SPListItem item in customers)
{
Console.WriteLine(item.ID.ToString() + "-" +item["CustomerName"].ToString());
}

or by using ananymous type

var customers = from SPListItem customer in lstCustomer.Items
select new {ID = customer.ID.ToString(), Name= customer[“CustomerName”].ToString()};
foreach (var item in customers)
{
Console.WriteLine(item.ID + "-" + item.Name);
}

use of where clause with this

var customers = from SPListItem customer in lstCustomer.Items
where customer.ID == 1
select new { ID = customer.ID.ToString(), Name = customer["CustomerName"].ToString() };

Join Three List to get Related Data

SPList lstCustomer = web.Lists["Customers"];
SPList lstorders = web.Lists["Orders"];
SPList lstorderdetails = web.Lists["OrderDetails"];
var customerorders =

from SPListItem customer in lstCustomer.Items
join SPListItem order in lstorders.Items on customer.ID.ToString() equals order["CustomerID"].ToString().Split(new string[]{";#"},StringSplitOptions.None)[0]
join SPListItem orderdetail in lstorderdetails.Items on order.ID.ToString() equals orderdetail["OrderID"].ToString().Split(new string[] { ";#" }, StringSplitOptions.None)[0]
select new {Product = orderdetail["Product"].ToString() , Price = Convert.ToDouble(orderdetail["Price"].ToString()) , Qty = Convert.ToInt32(orderdetail["Qty"].ToString()) , OrderID = order.ID , OrderDate = order["OrderDate"].ToString() , CustomerID = customer.ID.ToString(), CustomerName = customer["CustomerName"].ToString() };

foreach (var item in customerorders)
               {
                   Console.WriteLine(item.Product + " " + item.Price.ToString() + "," + item.Qty.ToString() + ","+ (item.Price * item.Qty).ToString() + ","+ item.OrderID.ToString() + "," + item.OrderDate + "," + item.CustomerName);
               }

Note :In above code, I used split operation on string in order to compare LookUp Field ID Value with ID of parent List. There is also posibility to join more than three tables.

For that you have to use nested this join inside other. Please give your comment or advice on this.

MCTS 70-528 Book update (MCTS Self-Paced Training Kit (Exam 70-528))

2008-12-17T21:48:00.001+05:30

MCTS book update. If you have book called MCTS Self-Paced Training Kit (Exam 70-528): Microsoft .NET Framework 2.0 Web-Based Client Development, then you have to look at following correction.

http://support.microsoft.com/kb/930739

MCTS Self-Paced Training Kit Exam 70-536 Correction and Updates link.

2008-12-15T14:17:00.001+05:30

MCTS 70-536 Self-Paced Training kit contains some wrong information. Microsoft support site provides updates in book and materials associated with book. (Like CD, Practice Test)

Part 1 : http://support.microsoft.com/kb/923018

Part 2 : http://support.microsoft.com/kb/935218

Part 3 : http://support.microsoft.com/kb/949730/

Part 4 : http://support.microsoft.com/kb/949734/

New controls for .NET Framework 3.5 SP1

2008-12-05T07:09:00.001+05:30

This is really a nice thing that Microsoft did in .NET Framework 3.5 SP1, Introduce really cool Chart Controls. This chart controls is for Windows as well as Web Application.

You can download it from Microsoft Site.

Link : Download Chart Control

In related download you can find document and VS 2008 Add-on for this control.

Change The Location Of GAC

2008-10-09T09:43:00.001+05:30

By default whne .NET framework install then it will install global assembly cache to operating system root drive:\windows\assembly.

In order to change its location you need to update following registry.

Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion

Add CacheLocation (REG_SZ) key and set it to new location.

Suppose your new location is c:\bkfrm then CacheLocation c:\bkfrm. Now .NET framework search for assembly directory inside c:\bkfrm.

Use code to backup assembly and give source directory c:\windows\assembly and destination (f you take c:\bkfrm) then c:\bkfrm\assembly. (assembly folder must required in any of case).

Note: It is required to change in registry so it may cause problem.

Global Assembly Cache Directory Structure and Backup

2008-10-09T09:25:00.001+05:30

Whenever .NET framework install on PC. There is one specific directory created called Global Assembly Cache.It contains all assemblies that available to all application on machine.

To open global assembly cache go to run and type assembly or if your sysroot in C drive then go for c:\windows\assembly.

It is a special directory so it look like this. By default it store data in directory structure.Please look at following image.

To Copy global assembly cache you can use following code in C# 2.0.

static void Main(string[] args)
        {
            string assemblyfolderpath = "d:\\windows\\assembly";
            string copypath = "c:\\newtest123";
            Directory.CreateDirectory(copypath);
            DirectoryInfo dir = new DirectoryInfo(assemblyfolderpath);
            ReadDir(dir,copypath);
            Console.ReadLine();
        }

        static void ReadDir(DirectoryInfo dir,string copypath)
        {
            if (dir != null)
            {
              FileInfo[] infos = dir.GetFiles();
              for (int i = 0; i < infos.Length; i++)
              {
                  Console.WriteLine(infos[i].Name);
                  infos[i].CopyTo(copypath + "/" + infos[i].Name);
              }
              DirectoryInfo[] dirs = dir.GetDirectories();
              for (int i = 0; i < dirs.Length; i++)
              {
                  Console.WriteLine(dirs[i].Name);
                  Directory.CreateDirectory(copypath + "/" + dirs[i].Name);
                  ReadDir(dirs[i],copypath +"/"+ dirs[i].Name);
              }
            }
        }

This is the way by which you can create copy of Assembly.

The File Exists. (Exception from HRESULT: 0x80070050)

2008-10-07T23:01:00.001+05:30

This error i got when i removed Active Directory from PC. Actually first i install active directory. Then on next day iremoved it from PC. So it remove all account from my PC. Only administrator are present over there. So none of other program working. Even IIS stop working. I removed iis and then reinstall it . Then configure .net by using aspnet_regiis command. This will create ASPNET user account. Also Reinstallation of IIS create IUSR_ <Machine Name> account.After everything runs ok sharepoint stop working . I removed sharepoint and reinstall it. In Installation of sharepoint i choose same database as previous installation.So it create all sites in IIS. After successfull installtion Central Admin so me error message The File Exists. (Exception from HRESULT: 0x80070050). So for solution i create one user in system with adiminstrators as group and try to login using that user. ( I am not able to login using administrator account).

After this i choose each of application and add new user as a secondary account.

Central Administration > Application Management > Site Collection Owners

Change each of site collection secondary user. This solution works for me.May be cause is different in certain condition.(Possible then restart PC after user setting in all site collection).Cause of problem is related to SID.

Retrieve SharePoint List With Folders and Files ( Tree Structure)

2008-10-05T09:16:00.001+05:30

To retrieve SPList structure wise use SPQuery to retrieve childitems.

There is property called FileSystemObjectType of SPListItem that identifies the current item (Either Folder or File).

SPSite site = new SPSite("http://localhost:43588");
SPWeb web = site.OpenWeb();
SPList list = web.Lists["WebLink List"];
Response.Write("<span style='padding-left:0px'>" + list.RootFolder.Name + "</span>" + "</br>");
GetChildItems(list, list.RootFolder,10);

GetChildItems is a recrusive function.

GetChildItems Function

private void GetChildItems(SPList lst , SPFolder folder,int padding)
   {
       SPQuery query = new SPQuery();
       query.Folder = folder;
       SPListItemCollection col = lst.GetItems(query);
       foreach (SPListItem item in col)
       {
           if (item.FileSystemObjectType == SPFileSystemObjectType.File)
           {
               Response.Write("<span style='padding-left:"+ padding +"px'>"+item["URL"]+"</span>"+ "</br>");
           }
           else if (item.FileSystemObjectType == SPFileSystemObjectType.Folder)
           {
               Response.Write("<span style='padding-left:" + padding + "px'>" + item.Title + "</span>" + "</br>");
               GetChildItems(lst, item.Folder,padding+30);
           }
       }
   }

Event Null Checking In VB.NET Before It Raise

2008-10-04T13:20:00.001+05:30

For Example In C#

class MyClass
    {
        public delegate void MyEventHandler(int i);
        public event MyEventHandler MyEvent;

        public MyClass()
        {
        }

        public void FireEvent()
        {
            if (MyEvent != null)
            {
                MyEvent(10);
            }
        }
    }

In above example we check MyEvent has reference or not by checking if(MyEvent != null) in FireEvent Method. So Event only raise when it has reference.

In VB.NET raiseevent internally check this thing. but if you want to manually check then use following method.

VB.NET Example:

Public Class MyClass1
    Public Event MyEvent(ByVal i As Integer)
    Public Sub New()
    End Sub
    Public Sub FireEvent()
        If MyEventEvent IsNot Nothing Then
            RaiseEvent MyEvent(10)
        End If
    End Sub
End Class

In VB.net that is not necessary to create delegate. You can directly create event. If you want to check that event has reference or not if you have to Add “Event” extra word at the end of Event Name . In above example out event is MyEvent so we did check MyEventEvent is nothing or not. We can not directly check MyEvent is not nothing in VB.NET.

One more thing to know VB.net allow us to create event directly ( Without creating delegate). But implicitly it create delegate that has same name like MyEventEvent. Suppose you declare event Add then AddEvent delegate automatically created. (Please see below image).

Passing reference type ByVal or ByRef.

2008-09-14T06:42:00.000+05:30

In .net framework there is two type set. One is reference type and another one is value type.

This post is about passing reference type by val or byref.

1. Passing ByVal.

Example:
class A
{
int i;
}

class bMain
{
public static void main()
{
A var = new A();
var.i = 10;
Console.WriteLine("Before Pass{0}",var.i);
TestFun(var);
Console.WriteLine("After Pass{0}",var.i);
}
public static void TestFun(A a)
{
a.i = 20;
}
}

output:
Before Passs : 10
After Pass: 20

Here you can see default behavior of reference type. When reference type pass by value then you can change member of that variable. But what happen when you try to reassign variable it self.

Please following code For TestFun

public static void TestFun(A a)
{
a = new A();
a.i = 20;
Console.WriteLine("Inside Fun: {0}",a.i);
}

Output:
Before Pass : 10
Inside Fun: 20
After Pass: 10

Because when reference type pass by value not actual reference is passed. Instead of that copy of reference is passed. When you try to update that parameter inself it will not take affect outside scope of function.

2. Passing By Ref.

class A
{
int i;
}

class bMain
{
public static void main()
{
A var = new A();
var.i = 10;
Console.WriteLine("Before Pass{0}",var.i);
TestFun(var);
Console.WriteLine("After Pass{0}",var.i);
}
public static void TestFun(ref A a)
{
a.i = 20;
}
}

output:
Before Pass : 10
After Pass :20

Now we update reference itself.
public static void TestFun(ref A a)
{
a = new A();
a.i = 20;
Console.WriteLine("Inside Fun {0}",a.i);
}
Output:
Before Pass: 10
Inside Fun: 20
After Pass: 20

Here actual reference is passed. So it will take affect outside function too.

You can get more detail at following location:
http://msdn.microsoft.com/en-us/library/0f66670z(vs.71).aspx#vclrfpassingmethodparameters_referencetypes

Bind Generic List To DataBound Control.

2008-09-09T22:09:00.000+05:30

Suppose you have class called Person that represent person.
(This is specific to ASP.net 3.5 , C# 3.0)

public class Person
{
public Person()
{
this.Name = "";
this.Email = "";
}

public string Name
{
get;
set;
}
public string Email
{
get;
set;
}
}

Generic feature available in .NET Framework 2.0 onwards. So you can use that to create generic list.

Here we create List of Person using following code.

System.Collections.Generic.List lst =
new System.Collections.Generic.List()
{
new Person{Name = "XYZ" , Email = "xyz@xyz.com"},
new Person{Name = "123" , Email = "123@xyz.com"}
};

Bind to GridView.

GridView1.DataSource = lst;
GridView.DataBind();

Bind To ListBox

Listbox1.DataSource = lst;
Listbox1.DataBind();

Binding with gridview works perfect and display Name and Email as column. Same is not happen with ListBox.

ListBox Display item something like

Person
Person But it not display anything.

For that you have to do following thing.

ListBox1.DataSource =lst;
ListBox1.DataTextField = "Name";
ListBox1.DataValueField = "Email";
ListBox1.DataBind();

So It display name and ListBox1.SelectedValue contain appropiate Eamil Id.

Prevent site from IFRAME

2008-09-08T22:19:00.000+05:30

Sometime it is neccessary to prevent site or perticular page opening in IFRAME. To do that use following code in page or site. (Someway every page on site).

<script language="javascript">
if(top != self)
top.location = self.location;
</script>

If some page written above code and still you want to open that page in IFRAME. You need to use following syntax. This is only supported in IE.

<iframe src="write your url that contain above code." width="500" Height="500" security="restricted">

If any one have firefox solution for this please inform me.

JSonSerialization Error Solution

2008-08-15T11:02:00.000+05:30

Sometime when working with ScriptSevice and ScriptMethod in ASP.net webservice following error may occur.

Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property.

Reason for this is JavaScript Serialization setting . This allow maximum 2097152 character by default. It method return string larger then this then it throw above error.

Solution for this is to put following configuration in web.config file.

<connectionStrings>
</connectionStrings>
<system.web.extensions>
<scripting>
<webServices>
<jsonSerialization maxJsonLength="500000"></jsonSerialization>
</webServices>
</scripting>
</system.web.extensions>

In above configuration instead you can set maxJsonLength to certain value so it allow larger string.

Maximum value for that field is 2147483647 as this property is System.Int32.

More information you can find it on following location.
http://msdn.microsoft.com/en-us/library/system.web.script.serialization.javascriptserializer.maxjsonlength.aspx

bool vs bitvector32 in C#

2008-08-13T23:05:00.000+05:30

In application sometime you need more boolean fields.Also that memory usage and performance is main concern.

For example you require 50 boolean fields. If you create 50 boolean variable
like
bool b1,b2,b3....b50;
or
create array of 50 than bool[] b = new bool[50]; then also each bool veriable require 1 byte. so total space usage 50 * 1 = 50bytes.

If you use bitvector32 instead of creating array or 50 variable then it just require 4byte. Each bitvector32 can hold upto 32 different flags.

so for 50 we just need two bitvector32,and space usage reduce to 8 byte instead of 50 byte.

BitArray is also provide functionality like bitvector32 but it is class so it overhead with instance of class, but bitvector32 is simple structure so it reduce that over head too.

Example:

BitVector32 bv = new BitVector32(0); This will assign all bits to 0, as 0 binary representation is 00000000000000000000000000000000.

BitVector32 bv = new BitVector32(-1); This will assign all bits set to 1. As –1 binary representation is 11111111111111111111111111111111. (Two’s complement).

You can choose BitArray over BitVector32 when size of array like 40 , 48. That is not in multiple of 32. ( This is just a suggestion).

More information you can find at following location.
http://msdn.microsoft.com/en-us/library/system.collections.specialized.bitvector32.aspx
http://msdn.microsoft.com/en-us/library/eahchzkf.aspx(C# ref)

Find distinct value from DataSet/DataTable in .NET

2008-08-12T21:07:00.000+05:30

Suppose you have dataset that contain data in following manner

ID Name Country
----------------------------
1 X USA
2 Y INDIA
3 Z INDIA
This is a DataTable name EmpInfo.

Now you want to select distinct country value from above table.

DataTable country = EmpInfo.DefaultView.ToTable(true,"Country");

Now country datatable contain distinct country value from EmpInfo Table.

You get more information from following link.
http://msdn.microsoft.com/en-us/library/wec2b2e6.aspx

Custom SessionID In ASP.net 2.0

2008-07-01T21:16:00.000+05:30

By default asp.net 2.0 create sessionid like this kidt1m55iyqcx2vrtkn3z0ba. But requirement is such that you need to use your own algorithm to generate sessionid. For this pupose you have to create class that inherit from SessionIDManager class and override it CreateSessionID and Validate methods.
For Example : I want to use GUID as sessionid .
public class CustomSessionID : System.Web.SessionState.SessionIDManager
{
public override string CreateSessionID(HttpContext context)
{
return Guid.NewGuid().ToString();
}
public override bool Validate(string id)
{
try
{
Guid idtest = new Guid(id);
if (idtest.ToString() == id)
return true;
}
catch
{
return false;
}
return false;
}
}

You can also use DateTime.Now().Ticks as SessionID, or any custom string as a sessionid.

This is very useful case when you want to functionality like same sessionid generate for sameuser.

You also have to set web.config sessionStat Section in following manner. Here i assume that above class present in App_code directory . but you can create class library and refrence that class in sessionState session.

web.config setting.

<sessionState sessionIDManagerType="CustomSessionID,App_code" >
</sessionState>