SP Murugesa Pandian - My scribbles in C#

2011-12-30T14:37:00.000+05:30

This code for retrieving the First Name and Last Name from the SharePoint 2010 User Profile Service.Here I determine the currently logged in user through SPWeb class's CurrentUser attributesThis code will be useful when you have your own attributes on sharePoint User Profile.Need to specify the internal name of the column.


                SPSite site = SPContext.Current.Site;
                SPWeb web = SPContext.Current.Web;
                SPServiceContext serviceContext = SPServiceContext.GetContext(site);
                UserProfileManager manager = new UserProfileManager(serviceContext);
                UserProfile profile = manager.GetUserProfile(web.CurrentUser.LoginName.ToString());
                ProfileValueCollectionBase baseVal = profile.GetProfileValueCollection("FirstName");
                ProfileValueCollectionBase baseVal = profile.GetProfileValueCollection("LastName");

2011-12-20T09:13:00.002+05:30

Creating SharePoint UI Modal Popup window using JavaScript. Here I have an gridview with data I am extracting the cell value from it and send this into URL as querystring.


 function OpenDialog(URL) {

        

         var NewPopUp = SP.UI.$create_DialogOptions();

         NewPopUp.url = URL;

         NewPopUp.width = 700;

         NewPopUp.height = 350;

         SP.UI.ModalDialog.showModalDialog(NewPopUp);

     }

GridView:


            EnableModelValidation="True" Font-Names="Verdana" Font-Size="Small" 

            ForeColor="#333333" GridLines="None" onrowcommand="GridView1_RowCommand">

            

            

            

            

            

            

            

            

             

                 

                 

                 

              

                 

                 ');">Show Page

On RowCommand method of GridView extracting the first and second value


 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)

        {

            

                int index = Convert.ToInt32(e.CommandArgument.ToString());

                GridViewRow selectedRow = GridView1.Rows[index];

                TableCell  docType = selectedRow.Cells[1];

                TableCell documentName = selectedRow.Cells[2];

                ListItem item = new ListItem();

                item.Text = Server.HtmlDecode(selectedRow.Cells[2].Text);

                

            

            

        }

Reading DataRow into Generic class

2011-12-10T19:05:00.001+05:30

Recently I worked out for an business requirement to split the number of rows as per the value.
Example if a purchase order contains number of quantity as 5.Then my code should create the 5 records on the same purchase order and splitting the quantities as 1.
Here is an XML file:





  
    004
    Samsung Galaxy Tab
    1
      
  
  005
  iPhone
  1
  
  
    006
    Nokia
    2
  

  
    007
    Motorola Razer Tab
    5

Here I read these records into generic class and identifying the each product's quantity.So there will be 9 record generated.Always best practice to read the Data Row in to generic class.


public class ExcelColumns
{
 public ExcelColumns(string PID,string PName,int PQN)
 {
        this.ProductID = PID;
        this.ProductName = PName;
        this.Quantity = PQN;
 }

    private string pId, pName;
    private int quantity;
    public string ProductID
    {
        get { return pId; }
        set { pId = value; }

    }

    public string ProductName
    {
        get { return pName; }
        set { pName = value; }
    
    }

    public int Quantity
    {
        get { return quantity; }
        set { quantity = value; }

    }

}

Reading the each row and applying the logic here


      DataSet ds = new DataSet();

        ds.ReadXml(@"D:\SPProjects\First\Products.xml");
        List list = new System.Collections.Generic.List();
        foreach (DataRow row in ds.Tables[0].Rows)
        {
            if (Convert.ToInt32(row[2]) == 1)
            {
                list.Add(new ExcelColumns(row[0].ToString(), row[1].ToString(), Convert.ToInt32(row[2])));
            }
            else
            {
                int a = Convert.ToInt32(row[2]);

                for (int b = 0; b < a; b++)
                {

                    list.Add(new ExcelColumns(row[0].ToString(), row[1].ToString(), 1));
                }

            }

        }

        GridView1.DataSource = list;
        GridView1.DataBind();

Creating QR code using ASP.NET form

2011-12-07T21:51:00.001+05:30

Creating QR code using ASP.NET form.

string name = TextBox1.Text.ToString() + "\n";
        string age = TextBox2.Text.ToString() + "\n";
        string profession = TextBox3.Text.ToString();
        string s = name + age + profession;
        txt.Text = s;
        System.Net.WebClient client = new System.Net.WebClient();
        byte[] b = client.DownloadData("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=" + txt.Text.ToString());

        Stream stream = new MemoryStream(b);
        System.Drawing.Bitmap bmb = new System.Drawing.Bitmap(stream);
        bmb.Save("C:\\windows\\3.png", ImageFormat.Png);
        stream.Dispose();
        stream.Flush();

Listing all files inside subfolders in SharePoint

2011-10-05T16:38:00.000+05:30

This code will loop all the files inside the all subfolders of Shared Documents library in SharePoint 2010.

public ArrayList getfilesinfoder()
{
ArrayList al1 = new ArrayList();
string[] arr = LoopAllFolder();

SPSite site = SPContext.Current.Site;
for (int i = 0; i < arr.Length; i++)
{
SPFolder cols = site.OpenWeb().GetFolder("site.Url"+/Shared%20Documents/" + arr[i].ToString());
SPFileCollection files = cols.Files;
foreach (SPFile file in files)
{
al1.Add(file.Name.ToString());
}
}
return al1;
}

SPWorkflow Status programmatically

2011-09-30T10:00:00.000+05:30

I have an document folders which associated with multiple workflows,This code snippet find the specific workflow name and its status.
This code has been developed for my requirement,I need to copy the document to another folder as soon as "Workflow completed".
Associated with List Workflow events in event receiver template.

public override void WorkflowCompleted(SPWorkflowEventProperties properties)
{
using (SPSite site = new SPSite(properties.WebUrl))
{
using (SPWeb web = site.OpenWeb())
{
SPList list = properties.ActivationProperties.List;
foreach (SPListItem item in list.Items)
{
foreach (SPWorkflow wf in item.Workflows)
{

if (list.WorkflowAssociations[wf.AssociationId].Name.ToString() == "MultipleTasksFlow")
{

string WFStatus = item[list.WorkflowAssociations[wf.AssociationId].Name].ToString();

}
}

}

}

}

base.WorkflowCompleted(properties);

}

Getting SPWeb ref inside workflow programmatically

2011-09-10T15:53:00.002+05:30

If you want to get SPWeb reference inside the OnTaskChanged_Invoked or Task_MethodInvoking
method

SPWorkflowActivationProperties workflowProperties= new SPWorkflowTaskProperties();
SPWeb web = workflowProperties.Web;

you can get the SPWeb properties of "SPWorkflowActivationProperties" class.
SPContext or HttpContext will not works inside the SharePoint Workflow.

This single line snippet saved my lot of developing hours to trigger the workflow programmatically.

Creating SubFolder in SharePoint 2010

2011-09-08T22:03:00.000+05:30

Creating SubFolder in SharePoint 2010


n1="FolderName";           
SPList list = site.Lists.TryGetList("Shared Documents");
           SPFolderCollection cols = list.RootFolder.SubFolders;
           SPFolder docFolder =
 cols.Add("/Shared Documents/" + n1);

The default term store cannot be identified

2011-08-22T23:19:00.002+05:30

I was trying to activate the Taxonomy on my site which created from the blank site template.When I connecting and add some properties for "Managed Meta data service" from Central application I have got this error.Initially I have no clue.I googled its WCF hotfix for service application.

when creating the "Enterprise Keyword" column,my term store was not able to find the default term store.
"The default term store cannot be identified"
After tried some attempts to create the same column below error was thrown.
Unrecognized attribute 'allowInSecureTransport'

You can download the hotfix from the below link

http://connect.microsoft.com/VisualStudio/Downloads/DownloadDetails.aspx?DownloadID=23806

Enable Enterprise keywords colum in site

2011-08-22T22:00:00.000+05:30

Enabling the "Enterprise Keywords" in sharepoint list or document library.
If you are not seeing this column by default,the reason was you have been selected the blank site to create root site.
There are no way to activate this feature if you selected the blanksite.
You need to activate it through stsadm command

STSADM -o activatefeature -n TaxonomyFieldAdded -url http://myserver
before activating this feature please be make sure you activated the site featured called "SharePoint Server Enterprise Site features"

SPFolder Collection in SharePoint 2010

2011-08-21T08:44:00.000+05:30

This code loop all the folders inside the "Shared Documents" folder.
It will retrieve all the folders inside the Shared documents.I have an requirement to allow the user to upload the documents in to managed folder into Shared Documents and trigger the Workflow.Soon I will post the Workflow code.

public string[] LoopAllFolder()

        {

            string folderName = "";

            SPSite site = SPContext.Current.Site;

            SPFolder cols = site.OpenWeb().Folders[site.Url + "/Shared Documents"];

            if (cols.SubFolders.Count > 0)

                    {

                        //SPFileCollection files = cols.Files;

                        SPFolderCollection folders = cols.SubFolders;

                        foreach (SPFolder Colsfolders in folders)

                        {

                            folderName = folderName + Colsfolders.Name.ToString() + ",";

                        }



                    }

            return folderName.TrimEnd(',').Split(',');

          

                }



                

        }

I bind these folders in dropdownlist by removing the "Forms" folder.

List FolderList = new List(LoopAllFolder());

            FolderList.RemoveAt(0);

            ddlList.DataSource = FolderList;

            ddlList.DataBind();

Looping the people picker values

2011-08-17T08:06:00.000+05:30

Recently I encountered the strange error while retrieving the all user from the
People picker control using SPQuery.
My datatable comes with Site user id and Name.As I wanted to assign these user to a
specific task in workflow.
while using these first user comes without site user id and the remaining were perfect as i expected.
I should admit,I tried many times but could not figure it out for my first user comes along with site id.Finally I made it to work.

