Content of Michael Kaplan's personal blog not approved by Microsoft (see disclaimer)! 

My oldest active Suggestion Box question (from Stef) is:

Hey, I'm a IT Student and at home i work alot with access.

'i work alot with' means that i made 3 db's projects that are 'Finished'.

Now working on the fourth i'm getting smarter and better,...

I learnt to split my db, but this last thing realy bite me

I'm having huge problems updating my older be version to a newer be version.

I know that you will say now use the Sync method!!! of the replica object...

But the 2 db's one of the costumer and my own are not linked in any way, I can only walk to the place and insert my usb drive. and your website sais don't use it when your moving your db around since it will create another replica wich is very bad. So i didn't use it.

Now, what would be the best way to update my backend with let's say 1 new table and 5 new fields in that table and 100 rows of data on the older db all have to be transported to my new version automaticely with the push of a button.

aren't computers made for this? :d

Sorry it took so long to get to this one, Stef. It is just that I am a lot of years out of Jet replication work (my last active development project that used replication was at least eight years ago). :-)

But there are many problems with using Jet replication for this scenario....

The problem you were hitting with removable storage? That's the old illegal move/copy problem wth replicas.

Add to that Microsoft has never gone out of its way to get behind the technology at all (and now in Access 2007 Microsoft uses their new fike format option to disallow replication -- a definite indication that they want to de-emphasize it even further!

Anyway, I usually point people to solutions like Tony Toews and his Auto FE Updater and/or Bob Laraon and his Auto Updater for Backend Databases, instead. :-)

In other news -- Limonata and Fruity Cheerios: yet another great combination (and good for you, too!).

 

This blog brought to you by ␖ (U+2416, aka SYMBOL FOR SYNCHRONOUS IDLE)

Example of generic ASP.NET code-behind for CRUD of any NHibernate entity.

Unity, the next object builder, had been released yesterday to the wild !

During the preparation for TechEd's Prism deck I've got into core relationship with this new DI Container from Microsoft. One of the patterns which are the basis of Prism is Dependency Injection and as such Prism is designed to use a facade which will enable us to choose our own preferred DI container. Of course we need a default DI container and Unity is the one.

So hurry up and download it over here

Must read:

http://janvandenbeld.blogspot.com/2008/04/hypocrisy.html

Full implementation of a reusable DNS resolver component and a Dig.Net example application

This article will show how to convert an existing ASP.NET application into a SharePoint site using the same look and feel of a SharePoint site

TechEd Eilat only starting officially tomorrow but for me its already stated on Thursday when I picked up Glenn Block from the airport.

On Thursday's evening we had a great dinner and lots of geek discussions around the table, well what can you expect if you put Roy, Udi, me, Itay, Glenn and Oren on the same table.

During the talk Glenn showed his way to educate programmers to use patterns & practices products.

And since then... during the last couple of days and nights (yesterday... Friday night... we worked till 3am) we are working together in preparing our PRISM deck, so although the PRISM deck turned out to be the last TechEd's Deck (Last day, last deck) if you want to learn what PRSIM is all about... don't forget to show up.

DEV432 - Hilton - Knaan - Tuesday 8.4.2008  15:00 - 16:15

In this series I'll go through the steps of my implementation of ASP.NET XmlProviders.

Check/uncheck CheckBox control inside a GridView using javascript without postback.

How to Implement Login/Signup Screen Using Ajax ModalPopup Extender

The .NET framework has shipped with the System.Diagnostics namespace since version 1.0. My efforts to build a method context information gathering framework on the services of System.Diagnostics has brought me a deeper understanding of its classes and configuration settings. I will talk about my method context information gathering framework in a later post, but first I thought I would get us all on the same page on System.Diagnostics.

System.Diagnostics implements several classes that play a key role in outputting trace text from your application. Better understanding these classes will bring you insights in to how to extend the existing diagnostic framework in .NET or how to set up the configuration file to make full use of the out-of-the-box functionality.

 

Read the full article at Obiwan Jacobi's Blog

The Article will guide you with complete knowledge of how to add a google map in your webpage with knowledge of JAVASCRIPT, Use of Geocoder, Use of InfoWindow, Use of Marker, Tabbed Markers, Maximising marker, Creating context menu in your map

This article describes how to build a lightweight test bench for testing user interfaces which are written entirely in C#/.NET, using NUnit or any other unit test framework.

An AJAX UpdatePanel with less communication overhead and better performance.

I just released TinySQL code generator v2.0 with few bug fixes and a new feature of using separator tag for loop statement. You can now use {sap}{/sap} tags to place your separators inside loop.

Here is the example of using {sap}{/sap} tags in TinySQL template:
** Generate Data Provider: Update/v2.0
CREATE PROCEDURE [dbo].[usp_Update$table]{loop}
@$field = $sp_type{sap},{/sap}{/loop}
AS
BEGIN
UPDATE dbo.$table WITH (ROWLOCK)
SET {loop}$field = @$field{sap},{/sap}
{/loop}
WHERE --TODO
RETURN -1
END

And generated code from above template will be like:
CREATE PROCEDURE [dbo].[usp_UpdateAction]
@Id = NUMERIC,
@Action = VARCHAR(250),
@ProjectId = NUMERIC,
@IsNextAction = BIT,
@IsWaitingFor = BIT,
@WaitingForNotes = VARCHAR(1000),
@RemindOn = DATETIME,
@IsDefer = BIT,
@DeferDate = DATETIME,
@IsDone = BIT,
@Sequence = INT
AS
BEGIN
UPDATE dbo.Action WITH (ROWLOCK)
SET Id = @Id,
Action = @Action,
ProjectId = @ProjectId,
IsNextAction = @IsNextAction,
IsWaitingFor = @IsWaitingFor,
WaitingForNotes = @WaitingForNotes,
RemindOn = @RemindOn,
IsDefer = @IsDefer,
DeferDate = @DeferDate,
IsDone = @IsDone,
Sequence = @Sequence
WHERE --TODO
RETURN -1
END

Download: TinySQL v2.0

You can also read my previous blog to learn more about TinySQL tool.
TinySQL Code Generator

Hope you will find this tool useful.

 

I was showing someone yesterday how to view webparts that were on their page and closed, yet not truely deleted (Add WebPart, selecting Advanced web part gallery and options).   Then today, I stumbled across another (and faster) way to view them.

You can view the web part page mainteance by adding "?contents=1" to the end of your URL and the maintenance page will load.

 - Dan Lewis

Import export library for Excel XML Format, which reduces a programmer's work to the bare minimum

A simple yet useful library for file based logging implemented in .NET using C#

Jigsaw Puzzle Game using Ajax Drag and Drop (ASP.NET 2.0 AJAX Futures November CTP)

In this series I'll go through the steps of my implementation of ASP.NET XmlProviders.