Surendra Sharma

Surendra Sharma

Search This Blog

Tuesday, July 27, 2010

Add or Remove items from windows Combobox

public class ComboBoxItem


    private string display;

    private object data;

    public ComboBoxItem(string display, object data)


      this.display = display; = data;


    public override string ToString()


      return display;



void Form1_Load(object sender, EventArgs e)


    comboBox1.Items.Add(new ComboBoxItem("a", 1));

    comboBox1.Items.Add(new ComboBoxItem("b", 2));

    comboBox1.Items.Add(new ComboBoxItem("c", 3));

    comboBox1.Items.Add(new ComboBoxItem("d", 4));


private void button1_Click(object sender, EventArgs e)




Exporting Grid view or data Grid to Excel ,Formatting cells with style sheet mso-number-format

When you export the gridview to Excel it looses it format. It means that maybe your gridview has string field which consisted of numbers say '002675'. But when you export the grid and see it in excel file you will find that the number changed to '2675'.

You can solve this issue using ‘mso-number-format’

e.Row.Cells[i].Attributes["style"] = "mso-number-format:\\#\\,\\#\\#0\\.00_\\)\\;\\[Black\\]\\\\(\\#\\,\\#\\#0\\.00\\\\)";
mso-number-format:"0" No Decimals
mso-number-format:"0\.00" 2 Decimals
mso-number-format:"mm\/dd\/yy" Date format
mso-number-format:"m\/d\/yy\ h\:mm\ AM\/PM" D -T AMPM
mso-number-format:"Short Date" 05/06/-2008
mso-number-format:"Medium Date" 05-jan-2008
mso-number-format:"Short Time" 8:67
mso-number-format:"Medium Time" 8:67 am
mso-number-format:"Long Time" 8:67:25:00
mso-number-format:"Percent" Percent - two decimals
mso-number-format:"0\.E+00" Scientific Notation
mso-number-format:"\@" Text
mso-number-format:"\#\ ???\/???" Fractions - up to 3 digits (312/943)
mso-number-format:"\0022£\0022\#\,\#\#0\.00" £12.76
mso-number-format:"\#\,\#\#0\.00_ \;\[Red\]\-\#\,\#\#0\.00\ " 2 decimals, negative numbers in red and signed
(1.86 -1.66)
mso-number-format:”\\#\\,\\#\\#0\\.00_\\)\\;\\[Black\\]\\\\(\\#\\,\\#\\#0\\.00\\\\)” Accounting Format –5,(5)

Master Page Fix Height

form id="form2" runat="server">


<table border="0" width="100%">


<td colspan="2" height="150" bgcolor="gray" valign="middle"  align="center">





<td width="20%" bgcolor="silver">SIDEBAR</td>

<td width="80%" height="400" bgcolor="white">

<asp:contentplaceholder id="ContentPlaceHolder1" runat="server">





<td colspan="2" align="center" height="20" bgcolor="gray">







Friday, June 4, 2010

Regex for allowing only Alphabetics, numbers, apostrophe, spaces, dash for string having length 20

ValidationExpression="^[0-9a-zA-Z''\-'' '\s]{1,20}$"

To Display some ListItem in different colour in ListBox in ASP.NET

foreach (ListItem objTempItem in ListBox2.Items)


   //Code to change background colour of listitem

   //objTempItem.Attributes.Add("style", "background-color: RED");

  //Code to change text or foreground colour of listitem



How to get Temporary Folder Path using .NET (C#)

How to get path of the current system's temporary folder using .NET (C#)
Temporary folders are useful to store simple logs during execution of the program. It is also used for storing the decompressed files before any operation. The folder location varies from OS to OS. The following C# snippet would help in retrieving the Temporary folder path

string sPath;

sPath =

Console.WriteLine("Temporary Path := " + sPath );

Get filenames from all folders

Here is another way to get filenames from all folders, including subdirectories (notice the SearchOption.AllDirectories parametre):

// Process the list of files found in all directory.

fileEntries = Directory.GetFiles(sourceDir,
"*", SearchOption.AllDirectories);


(string fileName in


// do something with fileName



If you change the "*" to ex. "*.log" you will get all filenames that ends with ".log".