Firstly queried the all user from the people picker control with certain condition using CAML.

 private string GetApproverList()

        {

            using (SPWeb web = workflowProperties.Web)

            {

                string appList = "";

                SPList docApproverList = web.Lists["DocApprovers"];

                

                string DocType = workflowProperties.Item["DocumentType"].ToString();               

                SPQuery q = new SPQuery();

                

                //q.Query = q.Query = "" + DocType + "";

                q.Query = "" + DocType + "";

                DataTable dt = docApproverList.GetItems(q).GetDataTable();

                foreach (DataRow row in dt.Rows)

                {

                    appList = appList + row["Approvers"].ToString()+",";

                }

                return appList.TrimEnd(',');

            }

        }

Secondly split this string into array by passing the comma sperator and '#' separator.

 string DocListUser = GetApproverList();

            string[] uids = DocListUser.Split(';', '#');

            for (int a = 0; a < uids.Length; a++)

            {

                if (uids[a].ToString() != "" && !CheckNumber(uids[a].ToString()))

                {

                    uidsList.Add(uids[a]);

                }



            }

Now I have final string array which comes with "",user id and display name.

public bool CheckNumber(string value)

        {



            int number1;

            return int.TryParse(value, out number1);

        }

I used array list to add each items in above string.Then I omit the "" string and numbers in the array.

 foreach (var userList in uidsList)

            {

                SPUser user = SPContext.Current.Web.EnsureUser(userList.ToString());

                assignees.Add(user.LoginName);

            }

How to Find the Holidays in given date range

2011-07-06T11:32:00.000+05:30

I was working with fully date time format around to develop the attendance system.
I need to ignore the Weekend days and other government announced holiday list.
This will used to find the day was a holiday or not in the given date range.

 public DataSet ShowHolidays()
    {

        DataSet ds = new DataSet();
        ds.ReadXml(@"D:\\holiday.xml");
        return ds;
    }

I am maintaining the holiday list xml file


2011/07/04
2011/07/05
2011/07/06

 ArrayList list = new ArrayList();

 public bool IsHolidays(DateTime dt1)
    {
        DataSet d1 = ShowHolidays();
        foreach (DataRow row in d1.Tables[0].Rows)
        {
            list.Add(Convert.ToDateTime(row["Dates_Text"]).ToShortDateString());

        }
        return list.Contains(dt.ToShortDateString());
    }

How to find the WeekEnd days in C#

2011-07-06T11:20:00.000+05:30

This code snippet will used to find out the WeekEnd days in C#.Once you find out then you can write your own business requirement logic to be build.

  public bool isWeekEnd(DateTime dt)
    {
        if (dt.DayOfWeek == DayOfWeek.Saturday || dt.DayOfWeek == DayOfWeek.Sunday)
        { return true; }
        else
        { return false; }

    }

Enumerating different items from Arrays

2011-07-05T14:28:00.002+05:30

This morning I started to working on some thing to compare the two array list or array values and identifying the similarities and differential items.
The below code is equivalent to looping the both arrays and identifying the common and different items in two array values.

In C#.NET 3.5 We have Intersect and Except extension method to get solution for these kind scenarios.

List List1 = new List();
List1.Add("Murugesan");
List1.Add("Geetha");
List1.Add("GuruSelvam");


List List2 = new List();
List2.Add("Murugesan");
List2.Add("Geetha");


List exce = List1.Except(List2).ToList();
foreach (string n in exce)
{
Response.Write(n.ToString());
}
//It will returns the GuruSelvam

export sharepoint site

2011-07-04T18:20:00.001+05:30

Today i learned some more deeply about site collection data backup with all attributes of sites such as versions of contents,security permission level.file compression during export and import of the site using sharepoint 2010 powershell cmdlets.
I am on preparing for the exam 70-667 sharepoint 2010 configure.i always use the beckybertram blog for microsoft exam preparation.

C# SMTP email sending code

2011-07-01T08:37:00.005+05:30

When I tested this code in webapplication its works fine.But my webmail server is HTTPS based and I wanted to integrate this into my SharePoint webpart.

In this case,set EnableSsl true on your smtp object and specify the port number if you are not using the SMTP's default port 25.

Still you got an error use the below code to off the Certificate Validation while relying on HTTP.
If you are an developer and testing it on the PC where you installed "fiddler".Just make sure its Off.
Use the below line just before to Send method.

 System.Net.ServicePointManager.ServerCertificateValidationCallback = delegate(object s, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { return true; };

try
        {
            MailMessage mail = new MailMessage();
            SmtpClient smtp = new SmtpClient("webmail smtp");

            mail.From = new MailAddress("user@webmail.com");
            mail.To.Add("murugesa.pandian@webmail.com");
           
            mail.CC.Add("CC");

            mail.Subject = "Subject";
            mail.Body = "Email contents";


            smtp.Credentials = new System.Net.NetworkCredential("userid", "pwd");
            smtp.EnableSsl = true;

            smtp.Send(mail);
            Response.Write("Sent !");
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message.ToString());
        }

Binding Month days in DropDownList

2011-06-22T12:19:00.002+05:30

public void BindDays()
{
for (int i = 1; i <= 31; i++)
{
ListItem item = new ListItem();
item.Value = i.ToString();
item.Text = i.ToString();
DropDownList1.Items.Add(item);
}
}

My virtual business card

2011-06-22T08:34:00.002+05:30

Learn more about me !
https://www.mcpvirtualbusinesscard.com/VBCServer/passionate/profile

Calculating monthwise leaves in date range in C#.NET

2011-06-20T09:32:00.005+05:30

Recently there was an requirement at my work was finding the leave month wise.
Assume this way,If an employee apply leaves for the duration between 4th Feb,2011 and
4th July 2011.HR team wanted to calculate the month wise leave for that employee against total number of leave days.
By doing this way there is a room to not to calculate the "Week end" and other government announced holidays.

Here is the code for to do so.

class Program
{

static void Main(string[] args)
{
MonthChecker cObj = new MonthChecker();
List listDate = new List();

List strList = new List();

DateTime from = new DateTime(2011, 02, 25);
DateTime to = new DateTime(2011, 04, 14);

DateTime dt2 = new DateTime(2011,02,25);
DateTime to2 = new DateTime(2011, 06, 14);

string n = "";
string n1 = "";

while (from <= to)
{
from = from.AddDays(1);
DateTime d = new DateTime();
d = from.AddDays(-1);
if (cObj.CheckMonthLastDay(d))
{

listDate.Add(d);
}

}

for(int i=0;i
{

if (i == 0)
{
TimeSpan span = listDate[i].Subtract(dt2);
n = n + "\n" + span.Days.ToString();
strList.Add(n);
}

else
{
DateTime ck = new DateTime(listDate[i].Year, listDate[i].Month, 01);
TimeSpan spanck = listDate[i].AddDays(1).Subtract(ck);
string M = spanck.Days.ToString();
strList.Add(M);
}

}

foreach (string str in strList)
{
Console.WriteLine(str);
}
Console.ReadLine();

}
}

Class MonthChecker
{
public DateTime GetLastDayOfMonth(DateTime dtDate)
{

int a = DateTime.DaysInMonth(dtDate.Year, dtDate.Month);
DateTime dt = new DateTime(dtDate.Year, dtDate.Month, a);
return dt;

}
public bool CheckMonthLastDay(DateTime dtDate)
{
DateTime d1 = dtDate;
if (d1 == GetLastDayOfMonth(dtDate))
{
return true;
}
else
{
return false;
}
}

}

Syntax test

2011-06-19T17:19:00.002+05:30

Find Number of Days in specific month

2011-06-17T09:11:00.000+05:30

Recently I encountered the situation to find the number of days in specific month of the given year.In ASP.NET 3.5 comes up with built-in method called "DaysInMonth".This method takes two parameter as Year and Month.
If you want to find out the number of days for "January",then pass the value 1 for Month parameter.

int numberOfDays = DateTime.DaysInMonth(Convert.ToInt32(YearList.SelectedItem.Value), Convert.ToInt32(MonthList.SelectedItem.Value))

retrieve unique rows from sharepoint List

2011-06-17T09:04:00.001+05:30

To retrieve the unique rows from the sharepoint list use the "DefaultView" of the DataTable.

public DataTable GetLeaveAppliers()
        {
 using (SPSite site = new SPSite(SPContext.Current.Site.Url))
            {
                using (SPWeb web = site.OpenWeb())
                {
                    SPList list = web.Lists["Leave Plan"];
                    SPQuery q = new SPQuery();
                    string query = "";
                    q.Query=query;
                    DataTable dt = list.GetItems(q).GetDataTable();
                    DataTable row= dt.DefaultView.ToTable(true, "Author");


                    return row;


                }

            }
}

ListItem Client OM

2011-06-06T18:00:00.001+05:30

Listing all items in sharepoint list usingClient Object Model in SharePoint 2010(Client OM)

ClientContext cntx=new ClientContext("Site URL");
Web web = cntx.Current.Web;
List list=web.Lists.GetByTitle("List Name");
CamlQuery query=new CamlQuery();
query.ViewXML="";
ListItemCollection cols=list.GetItems(q);
cntx.Load(cols);
foreach(var item in cols)
{
list1.Items.Add(item["Title"]);
}
cntx.ExecuteQuery();

SharePoint 2010 Delegate Control

2011-06-03T22:04:00.003+05:30

SharePoint 2010 Delegate Control

This control delegates asp.net control to render inside its template.
In your home page of the sharepoint site you can see the "MySite,Search Input box with lens icon and "Global Navigation".
These controls are called "Delegate Controls".You can create new asp.net web controls or user control and put
them inside the delegate template.Your customised user control will be render as per your sequence specified in
"Element.xml" of the sharepoint project solution.
If you want host multiple user controls in "Delegate template" then set the property of the Control "AllowMultipleControls" to true.
This will allow the delegate control consider as "Child control" as per the sequence.
The Lower sequence will always replace the highest sequence in rendering mode.
If you create the user control refer the controlSrc[usually it will be the virtual directory of ControlTemplate(_controltemplates) ]properties of "Control" in Element.xml
My Element.xml belows like.

on my UserControl's on Click of the Button events I just simply placed an javascript alert.

this.Page.ClientScript.RegisterClientScriptBlock(Page.GetType(),"Greetings", "Type your script");

You can set scope on your "Feature File"

How to generate live data for chat webpart in sharepoint 2010

2011-05-31T08:41:00.000+05:30

How to generate the live data for "Chart WebPart in SharePoint 2010" using SharePoint List.
Visit
http://www.codeproject.com/KB/TipsnTricks/LiveData_ChartWebPart.aspx

updating sharepoint list programmatically

2011-05-24T18:29:00.002+05:30

updating sharepoint list programmatically
Recently I encountered the new requirement which wanted to create "Import SharePoint List"
There were more than 700 rows to be updated on a column value had null.

try
            {
                SPSite site = SPContext.Current.Site;
                SPWeb web = site.OpenWeb("http://mosstemp:5000");
                SPList list = web.Lists["Prospects"];

                SPQuery query = new SPQuery();
                query.Query = "";
                SPListItemCollection items = list.GetItems(query);

                foreach (SPListItem item in items)
                {

                    item["Status"] = "Not Called";
                    item.Update();

                }
               
                control = new LiteralControl();
                control.Text = "Updated";
            }
            catch (Exception ex)
            {
                control.Text = ex.InnerException.Message.ToString();
            }

You can't update the "look up" column in the sharepoint list.

Retrieve List Item using SharePoint Client Object

2011-05-17T13:53:00.001+05:30

This code retrieve the sharepoint list item using SharePoint Client Object Model

ClientContext context = new ClientContext("http://WIN-ASNOSC246SV");
var web = context.Web;
context.Load(web);

List list = web.Lists.GetByTitle("Friends");
context.Load(list);

CamlQuery query = new CamlQuery();
query.ViewXml = "";
ListItemCollection cols = list.GetItems(query);
context.Load(cols);

ListItem item = cols.GetById(1);
context.Load(item);

context.ExecuteQuery();
Response.Write(item["Name"].ToString());

Feel Good about myself

2011-05-11T11:50:00.000+05:30

This is my first attempt to take MS 70-667 SharePoint configuration and Maintenance exam on "MeasureUp.com".When I test my knowledge on these topic on trial test engine page on my attempt,I have passed with 80%.I am really feel good about myself.:)-

