re: Row Size limitation in SQL 2000 and 2005

Tony Martin — Tue, 05 Jun 2012 19:30:55 GMT

Thank you very much for this great information.

re: How to bind a DataGridView column to a second-level property of a data source

ahole *** — Sun, 08 Apr 2012 21:20:13 GMT

hey Linda Liu where is some source code for download you stupid *** ***.

As usual article is crapola and author is some foreign half burnt ***

re: Row Size limitation in SQL 2000 and 2005

Rahul — Thu, 21 Jul 2011 10:07:35 GMT

I am getting same error i think it is not resolved in 2005

re: Amazing SSIS: Parameters in Execute SQL Task

vinod — Tue, 29 Mar 2011 06:38:23 GMT

what is the best way to log execution details into a table ETL_Audit_Log as long as usage of INSERT statement holds good with sql INSERT or sp with INSERT

e.g, direct SQL in execute sql task : INSERT into ETL_Audit_Log(P_Name, PStartDate) values(@pack_name, @start_time)

create proc log_details (@pack_name varchar(100), @start_time datetime) as begin INSERT into ETL_Audit_Log(P_Name, PStartDate) select @pack_name, @start_time end

re: How to bind a DataGridView column to a second-level property of a data source

Deeps — Tue, 08 Mar 2011 21:23:10 GMT

Overriding the CellFormatting event described by Guillermo works like a charm!

re: How to bind a DataGridView column to a second-level property of a data source

Bernardo — Tue, 18 Jan 2011 22:11:07 GMT

The code below implements a DeepBindingList<T> class that exposes nested properties (to any level). It also supports sorting. I hope it's useful to some of you:

using System;

using System.ComponentModel;

using System.Collections.Generic;

using System.Text;

namespace DeepBindingList

{

/// <summary>

/// Extends the BindingList<T> to provide sorting and deep property

/// binding (e.g. Address.Street).

/// </summary>

public class DeepBindingList<T> : BindingList<T>, ITypedList

{

//-----------------------------------------------------------------------

#region ** IBindingList overrides (to provide sorting)

PropertyDescriptor _sort;

ListSortDirection _direction;

protected override bool IsSortedCore

{

get { return _sort != null; }

}

protected override void RemoveSortCore()

{

_sort = null;

}

protected override ListSortDirection SortDirectionCore

{

get { return _direction; }

}

protected override PropertyDescriptor SortPropertyCore

{

get { return _sort; }

}

protected override bool SupportsSortingCore

{

get { return true; }

}

protected override void ApplySortCore(PropertyDescriptor pd, ListSortDirection direction)

{

// get list to sort

var items = this.Items as List<T>;

// apply the sort

if (items != null)

{

var pc = new PropertyComparer<T>(pd, direction);

items.Sort(pc);

}

// save new settings and notify listeners

_sort = pd;

_direction = direction;

this.OnListChanged(new ListChangedEventArgs(ListChangedType.Reset, -1));

}

// PropertyComparer (used to sort the list)

class PropertyComparer<TC> : IComparer<TC>

{

PropertyDescriptor _pd;

ListSortDirection _direction;

public PropertyComparer(PropertyDescriptor pd, ListSortDirection direction)

{

_pd = pd;

_direction = direction;

}

public int Compare(TC x, TC y)

{

try

{

var v1 = _pd.GetValue(x) as IComparable;

var v2 = _pd.GetValue(y) as IComparable;

int cmp =

v1 == null && v2 == null ? 0 :

v1 == null ? +1 :

v2 == null ? -1 :

v1.CompareTo(v2);

return _direction == ListSortDirection.Ascending ? +cmp : -cmp;

}

catch

{

return 0; // comparison failed...

}

#endregion

//-----------------------------------------------------------------------

#region ** ITypedList (to expose inner properties)

public PropertyDescriptorCollection GetItemProperties(PropertyDescriptor[] listAccessors)

{

var list = new List<PropertyDescriptor>();

foreach (PropertyDescriptor pd in TypeDescriptor.GetProperties(typeof(T)))

{

AddProperties(pd, null, list);

}

return new PropertyDescriptorCollection(list.ToArray());

}

void AddProperties(PropertyDescriptor pd, PropertyDescriptor parent, List<PropertyDescriptor> list)

{

// add this property

pd = new DeepPropertyDescriptor(pd, parent);

list.Add(pd);

// and subproperties for non-value types

if (!pd.PropertyType.IsValueType && pd.PropertyType != typeof(string))

{

foreach (PropertyDescriptor sub in TypeDescriptor.GetProperties(pd.PropertyType))

{

AddProperties(sub, pd, list);

}

public string GetListName(PropertyDescriptor[] listAccessors)

{

return null;

}

// property descriptor with support for sub properties (e.g. Address.Street)

class DeepPropertyDescriptor : PropertyDescriptor

{

PropertyDescriptor _pd;

PropertyDescriptor _parentPD;

public DeepPropertyDescriptor(PropertyDescriptor pd, PropertyDescriptor parentPd)

: base(pd.Name, null)

{

_pd = pd;

_parentPD = parentPd;

}

public override string Name

{

get

{

return _parentPD != null

? string.Format("{0}.{1}", _parentPD.Name, _pd.Name)

: _pd.Name;

}

public override bool IsReadOnly

{

get { return _pd.IsReadOnly; }

}

public override void ResetValue(object component)

{

_pd.ResetValue(component);

}

public override bool CanResetValue(object component)

{

return _pd.CanResetValue(component);

}

public override bool ShouldSerializeValue(object component)

{

return _pd.ShouldSerializeValue(component);

}

public override Type ComponentType

{

get { return _pd.ComponentType; }

}

public override Type PropertyType

{

get { return _pd.PropertyType; }

}

public override object GetValue(object component)

{

if (_parentPD != null)

{

component = _parentPD.GetValue(component);

}

return _pd.GetValue(component);

}

public override void SetValue(object component, object value)

{

_pd.SetValue(_parentPD.GetValue(component), value);

OnValueChanged(component, EventArgs.Empty);

}

#endregion

}

re: Call C# class library from native C++ code

Coder — Mon, 22 Nov 2010 18:43:38 GMT

Thanks for posting these links, very helpful! :-)

http://www.codeobsessed.com/

re: MSDN Managed Newsgroup Support Service Introduction

Mon, 18 Oct 2010 12:04:00 GMT

It is great there's now a support community fot the MSDN.

re: How to debug application crash/hang in production environment?

Vishal — Thu, 07 Oct 2010 08:26:20 GMT

For educational resources on this and related topics that might prove useful in clarifying and expanding upon the ideas in this article, see the new BTM Industry Portal: www.businesstransactionmanagement.com

re: What’s new in Microsoft Visual SourceSafe 2005?

iurtz — Thu, 26 Aug 2010 14:36:04 GMT

VSS2005 allows you to use a 3rd party diff tool. The built in one really sucks in my opinion, so that was my major motivation for upgrading.

MSDN Managed Newsgroup Support Team Blog - All Comments

re: Row Size limitation in SQL 2000 and 2005

re: How to bind a DataGridView column to a second-level property of a data source

re: Row Size limitation in SQL 2000 and 2005

re: Amazing SSIS: Parameters in Execute SQL Task

re: How to bind a DataGridView column to a second-level property of a data source

re: How to bind a DataGridView column to a second-level property of a data source

re: Call C# class library from native C++ code

re: MSDN Managed Newsgroup Support Service Introduction

re: How to debug application crash/hang in production environment?

re: What’s new in Microsoft Visual SourceSafe 2005?