The Nobels Blog

Config files and XDT or Config Transforms

noreply@blogger.com (Kris Nobels) — Sun, 24 Oct 2010 18:14:00 +0000

In VS 2010 there is a new feature to transform your config file for the active configuration. (for example –> Debug / Release)

All you need to do is right click on the web.config en select config transforms.

Now this feature is only available for Web.config files.

But i google do the search for me and i found a solution for app.config

How you do it can you find out in this blogpost written by Vishal Joshi

Now i work with this technique and i had some problems with the web.config.

Some times i get this message:

It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level.
This error can be caused by a virtual directory not being configured as an application in IIS.

What i did to get it work:

Clean Project
Make shure that the bin folder is empty
Rebuild project
Result --> error is gonne

Enjoy …

Create Journaling on a table for mysql database

noreply@blogger.com (Kris Nobels) — Sun, 11 Jul 2010 08:48:00 +0000

If you have some tables with very sensitive data in it you would create backups.

that is 1 thing, but if somethings wrong you would like to now when and what data is changed.

This is a nice solution that create a copy of table that you would like to monitor.

and add a 3 triggers –> 1 for Insert, update and delete.

If some data is inserted it will be in the journaling table 2.

If Updated or deleted you wil find what is changed in that table.

I created 2 Stored procedures:

SP1 –> to create the second table(copy) with 2 extra colums.

SP2 –> to create 3 triggers

This 2 SP will write the script to a file where you would like to be.

These are my SP code:

CREATE JN_TABLE

DELIMITER $$

USE `YOUR TABLESCHEMA`$$

DROP PROCEDURE IF EXISTS `CreateJNTable`$$

CREATE PROCEDURE `CreateJNTable`(IN tabelnaamostr VARCHAR(64),IN tabelschemastr VARCHAR(64))
BEGIN
-- 1. aanmaken temp table
CREATE TEMPORARY TABLE TMPJN (ID DOUBLE AUTO_INCREMENT KEY,stringval VARCHAR(21844) NOT NULL);
-- 2. aanmaken commentaar
INSERT INTO TMPJN (stringval) VALUES (CONCAT('-- We maken een Journaling tabel aan voor tabel ',tabelnaamostr ,' in tabelschema ',tabelschemastr));
-- 3. 1e lijn stuk text toevoegen
INSERT INTO TMPJN (stringval) VALUES (CONCAT('Create table ',tabelnaamostr,'_JN('));
-- 4. We gaan de Kolom namen toevoegen + hun datatype en een comma er achter
INSERT INTO TMPJN (stringval)
SELECT CONCAT(column_name,' ', Column_type,',') AS result
FROM information_schema.columns WHERE table_name= tabelnaamostr AND TABLE_Schema = tabelschemastr ;
-- 5. We gaan de andere 2 kolomen toevoegen die nodig zijn voor de Journaling
INSERT INTO TMPJN (stringval) VALUES ('RowAction varchar(1),');
INSERT INTO TMPJN (stringval) VALUES ('Tijdstip DateTime);');
-- 6. We schrijven dit alles weg naar en file op onderstaande locatie
SELECT stringval FROM TMPJN INTO OUTFILE '\\\\\192.168.0.13\\Divers\\CreateJNTable.sql';
-- 7. Tot slot deleten we de tmp tabel
DROP TEMPORARY TABLE TMPJN;
END$$

DELIMITER ;

And

CREATE JN_TRIGGERS

DELIMITER $$

USE `YOUR TABLESCHEMA`$$

DROP PROCEDURE IF EXISTS `CreateJNTriggers`$$