SharePoint Claim based Identity

2011-05-09T13:09:00.000+05:30

Assume you have an SharePoint web application which build on "Claim based Authentication"

When user requested the page or Sharepoint documents using web browser,SharePoint will check the user has been authorised or not.
If it is not authorised,It will send back to user with requested URL,in turn user's request will be redirected to "Identity Provider".It can be Active Directory or "ASP.NET Membership Provider".
Once your credentials are validated by "Identity Providers" you will be given a token to which will allow your request to be authenticated by SharePoint.

Listing all Folder in SharePoint 2010

2011-05-06T12:18:00.001+05:30

To list all the "Folders" in a site or web in SharePoint 2010

SPSite site = SPContext.Current.Site;
            SPFolderCollection cols =  site.OpenWeb().Folders;
            foreach (SPFolder folder in cols)
            {
                ListBox1.Items.Add(folder.Name.ToString());
            }

WCF error in SharePoint 2010

2011-05-05T12:36:00.000+05:30

I was about to consume the SharePoint 2010 List WCF service on my web application using jSon.
When I tried this link http://serverName:8056/_vti_bin/ListData.svc
on my sharepoint environment,I got this error saying "Could not load type "System.Data.Services.Providers.IDataServiceUpdateProvider".

To resolve this issue
Apply : the batch update
http://support.microsoft.com/kb/976127

Downloading the SharePoint Document

2011-05-04T17:45:00.002+05:30

Recently,a strange scenario in SharePoint 2010 development I faced.
I created a Visual WebPart with sandbox solution based to let user download the files from the SharePoint Document Library.
Labour the lines of code to get reference of the SPFile from the current web context.
Reading and Writing the file contents into streams to let user to download the file as soon as they clicked it on the "Download" link.It will prompts the "File Download Dialog box".
I deployed it on the sharepoint development environment it just works fine.
Later,I came to know that webpart is not allowing the end user to download.
Again I checked the same webpart performance and put optimised looping and disposing the objects verily stated manner.
Its works fine as I expected.But When I deployed it on SharePoint Server,I faced the same problem when user accessing the page.
When end user clicks the link "Download",Browser redirect to "Forbidden page".

Finally I have concluded the user is only "Reader" permission group.

Simply added RunWithElevatedPrivileges
Its works fine for all user group permission.

protected void Button1_Click(object sender, EventArgs e)
{
SPSecurity.RunWithElevatedPrivileges(delegate()
{
FileAction();
});
}

protected void FileAction()
{
SPWeb site = SPControl.GetContextWeb(Context);
SPFile spFile = site.GetFile(site.Url + "/DocLibrary/" + "1.txt");
// Above line for clarity purpose hard coded.You can read the file name from the //library.My requirement there was only one file.
FileStream fs = new FileStream("C:\\Windows\\Temp\\tempContents.txt", FileMode.Create);
BinaryWriter bw = new BinaryWriter(fs);
bw.Write(spFile.OpenBinary());
bw.Close();
fs.Close();

using (FileStream sm = File.Open("C:\\Windows\\Temp\\tempContents.txt", FileMode.Open))
 {
using (StreamReader sr = new StreamReader(sm))
{
Response.AppendHeader("Content-Disposition", "attachment; filename =" + spFile.Name);
Response.ContentType = "text/plain";
using (StreamWriter sw = new StreamWriter(Response.OutputStream))
{
sw.Write(sr.ReadToEnd());
}
}
sm.Close();
Response.Flush();
Response.Close();
}
}

decimal control in double value

2011-04-20T03:29:00.000+05:30

There were situation double values are to be controlled only to 3 decimal or 2 decimal.
This one line code does the exact function.

        double d = 42.566454648;
        double d1 = 23.545548125;
        double d2 = d + d1;
        Response.Write(d2.ToString("N3"));

two column filtering - AND CAML

2011-04-11T18:15:00.002+05:30

Filtering the rows on two column condition on CAML query





India




Chennai

MVC2 Template Helpers

2011-02-24T08:54:00.001+05:30

Templated Helpers

In ASP.NET MVC 2.0 newly added feature is Templated Helpers.This allows you to create display screens and
editable screens.
It strongly supports the refactoring,intellisense and compile time checking.


<%= Html.DisplayFor(m => m.Name) %>

Alternatively you can try the
Html.EditorFor()

<%= Html.LabelFor(m =>m.Name) %>

SharePoint 2010 Developer Dashboard

2011-02-18T11:19:00.003+05:30

This will allows the developer to detect the critical modules, web parts and queries in the hosted SharePoint applications.
It lets the developer to analyses the each request and response’s time and each method’s responding time.
So the developer can easily locate the errors and resolve them.

To Activate this feature through stsadm tool

Stsadm -o setproperty -pn developer-dashboard -pv on

after these command you will get "Operation Successful" message.

To Deactivate
Stsadm -o setproperty -pn developer-dashboard -pv off

C# - New line constant

2011-01-27T22:59:00.001+05:30

String AccountName = "DomainNAme\\" + TextBox1.Text.ToString() + "." + TextBox2.Text.ToString();

SPListItem updating programmatically

2011-01-17T23:02:00.000+05:30

After multiple attempts of opening the site using SPSite class,I could not make it happen.But searching of these topics i learned many tips and idea to resolve my task.
My requirement was having on webpart there I must create the Form to be filled by end user.These will be inserted into SharePoint List.
In Visual webpart I used the below code

 SPSite site = SPContext.Current.Site;
               SPWeb web = site.OpenWeb();
                SPList myList = web.Lists["List OF Employee"];
                SPListItem Item = myList.Items.Add();
                Item["Title"] = TextBox1.Text;
                Item["Name"] = TextBox2.Text;
                Item.Update();

Linq to class objects

2010-12-22T16:50:00.002+05:30

This example shows how to use the array of class object and its variables on run time using "LINQ".

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
public class LinqClass
{
    public string Name;
    public string contact;
    public string city;

}

using System.Xml;
using System.Xml.Linq;
using System.Linq;
using System.Data;

var sp = new[] {
          new LinqClass { Name="Murugesan",
                          contact="9769104815",
                          city="Chennai"
                        },
                        new LinqClass { Name="Pandian",
                                        city="Madurai",
                                        contact="9786466642"
                                      }
          };
        foreach (var n in sp)
        { 
            Response.Write(n.Name.ToString());
        }

C# Writing XML strings on runtime

2010-12-09T18:30:00.001+05:30

This is an example for creating the XML string from the dynamic data.

StringWriter sw = new StringWriter();
XmlTextWriter txtWriter = new XmlTextWriter(sw);
txtWriter.Formatting = Formatting.Indented;
//txtWriter.WriteStartDocument();
txtWriter.WriteStartElement("Employee");
DataSet myDataSet = new DataSet();
myDataSet.ReadXml("C:\\ContactXML\\Contacts.xml");
foreach (DataRow row in myDataSet.Tables[0].Rows)
{
txtWriter.WriteElementString("Name", row[0].ToString());

}
txtWriter.WriteEndElement();

//txtWriter.WriteEndDocument();
sw.Close();
string s1 = sw.ToString().TrimStart('{');
string s2 = s1.TrimEnd('}');

SharePoint-Active Directory Synchronize

2010-12-06T16:11:00.002+05:30

Last week,I prepared the small SharePoint utility to retrieving the Active Directory users and synchronize with SharePoint List.

public string LDAPUsers()
        {
            string listD = "";
            string strResult = "";
            string strRes = "";
            DirectoryEntry entry = new DirectoryEntry("LDAP://domainName", "userid", "pAsSwrd");
            DirectorySearcher mySearcher = new DirectorySearcher(entry);
            mySearcher.Filter = "((objectCategory=Person))";

            foreach (SearchResult resEnt in mySearcher.FindAll())
            {
                listD = listD + resEnt.GetDirectoryEntry().Name + ",";


            }
            string[] test = listD.Split('=');
            for (int i = 0; i < test.Length; i++)
            {
                strResult = strResult + test[i].ToString();
            }

            string[] test1 = strResult.Split(',');
            for (int j = 0; j < test1.Length; j++)
            {
                strRes = strRes + test1[j] + ",";
            }
            return strRes.Replace("CN", ""); ;
        }

