IProgrammer

Schedule Daily backup of database in MS-SQL Server 2008

2012-01-22T14:02:00.002+02:00

1. Open Management Studio.
2. Under "Mangement" select Maintenance Plans.
3. Right click and choose New Plan (it will ask for name).
4. Double click on Subplan_1 and change it to your name.
5. Drag from toolbox "Back Up Database Task" control.
6. Right click on it and choose Edit.
7. Choose Backup Type, Databases and change more fields.
8.OK
9. Click on Job Schedule (in end of row) and set backup date/time.
10. Save plan.
11. Under "Mangement" right click on your job and choose "Execute" for validation.

Enjoy!

Is my code Fluent?

2012-01-19T09:10:00.000+02:00

http://www.smelser.net/blog/post/2009/11/12/Is-my-code-Fluent.aspx

Activator or Lambda Expressions

2012-01-19T09:06:00.003+02:00

http://www.smelser.net/blog/post/2010/03/05/When-Activator-is-just-to-slow.aspx

Log4Net... Friend or Foe?

2012-01-19T08:59:00.002+02:00

http://www.smelser.net/blog/post/2011/08/16/Log4Net-Friend-or-Foe.aspx

Hidden Features of C#?

2012-01-18T09:29:00.003+02:00

http://stackoverflow.com/q/9033

10 Things ASP.NET Developers Should Know About Web.config Inheritance and Overrides - Jon Galloway

2012-01-18T09:12:00.000+02:00

10 Things ASP.NET Developers Should Know About Web.config Inheritance and Overrides - Jon Galloway

Installing and Running IIS and Apache Server Together

2011-11-08T15:23:00.001+02:00

We working on project that include web application based on python and several application based on IIS (as WCF , Web application, web site ant etc'). "Python" application use port 80 therefore we cannot use same port in IIS application. HERE was explained solution that based on 2 IP addresses.

p.s. One more note: you must run command prompt as administrator.

"The specified metadata path is not valid." error in using Windows Service and Entity Framework

2011-09-06T11:06:00.000+03:00

I have project (Windows Service) that use Entity Framework model as external DLL.
I cannot use a metadada as embedded resource and must define connection string in config file of Windows Service. In the Debug mode I got right result, I created setup project and installed service in directory but a immediately I saw the next error:

The specified metadata path is not valid. A valid path must be either an existing directory, an existing file with extension '.csdl', '.ssdl', or '.msl', or a URI that identifies an embedded resource.

I'll not tell you what I not tried and a solution was found after deep research in order to understand where is run Windows Service. Bad news! Windows Service not run in installed directory therefore all path's to files in config file must be define as physical path otherwise application cannot find it. Windows service use relative path different to installation directory.

Where you use Entity Framework you must to define row as this one:

...metadata=.\ServiceModel.csdl|.\ServiceModel.ssdl|.\ServiceModel.msl...

In order to not change path to physical path just add next row in event OnStart in Windows Service:

System.IO.Directory.SetCurrentDirectory(System.AppDomain.CurrentDomain.BaseDirectory);

This is a way to define relative path of Service as installed directory.

Enjoy!

Trim leading zeros

2011-08-23T09:20:00.001+03:00

REPLACE(LTRIM(REPLACE([Column], '0', ' ')), ' ', '0')
Thanks,

Paging in LINQ

2011-08-05T12:28:00.001+03:00

Implementation of paging with help from ROW_COUNT() of SQL in LINQ :

Implementation:

public static IEnumerable<T> Paging<T>(int rowCount, int pageId, IQueryable<T> query)
{
    return  query        
        .Skip((pageId - 1) * rowCount)
        .Take(rowCount);
}

Using:

private void TestMethod()
{
    Random rnd = new Random();
    List<Foo> fooList = new List<Foo>();
    for (int i = 0; i < 20; i++)
    {
        fooList.Add(
                new Foo
                {
                    ID = rnd.Next(100),
                    Name = Membership.GeneratePassword(5, 0)
                }
            );
    }
 
    var query = fooList.OrderBy(item => item.ID).AsQueryable();
 
   Console.WriteLine("Attempt 1");
   Paging(10, 1,query )
       .ToList()
       .ForEach(
        item => Console.WriteLine(item.ID + ": " + item.Name)
        );
    Console.WriteLine("Attempt 2");
    Paging(5, 2, query)
        .ToList()
        .ForEach(
        item => Console.WriteLine(item.ID + ": " + item.Name)
        );
}

Class:

public class Foo
{
    public int ID { get; set; }
    public string Name { get; set; }
}

And now as extension!

Enjoy!

Entity Framework and Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

2011-08-01T12:58:00.000+03:00

I had troubles with long list in "delete" action. After several unsuccessful attempts I found solution (maybe is not the best):

using (var ctx = new EntityContext())
{
  var tmpTimeout = ctx.CommandTimeout;
  try
  {
   ctx.CommandTimeout = int.MaxValue;
   ctx.YOUROBJECTS.DeleteObject(value));
   ctx.SaveChanges();
  }
  catch (Exception ex)
  {}
  finally
  {
   ctx.CommandTimeout = tmpTimeout;
  }
}

Reading XLSX format file from C#

2011-07-21T15:45:00.000+03:00

The best guide for reading excel file without Excel instance exist here.

Pay attentions! In the final example in the loop ForEach missed validation of not string values and NULL value cells, threfore change it to:

foreach (XElement cell in cells)
{
    if (cell.IsEmpty)
    {
        continue;
    }
    string cellPosition = cell.Attribute("r").Value;
    int index = IndexOfNumber(cellPosition);
    string column = cellPosition.Substring(0, index);
    int row = Convert.ToInt32(cellPosition.Substring(index, cellPosition.Length - index));
    if (cell.HasElements)
    {
        if (cell.Attribute("t") != null && cell.Attribute("t").Value == "s")
        {
            // Shared value
            int valueIndex = Convert.ToInt32(cell.Descendants(ExcelNamespaces.excelNamespace + "v").Single().Value);
            parsedCells.Add(new Cell(column, row, sharedStrings[valueIndex]));
        }
        else
        {
            string value = cell.Descendants(ExcelNamespaces.excelNamespace + "v").Single().Value;
            parsedCells.Add(new Cell(column, row, value));
        }
    }
    else
    {
        parsedCells.Add(new Cell(column, row, ""));
    }
}

Error in SecurityMode = None in WsHttpBinding

2011-07-20T12:14:00.000+03:00

Define next attributes in the binding:

<bindings>
      <wsHttpBinding>
        <binding name="wsHttpBindingConfig">
          <security mode ="None"/>
          <reliableSession enabled="true" />

        binding>
      wsHttpBinding>
    bindings>

WCF error messages - the guide.

2011-07-19T11:46:00.000+03:00

Whenever web developers hear the term session, we think of Http Session which is used to store data between multiple HTTP requests....to full article click here!

Extension for expression (List == null || List.Count > 0)

2011-07-17T20:36:00.001+03:00

This one and more extensions exist here.

Could not load file or assembly 'ASSEMBLY_NAME' or one of its dependencies. An attempt was made to load a program with an incorrect format.

2011-07-10T10:02:00.003+03:00

The error occurred as transfer from 32-bit to 64-bit platforms. A solution is very easy:

1. Go to "ASSEMBLY_NAME" project in solution
2. Open project properties
3. Open "Build" tab
4. Change "Platform target" to "Any CPU"
5. Compile solutions.

Enjoy!

How to prevent duplicates in 2 columns in one table

2011-06-30T14:56:00.000+03:00

We know how to define column as unique, but what to do where you need to prevent duplicate in 2 columns?
This is a state:

CREATE TABLE #tmp
(
Id INT,
Wine VARCHAR(50),
Country VARCHAR(50)
)

INSERT INTO #tmp VALUES 
(1,'Merlot','France')
INSERT INTO #tmp VALUES
(2,'Merlot','Argentina')
INSERT INTO #tmp VALUES
(3,'Malbec','Argentina')

SELECT * FROM #tmp
DROP TABLE #tmp

A result is:

Id |  Wine    |  Country
----------- ------------------
1 |  Merlot   |  France
2 |  Merlot   |  Argentina
3 |  Malbec |  Argentina

A target to prevent:

Id |  Wine    |  Country
----------- ------------------

1 |  Merlot   |  France
2 |  Merlot   |  Argentina
3 |  Malbec |  Argentina

4 |  Merlot   |  France
5 |  Caberne   |  France

That means table allow duplicate Wines and duplicate Countries, but must prevent double rows.
A solution is to add next row after table creation:

ALTER TABLE  #tmp      ADD UNIQUE(Wine, Country)

Enjoy

Generic Type Convert Function

2011-06-27T16:01:00.003+03:00

It's simple method can be use as extension method for conversion types :