CREATE PROCEDURE `CreateJNTriggers`(IN tabelnaamostr VARCHAR(64),IN tabelschemastr VARCHAR(64))
BEGIN
-- 1. aanmaken temp table
CREATE TEMPORARY TABLE TMPJN (ID DOUBLE AUTO_INCREMENT KEY,stringval VARCHAR(21844) NOT NULL);
-- 2. Toevoegen van vaste script lijnen
INSERT INTO TMPJN (stringval) VALUES ('DELIMITER $$');
INSERT INTO TMPJN (stringval) VALUES (CONCAT('USE ',tabelschemastr,' $$'));
-- ************************************************************************************************************************
-- *                                                INSERT Trigger                                                        *
-- ************************************************************************************************************************
INSERT INTO TMPJN (stringval) VALUES ('--');
INSERT INTO TMPJN (stringval) VALUES ('--');
INSERT INTO TMPJN (stringval) VALUES (CONCAT('-- We maken een insert trigger aan voor tabel ',tabelnaamostr ,' in tabelschema ',tabelschemastr));
INSERT INTO TMPJN (stringval) VALUES (CONCAT('DROP TRIGGER IF EXISTS TR_',tabelnaamostr,'_Insert $$'));
INSERT INTO TMPJN (stringval) VALUES (CONCAT('CREATE TRIGGER TR_',tabelnaamostr,'_Insert AFTER INSERT ON ', tabelnaamostr));
INSERT INTO TMPJN (stringval) VALUES ('FOR EACH ROW BEGIN');
INSERT INTO TMPJN (stringval) VALUES (CONCAT('INSERT INTO ',tabelnaamostr,'_JN('));
-- 3. Toevoegen van colomnamen van de Journaling tabel waar we de data gaan in stoppen
INSERT INTO TMPJN (stringval)
SELECT CONCAT(column_name,',') AS result
FROM information_schema.columns WHERE table_name = CONCAT(tabelnaamostr,'_JN') AND TABLE_Schema = tabelschemastr ;
-- 4. variable om tijdelijk de max ID bij te houden
SET @MaxID := 0;
-- 5. we stoppen de max id er in.
SELECT @MaxID := MAX(ID) FROM TMPJN;
-- 6. we gaan de laaste waarde de , er uit halen want die hoeft daar niet te staan. (anders sintax fout)
UPDATE TMPJN SET stringval = REPLACE(stringval,',',')') WHERE id = @MaxID;
-- 7. Toevoegen van vaste script lijnen  
INSERT INTO TMPJN (stringval) VALUES ('VALUES(');
-- 8. Toevoegen van kolomnamen met een prefix van new. zonder de laatse 2 kolommen er bij
INSERT INTO TMPJN (stringval)
SELECT CONCAT('new.',column_name,',') AS result
FROM information_schema.columns WHERE table_name = CONCAT(tabelnaamostr,'_JN') AND TABLE_Schema = tabelschemastr AND  column_name NOT IN ('RowAction','Tijdstip');
-- 9. Toevoegen van vaste script lijnen
INSERT INTO TMPJN (stringval) VALUES ('\'I\',');
INSERT INTO TMPJN (stringval) VALUES ('NOW());');
INSERT INTO TMPJN (stringval) VALUES ('END;');
INSERT INTO TMPJN (stringval) VALUES ('$$');
-- ************************************************************************************************************************
-- *                                                UPDATE Trigger                                                        *
-- ************************************************************************************************************************
INSERT INTO TMPJN (stringval) VALUES ('--');
INSERT INTO TMPJN (stringval) VALUES ('--');
INSERT INTO TMPJN (stringval) VALUES (CONCAT('-- We maken een Update trigger aan voor tabel ',tabelnaamostr ,' in tabelschema ',tabelschemastr));
INSERT INTO TMPJN (stringval) VALUES (CONCAT('DROP TRIGGER IF EXISTS TR_',tabelnaamostr,'_Update $$'));
INSERT INTO TMPJN (stringval) VALUES (CONCAT('CREATE TRIGGER TR_',tabelnaamostr,'_Update AFTER Update ON ', tabelnaamostr));
INSERT INTO TMPJN (stringval) VALUES ('FOR EACH ROW BEGIN');
INSERT INTO TMPJN (stringval) VALUES (CONCAT('INSERT INTO ',tabelnaamostr,'_JN('));
INSERT INTO TMPJN (stringval)
SELECT CONCAT(column_name,',') AS result
FROM information_schema.columns WHERE table_name = CONCAT(tabelnaamostr,'_JN') AND TABLE_Schema = tabelschemastr ;
-- 4. variable om tijdelijk de max ID bij te houden
SET @MaxID := 0;
-- 5. we stoppen de max id er in.
SELECT @MaxID := MAX(ID) FROM TMPJN;
-- 6. we gaan de laaste waarde de , er uit halen want die hoeft daar niet te staan. (anders sintax fout)
UPDATE TMPJN SET stringval = REPLACE(stringval,',',')') WHERE id = @MaxID;   
INSERT INTO TMPJN (stringval) VALUES ('VALUES(');
INSERT INTO TMPJN (stringval)
SELECT CONCAT('new.',column_name,',') AS result
FROM information_schema.columns WHERE table_name = CONCAT(tabelnaamostr,'_JN') AND TABLE_Schema = tabelschemastr AND  column_name NOT IN ('RowAction','Tijdstip');
INSERT INTO TMPJN (stringval) VALUES ('\'U\',');
INSERT INTO TMPJN (stringval) VALUES ('NOW());');
INSERT INTO TMPJN (stringval) VALUES ('END;');
INSERT INTO TMPJN (stringval) VALUES ('$$');
-- ************************************************************************************************************************
-- *                                                DELETE Trigger                                                        *
-- ************************************************************************************************************************
INSERT INTO TMPJN (stringval) VALUES ('--');
INSERT INTO TMPJN (stringval) VALUES ('--');
INSERT INTO TMPJN (stringval) VALUES (CONCAT('-- We maken een Delete trigger aan voor tabel ',tabelnaamostr ,' in tabelschema ',tabelschemastr));
INSERT INTO TMPJN (stringval) VALUES (CONCAT('DROP TRIGGER IF EXISTS TR_',tabelnaamostr,'_Delete $$'));
INSERT INTO TMPJN (stringval) VALUES (CONCAT('CREATE TRIGGER TR_',tabelnaamostr,'_Delete AFTER Delete ON ', tabelnaamostr));
INSERT INTO TMPJN (stringval) VALUES ('FOR EACH ROW BEGIN');
INSERT INTO TMPJN (stringval) VALUES (CONCAT('INSERT INTO ',tabelnaamostr,'_JN('));
INSERT INTO TMPJN (stringval)
SELECT CONCAT(column_name,',') AS result
FROM information_schema.columns WHERE table_name = CONCAT(tabelnaamostr,'_JN') AND TABLE_Schema = tabelschemastr ;
-- 4. variable om tijdelijk de max ID bij te houden
SET @MaxID := 0;
-- 5. we stoppen de max id er in.
SELECT @MaxID := MAX(ID) FROM TMPJN;
-- 6. we gaan de laaste waarde de , er uit halen want die hoeft daar niet te staan. (anders sintax fout)
UPDATE TMPJN SET stringval = REPLACE(stringval,',',')') WHERE id = @MaxID;   
INSERT INTO TMPJN (stringval) VALUES ('VALUES(');
INSERT INTO TMPJN (stringval)
SELECT CONCAT('OLD.',column_name,',') AS result
FROM information_schema.columns WHERE table_name = CONCAT(tabelnaamostr,'_JN') AND TABLE_Schema = tabelschemastr AND  column_name NOT IN ('RowAction','Tijdstip');
INSERT INTO TMPJN (stringval) VALUES ('\'D\',');
INSERT INTO TMPJN (stringval) VALUES ('NOW());');
INSERT INTO TMPJN (stringval) VALUES ('END;');
INSERT INTO TMPJN (stringval) VALUES ('$$');
-- Vaste scriptlijn toevoegen
INSERT INTO TMPJN (stringval) VALUES ('DELIMITER ;');
-- weg schrijven van de gegevens
SELECT stringval FROM TMPJN INTO OUTFILE '\\\\\192.168.0.13\\Divers\\CreateJNTriggers.sql';
-- Tot slot deleten we de tmp tabel
DROP TEMPORARY TABLE TMPJN;
END$$