Below code pushing the string array values in to SharePoint List.

SPSite site = new SPSite("http://moss:4100");
        SPWeb web = site.OpenWeb();
        SPList list = web.Lists["LDAP User"];
        string[] names = LDAPUsers().Split(',');
        for (int j = 0; j < names.Length; j++)
        {
            SPListItem item = list.Items.Add();
            web.AllowUnsafeUpdates = true;
            item["Title"] = names[j].ToString();
            web.AllowUnsafeUpdates = true;
            item.Update();
            web.AllowUnsafeUpdates = false;
        }

SPQuery Value retreiving

2010-11-21T22:49:00.000+05:30

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

            SPQuery spQuery = new SPQuery();
            spQuery.Query = "" +
                "Senthil";
            SPListItemCollection ListItems = item.GetItems(spQuery);

            foreach (SPListItem items in ListItems)
            {
                Response.Write((items["Name"].ToString()) +
                    "
");
            }
        }

UserProfileManager - Webservice in Sharepoint

2010-11-08T09:03:00.001+05:30

Listing all domain users in Sharepoint 2007 using UserProfileManager webservice class.
First create the proxy class using wsdl or add webreference from Visual Studio.
The main difference in using webservice method is any user can access the resources within default network credentials.
But Sharepoint object model lets you use only with in production server with administrative privileges.


 localhost.UserProfileService service = new localhost.UserProfileService();
        service.Credentials = System.Net.CredentialCache.DefaultCredentials;
        int a = (int)service.GetUserProfileCount();
        for (int i = 0; i < a; i++)
        {
            Response.Write(service.GetUserProfileByIndex(i).UserProfile[1].Values[0].Value);
        }

Sharepoint 2007 migration to Sharepoint 2010

2010-10-15T17:00:00.005+05:30

SharePoint 2007 upgrade to SharePoint 2010

Method:

Attach/detach the Content database

Checklist

Check the SQL Server version and SQL Instance build number on the SharePoint 2007 farm.

Check the what instance has been used to storing the content database to point SharePoint 2007 site whether SharePoint 2007’s built in instance or external SQL Server instance.

If external SQL Instance have been used you must have the same SQL Server version and build number on targeting server same apply for built in SQL Instance. Otherwise version conflict will occur on migration time.

Scan thoroughly all the Solutions and Features those are installed on SharePoint 2007 and map with the sites those using the solutions.

Install these features and solutions on targeting machine before attaching the content database on SharePoint 2010 machine.

Step – I

Starting the detach operation on SharePoint 2007 machine.

Step –II

If there is active connection on the database, check the Drop check box.

Now the database will goes away from the tree view.

Go to physical location of your database. Caution on taking the copy of the detached file if there is more than one SQL Server instances are on your machine.

C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEX2K8\MSSQL\DATA

Copy the files named WSS_Content_10K.mdf and WSS_Content_10.ldf and place it on SharePoint 2010 machine to attach later to SQL Server.
Usually SQL SERVER 2008 or SQL SERVER 2008R2 on SHAREPOINT 2010.

Step- III

Attaching the detached database which we have got from SharePoint 2007 machine to SharePoint 2010

Once you attached the database go to stsadm command prompt on your SharePoint 2010 server.

Step-IV

Create new webapplication on SharePoint 2010 as follows:

By default SharePoint 2010 will use the SharePoint instance of the SQL Server.So let it is as it is.

After you created the site without errors,

Go to Central Administration – Application Management ->Select the Content Database.

Choose the newly created web application from the drop down menu.

It will shows the database name with some scrambled id prefix with “WSS_Content”.

Remove the content database as it shows.

Now you have only site skeleton without “Content Database”.

Add the content database using the STSADM tool or mount the database using SharePoint Power Shell

If you add the content database for the first time to your newly created website,

You will see the progress of database attaching to your new server.

I encountered the serious problem when I am migrating the site which had “U2UCAMLQUERYBUILDER” list items.

I downloaded the “C2UCA MLQUERYBUILDER” from the product site and tried to install it on SharePoint 2010 machine by clicking the “.EXE” file from the “Setup” Folder.
It gives the error says that “I must have installed Windows SharePoint Services 3.0”.

I overcome this issue by picking the “U2Ucamlquerybuilder.wsp” file and adding the solution on “Server Farm features of SharePoint 2010”.

First add the solution to SharePoint 2010 Farm

Deploy the solution with gacdeployment parameter

subsites in sharepoint

2010-09-23T00:53:00.001+05:30

this code snippet retrieving all sub sites from the root site in Share point Server 2007


SPSite site = new SPSite("http://win-j40e6cmrcl9/personal/administrator/");
        string[] subsites = site.AllWebs.Names;
        for (int i = 0; i < subsites.Length; i++)
        {
           SPWeb web = site.AllWebs[i];
           Response.Write(web.Name.ToString());
         
        }

Site deleting in sharepoint server

2010-09-21T19:26:00.004+05:30

Deleting the site from the share point server can be done via STSADM.EXE and through the central administration.

switch command prompt

C:\Program Files\Common Files\microsoft shared\Web Server Extensions\12\BIN\STSADM -o deletesite -url http://localhost/sites/Murugesan

Through Central Administration,

Click on Application Management and Delete Site collection,choose the site name under the web application.

Site backup in Moss 2007

2010-09-15T22:56:00.003+05:30

Site backup in moss 2007 is not an rocket science anymore.
Download the tool Smigrate.exe from the Microsoft site.
extract under the Bin folder of the 12 hive.

pass the command
sMigrate.exe -w http://localhost/sites/Murugesan -f Murugesan1.fwp -u administrator -pw your password

Yes ! look at the command window for the status of the given command.

Listing all webpages from moss site

2010-09-10T13:14:00.002+05:30

Listing the all the webpages from the site in MOSS 2007/sharepoint service
I used to itereate the file names using the Sharepoint Object Model's SPListItems


        SPSite mySite = new SPSite("http://localhost/MurugesanSite/");
         SPWeb myWeb = mySite.OpenWeb();
         SPList NoOfPages= myWeb.Lists[2];
         foreach(SPListItem items in NoOfPages.Items)
         {
             Response.Write(items.File.ToString());
         }
           
        }

Calling usercontrol in sharepoint webparts

2010-09-06T23:10:00.005+05:30

Create the usual User Control in asp.net and calling into Share point is simple process that reduces the complexity of deploying and developing the web part.
Place the 2 text boxes and label to create simple add two number calculator in your
On click of the button result will be displayed on label.


protected void Button1_Click(object sender, EventArgs e)
    {
        int a = Convert.ToInt32(TextBox1.Text);
        int b = Convert.ToInt32(TextBox2.Text);
        Label3.Text = (a + b).ToString();
    }

Before using the user control check it on .aspx file by registering the user control in directives.


<%@ Register Src="~/Calculator.ascx" TagName="_userCntrl" TagPrefix="SP" %>

once you tested the user control on .aspx file,now you are ready to place the
user control design page calculator.ascx and source code file calculator.ascx.cs in to share point folder structure

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS

Now go to visual studio,select the Webpart template,


public class UserControlCalculator : System.Web.UI.WebControls.WebParts.WebPart
    {
        Control _cntrl;
        string ErrorDesc;
        public UserControlCalculator()
        {
            this.ExportMode = WebPartExportMode.All;
        }

        protected override void CreateChildControls()
        {
            base.CreateChildControls();
            try
            {
                _cntrl =Page.LoadControl("\\_layouts\\Calculator.ascx");
                this.Controls.Add(_cntrl);

            }
            catch (Exception ex)
            {
                ErrorDesc = ex.Message.ToString();
            }

        }
        protected override void Render(HtmlTextWriter writer)
        {
            try
            {
                _cntrl.RenderControl(writer);
            }
            catch (Exception ex)

            {
                writer.Write(ex.Message.ToString());
            }
        }


    }

Sharepoint BDC

2010-08-29T22:52:00.009+05:30

BDC [Business Data Catalog] is a service which part of MOSS 2007.
Its an middle man between external datasources and Sharepoint service.
It manages how the data should be passed between outside datasources are like
SQL Server and WebService using Metadata to Sharepoint service.
Example "DUET" its an collaboration software between SAP and Microsoft Office.
From SAP,Sibel or any other RDBMS data source can be used to supply the information to
SharePoint portal.
For this BDC uses the metadata to describe the APIs of business application.
This metadata model abstracts the underlying physical sources an provides a consistent and simple model of business applications to Sharepoint Service.

Runtime Object Model allows you to create,read,update and delete metadata objects in the Shared Services database.

Eventhandlers in MOSS 2007

2010-08-25T13:19:00.003+05:30

Creating or adding extra customised features to the sharepoint components like
SharepointItems,List and WebEventReceivers is called "Features in Sharepoint/moss 2007".
usually developer create the customised action by deriving the event handler class of the sharepoints ie.SPItemEventReceiver,SPListEventReceiver and SPWebEventReceiver and attach to the sharepoint site.

Administrator installing the features and activate them on the site or web.

Synchronous Event:
Events that activate before the action occur
Example : FieldAdding event of SPListEventReceiver

Asynchronous Event
Events that activate before the action occur
Example : FiledAdded event of SPListEventReceiver

Sharepoint Object model

2010-07-21T20:27:00.002+05:30

Sharepoint Object model

To programmatically deal with your Sharepoint services or officer server you need to
add the references Microsoft.Office.Server or Microsoft.Sharepoint to your
project.
You can find this references under
C:\Program Files\Common Files\microsoft shared\Web Server Extensions\12\ISAPI

These are my oftenly used classes.Here I categorised these classes

Document Library
SPDocumentLibrary
SPPictureLibrary

Features [ EventHandling in sharepoint you can find these in Feature.XML as attributes]
SPFeature
SPFeatureScope
SPFeatureProperty
SPElementDefinition

Site Level
SPSite
SPSiteCollection
SPWeb
SPSiteAdministration