public static TK ConvertTo<TK>(this object value,bool isThrowException = false, 
                   TK defaultValue = default(TK))
{
  try
  {
    return (TK)Convert.ChangeType(value, typeof(TK));
  }
  catch (InvalidCastException ex)
  {
     if (isThrowException)
      {
        throw ex;
     }
  return defaultValue;
}

Using example:


string value = "15";
//Method will convert string to int. 
//In case val is not numeric will throw exception.
int result = value.ConvertTo();
//In case val is not numeric will return type default value.
int result1 = value.ConvertTo(false);
//In case val is not numeric will return your defined value (5).
int result2 = value.ConvertTo(false,5);

Enjoy!

Entity Framework, web.config and error "The specified named connection is either not found in the configuration..."

2011-06-22T13:02:00.003+03:00

Hi my friend,

If you come to here from generic search, then you already know what is a real nightmare. Every new feature from Microsoft can include surprised items and will take hours (sometimes days) for understand how it work correct. Anyway...

For using Entity Framework as DLL class-library in win/console application you should work by next steps:

1. Create YOUR_NAME.edmx.
2. Open designer.
3. Click on background.
4. In property tab change property "Metadata artifact Processing" to "Copy to Output Directory".
5. Save project (Connection string will be changed from "res//*/" to ".\" ).
6. Copy connection string to main app.config as is.
7. Go to EF project properties. Choose "Build event" and in Post-Build event command line add next rows:

copy YOUR_NAME.csdl $(SolutionDir)START_PROJECT\bin\Debug\
copy YOUR_NAME.ssdl $(SolutionDir)START_PROJECT\bin\Debug\
copy YOUR_NAME.msl $(SolutionDir)START_PROJECT\bin\Debug\

8. Remove app.config of EF project.

But the nightmare does not live in win application, because she's place in Web Application!

Next steps will help you to back out from hell:
Do it 1-6 steps as in win application case.
7. In web.config change ".\" to "~\App_Data" in c/m/s files
8. Go to EF project properties. Choose "Build event" and in Post-Build event command line add next rows:

copy YOUR_NAME.csdl $(SolutionDir)START_WEB_PROJECT\App_Data\
copy YOUR_NAME.ssdl $(SolutionDir)START_WEB_PROJECT\App_Data\
copy YOUR_NAME.msl $(SolutionDir)START_WEB_PROJECT\App_Data\

9. Remove app.config of EF project.
10. Cross fingers, run it and pray!

Enjoy!

Full solution to: The server committed a protocol violation. Section=ResponseStatusLine

2011-06-05T14:48:00.000+03:00

In most answers to this error you will get same answer:
<system.net>
    <settings>
      <httpWebRequest useUnsafeHeaderParsing="true" />
    </settings>
</system.net>

But not always a problem will be resolved. A full solutions to error present here. Just add next row to request variable:

request.KeepAlive = false;

((HttpWebRequest)request).KeepAlive = false; (Where request type is WebRequest)

LINQ2SQL Connection Strings with class library projects

2011-06-05T10:54:00.000+03:00

1. Set connection string in Web/App.config in main external project.
2. Open up your DBML and click the designer service. Expand the Connection property, delete Connection String and set "Application Settings" to False.
3. Open designer file and add new construtor as:

public DataClassesDataContext()
            : base(ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString)
        {

            OnCreated();

        }

4. Enjoy!

Full article and inspiration exist here.

Check is IP in range

2011-04-03T11:47:00.005+03:00

You can find countless examples how to check is IP in range. I would like to offer my way for solution with LINQ:

using System.Collections.Generic;
using System.Net;
using System.Linq;

public class IPRange
    {
        public byte[] StartAddressBytes { get; private set; }
        public byte[] EndAddressBytes { get; private set; }

        public IPRange(IPAddress startAddress, IPAddress endAddress)
        {
            StartAddressBytes = startAddress.GetAddressBytes();
            EndAddressBytes = endAddress.GetAddressBytes();
        }
        public IPRange(string strartIp, string endIp)
        {
            IPAddress startAddress, endAddress;
            if (IPAddress.TryParse(strartIp, out startAddress)
                && IPAddress.TryParse(endIp, out endAddress))
            {
                StartAddressBytes = startAddress.GetAddressBytes();
                EndAddressBytes = endAddress.GetAddressBytes();
            }
        }
    }
//--------------------------
public class IPRangeUtil
    {
        public static bool IsInRange(List<IPRange> ipRange , string clientIp)
        {
            IPAddress clientAddress;
            if (!IPAddress.TryParse(clientIp, out clientAddress))
            {
                return false;
            }
            return IsInRange(ipRange, clientAddress);
        }
        public static bool IsInRange(List<IPRange> ipRange, IPAddress clientAddress)
        {
            int clientIpSum = clientAddress.GetAddressBytes().Sum(item => item);
            return ipRange.Where(range =>
                clientIpSum >= range.StartAddressBytes.Sum(item => item)
                && clientIpSum <= range.EndAddressBytes.Sum(item => item)).Any() ;
        }
    }

A using is very easy:
List ranges = new List
                    {
                        //You can replace "xxx.xxx.xxx.xxx" to IPAddress typed variable
                          new IPRange("192.168.10.68", "192.168.10.255"),
                          new IPRange("192.168.0.68h", "192.168.10.68")
                    };

bool isInRange = IPRangeUtil.IsInRange(ranges, "192.168.10.70");

Enjoy!

What is Authentication and Authorization?

2011-03-23T11:05:00.000+02:00

Simple video which explain who is who:

LINQ and #Temporary tables in Stored Procedure do not have return values

2011-01-20T11:50:00.002+02:00

I have Stored Procedure which include #tmp table. I tried to drag it to DBML but every time i got message "bla-bla-bla ... do not have return values...".After countless attempts was found solution! (Thanks to Marc Gravell )
Replace the #tmp in variable, a meaning:

CREATE TABLE #tmp (Item in)
Replace it to:
DECLARE @tmp TABLE (Item int)

A using in query is:
SELECT yt.*, t.Item
FROM YUOR_TABLE yt, @tmp t

Enjoy!

How to encrypt and decrypt password in SQL Server

2010-12-26T17:43:00.000+02:00

Here you can find nice and full solution to encrypt and decrypt password for use in SQL Server.

Using:

declare @value VARCHAR(8000)
--Encrypt
set @value = dbo.fnEncDecRc4('Magic Word','password')
--Decrypt
select dbo.fnEncDecRc4('Magic Word',@value)

Enjoy!

Log Viewer Pro

2010-12-25T19:18:00.001+02:00

Many years I’m use the best file manager Total Commander (Windows commander in the past). In the home site was found link to the site http://www.totalcmd.net which include additional plugins and utilities. But I would present only one very usability utility – Log Viewer Pro. Current application dedicated to viewing logs and available to using in every text file . Every level of Log may be define in different color, a program is free (for home users) and not required install.

Screenshot:

Main features of viewer:
Fast scrolling, eats low memory.
Supports any file size (4 Gb and larger).
Multitabbed interface.
Auto-reload file, Follow tail mode.
Allows to highlight some lines (e.g. "errors", "warnings").
Allows to view encodings: ANSI, OEM, Unicode LE, Unicode BE etc.
File search (both forward and backward).

Download here.

Size: 650 KB
Author: Alexey Torgashin

Snippet editor

2010-12-05T11:51:00.001+02:00

In my work I'm often use snippets, but by old habit I created every time new snippet manual. Today found nice solutions to my suffering - Snippet Editor by BillMcC. Snippet editor ready to work with all version of Visual Studio, support C# and VB snippet, easy interface and big help to programmer.
Link to download.

Generate random string

2010-06-29T09:32:00.001+03:00

Current code is generate string in defined length and include chars, numbers and symbols.

public static string GetRandomString(int size)
{
    StringBuilder builder = new StringBuilder();
    Random random = new Random();
    int[] symbol = new[] { 33, 36, 38, 64, 94 };
    int[] digits = new[] { 48, 49, 50, 51, 52, 53, 54, 55, 56, 57 };
    int symbolsAmount = size / 3;
    int digitAmount = size / 3;
    for(int i = 0; i < size; i++)
    {

        int switcher = random.Next(3);
        char ch;
        if(switcher == 0 && symbolsAmount > 0)
        {
            int id = random.Next(symbol.Length);
            ch = Convert.ToChar(symbol[id]);
            symbolsAmount--;
        }
        else if(switcher == 1 && digitAmount > 0)
        {
            int id = random.Next(digits.Length);
            ch = Convert.ToChar(digits[id]);
            digitAmount--;
        }
        else
        {
            bool isLower = random.Next(2) == 0 ? false : true;
            ch = Convert.ToChar(
                 Convert.ToInt32(
                 Math.Floor(26 * random.NextDouble() + ((isLower) ? 65 : 97))
                     )
                 );

        }
        builder.Append(ch);
    }

    return builder.ToString();
}

Range Operator in Linq

2010-06-23T09:26:00.001+03:00

Simple example to big item. Click here to read article.

Combinatorics Utilities

2010-06-21T11:34:00.001+03:00

Beautiful solution to combinatorics algorithm. Click here to read article.

VS 2008 SP1 deletes .dbml designer file – a solution

2010-04-27T17:12:00.002+03:00

Also me was surprised after installation Visual Studio 2008 SP1. every little change in dbml hierarchy give raise to deleting designer file. Short googling return elegant solution:
In partial class move all using statements after namespace

Original code:

using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Reflection;

namespace Test
{
partial class DataClassesDataContext
{
//...
}
}

New Code:

namespace Test
{
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Reflection;

partial class DataClassesDataContext
{
//...
}
}

Right click on the .dbml file and run “Run Custom Tool”.

Enjoy!

Twice calling Render in ASP.NET page

2010-02-11T10:47:00.002+02:00

I have web page, which use HtmlTextWriter for creating HTML in client. List<T> get data from DB and start in loop to add HTML tags, attributes and more. I hoped to create page with div’s, images and text, but in the debug phase i saw the Render() method called twice. After long tests and researches was found out what is a problem. In creating image <img>, a attribute “src” get value from DB and in one images “accidently” a value was …null. You can say “so what?” A problem exist not in HTML page, a problem concealing in IIS. If page has attribute <…src=”” …/> or<… src=”#” …> that makes IIS load the page twice. Good luck!

Object Property as Key in Collection

2010-01-06T16:55:00.001+02:00

A innovation of Dictionary got excellent solution in stocking data. After countless uses I decided to find alternative method in combination of key and object and now I offering KeyedCollection. Little example will present a using of aforementioned object:

Simple classes:

public class User
   {
       public int Id { get; set; }
       public string Name { get; set; }
       public Address Address { get; set; }
   }

   public class Address
   {
       public string Country { get; set; }
       public string City { get; set; }
       public string Zip { get; set; }
   }

Two object that inherits abstract KeyedCollections:

/// <summary>
///A key is ID of player
/// </summary>
public class UserCollection : KeyedCollection<int, User>
{
    //Implementing member
    protected override int GetKeyForItem(User item)
    {
        return item.Id;
    }
}

/// <summary>
/// A key is User Name
/// </summary>
public class UserCollection1 : KeyedCollection<string, User>
{
    //Implementing member
    protected override string GetKeyForItem(User item)
    {
        return item.Name;
    }
}

Little example to using:

public class Test
{
    public TestById()
    {
        var userCollection = new UserCollection();
        userCollection.Add(new User
                               {
                                   Id = 5,
                                   Name = "John Smith",
                                   Address = new Address
                                                 {
                                                     City = "NY",
                                                     Country = "USA",
                                                     Zip = "12345"
                                                 }
                               });

        userCollection.Add(new User
                               {
                                   Id = 17,
                                   Name = "James Brown",
                                   Address = new Address
                                                 {
                                                     City = "LA",
                                                     Country = "USA",
                                                     Zip = "54321"
                                                 }
                               });

        Console.Write(userCollection[6]);
    }
     public void TestByName()
    {
        var userCollection = new UserCollection1();
        userCollection.Add(new User
                               {
                                   Id = 5,
                                   Name = "John Smith",
                                   Address = new Address
                                                 {
                                                     City = "NY",
                                                     Country = "USA",
                                                     Zip = "12345"
                                                 }
                               });

Console.Write(userCollection["John Smith"]);
}
}

If a project in VS 2008 you can run in heritable object LINQ requests and more. Enjoy!

5 Very Useful C# Attributes

2010-01-05T15:55:00.001+02:00

More one good…

10 Not So Well Known Keywords in C#

2010-01-05T14:01:00.001+02:00

Very impressive article! Click here

SQL to LINQ Cheat Sheet

2009-10-25T11:16:00.001+02:00

Excellent explanation how to covert SQL query to LINQ. Click HERE to article.

C# And Accepting Parameters

2009-07-12T15:16:00.001+03:00

Have you ever written a function that looked similar to the following – Passing in an array of a value? To interesting solution click here.

via DotNetKicks.com

Using Type Alias in C#

2009-06-18T13:27:00.001+03:00

To read article click HERE.

Debug windows service

2009-06-17T15:35:00.001+03:00

In the time, when you work on development a windows service not possible to debug it. A solution is a converting service to console application or creating additional service runner or anymore. I want to present very simple, effective and easy way how to resolve this. In debug mode will run application and in not debug mode will run service.

[RunInstaller(true)]
public partial class ServiceRunner : ServiceBase
{
    [STAThread]
    static void Main()
    {
#if !DEBUG
        //Run Windows Service
        Run(new ServiceRunner());
#else
        //Run Application
        new YourServiceBody();
#endif
    }
    public ServiceRunner()
    {
        InitializeComponent();

    }
    protected override void OnStart(string[] args)
    {
        new YourServiceBody();
    }

    protected override void OnStop()
    {}
}

Good luck!

Singletons vs. Static Classes

2009-05-12T16:17:00.001+03:00

To read article click HERE

Clone an object in C# using reflection for system and generic types

2009-04-05T14:17:00.003+03:00

public object Clone()
{
    object newObject = Activator.CreateInstance(GetType());
    PropertyInfo[] propertyInfos = GetType().GetProperties();
    foreach (PropertyInfo propertyInfo in propertyInfos)
    {
        if (propertyInfo.PropertyType.IsGenericType)
        {
            if (propertyInfo.PropertyType.GetInterface("IList", true) != null)
            {
                IList oldList = propertyInfo.GetValue(this, null) as IList;
                if (oldList != null && oldList.Count > 0 &&
            oldList[0].GetType().GetInterface("ICloneable", true) != null)
                {
                    IList newList = (IList)propertyInfo.GetValue(newObject, null);
                    foreach (object obj in oldList)
                    {
                        ICloneable clone = (ICloneable)obj;
                        newList.Add(clone.Clone());
                    }
                }
                else
                {
                    propertyInfo.SetValue(newObject, oldList, null);
                }
            }
            if (propertyInfo.PropertyType.GetInterface("IDictionary", true) != null)
            {
                IDictionary oldDic =
                  propertyInfo.GetValue(this, null) as IDictionary;
                if (oldDic != null && oldDic.Count > 0 &&
               oldDic[0].GetType().GetInterface("ICloneable", true) != null)
                {
                    IDictionary newDic =
                     (IDictionary)propertyInfo.GetValue(newObject, null);
                    foreach (DictionaryEntry entry in oldDic)
                    {
                        ICloneable clone = (ICloneable)entry.Value;
                        newDic[entry.Key] = clone.Clone();
                    }
                }
                else
                {
                    propertyInfo.SetValue(newObject, oldDic, null);
                }
            }
        }
        else
        {
            //Clone IClonable object
            if (propertyInfo.GetType().GetInterface("ICloneable", true) != null)
            {
                ICloneable clone = (ICloneable)propertyInfo.GetValue(this, null);
                propertyInfo.SetValue(newObject, clone.Clone(), null);
            }
            else
            {
                propertyInfo.SetValue(
                 newObject, propertyInfo.GetValue(this, null), null);
            }
        }
    }
    return newObject;
}

Snippet Designer for Visual Studio 2008

2008-09-25T10:30:00.001+03:00

The Snippet Designer is a plugin which enhances the Visual Studio IDE to allow a richer and more productive code snippet experience.

Home Page

Multi Sorting array of objects

2008-08-14T18:42:00.007+03:00

A method sort (asc and desc) array of objects by properties and return sorted array.

private static T[] MultiSortObjectArray<T>(T[] objects,
                                           bool isReverseSort, params string[] propertyNames)
{
    //Get array object type
    PropertyInfo[] propertiesInfo = (typeof (T)).GetProperties();
    //Define list of properties for sorting
    List<PropertyInfo> lstProperties2Compare = new List<PropertyInfo>();

    //Check sorting properties one by one
    foreach (string sortPropertyName in propertyNames)
    {
        //Find sorting property in Object property
        PropertyInfo sortProperty = 
            Array.Find(propertiesInfo,
               delegate(PropertyInfo property)
                   {
                       return (
                                  string.Compare(property.Name, sortPropertyName,
                                                 true) == 0
                              );
                   }
            );

        //Add existing property to sorting list
        if (sortProperty != null)
            lstProperties2Compare.Add(sortProperty);
    }

    if (lstProperties2Compare.Count == 0)
        return null;

    Array.Sort(objects,
               delegate(T x, T y)
                   {
                       int result = -1;
                       foreach (PropertyInfo propInfo2Compare in
                           lstProperties2Compare)
                       {
                           result = (!isReverseSort)
                                        ? //Sort by asc
                                    (new CaseInsensitiveComparer()).Compare(
                                        propInfo2Compare.GetValue(x, null),
                                        propInfo2Compare.GetValue(y, null)
                                        )
                                        : //Sort by desc
                                    (new CaseInsensitiveComparer()).Compare(
                                        propInfo2Compare.GetValue(y, null),
                                        propInfo2Compare.GetValue(x, null)
                                        );
                           //If x equals y continue compare process
                           if (result != 0)
                               break;
                       }

                       return result;
                   }
        );

    return objects;
}

Free CSS Designs

2008-06-16T10:02:00.001+03:00

List of free web design templates:

Open Source Web Design

Open Web Design

Open Source Templates

Open Source Web Templates (oswt)

Free CSS.com

Style Shout

Sys.WebForms.PageRequestManagerParserError in MS AJAX

2008-05-14T11:50:00.001+03:00

Thanks to Al Pascual to solution.

On top of the webform add:
enableEventValidation="false"

To full article lick Here

10 Tips to Improve your LINQ to SQL Application Performance

2008-05-04T12:58:00.001+03:00

Full arcticle

Get column info in MS SQL

2008-04-28T09:33:00.001+03:00

Existing some ways how to get column information, but Joe Webb offered very simple and effective query:

SELECT 
   ORDINAL_POSITION
  ,COLUMN_NAME
  ,DATA_TYPE
  ,CHARACTER_MAXIMUM_LENGTH
  ,IS_NULLABLE
  ,COLUMN_DEFAULT
FROM   
  INFORMATION_SCHEMA.COLUMNS 
WHERE   
  TABLE_NAME ='TABLE_NAME' 
ORDER BY 
  ORDINAL_POSITION ASC;

VS 2005 Intellisense in web.config files stop work

2008-04-08T09:59:00.001+03:00

Now one annoying gotcha:
There is one gotcha to be aware of, though, that can sometimes cause intellisense for the web.config file to stop working in the IDE. This happens when a default namespace is added to the root <configuration> element. For example, like so:
<configuration xmlns=
"http://schemas.microsoft.com/.NetConfiguration/v2.0">
This doesn’t cause any runtime problems – but it does stop intellisense completion happening for the built-in .NET XML elements in the web.config file.
The bad news is that the built-in web admin tool (launched via the WebSite->ASP.NET Configuration menu item in VS 2005 and Visual Web Developer) always adds this xmlns namespace when it launches – so if you use this tool to manage users/roles you’ll end up having it added to your web.config file for you.
How to fix this gotcha:
To get intellisense back when you are editing the web.config file in the IDE, just delete the xmlns reference and have the root configuration element look like so:
<configuration>
Everything will then work fine again.

via

The regular expression generator

2008-03-30T09:58:00.001+03:00

Click Here

HttpWebRequest over SSL

2008-03-27T17:32:00.001+02:00

public static bool
AcceptAllCertificatePolicy(
    object sender,
    X509Certificate certificate,
    X509Chain chain,
    SslPolicyErrors sslPolicyErrors)
{
    return true;
}

The returned value determines whether the specified certificate is accepted for authentication.

Then set:

ServicePointManager.ServerCertificateValidationCallback
 += AcceptAllCertificatePolicy;

From here

Inline ASP.NET tags(<%$, <%=, <%, <%#, etc.)

2008-03-25T16:48:00.001+02:00

Full article read here.

Class name generator

2008-03-18T09:44:00.001+02:00

Can't think of a good class name? Try this: ClassNamer

Singleton Factory in C#

2008-03-09T09:56:00.001+02:00

    // this is the class for which
   // I want to maintain a single instance
    public class MyClass
    {
        private MyClass()
        {
            /* private constructor ensures that
              callers cannot instantiate an
               object using new() */
         }
    }

    // Singleton factory implementation
    public static class Singleton<T> where T : class
    {
        // static constructor, 
        //runtime ensures thread safety
        static Singleton()
        {
            // create the single instance 
  	   //	of the type T using reflection
            Instance = (T)Activator.CreateInstance(
            typeof(T),true);
        }

        // serve the single instance to callers
        public static T Instance { private set; get; }
    }

    class Program
    {
        public static void Main()
        {
            // test
            Console.WriteLine(
               Object.ReferenceEquals(
                Singleton<MyClass>.Instance, 
                Singleton<MyClass>.Instance));
        }
    }

via Cognitive Coding

Patterns and Practices: Complete Catalog

2008-03-06T10:04:00.001+02:00

Full catalog by index of the patterns & practices:

Link 1 or Link 2

Disable .pdb file generation in Release Mode

2008-02-26T10:38:00.001+02:00

Click here

.NET Framework V2.0 Obsolete API List

2008-02-24T10:01:00.001+02:00

Obsolete List: By Assembly

Obsolete List: By Namespace

Full article in MSDN

Enum Utilities

2008-02-18T09:39:00.001+02:00

In this article I will discuss some classes I've written to simplify working with enumerations. The primary thrust of these classes is added functionality, but in some cases there are performance improvements as well.

Click here

Download source

The zip file contains:
EnumDefaultValueAttribute.cs
EnumTransmogrifier.cs
LibEnum.cs
build.bat
csc.rsp
EnumDemo1.cs
EnumDemo2.cs
EnumDump.cs
MonthEnum.cs
PolyglotAttribute.cs
WeekdayEnum.cs

Once you extract the files to a directory you should be able to execute build.bat to compile the demo programs. (They are console applications.)

To use the methods in your own projects, simply add the appropriate files.

Directives in Asp.Net

2008-02-17T12:57:00.001+02:00

Directives are used to pass optional settings to the ASP.NET pages and compilers.

Click here to read article.

Custom Controls: Extra Property Tab

2008-02-12T13:14:00.001+02:00

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Text;
using System.Windows.Forms;

namespace Elsehemy.Controls
{
    [Designer(typeof(UserControlDesigner))]
    [PropertyTab(typeof(ExtraSuperTab), 
          PropertyTabScope.Component)]
    public partial class TestUserControl : UserControl
    {
        public TestUserControl()
        {
            InitializeComponent();
        }
        int _x;

        public int XXX
        {
            get { return _x; }
            set { _x = value; }
        }
    }


    public class ExtraSuperTab : 
         System.Windows.Forms.Design.PropertyTab
    {
        public override PropertyDescriptorCollection
         GetProperties(object component, 
                        Attribute[] attributes)
        {
            PropertyDescriptor pd = 
               TypeDescriptor.CreateProperty(
                          component.GetType(),
                          "XXX",
                           typeof(int), 
             new CategoryAttribute("Super Properties"));

            return (
                new PropertyDescriptorCollection(
                         new PropertyDescriptor[]{pd}
                                               ));
        }

        public override string TabName
        {
            get { return "Super Tab"; }
        }

        public override System.Drawing.Bitmap Bitmap
        {
            get
            {
                return (System.Drawing.Bitmap)System.
                  Drawing.Image.FromFile(@"C:\icon.jpg");
            }
        }
    }
}

And in the control don't forget the attribute

[PropertyTab(typeof(ExtraSuperTab),
       PropertyTabScope.Component)] 
public partial class TestUserControl : UserControl

Via Amr Elsehemy's Blog

How to use delegates to remove duplicated code

2008-02-10T10:48:00.001+02:00

Click Here

Static Extension Methods

2008-02-10T10:45:00.001+02:00

DateTime d = DateTime.Yesterday();
//...
public static DateTime Yesterday<this DateTime>()
{
    return DateTime.Today.AddDays(-1);
}

Via Mabstrerama

Security Tutorials by Microsoft

2008-02-06T10:22:00.001+02:00

A series of tutorials about ASP.NET Security, that include 3 articles:

A tutorial series is showing in C# and VB.

101 Design Patterns & Tips for Developers

2008-02-05T10:12:00.001+02:00

Full guide for developer how to create your application in the using a "design patterns", that include next parts:

Creational Patterns
Structural Patterns
Behavioral Patterns
Composing Methods of Refactoring
Moving Features Between Objects
Organizing Data
Simplifying Conditional Expressions
Making Method Calls Simpler
Dealing with Generalization
Big Refactorings

Click here to read.

The Chart free generation for Web Application from Google

2008-01-28T10:49:00.001+02:00

Google Provided addition tool for Web developers - The Google Chart API.

You can create a charts in very simple way - build necessary URL and will receive chart in one of 5 types (Line, Bar, Pie, Venn or Scatter).

A simple "pie" for example:

URL = "http://chart.apis.google.com/chart?
cht=p3&chco=4C8ED6&chs=250x120&
chl=Sun|Mon|Tue|Wed|Thu|Fri|Sat&chd=s:ABCDEFG"

and a result:

In your control next chart parameters: Data, Type, Colors, Labels, Style, Character mappings and several optional parameters.

To Home Page click HERE

Find all tables, which includes column name

2008-01-20T09:58:00.001+02:00

Get all table names for a specific column name

SELECT sysobj.name as Table_Name
FROM sysobjects sysobj
INNER JOIN syscolumns syscol
 ON sysobj.id= syscol.id
WHERE  syscol.name = 'COLUMN_NAME_FOR_SEARCH'

-------------------------------------------

Get all columns and table names for a 'like column_name' query

SELECT syscol.[name] as Column_Name,
 sysobj.name as Table_Name 
FROM sysobjects sysobj
INNER JOIN syscolumns syscol 
ON sysobj.id=syscol.id
WHERE syscol.name like '%COLUMN_NAME%'

Example & Tutorial of Rhino Mocks

2008-01-17T12:00:00.001+02:00

In object-oriented programming, mock objects are simulated objects that mimic the behavior of real objects in controlled ways. A computer programmer typically creates a mock object to test the behavior of some other object, in much the same way that a car designer uses a crash test dummy to test the behavior of a car during an accident.

Wikipedia

To full guide in code examples about Rhino Mocks Click Here

Full guide how to configuring VS 2008 for debugging .NET Framework Source Code

2008-01-17T10:58:00.001+02:00

Click here to read a article.

SQL Server 2005, Clean your Database Records & reset Identity Columns, all in 6 lines

2008-01-10T11:48:00.001+02:00

Well, I had a small issue regarding writing a script to clean a database we have and reset its identity columns in all tables. Although the database wasn't huge one (less than 100 tables) I had to trace relations to be able to delete child table's records before parent's ones because of the foreign key constraints. The solution is disable the foreign keys and delete records with no fear of any errors then enables the constraints again.
Well, I found a solution to disable all constraints without the need to go on each table and disable it manually. and I was happy to know that I can use this solution in deleting all records from all tables. Not only this I was able to use the same solution to reset identity columns in all tables.
The solution was to use this built in stored procedure sp_MSforeachtable. For help about this proc search for it in Books online or use this sp_helptext sp_MSForeachtable.
Now back to my 6 lines, bellow is how I re-zeroed my Database:

/*Disable Constraints & Triggers*/
exec sp_MSforeachtable
     'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
exec sp_MSforeachtable 
     'ALTER TABLE ? DISABLE TRIGGER ALL'

/*Perform delete operation on all table for cleanup*/
exec sp_MSforeachtable 'DELETE ?'

/*Enable Constraints & Triggers again*/
exec sp_MSforeachtable
      'ALTER TABLE ? CHECK CONSTRAINT ALL'
exec sp_MSforeachtable
     'ALTER TABLE ? ENABLE TRIGGER ALL'

/*Reset Identity on tables with identity column*/
exec sp_MSforeachtable
      'IF OBJECTPROPERTY(OBJECT_ID(''?''),
      ''TableHasIdentity'') = 1 
      BEGIN DBCC CHECKIDENT (''?'',RESEED,0) END'

Via Moses on DotNetSlackers

How to check email works with no SMTP

2008-01-09T13:02:00.001+02:00

<system.net>
   <mailSettings>
      <smtp deliveryMethod="SpecifiedPickupDirectory">
         <specifiedPickupDirectory 
             pickupDirectoryLocation="c:\Test\" />
      </smtp>
   </mailSettings>
</system.net>

Via .Net Tip of The Day

How to extract URLs (href property) from HTML

2008-01-07T09:50:00.001+02:00

protected ArrayList GetUrl(string text)
{
    ArrayList listURL = new ArrayList();
    Regex r = 
        new Regex("href\\s*=\\s*(?:(?:\\\
        "(?<url>[^\\\"]*)\\\")|
        (?<url>[^\\s]* ))");
    MatchCollection mathColl = r.Matches(text);

    foreach (Match math in mathColl)
    {
        foreach (Group gr in math.Groups)
        {
            listURL.Add(gr.Value);
        }
    }
    return listURL;
}

What is the difference between URL and URI?

2007-12-23T16:23:00.001+02:00

A URL is the address of some resource on the web, which means that normally you type the address into a browser and you get something back. There are other type of resources than web pages, but that's the easiest conceptually. The browser goes out somewhere on the internet and accesses something.
A URI is just a unique string that uniquely identifies something, commonly a namespace. Sometimes they look like a URL that you could type into the address bar of your web browser, but it doesn't have to point to any physical resource on the web.
URI is the more generic term, and a URL is a particular type of URI in that a URL has to uniquely identify some resource on the web.

Via .Net Tip of The Day

Ajax control toolkit updated for Visual Studio 2008

2007-11-22T11:42:00.001+02:00

Ajax control toolkit has been updated and released to version version 3.5.11119.0

AjaxControlToolkit-Framework3.5.zip is the full release package with complete source code to all controls, the test framework, VSI, and more.

AjaxControlToolkit-Framework3.5-NoSource.zip contains only the sample web site and VSI and is for people who don't need or want the source code for the controls.

Download link

Visual Studio 2008 and .NET Framework 3.5 Training Kit

2007-11-21T09:52:00.001+02:00

The Visual Studio 2008 and .NET Framework 3.5 Training Kit includes presentations, hands-on labs, and demos. This content is designed to help you learn how to utilize the Visual Studio 2008 features and a variety of framework technologies including: LINQ, C# 3.0, Visual Basic 9, WCF, WF, WPF, ASP.NET AJAX, VSTO, CardSpace, SilverLight, Mobile and Application Lifecycle Management.

Download Page

Visual C# 2008 Keyboard Shortcuts Reference Poster

2007-11-19T11:24:00.001+02:00

Microsoft present keybinding reference poster for Visual C# in Visual Studio 2008

Download page

Add automatic updates to your application

2007-11-15T09:58:00.001+02:00

This article explain step-by-step how to add automatic update capabilities to application quickly and easily.

Click here

How to add ComboBox to PropertyGrid

2007-11-14T17:10:00.001+02:00

Create new class which inherit StringCoverter, and 3 methods:

internal class List2PropertyConverter : StringConverter
    {
        public override bool
            GetStandardValuesSupported(
            ITypeDescriptorContext context)
        {
            //True - means show a Combobox
            //and False for show a Modal 
            return true;
        }

        public override bool
            GetStandardValuesExclusive(
            ITypeDescriptorContext context)
        {
            //False - a option to edit values 
            //and True - set values to state readonly
            return true;
        }

        public override StandardValuesCollection
            GetStandardValues(
            ITypeDescriptorContext context)
        {
            return new StandardValuesCollection(
                new string[] {"test1", "test2", "..."});
        }
    }

Add variable and encapsulate it:

 private string testValue;
        [Browsable(true)]
        [Category("Category name")]
        [TypeConverter(typeof(List2PropertyConverter))]
        public string TestValues
        {
            get { return testValue; }
            set { testValue = value; }
        }

PropertyGrid has 4 attributes for a manage properties:

[Browsable(bool)] - Visible/Hide property

[ReadOnly(bool)] - Editing (true/false)

[Category(string)] - Group of properties

[Description(string)] - Description of the property

Regards,

CAPTCHA Kinda Spam Prevention in ASP.NET

2007-11-11T11:20:00.001+02:00

Spammers really bug me.

I've been working on this on-going sports related portal project (that probably will NEVER go live :)

I love of hobby community sites degrade quickly because they lack the moderation resources to keep the user submitted content quality high and I've been thinking about this problem.

I thought I would share some interesting links that I found on the subject.

The Official Captcha Site

Microsoft Research HIP (Human Interactions Programming)

MSR Asirra (Animal Species Image Recognition for Restricting Access)

Subkismit on CodePlex.com

ASP.NET AJAX NoBot

ASP.NET CAPTCHA Server Control on CodingHorror.com

ASP.NET CAPTCHA Server Control on CodeProject.com

by Joe Stagner

Template Method Design Pattern vs. Functional Programming

2007-11-11T10:20:00.001+02:00

Simple and obvious example how to realize Design Patterns. A example based on Hot Drinks and presented design of the application with explanations.

Click here

ADInsight - new utility by Microsoft

2007-11-08T10:33:00.001+02:00

ADInsight is an LDAP (Light-weight Directory Access Protocol) real-time monitoring tool aimed at troubleshooting Active Directory client applications. Use its detailed tracing of Active Directory client-server communications to solve Windows authentication, Exchange, DNS, and other problems.

Homepage

Download (720kb)

BGInfo - display PC information on the desktop

2007-11-08T10:23:00.001+02:00

How many times have you walked up to a system in your office and needed to click through several diagnostic windows to remind yourself of important aspects of its configuration, such as its name, IP address, or operating system version If you manage multiple computers you probably need BGInfo. It automatically displays relevant information about a Windows computer on the desktop's background, such as the computer name, IP address, service pack version, and more. You can edit any field as well as the font and background colors, and can place it in your startup folder so that it runs every boot, or even configure it to display as the background for the logon screen.

HomePage

Download

Calling delegates using BeginInvoke, Invoke, DynamicInvoke and delegate

2007-11-08T09:51:00.001+02:00

I wanted to write about delegates this month. There are different ways in which you can invoke delegates to get either a synchronous or an asynchronous behavior. But from what I noticed, the delegate model provides you very less control when you invoke it asynchronously. The caller cannot easily abort or terminate the operation.
If you want to execute a delegate asynchronously and still want to have good control from the caller then invoke it explicitly from a thread. The sample below demonstrates multiple ways you can invoke a delegate and each has its own features with it. Till I wrote this, I didn’t realize that there are 6 ways to invoke a delegate and I am sure there are a few more that I am missing here. It was also interesting that when you execute a delegate on a thread then it cannot return a value as the caller of the thread is gone when the thread returns. If you want to pass parameters to the delegate in the thread you can use the ParameterizedThread option which is very useful.

Click here to continue...

Care about Event Memory Leaks with Delegate.GetInvocationList()

2007-10-28T10:39:00.001+02:00

Subscribed events are one of the most common reasons of memory leaks in .Net. This means that if you have an object that has an event
and there are other object that are subscribed to that event, the original object won't be properly disposed until all events are unsubscribed since
an event is a strong reference.
....
public partial class MyForm : Form
 {    
    public event EventHandler OnDoMyFormThing;
    
    public MyForm()
    {
        InitializeComponent();        
    }
    
    private void button1_OnClick
    {
        MessageBox.Show(
           "Test of OnDoMyFormThing event");
        OnDoMyFormThing(this, new EventArgs());
    }
    
    protected override void Dispose(bool disposing)
    {
        if (disposing && (components != null))
        {
            foreach (EventHandler eventDelegate 
             in OnDoMyFormThing.GetInvocationList())
                OnDoMyFormThing -= eventDelegate;
            components.Dispose();
        }
        base.Dispose(disposing);
    }
}

To full article click here

Convert UTF-8 to Unicode

2007-10-23T10:11:00.001+02:00

private static string Utf8ToUnicode(string utf8)
{
    return Encoding.Unicode.GetString(
        Encoding.Convert(
        Encoding.UTF8,
        Encoding.Unicode,
        Encoding.UTF8.GetBytes(utf8)));
}

Strategy Pattern in C# 2.0

2007-10-23T10:07:00.001+02:00

Strategy pattern can very handy when a system designer or architect wants to separate algorithms from the system implementation. Also with strategy pattern approach it is very easy to select between different algorithms on the fly. With the introduction of generics in .NET 2.0 implementing strategy pattern is even more easy.

Click Here

via DotNetKicks.com

Full guide to create Installer class in VS.Net 2005

2007-10-21T10:18:00.001+02:00

6 pages of amazing guide by devCity.net explains all point of deployment project and include follow parts:

Requirements
Terminology
How to create an Installer Class
Un-written rules
Unpleasent features
Using these events (about Installer Class events)
Using the Commit event to change the target directory permissions.
Using the Uninstall event to clean the target directory
Where is the "NT AUTHORITY\SERVICE" account coming from?
Exceptions and Exception handling in your installer class.
Adding user interfaces (forms) to your installer class.
Launching your application after installation.
Conclusions.
References.

To read "Visual Studio 2005 Setup and Deployment Installer Classes and Custom Actions" CLICK HERE

Listas - new feature from Microsoft

2007-10-21T09:58:00.001+02:00

At Live Labs, we are always experimenting with new ideas that we think will be useful. Today we are releasing our latest technology preview:
Listas (http://listas.labs.live.com)
Listas is a tool for the creation, management and sharing of lists, notes, favorites, and more. It allows you to quickly and easily edit lists, share them with others for reading or wiki-style editing, and discover the public lists of other users. We encourage you to try using it for meeting notes, bookmarks, shopping lists, to plan a night out, or whatever other creative ways you can think of....

Creating Custom Configuration Sections In ASP.NET

2007-10-18T10:11:00.001+02:00

Click here

Sharp Cache Session Manager

2007-10-14T09:57:00.001+02:00

The SharpCacheSessionManager is a HttpHandler that allows to display the entries stored in the Cache, Session and Application object. You can view the data stored inside the objects and you can also remove the objects from the corresponding storage. To download the SharpCacheSessionManager click HERE

via Christopher Steen

43 Exceptionally Useful AJAX Applications

2007-10-10T12:11:00.001+02:00

43 extremely useful AJAX applications for use on any website.

Click here

via DotNetKicks.com

Find and get list of controls on page

2007-10-08T13:10:00.001+02:00

If you want to find list of controls on Page you can use this method:

private List<T> GetControls<T>() where T:Control
{
 List<T> list = new List<T>();        
 foreach (Control rootControl in Controls)
 {
    foreach (Control control in rootControl.Controls)
    {
        if (control as T != null)
        {
            list.Add(control as T);
        }
    }
 }
 return list;
}

And a using is very simple. In example you can see how to change background to all labels:

List<Label> list = 
        GetControls<Label>();
list.ForEach(
    delegate (Label lab)
   {
     lab.BackColor = 
       System.Drawing.Color.Pink;
   }
);

A Visual Guide to Version Control

2007-10-07T09:22:00.001+02:00

A beautiful, "highly visual" overview of Version Control, (a.k.a. Source Control). It also references Subversion command line examples, but the overview applies to most version control systems by BetterExplained.

To read a full article click HERE.

How to Use Windows Authentication to Access SQL Server Through a ASP.NET Web Application

2007-10-01T10:34:00.001+02:00

Click here to full article

What is a Fluent Interface?

2007-09-30T12:51:00.001+02:00

Full article "How to design a Fluent Interface", compares and examples see HERE

Get last day of the month

2007-09-30T12:46:00.001+02:00

DateTime GetLastDayOfMonth(DateTime date)

{
return
     new DateTime(date.Year, 
                  date.Month, 
                  DateTime.DaysInMonth(
                         date.Year,
                         date.Month));
}

Accordion 2.0 by Kevin Miller

2007-09-20T13:16:00.001+02:00

Kevin Miller has updated to version 2.0 his extraordinary AJAX control ACCORDION

New futures:

Open/Close functionality added (Click on an active accordion).
Nested Vertical Accordions
Accordions will dynamically resize on content added REAL TIME!
...lots of bug fixes!

Very simple using:

Include 3 JavaScript files to HTML page

<script type="text/javascript" 
src="javascript/prototype.js"></script>
<script type="text/javascript"
src="javascript/effects.js"></script>
<script type="text/javascript"
src="javascript/accordion.js"></script>

and...

<h2 class="accordion_toggle">Title Bar</h2>
<div class="accordion_content">...</div>
...
...
...
<h2 class="accordion_toggle">Title Bar</h2>
<div class="accordion_content">...</div>

More option see here (In toggle "How to use")

SQLQueryStress - T-SQL server query performance testing tool

2007-09-16T11:50:00.001+02:00

Small, effective and free tool for testing performance of the sql query.

Homepage

Download

Labels: Tools

One Shell Command to delete all SVN hidden folders

2007-09-10T10:03:00.001+03:00

Full article

Labels: Programming

Determining when a procedure has been changed

2007-09-09T09:29:00.001+03:00

SELECT 
    [StoredProcedure name]
    ,Modify_date
    ,Create_date
    ,*
FROM
    sys.procedures

Labels: SQL

CSS Table Gallery

2007-09-05T13:18:00.001+03:00

Candy style

Red and Black style

The OC style

To more styles click here

10 SQL Server Functions That You Hardly Use But Should

2007-09-05T11:20:00.001+03:00

A using and explanation next SQL functions:

BINARY_CHECKSUM
SIGN
COLUMNPROPERTY
DATALENGTH
ASCII, UNICODE
NULLIF
PARSENAME
STUFF
REVERSE
GETUTCDATE

Labels: SQL