DELIMITER ;

After that you can call SP like this:

CALL CreateJNTable('TABLENAME','YOUR TABLESCHEMA');

CALL CreateJNTriggers('TABLENAME','YOUR TABLESCHEMA');

Write Mysql output to file

noreply@blogger.com (Kris Nobels) — Tue, 29 Jun 2010 20:25:00 +0000

This is what i use to write the SQL output to a filedrive:

SELECT 1 FROM DUAL INTO OUTFILE '\\\\\192.168.0.13\\Divers\\demo.sql';

Note: you can write only once like this, otherwise you get message that the file exists. :-)

This example shows how to create dynamic name:

CREATE PROCEDURE export_dynamic(IN file_name CHAR(64))
BEGIN
SET @myvar = CONCAT('SELECT * INTO OUTFILE ',"'",file_name,"'",' FROM Table1') ;
PREPARE stmt1 FROM @myvar;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;
END;

New RSS Feed URL

noreply@blogger.com (Kris Nobels) — Tue, 22 Jun 2010 07:13:00 +0000

I use feedburner now as RSS feed URL.

Please use this RSS feed url:

http://feeds2.feedburner.com/KrisNobels

Thanks

Customize Setup wizard with your Company Logo

noreply@blogger.com (Kris Nobels) — Tue, 22 Jun 2010 07:03:00 +0000