List Level
SPList
SPListCollection
SPListItem

Solution Level
SPSolution
SPSolutionCollection
SPFeatureReceiver

Meeting

SPMeeting
MtgUtility

User Profile related [ Imports the namespace Microsoft.Office.Server.UserProfiles ]
UserProfiles
UserProfilesManager [ In moss 2007 installed farm,Its obsolete]

selecting records between two dates

2010-05-11T08:04:00.000+05:30

ALTER procedure [dbo].[uspLeaveDetails](@User varchar(15),@FromDate datetime,@ToDate datetime)
AS
BEGIN

Select FromDate,ToDate,
NoOfDays,FirstName from UserDetails,LeaveDetails
where FromDate > =@FromDate AND ToDate <=@ToDate AND
UserDetails.USerID=@User
End

Sharepoint Website Collection.

2010-03-30T15:24:00.005+05:30

Listing all the websites from the share point site and its owner.


SPSite site = new SPSite("http://localhost");
SPWeb web=site.AllWebs;
foreach(SPWeb web in collection)
        {
            DropDownList1.Items.Add(web.Author.ToString());
        }


Listing all lists in the website
SPSite site = new SPSite("http://localhost/SiteDirectory/IT"); //IT-site name
        SPWeb web = site.OpenWeb();
        SPList list = web.Lists["Posts"]; // a List in the site
        foreach(SPListItem col in list.Items)
        {
            DropDownList2.Items.Add(col.Title.ToString()); // Item in the List
        }

SPWebCollection

2010-03-30T13:07:00.004+05:30

SPWebCollection lets you to enumerate the Websites in the Share point server.



SPSite site = new SPSite("http://win-zmmypcbnz7k/");


        SPWebCollection collection = site.AllWebs;
        foreach (SPWeb web in collection)
        {
            Response.Write(web.Author.ToString());
        }

Webservice String array value in C #

2010-03-15T12:28:00.003+05:30

When we works with Webservice,we can't use the .NET data types like DataSet or DataTable,ArrayList as return value.
So we need to convert these into unified data type such as string or string array.

public string[] RecordAll()
{
SqlConnection con = new SqlConnection("Server=Your server\\SQLExpress;Database=SPTest; Trusted_Connection=Yes");
con.Open();
DataSet ds = new DataSet();
ArrayList al = new ArrayList();
SqlCommand cmd = new SqlCommand("Select * from Registers",con);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ds, "Registers");
foreach (DataRow row in ds.Tables[0].Rows)
{
al.Add(row[0]);
al.Add(row[1]);
}
string[] stringArray = (string[])al.ToArray(typeof(string));
return stringArray;

}

Querying the XML file using LINQ

2010-03-13T11:20:00.002+05:30

In this example i tried to find the available balance by passing the account number as parameter to the function through Linq


  
        XDocument doc = XDocument.Load("C:\\Account.xml");
        var result = from ds in doc.Descendants("Account")
                     where ds.Element("IDNumber").Value == account.ToString()
                     select new
                     {
                         Balance = ds.Element("AvailableBalance").Value,
                         AccountID = ds.Element("IDNumber").Value

                     };
        return result.ToArray();

My accounts XML will be

How sharepoint functioning

2010-03-12T12:53:00.003+05:30

Its my scribble for understanding clearly what i learned from googling.

When you install the WSS 3.0 or Microsoft Office Sharepoint server 2007,WSS configures the IIS server to forward all requests regardless of file[such as HTML,ASPX or other web supported files]and content types[ such as .doc,.docx,.xls,ppt or.pdf or video streaming files] using the "Virtual Path Provider component".

In traditional web application ASP.NET framework process the file system[.aspx] alone.But in WSS or MOSS handles this in different way using Virtual Path Provider.
All site details and file name will be stored in MS-SQL Database or Windows Internal Database.WSS or MOSS fetch these details from the SQL Database.
We can deal with the database using SPContentDatabase object from the Microsoft.Sharepoint namespace to manipulate.

When you create the site in WSS 3.0,all site details,file name,contents such as webparts and context [Admin or user] will be stored in SQL Database.When accessing this site WSS serves from the SQL DB.

UserControl events in ASP.NET

2010-03-09T14:11:00.000+05:30

Usercontrol's events
AbortTransaction:
It occurs when user ends transaction
CommitTransaction:
It occurs when user completes transaction
DataBinding:
It occurs when usercontrol binds to DataSource
Disposed:
When user control(Server controls) releases the memory.This is last stage of server control's life cycle.
Init:
It occurs when usercontrol initializes.This is the first step of server control's life cycle.
Load:
this event occurs where server control load into Page Object
PreRender:
occurs after the controls loaded but prior to rendering.
UnLoad:
Occurs where server controls unloaded from the memory

CacheManager in enterprise library 4.1

2010-02-09T19:27:00.004+05:30

I worked around how to get familiar with Microsoft's Enterprise Library 4.1 Cache Manager.
GetCacheManager method of CacheFactory will retrieve the data from the Cached pool of data.



        CacheManager cm = CacheFactory.GetCacheManager("Cache Manager");
        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("Students.xml"));
        cm.Add("CachedDataSet", ds.Tables[0]);
        DataTable dt = (DataTable)cm.GetData("CachedDataSet");
        foreach (DataRow row in dt.Rows)
        {
            Response.Write(row[0].ToString());
        }

Place the following line between or use the Enterprise Library 4.1 GUI to generate config setting for your web.config file.

Following code goes between tag

LINQ - Simple examples

2009-12-10T06:33:00.001+05:30



LINQ where - operation

int[]array ={1,2,3,4,5,6,7,8};

var between5 = from N in array where N < 5 select N;

foreach(var elements in between5)
{
Response.write(elements);
}

// Transforming the array into ToList

ToList - LINQ

string[] name ={"Senthil","Murugesan","Karthick"};
var Name = from SP in name order by K select K

var namelist=Name.ToList()
foreach(var item in namelist)
{
Response.write(item); 
}



// Loading XML document in LINQ

var record = from e in XElement.Load(Server.Mappath("students.xml").Element("Name") select e.Element("Name");
foreach(students in record)
{
Response.write(students);
}

webservice consuming through jQuery - parameter

2009-12-10T00:55:00.003+05:30

I have a web service which will check the user name and password against database.I used to send 2 parameters one is user id and password.If both are matched then status will be comes

$.ajax({
type: "POST",
url: "LoginService.asmx/AuthenticateMethod",
data: "{'UserName': '" + $("#TextBox1").val() +"', 'Password': '" + $("#TextBox2").val() + "'}",
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function(msg)
{
$("#status").html(msg.d);
}
});

GridView with ModalPopupextender in C#

2009-12-09T23:24:00.002+05:30


    

    
    
    
    

    
    
    
        
                            onrowdatabound="GridView1_RowDataBound">

Code behind to send selected index as parameter to webservice to retrieve record
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
LinkButton lk = (LinkButton)e.Row.FindControl("lnk");

lk.Attributes.Add("onclick", "ShowMyModalPopup('"+s+"')");
}
}

Self Code testing - FxCop 1.36

2009-12-07T15:03:00.004+05:30

I wanted to test my codes are written correctly what Microsoft's defined.So I prepared a class library for Banking Transaction.Before testing this my BankTransaction.dll

Simply I test my codes against Design Rules,Naming Rules,Interoperability Rules,Performance and Portability Rules.

My codes were


using System;
using System.Collections.Generic;
using System.Text;

namespace SP.MyBankTransaction
{
    
    public class BankTransactionClass
    {
        private string account_holder_name;
        private string account_number;
        private double deposit_amount;
        private double withdraw_amount;
        private double balance_amount;
        public string AccountHolderName
        {
            get { return account_holder_name; }
            set {  account_holder_name = valu; }
        }
        public string AccountNumber
        {
            get { return account_number; }
            set {  account_number=value; }
        }
        public double WithdrawAmount
        {
            get { return withdraw_amount; }
            set {  withdraw_amount = value; }
        }
        public double DepositAmount
        {
            get { return deposit_amount; }
            set { deposit_amount =value; }
        }

        public double BalanceAmount
        {
            get { return balance_amount; }
            set {  balance_amount=value; }
        }
        public double DepositTrasaction(string FromAccount, double AmountToBeDeposited)
        {
            FromAccount = AccountNumber;
            AmountToBeDeposited = DepositAmount;
            return BalanceAmount + AmountToBeDeposited;
            
        }
    }
    
}

Resolution were

Correct the spelling of 'Trasaction' in member name 'BankTransactionClass.DepositTrasaction(string, double)' or remove it entirely if it represents any sort of Hungarian notation.

in line 43,Method name has been misspelled,I changed.Notice the "Transaction".
in line 42,Parameters were Pascal-cased word,I changed to camel cased.
in line 16,Compound Word "AccountHolderName" changed as "Accountholder.

My corrected Code is


using System;
using System.Collections.Generic;
using System.Text;

namespace SP.MyBankTransaction
{
    
    public class BankTransactionClass
    {
        private string account_holder_name="";
        private string account_number="";
        private double deposit_amount=0.0;
        private double withdraw_amount=0.0;
        private double balance_amount=0.0;

        public string Accountholder
        {
            get { return account_holder_name; }
            set { value = account_holder_name; }
        }
        public string AccountNumber
        {
            get { return account_number; }
            set { value = account_number; }
        }
        public double WithdrawAmount
        {
            get { return withdraw_amount; }
            set { value = withdraw_amount; }
        }
        public double DepositAmount
        {
            get { return deposit_amount; }
            set { value = deposit_amount; }
        }

        public double BalanceAmount
        {
            get { return balance_amount; }
            set { value = balance_amount; }
        }
        public double DepositTransaction(string fromAccount, double amountToBeDeposited)
        {
            fromAccount = AccountNumber;
            amountToBeDeposited = DepositAmount;
            return BalanceAmount + amountToBeDeposited;
            
        }
    }
    
}

Gridview row deleting in C#

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

