July | 2007 | Emad's Blog

Archive for July, 2007

A nice collection of short “how do I?” videos from microsoft covering a wide variety of technologies: ASP.NET, SQL EXPRESS, AJAX, VS Team syste, etc.

An Easy way to add an Identity column to a table created by SELECT .. INTO is:

Assume the table is created using

SELECT NAME INTO NAMES2 FROM NAMES1

simply add this,

SELECT IDENTITY(INT, 1,1) AS [ID], NAME INTO NAMES2 FROM NAMES1

A single line makes all the difference when using log4net with .NET 2.0

log4net.Config.DOMConfigurator.Configure();

If this line is not included, log4net will not work at all.

This Exeption may rise when trying to Fill a table using a Table adapter.

One of the reasons this may happen is if the SQL statement is not Selecting a column that is not null in the DB

for example :

if table has field1, field2, field3 and all do not allow null, This exception will be thrown if you try SELECT field1, field2 from Table.

Of course, there may be other reasons for the excption like actually violating a constraint 🙂