Download Windows Installer SDK.
In it you will find a Orca.msi. install it.
With explorer browse to C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\Tools\Deployment\VsdDialogs.
There you will find a subfolder for most cultures.
Go to the culture subfolder you're using.
Open VsdUserInterface.wim with Orca. (or download here)
In the binary table you'll find a row with name DefBannerBitmap.
Double click [Binary Data] to select your own banner image file (jpg or bmp, not gif). It has to have a width of 500 pixels and a height of 70 pixels.
Store the VsdUserInterface.wim.
Build the setup projects again with having the BannerBitmap property refering to Default.

Change dot "." to Comma "," with javascript

noreply@blogger.com (Kris Nobels) — Sun, 25 Jan 2009 10:07:00 +0000

Here is the syntax to change your dot to comma.
Very handy because your hand stays in the nummeric area of your keyboard.

<html>
<head>

<script type="text/javascript">
   function DotToComma(that) {
        if (that.value.indexOf(".") >= 0) {
            that.value = that.value.replace(".",",");
        }
   }
</script>

</head>
<body>
<input type="text" name="txt" onkeyup="DotToComma(this);">
</body>
</html>

On a .ASPX page you would have something inside like this:

<asp:textbox id="TextBox1" runat="server" text="Sample Text" 
  onkeyup="DotToComma(this);" />

Export Gridview to Excel with ASP.NET (workaround)

noreply@blogger.com (Kris Nobels) — Wed, 09 Jul 2008 12:13:00 +0000

Today I had to create a grid in ASP.Net. But i had this problem when i created the export to Excel:
'GridView' must be placed inside a form tag with runat=server

My gridview was inside the form ???

So this is the workaround i found:

This is the normal function for the export to Excel:

Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=filename.xls");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
GridView1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();

/* Confirms that an HtmlForm control is rendered for the specified ASP.NET server control at run time. */
public override void VerifyRenderingInServerForm(Control control){}

Just insert this inside your code behind:

More info you can find here @ microsoft (Microsoft has accepted it as bug)

List of software to install on Clean OS

noreply@blogger.com (Kris Nobels) — Sat, 22 Mar 2008 08:21:00 +0000

List of default items to Install:

Notepad++
Silverlight 2 RTW (2.0.31005.0)
ASP.NET AJAX 1.0
Flash player
Dot Net framework (comes with Microsoft update 2)
- Version 1.0 (SP3)
- Version 1.1 (SP1)
- Version 2.0 x86 (SP1 x86)
- Version 3.0 (SP1)
- Version 3.5
Firefox Browser
Addons for Firefox:
- IE Tab
- Customize google (Enhance Google search results, Remove advertizing, ...)
- Del.ico.us bookmarks (Access and manage your bookmarks wherever you are)
- Download Statusbar (View and manage downloads from a tidy statusbar - without the download window getting in the way of your web browsing.)
- Email This! (Send URL in 1 click)
- Greasemonkey (Allows you to customize the way a webpage displays using small bits of JavaScript.)
  Userscripts for Greasmonkey
1. GoogleMonkeyR
2. Live Hotmail Companion (remove advertise on top)
- GreaseFire Automatically find Greasemonkey scripts on Userscripts.org (requires Greasemonkey)
- Google Kladblok
- Access Me (Access vulnerabilities in an application can allow an attacker to access resources without being authenticated.)
- SQL Inject Me (SQL Injection vulnerabilites can cause a lot of damage to a web application.)
Unlocker (Unlock locked files) very handy !
Winsnap (Utility for taking and editing screenshots NOT Free anymore)
Google Talk (Chat tool)
MSN Messenger (Chat tool) + Mess Messenger (Remove advertising, ... Tweak tool)
Winrar (Compress and decompress tool)
Paint.net
Adobe Pdf reader
Copy path to clipboard
Deamon Tools (DAEMON Tools enabling you to use your CD/DVD images as if they were already burned to CD/DVD.)