Steps to delete a row in Grid view programmatic which bind with real time database table.
1,In Grid view server control must be set to false of AutoGenerateColumns
2,Make Columns tag to list the user defined column header on the asp.net page.
just like the following

  
           DataKeyNames="ProductID" SelectedIndex="1" 
        onselectedindexchanged="GridView1_SelectedIndexChanged" 
        onrowcommand="GridView1_RowCommand" AutoGenerateColumns="false">

3,Set to DataKeyNames value to Table's primary key like

  
         DataKeyNames="ProductID" SelectedIndex="1" 
       onselectedindexchanged="GridView1_SelectedIndexChanged" 
        onrowcommand="GridView1_RowCommand" AutoGenerateColumns="false">

An event named "onrowcommand" triggered on the Grid view deletion of the selected row must be deleted from the table.

Here I used the filter CommandName and commandArgument to check whether the deletion link button which attached the GridView clicked.


 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Remove")
        {
            int index = Convert.ToInt32(e.CommandArgument);
            GridViewRow row = GridView1.Rows[index];
         
            Database db = DatabaseFactory.CreateDatabase("DatabaseConnectionString");
            DbCommand cmd = db.GetSqlStringCommand("DELETE from Products where ProductID='" + row.Cells[1].Text.ToString() + "'");
            db.ExecuteNonQuery(cmd);
            GridView1.DataSource = ShowProductDetail();
            GridView1.DataBind();
        
            }

        }

I used Microsoft Enterprise Library 4.1 in my example to deal with database and its related operation.Its based on SQLExpress database.

script test

2009-11-26T19:55:00.001+05:30

Convert DataSet into ArrayList in C#

2009-11-15T20:39:00.001+05:30

Converting the DataSet into ArrayList is not an big deal anymore.
If you are sure about the number of columns in the DataTable,create the same class members in the Class.

Let assume I have an DataSet contains of the table named "Product" which has three columns called ProductID and Stock.

First step to convert the DataSet into ArrayList is,creating the Class name ProductClass

Database db = DatabaseFactory.CreateDatabase("DatabaseConnectionString");
DbCommand cmd = db.GetSqlStringCommand("Select * from Products");
DataSet ds = db.ExecuteDataSet(cmd);
List proList = new List();

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Products p = new Products();
p.ProductName = ds.Tables[0].Rows[i]["ProductName"].ToString();
p.ProductID = ds.Tables[0].Rows[i]["ProductID"].ToString();
proList.Add(p);

}

Product.cs

public class Products
{
private string _productName;

private string _productid;

public string ProductName
{
get { return _productName; }
set { _productName = value; }

}

public string ProductID
{
get { return _productid; }
set { _productid = value; }

}

}

GridView1.DataSource = proList.ToArray();
GridView1.DataBind();

LINQ to SQL Classes tutorial

2009-11-11T19:52:00.006+05:30

Step 1:

Add Linq to Sql classes to your application,and make sure you selected the .NET 3.5 as target framework.

Step : 2

Add Server database to solution explorer.After adding Database diagram toggle to find the tables on selected database.

Step :3

Linq to SQL template name will becomes the parent class and retrieve the data from the table as below.

Snippet:

DataClasses2DataContext db2 = new DataClasses2DataContext();
var c = from sp in db.Peoples
select sp;
List li = c.ToList();
GridView1.DataSource = li.ToArray();
GridView1.DataBind();

Basic LINQ in C#

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

Encrypting-Decrypting the password in C#

2009-11-01T11:07:00.003+05:30

Encrypting the password in .NET become ease,DESCryptoServiceProvider enables the developer to encrypt the plain text in to encrypted form.

Code snippet as below :

public static byte[] Encrypt(string txtPassword, SymmetricAlgorithm key)
{
MemoryStream mStream = new MemoryStream();
CryptoStream cStream = new CryptoStream(mStream, key.CreateEncryptor(), CryptoStreamMode.Write);
StreamWriter sw = new StreamWriter(cStream);
sw.WriteLine(txtPassword);
sw.Close();
cStream.Close();
byte[] buffer = mStream.ToArray();
mStream.Close();
return buffer;
}

Decrypting the encrypted bytes:

public static string Decrypt(byte[] CryptedBytes, SymmetricAlgorithm key)
{
MemoryStream mStream = new MemoryStream(CryptedBytes);
CryptoStream cStream = new CryptoStream(mStream, key.CreateDecryptor(), CryptoStreamMode.Read);
StreamReader sr = new StreamReader(cStream);
string PlainTxt = sr.ReadLine();
sr.Close();
cStream.Close();
mStream.Close();
return PlainTxt;
}

In Database,I used to save these bytes in Password column.While retrieving/Checking the Password,I used the Decrypt the function.So Password column will have encrypted text that easily human can't read or memorize.

For using this code you need to import System.Security.Cryptography class into your application.

Listing server files

2009-09-24T09:03:00.001+05:30

This code snippet for listing all the files under specific folder.
string[] list = Directory.GetFiles(Server.MapPath("~/Images"));
for (int i = 0; i < files.Length; i++){
list [i] = Path.GetFileName(list [i]);
GridView1.DataSource = list;
GridView1.DataBind(); }

Returning multiple refcursor in Oracle through enterprise library 4.1

2009-08-22T09:25:00.002+05:30

I found this simple code snippet for how to retrieve multiple RefCursor values in Oracle through Enterprise Library 4.1

object[] parameters = new object[3];
DataSet ds = new DataSet();
Database db = DatabaseFactory.CreateDatabase();
DBCommandWrapper cw = db.GetStoredProcCommandWrapper("mypackage.mypackagename", parameters);
db.LoadDataSet(cw, ds, new string[] {"RefCur1", "RefCur2", "RefCur3"});

Exception handling in Enterpirse Library 4.1

2009-08-20T23:51:00.003+05:30

After goggling lot very patiently,I find something all irrelevant to my task.
Finally i corrected by watching carefully on my system thrown exceptions.

Add this below line between ConfigSection of tag.

section name="exceptionHandling" type="Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Configuration.ExceptionHandlingSettings, Microsoft.Practices.EnterpriseLibrary.ExceptionHandling" /

Paste this line somewhere but between configuration tag
exceptionHandling
exceptionPolicies
add name="Global Policy"
exceptionTypes
add name="Exception"
type="System.Exception,
mscorlib, Version=2.0.0.0,
Culture=neutral,
PublicKeyToken=b77a5c561934e089"
postHandlingAction="None"

/add
/exceptionTypes
/add
/exceptionPolicies
/exceptionHandling

My source code for catching the exception is

try
{
int a = 0;
int b = 1;
int result = b / a;
Response.Write(result.ToString());

}
catch (System.Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "Global Policy");
Response.Write(rethrow.ToString());

}

Output is "False".So I am strongly believe exceptions were caught by enterprise library : )-

Record retreiving C# using OracleProcedure

2009-08-17T21:24:00.002+05:30

Oracle Proc:

create or replace procedure returnAllRecords(cur_allrec out t_cursor)
is
begin
open cur_allrec for SELECT * from Students;
end returnAllRecords

on Button click event write this below code:

OracleConnection Conn = new OracleConnection("Data Source=ORCL; User ID=scott; Password=tiger")
OracleCommand Cmd = new OracleCommand();
Cmd.Connection = Conn;
Cmd.CommandText = "returnAllRecords";
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.Add("cur_allrec", OracleType.Cursor).Direction = ParameterDirection.Output;
try

{

Conn.Open();

OracleDataReader Reader = Cmd.ExecuteReader();

}

catch (Exception ex)

{

Response.Write(ex.ToString();

}

Conn.Close();

Operation Contract's properties

2009-08-12T08:25:00.001+05:30

OperationContract Properties
Action
The Action property specifies the action that uniquely identifies this operation. WCF dispatches request messages to methods based on their action.
AsyncPattern
The AsyncPattern property indicates that the operation is implemented or can be called asynchronously using a Begin/End method pair.
HasProtectionLevel
The HasProtectionLevel property indicates whether the ProtectionLevel property has been explicitly set.
IsOneWay
The IsOneWay property indicates that the operation only consists of a single input message. The operation has no associated output message.
IsInitiating
The IsInitiating property specifies whether this operation can be the initial operation in a session.
IsTerminating
The IsTerminating property specifies whether WCF attempts to terminate the current session after the operation completes.
ProtectionLevel
The ProtectionLevel property specifies the message-level security that an operation requires at run time.
ReplyAction
The ReplyAction property specifies the action of the reply message for the operation.

Opening popup window in ASP.NET

2009-08-04T10:10:00.002+05:30

Opening popup window in ASP.NET is quite simple,but you need to very concern about concatenation on javascript and as well as ASP.NET concatenation.

I spent more time on this silly issue,atlast i rectified.
Here i attach my querystring and its value from the selected dropdown list control.

string result = DropDownList1.SelectedValue.ToString();
string script = "";
Page.RegisterStartupScript("myScript", script);

Working with access database in C#

2009-08-04T08:43:00.005+05:30

using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.OleDb;

public partial class _Default : System.Web.UI.Page
{
OleDbConnection Con = null;
OleDbCommand cmd = null;
OleDbDataReader reader;
protected void Page_Load(object sender, EventArgs e)
{

}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " + Server.MapPath("iTrack.mdb"));
Con.Open();
string t_date = txtDate.Text;
string t_location = txtLocation.Text;
string t_descrip = txtNotes.Text;
string t_time = txtTime.Text;
cmd = new OleDbCommand("INSERT INTO bills (Transaction_date,Location,Transaction_Description,TTime)values('" + t_date + "','" + t_location + "','" + t_descrip + "','" + t_time + "')", Con);

cmd.ExecuteNonQuery();

Response.Write("Added");
cmd.Dispose();
Con.Close();
cmd = null;
Con = null;

}

protected void btnRetrieve_Click1(object sender, EventArgs e)
{
try
{
Con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " + Server.MapPath("iTrack.mdb"));
Con.Open();
cmd = new OleDbCommand("SELECT * from Bills where Awb='"+DropDownList1.SelectedValue.ToString()+"'", Con);
reader = cmd.ExecuteReader();
while (reader.Read())
{
txtDate.Text = reader["Transaction_date"].ToString();
txtLocation.Text = reader["Location"].ToString();
txtNotes.Text = reader["Transaction_Description"].ToString();
txtTime.Text = reader["TTime"].ToString();
plDetails.Visible = true;
}
}
catch (Exception exception)
{
Response.Write("Exception Message " + exception.Message.ToString());
}

finally
{
cmd.Dispose();
cmd = null;
Con.Close();
Con = null;
}

}
}

