Code in the oven

Wednesday, August 24, 2011

Kill an Excel process in C#

foreach (System.Diagnostics.Process process in System.Diagnostics.Process.GetProcessesByName("EXCEL"))

{

            if (process.MainModule.ModuleName.ToUpper().Equals("EXCEL.EXE"))

{

                process.Kill();

                break;

}

}

Friday, August 19, 2011

Union of two dataTables and eliminate duplicates by using a customized IEqualityComparer

public class StudentDataRowComparer : IEqualityComparer

{

#region IEqualityComparer Members

public bool Equals(DataRow x, DataRow y)

{

return (x.Field("STUDENTID") == y.Field("STUDENTID"));

}

public int GetHashCode(DataRow obj)

{

return obj.ToString().GetHashCode();

}

#endregion

}

How to call it

...

//---Make an Union of both tables

IEnumerable bothTables = dt1.AsEnumerable().Union(dt2.AsEnumerable());

DataTable dtUnion = bothTables.CopyToDataTable();

//---Remove Duplicates

var distinctStudents = dtUnion.AsEnumerable().Distinct( new StudentDataRowComparer());

DataTable dtFinal = distinctStudents.CopyToDataTable();

Friday, June 10, 2011

Add video to your page using HTML5

<!DOCTYPE HTML>
<html>
<body>
<video width="320" height="240" controls="controls" poster="../images/PosterImage.png">
<source src="MyVideo.mp4" type="video/mp4" />
Your browser does not support the video tag.
</video>
</body>
</html>

Tuesday, April 19, 2011

Sort a Listbox using IComparer in C#

What are we cooking today?

Sort a Listbox using IComparer in C# without loosing the value.

RECIPE

The call

SortList(MyListbox);

The Procedure

public void SortList(ListBox list)

{

try

{

//---FROM LISTBOX TO LIST<>

List ListItems = new List();

foreach (ListItem lst in list.Items)

{

ListItems.Add(lst);

}

//---SORT LIST<>

ListItemComparer listC = new ListItemComparer();

ListItems.Sort(listC.Compare);

//---CLEAR LISTBOX

list.Items.Clear();

//---ADD FROM ordered LIST<> to LISTBOX

foreach (ListItem li in ListItems)

{

list.Items.Add(li);

}

catch (Exception ex)

{

lblMsg.Text = ex.Message;

}//--end catch

}

The Icomparer: I am using this because a listitem has text and value, and we just want to order by the text, which could be a person's name or a product( the criteria could be also the value like price, personId, year...)

public class ListItemComparer : IComparer

{

public int Compare(ListItem a, ListItem b)

{

int result = string.Compare(a.Text, b.Text);

return result;

}

Monday, February 28, 2011

Some helpful REGEX (regular expressions for postal code, email, phone, SIN)

What are we cooking today?

Some REGEX (Regular Expresions) for:

Canadian/US Postal Code
Email (x@x.x)
Phone number (xxx)(xxx-xx-xx)
Canadian SIN (xxx-xxx-xxx)

Recipe

Valid Canada Postal Code

(^[ABCEGHJ-NPRSTVXY]{1}[0-9]{1}[ABCEGHJ-NPRSTV-Z]{1}[ ]?[0-9]{1}[ABCEGHJ-NPRSTV-Z]{1}[0-9]{1}$)

Valid US and Canada

(\d{5}(-\d{4})?)|(^[ABCEGHJ-NPRSTVXY]{1}[0-9]{1}[ABCEGHJ-NPRSTV-Z]{1}[ ]?[0-9]{1}[ABCEGHJ-NPRSTV-Z]{1}[0-9]{1}$) )

Valid Email

\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*

Valid US Phone

(($\d{3}$ ?)|(\d{3}-))?\d{3}-\d{4}

Canadian SIN

\d{3}-\d{3}-\d{3}

Thursday, February 24, 2011

Loop through an enumeration to fill a dropdownlist

What are we cooking today?

Fill a dropdown list with my enumeration

Recipe

Tuesday, February 8, 2011

Troubleshooting a web service consuming app error

What are we cooking today?

Troubleshooting :
"Could not find default endpoint element that references contract in the ServiceModel client configuration section"

Recipe

Imagine you want to consume a web service.
You created a class that have the reference to the web service
You created a website (consuming application) that use the class described in (2)

When you run the web app you get this message:

"Could not find default endpoint element that references contract in the ServiceModel client configuration section"

An easy solution that worked for me: Copy all the content of the MyClassNamespace.dll.config when you compiled your class into the web.config file of the consuming application. (The objective is to expose the endpoint and the correct contract name)

Add to web.config

Other possible solutions I found when searching:

a) Copy config file (MyApi.dll.config) from class library to bin folder of consuming application and rename it to MyApp.config

b) Programatically create instances of Binding and RemoteAddress objects and use the constructor that takes these 2 parameters