List of Software you need as .NET developer:

SQL Server 2005 Express Edition SP2 (Database)
Subversion (Version control system)
TortoiseSVN (easy to use Revision control / version control / source control software for Windows. It is based on.)
Reflector (Reflector is the class browser, explorer, analyzer and documentation viewer for .NET)
Cool Commands for Visual Studio 2008 plugin or Coolcommands for Visual studio 2005
Resharper (Visual Studio Add-In NOT Free)
Winmerge (Comparer for directorys or files)
Process Explorer (More advanced process explorer)
LLBLGen Pro (ORM mapper)

RightHand.DataSet.Visualizer
Advanced quickwatch dataset vizualizer

List of software you need as web developer:

Colorpic (grab the color from 1 pixel)
Fiddler (Fiddler is a HTTP Debugging Proxy which logs all HTTP traffic between your computer and the Internet)
Addons for Firefox:
- Web Developer (Adds a menu and a toolbar in Firefox with various web developer tools.)
- Internet Explorer Developer tool bar
- Window Resizer
- Firebug
- DOM Inspector
- MeasureIt (Draw out a ruler to get the pixel width and height of any elements on a webpage.)

List of software that is handy:

Virtual PC (Run other OS in Virtual mode)
Windows Live Writer (Tool for writing blogposts)
MP3TAG Edit your Metadata of common audio formats. Add Pciture, full song info, ...

List working with Silverlight:

Silverlight SDK 1.0
Silverlight SDK 1.1
Silverlight SDK 2.0
Microsoft Silverlight Tools for Visual Studio 2008 SP1 (for Silverlight 2)
Microsoft Expression Blend™ 2 Service Pack 1

Handy Stuff you would like:

XP Royal Theme (nice theme for XP)
Bulk rename tool (fast and very nice rename tool)
Auto Shut down
Zoomit (nice zoom tool for presentations)
Powertoys for Windows XP
Visual Task Tips (Show tiny screenshot)
Windows Live Writer (Blog tool)
- Syntax Highlighting plugin
Filezilla (FTP tool)
Terracopy (copy past tool where you can change the buffersize)
DScaler Deinterlacer/Scaler (Play DVD's with Windows Real player)
Media player plugins

If you have a handy ore better tool please let me now. :-)

Kris Nobels

-- = Last updated 19-03-2009 = --

Handy stuff when you work with MS SQL Database

noreply@blogger.com (Kris Nobels) — Tue, 12 Feb 2008 10:33:00 +0000

GENERAL REMARK:
SQL SERVER IS IN MOST CASES INSTALLED CASE INSENSITIVE
IF INSTALLED CASE SENSITIVE USE UCASE('YOUR_VALUE')

The select for finding all Stored (P) Procedures, (TR) Triggers, (V) Views, (FN) scalar functions, (TF) Table valued Functions, (IF) inline table valued functions, (RF) replication filter procedures and (R) rules where you use some specific text:

SELECT *
FROM sys.sql_modules m INNER JOIN
sys.objects o ON m.object_id = o.object_id
WHERE definition LIKE '%YOUR_VALUE%';

Statement that returns all tables and views where column is used:

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'YOUR_VALUE';

Select statement for finding the indexes use on some Column name:

SELECT * 
from sys.index_columns ic INNER JOIN
sys.columns o ON ic.object_id = o.object_id AND ic.column_id = o.column_id INNER JOIN
sys.tables t ON ic.object_id = t.object_id INNER JOIN
sys.indexes i ON ic.object_id = i.object_id AND ic.index_id = i.index_id
WHERE o.name = 'YOUR_VALUE'

Select statement for finding constraints use on some column name:

SELECT * 
FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
WHERE COLUMN_NAME = 'YOUR_VALUE';

Handy stuff when you work with oracle Database

noreply@blogger.com (Kris Nobels) — Mon, 11 Feb 2008 13:30:00 +0000

When a database is so big and you do not now where to start, here are some helpfull selectstatements.

Let oracle search it for you.

Here are some usefull Selects:

The select for finding all Stored Procedures where you use some specific text
select * from all_source where Upper(text) like Upper('%YOUR_VALUE_TO_SEARCH%');
Select statement where you use the column name in a table
select * from all_tab_columns where column_name = Upper('YOUR_VALUE_TO_SEARCH');
Selectstatement for finding the indexes use on some Column name
select * from all_ind_columns where column_name = Upper('YOUR_VALUE');
Select statement for finding constraints use on some column name
select * from all_cons_columns where column_name = Upper('YOUR_VALUE');

Performace Tips:

Find the record count , the fastest way
Select Count(0) from TABLENAME;
Left join is slower against Inner join.

Reason:
When you use * it uses a varchar, when you use a number is it faster. there is no cast form varchar to Integer

Update TableName set Columname = 1 where CMD_ID in (Select CMD_ID from TableName)
the updatestatement above works but slow, use this instead:
Update TableName1 set Columname = 1
where exists (
Select 1 from TableName2
where TableName1.CMDID = TableName2.CMDID
)
Write a select statement that works faster
Select id, name, firstname, function
from functionlist FL
inner join person P on P.personid = FL.id
inner join functions F on F.functionid = FL.idfunction
If table contains something like
Select 1 from TableName where rownum < 2
The database stops searching when it finds the first item.

Oracle Version

select * from v$version
select * from product_component_version;

Customize or tweak your Vista

noreply@blogger.com (Kris Nobels) — Sun, 03 Feb 2008 21:53:00 +0000

Here is an overview what i did when you install Vista.

STEP 1 : Create partition --> Use BootIt to create my partition and choose type NTFS (walkthrough for using BootIt)
STEP 2 : Boot from Disk --> Easy, just put the DVD in boot drive and restart computer
STEP 3 : Disable UAC --> (you can do this in 4 ways) See this post on how to disable UAC.
STEP 4 : Disable the Warning Icon (now that UAC is turned off)

Right-click the Security Center icon in the notification tray, select Open Security Center.
In the Security Center window, click on the "Change the way Security Center alerts me"
In the "Do you want to be notified of security issues" window click on "Don't notify me and don't display the icon (not recommended)".

STEP 5 : Install Anti-virus --> for example Avast it's free :-)
STEP 6 (optional) : Startup without logging in.
When using the PC @ home, and it is difficult to login each time. You can open Start and enter in the Searchbox "netplwiz".
You will see a window useraccounts. Select the box and it will be turned off. (confirm by entering 2 times your password to be sure)

Tip: If you have a program that stops working in vista, you can run that program in XP mode.

Cleaning up transaction log from database

noreply@blogger.com (Kris Nobels) — Tue, 29 Jan 2008 07:50:00 +0000

I had a problem with cleaning up logfiles from some database.
But when the script does not work you have to search an other way.

I found a solution to clean up the logfiles, it's not a neat one but it works.

Follow these 3 steps:

Detach the database
rename the LDF
Attach again.
It will alert you to the fact that there's no log file, and will create a fresh one for you.
(The log file has shrunk from 1Gb to 700k)

Always show solution in Visual Studio

noreply@blogger.com (Kris Nobels) — Thu, 22 Nov 2007 15:49:00 +0000

I installed Visual Studio Team System on my laptop. When i have created a new Solution you see this in your Solution Explorer. On your Solution you can now add projects. What i did is click right on the solution in the solution explorer and select "add new Project". After the creation of the project you only see the project in the solution explorer. To add a second project you can go to File -> new project. In that form you have to select "add to solution" and your "location of the project". (After that the solution is visible again.)
But you can set view "Always show solution" on like this:

Select tools in menu
options
collapse tree structure and go to "Projects and Solutions"
there you can activate "Always show Solution"

noreply@blogger.com (Kris Nobels) — Tue, 06 Nov 2007 08:59:00 +0000

I have a daily job to create a backup from a file. But each backup must have a different name.
What i did is create a schedule job on my XP machine with .BAT file that runs every day.

The hard thing in Dos is giving a name that is unique.

Here are the doscommands:

@echo off
for /F "tokens=2-4 delims=/ " %%i in ('date /t') do set yyyymmdd=%%k%%i%%j
echo Date: %yyyymmdd%
for /F "tokens=1-2 delims=: " %%l in ('time /t') do set hhmm=%%l%%m
echo Time: %hhmm%
rem -- or use both
echo %yyyymmdd%%hhmm%
rem -- here is the copy command with just the date appended