How to install PHP on IIS 5.1

2009-07-04T20:40:00.005+05:30

I found the extracting the PHP source files into PHP folder in windows XP over PHP installer [Executing .exe file for the ISAPI extension].

Steps to install PHP 5.2.1 in IIS 5.1

Create the folder in C:\PHP.

Extract the compressed format "php-5.2.10-Win32" on the newly created folder.

give the permission for the folder C:\PHP by right click on the folder like you see here..
and do not forget to share the websharing option for the folder.select Share this folder option.

Now the major property setting is how the IIS is going to process the PHP script.
We can achieve this by setting ISAPI Filter as follows.

Now home directory setting for the PHP processes by IIS,Just see next to ISAPI Filter tab.

After completing this process,reset the IIS server by typing "iisreset" in command prompt.

type the script as follows to check IIS process the php scripting.

phpinfo();
?>

save this under C:\Inetpub\wwwroot as First.php

type the http://localhost/First.php

My setting works fine and got output as like this..

Converting DataSet to array list

2009-06-20T15:37:00.002+05:30

public string[] ProductList()
{

ArrayList al = new ArrayList();
string s = "";

Database db = DatabaseFactory.CreateDatabase();
DbCommand cmd = db.GetSqlStringCommand("SELECT ProductName from Products");
DataSet ds = db.ExecuteDataSet(cmd);

foreach (DataRow dRow in ds.Tables[0].Rows)
{

al.Add(dRow);
}

foreach (Object row in al)
{
s = s + ((DataRow)row)["ProductName"].ToString() + ",";

}
string rawString = s.TrimEnd(',').ToString();
string[] result = rawString.Split(',');
return result;

}
then you can bind this array to Gridview
Gridview1.DataSource=ProductList();
Gridview1.Bind();

MSMQ - Architecture

2009-06-16T12:06:00.002+05:30

This will be the simplest understanding diagram of what MSMQ architecture is
********************************************************
Sending Application[Physical]
|
|
|
V
MSMQ [Layer built in topof SQL Server]
|
|
|
V
Receiving Application [Physical]

**********************************************

Sending Application
|
|
|------>Writes Message [Transaction - 1]
|
|
|
|------> Put written message into Queue [Transaction-2]

Sending application prepares a message and puts into Queue.
A Message can be any type of information that receiving application understand.
Receiving Application
Receives the messages and process them.
Notes:
Receiving application and Sending application were not tightly coupled,they can work
without help of other application support

How it was possible ?
Because of built-in layers between connected computers[clients].
Two types of Messages are there,one is Private Message and secondly we have Public
message
Private message :These messages only on locally on particular machine and are not
published on publically.
Public message: These messages will reside on active directory.So applications
running on different servers throughout the network can find the public queues
through active directory.

Exception handling in WCF

2009-06-15T16:06:00.003+05:30

This is an simple example for how to manage exception in WCF and their client.
WCF returns system exception and application exception during development time.
But hosting time,these kind of exception will not handled by SOAP protocol.
So SOAP friendly exception details must be implemented on service side using FaultContractAttribute.
Generate the custome exception message must be implemented on a class that start preceding with DataContractAttribute.

WCF Source for Exception handling

[ServiceContract]
public interface IService
{
[OperationContract]
[FaultContractAttribute(typeof(FaultContractExceptionTest))]
string GetData(int value);

}
[DataContractAttribute]
public class FaultContractExceptionTest
{
private string Msg;
public FaultContractExceptionTest(string msg)
{
this.Msg = msg;
}
[DataMember]
public string ErrorMessage
{
get { return this.Msg; }
set { this.Msg = value; }
}
}
________________________________________________________________________

Service Implementation Source
_________________________________________________________________________
public class Service : IService
{
public string GetData(int value)
{

if (value == 152)
{
return "Your authentication code is " + value.ToString();
}
else
{
throw new FaultException(new FaultContractExceptionTest("Check your Pass Number"),"Some Problem");
}}}

Client Implementation - Source code - I written on Button click event
ServiceClient sc = new ServiceClient();
try
{

Response.Write(sc.GetData(Convert.ToInt32(TextBox1.Text)));

}

catch (FaultException msgObj)
{
Response.Write(msgObj.Detail.ErrorMessage);
}

Base64Binary-webservice consuming through PHP

2009-04-20T08:06:00.001+05:30

This is an example for how to consume the asp.net webservice method which will return the bytes of array as datatype.

How it will be consumed in PHP client is slightly different one.The returned xsd schema data type will be not as byte as we had in ASP.NET service rather encoded base64 string.

So we need to decode the base64 string as plain text.After we can write back to stream or screen.

ASP.NET webservice code for Base64Binary type
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.IO;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{
public Service ()
{

}

[WebMethod]
public byte[] ShowFileContent()
{

FileStream fs = File.OpenRead(Server.MapPath("Resume.doc"));
byte[] b = new byte[fs.Length];
fs.Read(b, 0, b.Length);
return b;
}

}

PHP Client:
using nusoap webservice class.really its very handy.so my code length shrink about to 4 or 5 lines.

require_once('lib/nusoap.php');
$client = new soapclient('http://localhost/website2/Service.asmx?WSDL','wsdl');
$result = $client->call(ShowFileContent);
$r=array($result['ShowFileContentResult']);
print_r(base64_decode($r[0]),$handle);

//here you can write into file also.

?>

asp.net webservice SoapHeader Authentication

2009-04-14T23:07:00.004+05:30

After long time,this is my second attempt to authenticate the webservice using SoapHeader.My System Architect team asked me to work aroud on this issue.Its works atlast :)-

SoapAuthenticateService.cs
*******************************
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(Name = "TestService", ConformsTo = WsiProfiles.BasicProfile1_1)]

public class SoapAuthenticateService : System.Web.Services.WebService
{

public UserAuthorise name;
public SoapAuthenticateService()
{

}

[WebMethod]
[SoapDocumentMethod(Binding = "TestService")]
[SoapHeader("name")]
public string GetString()
{
if (checkUser())
{
return "Authenticated Successfully";
}
else
{
return " You are not authorised yet !";
}

}

public bool checkUser()
{
if (name.userName == "Murugesan" && name.password == "12345")
{
return true;
}
else
{
return false;
}

}

}
________________________________________________________________________________

UserAuthorise.cs
**************************

public class UserAuthorise : System.Web.Services.Protocols.SoapHeader
{

public string userName;
public string password;

}
__________________________________________________________________________________

Service.asmx
***********************

<%@ WebService Language="C#" CodeBehind="~/App_Code/SoapAuthenticateService.cs" Class="SoapAuthenticateService" %>

Consumer Application code :

SoapAuthenticateService ap = new SoapAuthenticateService();
UserAuthorise u = new UserAuthorise();
u.userName = "Murugesan";
u.password = "12345";
ap.UserAuthoriseValue = u;

Response.Write(ap.GetString());

instead of hard coded user name and password,you can use the DB or XML as datasource.

Consuming ASP.NET webservice through PHP

2009-04-14T07:51:00.003+05:30

I am trying to get least familiar with PHP code.I tried this simple asp.net webservice which is going to be consumed through PHP.

My asp.net code snippet
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{
public Service () {

//Uncomment the following line if using designed components
//InitializeComponent();
}

[WebMethod]
public string HelloWorld(string name) {
return "Hello " + name;

}

}
_________________________________________________________________________

PHP
_________________________________________________________________________

require_once('lib/nusoap.php');
$objClient = new soapclient("http://localhost/website1/Service.asmx?WSDL");
$result = $objClient->call("HelloWorld", array('name' => 'Murugesan'));
echo $result;
?>

After i tried neckling fight with PHP code,I did not get my code works as I expected.
I keep my fingers cross over where I am doing wrong.

WCFService Library Simple Application

2008-12-20T20:04:00.004+05:30

Microsoft.NET framework 3.0 had new features called WCFServiceLibrary template through this you can create the dll for your service.Mostly this will be best option of making business logic for WCF Services.

In this post,I am going to explain how to create the WCFService Libray,how to utilise them in WCFService and then consuming the services.

Step 1

Select the template name "WCFServiceLibrary" and choose the .NET framwork 3.0 as above.

Step 2

Here I just created the function name GetDataLength.This will returns the number of characters in the passing string.
Before I removed the by default text from the source file.

Step 3

An implementation of the function GetDataLength will be

Step 4

After completion of compile,you can see the dll file on your project stored location.
This will be the source for your WCF service.

Step 5

Now open second visual studio 2008 window,and choose the classing WCF Service,here you are going to use the just created WCFServiceLibrary as source.

Step 6

In your WCFService application use AddReference to include the WCFServiceLibrary's dll as below

Step 7

In your code behind,I created the WCFService method name GetDataFromLibrary,this will takes the string as parameter,and then its length will be processed by the WCFServiceLibrary and sent back to your WCFService.

Step -8
Code Implementation for the above method.

Step 9
After this run the application to create the .svc file for generating proxy class for your consumer application.

Step 10

Create the proxy class using svcutil.exe

Step 11
Add the proxy class into your website application in order to consume the WCFService that use the WCFServiceLibrary dll.And place the text box and button for checking the user input's length.

Step 12

You must copy have the endpoint details in your web.config file.Check the output.xml on your generated proxy class location.Pick the servicemodel tag and upto endof servicemodel tag as belows

On your Button click event,Just follow the same code snippet for getting the result from the WCFService.

The result I have got,

Merging the array values

2008-12-05T02:14:00.001+05:30

Before writing the actual code I tested this arrays to calculate has to be done on one array and another will be as it is.

double[] Pre = new double[3];
Pre[0] = 1;
Pre[1] = 2;
Pre[2] = 3;
double[] Pre1 = new double[3];
Pre1[0] = 4;
Pre1[1] = 5;
Pre1[2] = 6;
string n1 = "";
string n2 = "";