REN E:\Sx3\FTP\pl.txt pl%yyyymmdd%%hhmm%.txt
REN E:\Sx3\FTP\llpg.txt llpg%yyyymmdd%%hhmm%.txt

overview parameters you find here

Dev Days 2007 materials and more ...

noreply@blogger.com (Kris Nobels) — Thu, 05 Apr 2007 08:31:00 +0000

Here you go ...

You can download powerpoints from the Dev Days 2007 @ Ghent here
Jeff Promise code samples on ASP.net Ajax, Burton and WPF/E (samples about Asynchronous ASP.NET are coming later on)
Raj Pai codesamples on LINQ, a set of updated samples for the Visual Studio Orcas March CTP
Peter Himschoot on WPF DataBinding Explained

Other event materials:

I found some codesamples from devweek here.
Session materials from Thinktecture @ DevWeek.
Session materials from Jeff Promise on "Introducing ASP.NET AJAX - The ASP.NET 2.0 AJAX Extensions".

Enjoy :-)

Fix to copy large files in vista faster

noreply@blogger.com (Kris Nobels) — Wed, 04 Apr 2007 21:30:00 +0000

Yes, the title is correct ! Vista has problems with copy large files.

This happens especially with mapped drives but it could also be that you witness network disconnects.

The problem is caused by a new feature called Auto Tuning which is by default enabled in Microsoft Windows Vista. What Auto Tuning does is that it reacts on changes in the network by tuning the receive windows size. The solution would be of course to disable Auto Tuning in Vista. Some users reported that disabling Auto Tuning had a positive effect.

Here are workarounds from Support Microsoft website to of from earlier OS.

To disable Auto Tuning and speed up the copy process and avoid timeouts and disconnects do the following:

Open a command prompt and type the following:

netsh int tcp set global autotuninglevel=disabled

To turn it on again:

netsh int tcp set global autotuninglevel=normal

GetOrdinal example

noreply@blogger.com (Kris Nobels) — Tue, 13 Mar 2007 10:27:00 +0000

When you use the ExecuteReader,
you have to select the fields created from the select statement.

There you have to be carefull with the numbers you give in the reader.

Here is the example using a MySQL database:

String select = "Select id, first_name, last_name, nickname from table_name" 
MySqlCommand command = new MySqlCommand(); 
MySqlDataReader reader; 
MakeConnection(); 
command.Connection = connect;
command.CommandText = select;
reader = command.ExecuteReader();
while (reader.Read())
{ 
//-> Fist column selected
int id = reader.GetInt32(0);
//->Second Column Selected
string FirstName = reader.GetString(1) ;
//->3é Column Selected
string LastName = reader.GetString(2) ;
//->Last Column Selected
string NickName = reader.GetString(3) ; 
} 
MakeDisconnection();

But when you change the select statement you have to pay attention that the order is exact the same order for the reader.

By Using the GetOrdinal is the possiton not a problem anymore.

This example show's the use of GetOrdinal:
(Only the select statement is changed by order.)

String select = "Select nickname, last_name, first_name, id from table_name" 
MySqlCommand command = new MySqlCommand(); 
MySqlDataReader reader; 
MakeConnection(); 
command.Connection = connect;
command.CommandText = select;
reader = command.ExecuteReader();
while (reader.Read())
{
//-> Fist column selected
int id = rdr.GetInt32(rdr.GetOrdinal("id"));
//->Second Column Selected
string FirstName = reader.GetString(rdr.GetOrdinal("first_name")) ;
//->3é Column Selected
string LastName = reader.GetString(rdr.GetOrdinal("last_name")) ;
//->Last Column Selected
string NickName = reader.GetString(rdr.GetOrdinal("nickname")) ; 
} 
MakeDisconnection();

This works and you don't have any troubles with the order.

Validate value on DBNull

noreply@blogger.com (Kris Nobels) — Sat, 10 Mar 2007 13:56:00 +0000

You need a specific value from a datareader, and it is possible that the value is DBNull.
This way we validate the value on DBNull.

if (!reader.GetValue(6).Equals(System.DBNull.Value))
{
tempr.aantalPlaten = reader.GetInt32(6);
}