for (int i = 0; i < Pre.Length; i++)
{
n1 = n1 + "-" + Pre[i].ToString() + ",";

}
for (int a = 0; a < Pre1.Length; a++)
{
n2 = n2 + Pre1[a].ToString() + ",";
}

string result = n1 + n2.TrimEnd(',');

Response.Write(result.ToString());

Loding multiple tables in DataSet

2008-12-03T21:35:00.001+05:30

How to load multiple tables in DataSet programmatically ?

DataSet ds= new DataSet();
string strConn="Server=(local);dataBase=Northwind;user id=sa;password=;";
SqlConnection cn = new SqlConnection(strConn);
string strSQL="select * from Customers;select * from employees";
cn.Open();
SqlDataAdapter da = new SqlDataAdapter( strSQL,cn);
ds.Tables.Add("Customers");
ds.Tables.Add("Employees");
ds.EnforceConstraints =false;
ds.Tables["Customers"].BeginLoadData();
da.Fill(ds.Tables["Customers"]);
ds.Tables["Customers"].EndLoadData();
ds.Tables["Employees"].BeginLoadData();
da.Fill(ds.Tables["Employees"]);
ds.Tables["Employees"].EndLoadData();
dataGrid1.DataSource=ds.Tables["Customers"];
dataGrid2.DataSource=ds.Tables["Employees"];
cn.Close();

Webservice -Basic Authentication

2008-10-21T23:48:00.003+05:30

Securing Webservice using IIS - Basic authentication
Once you create a webservice solution using VSS 2008 0r 2009 you MUST host them in IIS server.Please do not use or expect the VSS's built in IIS emulator will take care of authentication for your webservice.

In IIS control panel,choose your webservice directory and set to Basic Authentication checkbox ON.Decheck the Ananoymous authenticate check box.
Supply your computer's user name and password on IIS control for basic authentication.Now you have done 20 percent of secure web service hosting.

Now you need to piece of code in your client application,my code snippet is like

Service s = new Service();
ICredentials cred = new NetworkCredential("murugesa", "pandian", "pp");
s.Credentials = cred;
s.PreAuthenticate = true;
string s1 = s.HelloWorld();
Response.Write(s1);

If you are consuming the webservices from your vendor,please ask them to give their domain name,user name and password which allocated to you.

You can use them on your consume application like above how I used .

Server will check your authentication if fails,it will shows the HTTP 401 status page.

XML Attributes and value reading

2008-09-22T08:33:00.001+05:30

System.IO.StreamReader stream = new System.IO.StreamReader(@"D:\MyText.xml");
XmlTextReader reader = null;
reader = new XmlTextReader(stream);
while (reader.Read())
{
switch (reader.NodeType)
{
case XmlNodeType.Element: // The node is an Element.
Response.Write( reader.Name);

while (reader.MoveToNextAttribute()) // Read attributes.
Response.Write(" " + reader.Name + "='" + reader.Value + "'");

break;
case XmlNodeType.Text: //Display the text in each element.
Response.Write(reader.Value);
break;
case XmlNodeType.EndElement: //Display end of element.
Response.Write(" Response.Write(">");
break;
}
}

Difference between two dates

2008-09-17T20:35:00.002+05:30

This codesnippet for finding the differences between two given dates.
You can calculate for the months and years also by using this.

DateTime dt1 = Convert.ToDateTime(TextBox1.Text.ToString());
int t1 = dt1.Day;

DateTime dt2 = Convert.ToDateTime(TextBox2.Text.ToString());
int t2 = dt2.Day;

DateTime r1 = new System.DateTime(dt2.Year, dt2.Month, dt2.Day, 12, 0, 0);

DateTime r2 = new System.DateTime(dt1.Year, dt1.Month, dt1.Day, 12, 0, 0);
System.TimeSpan result = r1 - r2;
Response.Write(result.Days);

Writing XML dynamically

2008-07-31T22:12:00.002+05:30

string xmlFile = Server.MapPath("UserControl.xml");
System.Xml.XmlTextWriter writer = new System.Xml.XmlTextWriter(xmlFile, null);
writer.WriteStartDocument();
writer.Formatting = Formatting.Indented;
writer.WriteStartElement("InputValue");

for (int i = 0; i < 3; i++)
{

writer.WriteAttributeString(i.ToString(),i.ToString());
//writer.WriteElementString(i.ToString(), i.ToString());
}
writer.WriteEndElement();
writer.Close();

Range value setting in C#

2008-07-28T12:19:00.000+05:30

string Source = TextBox2.Text;
string oops1,oops2;
int a1, a2;
string[] First = Source.Split('-');
for (int i = 1; i < First.Length; i++)
{
oops1 = First[0];
oops2 = First[1];
a1 = Convert.ToInt32(oops1);
a2 = Convert.ToInt32(oops2);
for (int ii = a1; ii <= a2; ii++)
{
DropDownList1.Items.Add(ii.ToString());
}

}

Extracting string through comma separator in C#

2008-07-27T17:22:00.001+05:30

Separating the given string into commas and adding them to dropdownlist.

string Months = TextBox1.Text;
string[] ind = Months.Split(new char[]{','});
foreach(string m in ind)
{

DropDownList1.Items.Add(m.ToString());

}

How to Querying XML raw data

2008-07-27T00:11:00.001+05:30

This code snippet for loading XML file in to Dataset and then querying particular record as we practising on SQL-Query.

DataSet ds = new DataSet();
XmlDocument xDoc = new XmlDocument();
xDoc.LoadXml(File.ReadAllText(@"E://Form.xml"));
ds.ReadXml(new XmlNodeReader(xDoc));
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["ID"].Equals(TextBox1.Text))
{
Response.Write(dr["txtControlName"].ToString() + "\t");
Response.Write(dr["lblControlName"].ToString());

}

}

DataSet as ArrayList in C#

2008-07-23T00:38:00.001+05:30

protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=(local);Database=Test;user id=sa;pwd=####");
con.Open();
SqlDataAdapter sq = new SqlDataAdapter("SELECT *From Employee", con);
DataSet ds = new DataSet();
sq.Fill(ds, "Employee");
ArrayList arrList = new ArrayList();

foreach (DataRow dr in ds.Tables[0].Rows)
{

arrList.Add(dr["Name"]);
GridView1.DataSource = arrList;
GridView1.DataBind();

string[] strArray = arrList.ToArray(typeof(string)) as string[];

}

sq.Dispose();
con.Close();
Response.Write("Done!");

}
}

Dynamically showing the TextBox in C#

2008-07-22T12:39:00.001+05:30

Its a manual TextBox showing accordingly the requirements.

string[] s1 ={ "TextBox4", "TextBox3","TextBox1" };

TextBox[] _TxtLoop = new TextBox[2];
for (int i = 0;i<_TxtLoop.Length; i++)
{
for(int ii=0;ii {

string t1 =s1[ii].ToString();
TextBox txt=(TextBox)FindControl(t1);
txt.Visible=true;

}

}

dynamically adding TextBox

2008-07-21T23:18:00.001+05:30

SqlConnection con = new SqlConnection("Data Source=(local);Database=Test;user id=sa;pwd=***");
con.Open();
SqlDataAdapter sq = new SqlDataAdapter("SELECT *From Employee", con);
DataSet ds = new DataSet();
sq.Fill(ds, "Employee");

foreach (DataRow dr in ds.Tables[0].Rows)
{
string test = "Murugesan";

TextBox txt = (TextBox)this.FindControl(test);

txt.Visible = true;

}

sq.Dispose();
con.Close();

}

switch-vb.net

2008-07-15T07:58:00.000+05:30

Sub Main()
Dim keyIn As Integer
WriteLine("Enter a number between 1 and 4")
keyIn = Val(ReadLine())

Select Case keyIn
Case 1
WriteLine("You entered 1")
Case 2
WriteLine("You entered 2")
Case 3
WriteLine("You entered 3")
Case 4
WriteLine("You entered 4")
End Select

End Sub

Reflection-C#

2008-07-02T09:34:00.002+05:30

This part is copied from Gopalan Suresh Raj's article for my reference purpose.

C# Reflection and Dynamic Method Invocation
Gopalan Suresh Raj

The Reflection API allows a C# program to inspect and manipulate itself. It can be used to effectively find all the types in an assembly and/or dynamically invoke methods in an assembly. It can at times even be used to emit Intermediate Language code on the fly so that the generated code can be executed directly.

Reflection is also used to obtain information about a class and its members. Reflection can be used to manipulate other objects on the .NET platform.

The Reflection API uses the System.Reflection namespace, with the Type class to identify the Type of the Class being reflected, and fields of a struct or enum represented by the FieldInfo class, Members of the reflected class represented by the MemberInfo class, Methods of a reflected class represented by the MethodInfo class, and parameters to Methods represented by the ParameterInfo class.

The Activator class's CreateInstance() method is used to dynamically invoke instances on the fly. Dynamic Invocation is very useful in providing a very late-binding architecture, where one component's runtime can be integrated with other component runtimes.

Obtaining All Classes and Their Type Information from an Assembly
using System;
using System.Reflection;

/**
* Develop a class that can Reflect all the Types available in an Assembly
*/
class ReflectTypes {

public static void Main (string[] args) {

// List all the types in the assembly that is passed in as a parameter
Assembly assembly = Assembly.LoadFrom (args[0]);

// Get all Types available in the assembly in an array
Type[] typeArray = assembly.GetTypes ();

Console.WriteLine ("The Different Types of Classes Available in {0} are:", args[0]);
Console.WriteLine ("_____");
// Walk through each Type and list their Information
foreach (Type type in typeArray) {
// Print the Class Name
Console.WriteLine ("Type Name : {0}", type.FullName);
// Print the name space
Console.WriteLine ("Type Namespace : {0}", type.Namespace);
// Print the Base Class Name
Console.WriteLine ("Type Base Class : {0}", (type.BaseType != null)?type.BaseType.FullName:"No Base Class Found...");
Console.WriteLine ("_____");
}
}
}