Thursday, October 16, 2008

Organise & Manage Multiple Remote Desktop Connections Easily with Windows Out-Of-The-Box!

Today is one of these days where I feel proud of myself!
I know there is not much to be proud of but I've saved myself so much time in the long run with this...

Look at that screenshot mister server man :)
I only need to double click on any of there entries to connect to the server(s) I like.
No need for a crappy 3rd party product, just simple out of the box Windows stuff!




You know when you have been in need of a life/time saving tool for ages without really finding exactly what you wanted and one day you come up with this brilliant, easy to implement and shining-by-its-simplicity idea all by yourself... well today is one of these days for me.

And I'm so excited about it I need to tell you all about it and finally end this very long period of non activity on this "dusty" blog.

How many of you have to manage more than let's say 5 servers from your Windows client?
If you're a network admin or a SharePoint guy just like me, you may even have around 20 servers to potentially connect to on a daily basis.

Also I bet quite a few admins out there are using Windows Remote Destop Connections (RDP) to connect to these servers?

Now, within that group of people how many of you have saved the RDP connection settings along with connection credentials and created a shortcut on their desktop to be able to instantly connect to the relevant machine by simply double clicking on the icon? (surely I'm not the only one here...)

If you're like me and you are really lazy that's exactly what you've done so far cause if you're like me and you've got 20 servers that you need to connect to on a daily basis, you don't want to have to type in your password and login details every single time.

Now, 20 desktop shortcuts can take a lot of room on your desktop:



I have been looking for a neat way to organise all these shorcuts for ages and came across a few badly implemented solutions until I re-discovered this fantastic Windows out-of-the-box function that "New Folder" is :)

For all the admins out there, please try this out:

1. Create a new folder on your desktop called "RDP"
2. Open Windows Remote Desktop Connection


3. Type in the name of the server you wish to connect to and select all your favourite RDP options
4. Don't forget to click the "Allow me to save credentials" box if you're a lazy b**** like me.
5. Hit "Save As..." and save these RDP connection settings to the folder created in step 1
6. Hit "Connect"
7. You may get this warning, tick the "Don't ask me again..." box


8. Then you will get this box if you've completed step 4 successfully


9. I can hear you already saying "I thought this article was going to save me some time, but in fact there is more popups I need to click on than on my favourite naughty sites !?" don't worry these popups will only appear once... and no more!
10. You will now get this window and hopefully be able to enter your password correctly (don't forget the old "CAPS LOCK ON"...)
11. Have a cup of tea cause steps 1 to 10 were quite daunting and complex

Now comes the fun.

Repeat step 2 to 11 till you have all your servers saved in your newly created folder.
Then follow this:

1. In the "View" menu > Toolbars, untick "Standard Buttons", "Link" and "Address" bars
2. Still in the "View" menu, untick "Status Bar"
3. Still in the "View" menu select "List"

4. And the final touch, resize the window to look a little thinner

If you are a purist you can even do like me and associate a custom icon to this folder so it looks a bit more like an app an meaningful (notice the RDP icon on this desktop).
And you can just drag & drop it to the "Startup" folder so it comes up everytime you restart the computer!
Beautifully simple and efficient, the final result is stunning and is definitely worth this epic blog article ;p

Have fun people and take care!

Microsoft SkyDrive Rocks!

Well, what can I say, 5 GB of free storage offered by Microsoft for free with a very funky web interface and upload tool (even if it is an ActiveX) ?

http://skydrive.live.com/

It would be silly not to make the most of it really...

Thursday, July 05, 2007

Personal review of Visual Studio Orcas beta 1

Hi all,

I know it's been a while, usual stuff really, swamped in a project up to my neck!
Blogging then becomes less of a priority ;)

However let me tell you a few things about the new Microsoft Visual Studio "Orcas" beta 1 release, which I am currently testing on my huge dual core AMD 64 bit, 4 Gb RAM, 500 Gb hard drive, Vista 64 business monster of a development machine.

I have to say, this release looks amazing and is packed with functionality that I have really been looking forward to.

However first impression is : very slow compared to VS 2005 (even on the PC described above). Maybe it's due to all this fancy new intellisense that ships with it, but big pages/controls take longer to be loaded/compiled. Don't even try the design view for complex pages, it's a nightmare... I've just disabled it.

Still, it's very usable and my general view on this new product is very positive indeed.

The good bits:
  • Much better intellisense
  • Great client side script step-by-step debugging!!! (F10 works on client side scripts!!!)
  • LINQ (fantastic)
  • Support for WPF and SilverLight (still have to be convinced by SilverLight I have to say...)
The bad bits:
  • Quite a bit slower than VS 2005 although usable
  • Had a few nasty crashes when "alt-tabbing" between a resource file (as in localization resource file) and a text editor called EditPadLight that I really like.
  • Other miscellaneous crashes, but nothing too bad for a beta release ;)
  • The "Copy website" function is still very bad and could have been improved...
So basically, my initial mark for Visual Studio Orcas beta 1 is: 85%

Will definitely make the move when it's released. Thanks for reading!

Cheers people and take it easy.

PS: You can find the Visual Studio "Orcas" files here:
http://msdn2.microsoft.com/en-gb/vstudio/aa700831.aspx

If you need tips to download the huge image files from the Microsoft website, read Jon Galloway's blog otherwise you can use the MSDN Subscriber downloader as explained on the link above:
http://weblogs.asp.net/jgalloway/archive/2006/09/30/Orcas-VPC-Download-info.aspx

Monday, May 14, 2007

How to get the ASP.NET Commerce Starter Kit 2.0 to run in medium trust !

Hi guys,

I am sure many of you will loooove this article.

IT IS POSSIBLE TO GET THE COMMERCE STARTER KIT TO WORK IN MEDIUM TRUST!!!

You can follow the instructions below, alternatively you can download the C# code from my SkyDrive:



I have been now fighting for a while to get the wonderful ASP.NET Commerce Starter
Kit 2.0 to work on my ISP Shared hosting server.

At first I thought it was a lost battle and started coding the CSK without SubSonic, Entreprise Library or any of this fancy stuff that requires full trust to run properly.

But after battling harder, I noticed a few things that changed my life yesterday and let me share my findings with you all!

Here is how I got there :

1. I added this line in the CSK web.config so it would simulate my hosting service environment on my dev machine :

<trust level="Medium" />


I also prevented SubSonic from using the Entreprise Library data access and to use the more supported SqlDataProvider (not sure this made a difference but I would like to mention it) :

<SubSonicService defaultProvider="ELib2DataProvider">
<providers>
<!--<add name="ELib2DataProvider" type="SubSonic.ELib2DataProvider, SubSonic" connectionStringName="CommerceTemplate"/>-->
<add name="ELib2DataProvider" type="SubSonic.SqlDataProvider, SubSonic" connectionStringName="CommerceTemplate" />
</providers>
</SubSonicService>


2. I updated the ATLAS stuff with the latest from Microsoft (optional):
http://ajax.asp.net/

Notes :

  • With that step more changes to the web.config are required (cf the web.config of the ajax web extensions).
  • Also I moved the ScriptManagers to the master pages (admin and site) and removed them from other pages, that way you always have ajax enabled pages :)
  • There is also an attribute that you need to remove from the ScriptManager or it won't compile.
  • One last thing you also have to replace the "Mode" attribute of all your UpdatePanels and change it to "UpdateMode".
3. In the App_Code\Configuration\SiteConfig.cs change the lines that say:
config.GetSection... to ConfigurationManager.GetSection
And rem out the line that says :

Dim config As System.Configuration.Configuration = WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath)


This will try to access your web.config file and save it, which is NOT allowed in partial trust.
The only pages that use this to write to the file are the Payment, Shipping and Tax configuration pages in the admin. I have simply disabled the "config.save" (i.e. rem'd it out) in those pages and you just need to go and configure those values manually in the web.config before you publish the code.

4. Next thing is to get rid of the eWorld.UI assembly all together cause it needs full trust to run and to replace the controls used in the CSK by nice new shiny AjaxControlToolkit controls (NumericBox to TextBox and Calendar are the only ones that I found in the project). Best to delete the eWorld.UI.dll from the bin folder and compile to see where we have to make the changes :o)

In order to use the AjaxControlToolkit you must put the AjaxControlToolKit dll in your bin folder and register it in the page :

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>


Then you can replace everywhere it says "ew:NumericBox" by "asp:TextBox" and get rid of the :

<%@ Register Assembly="eWorld.UI" Namespace="eWorld.UI" TagPrefix="ew" %>


Finally for the calendar, replace :

<ew:calendarpopup id="txtExpirationDate" runat="server"></ew:calendarpopup>


By:

<asp:TextBox ID="txtExpirationDate" runat="server"></asp:TextBox>
<ajaxToolkit:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="txtExpirationDate" Format="dd/MM/yyyy" />


Another thing, once you have done that some of your code behind files will stop working and you will have to replace the old "PostedDate" or "SelectedDate" of the old calendar controls by the "Text" property of your textbox.

Also everytime you need to set a datetime datafield just do DateTime.Parse(textbox.Text) instead of the old eWorldUIOldTextBox.SelectedDate.

There will also be occurrences of this sort of thing which will not pass the compilation:

calEnd.SelectedDate = DateTime.Today


Just replace it with:

calEnd.Text = String.Format("{0:dd/MM/yyyy}", DateTime.Today)


Or this sort of thing :

calEnd.SelectedDate


Replace it with :

DateTime.Parse(calEnd.Text)


There might be more small code changes that I forgot to document here but I will let you find out by yourself, you've got the general idea!

Once the project compiles locally with those changes and in medium trust (cf step 1) then you can publish it (Build > Publish Website) and compile it to a location on your hard drive. Copy the files to your ISP with the correct DB connection strings and that's it! (I agree it's actually quite a lot!)

If you need the code, drop me a line with your email address and I will send it to you.

I have tried to look at contributing in CodePlex for the CSK but the lack of documentation on how to do that made me loose motivation...

On the other hand, the changes that I have made so far may have other impacts on other functions of the CSK so following my advice is at your own risk, you are responsible for any change you make to the code :o)

From what I have seen so far though, everything works like a charm on a shared hosting server!!!

Good luck and let me know your feedback.

Cheers!

UPDATE 07/01/2008: WHAT TO DO WHEN YOU ARE GETTING THE INFAMOUS
"The SqlParameterCollection only accepts non-null SqlParameter type objects, not QueryParameter objects" ERROR

I received quite a few emails about this as it is a problem when using the CSK code and the solution is here:

You need to edit the OrderController.vb (or .cs) to include this function:


Public Shared Function GetDBCommand(ByVal objSubCom As SubSonic.QueryCommand) As DbCommand

Dim objDbCom As DbCommand
Dim objSqlCon As New SqlConnection(ConfigurationManager.ConnectionStrings("LocalSqlServer").ToString)

objDbCom = objSqlCon.CreateCommand()
objDbCom.CommandText = objSubCom.CommandSql
objDbCom.CommandType = objSubCom.CommandType

Dim par As QueryParameter
Dim objSqlParam As SqlParameter

For Each par In objSubCom.Parameters

objSqlParam = New SqlParameter

objSqlParam.DbType = par.DataType
objSqlParam.ParameterName = par.ParameterName
objSqlParam.Value = par.ParameterValue

objDbCom.Parameters.Add(objSqlParam)
Next

Return objDbCom

End Function


Then replace all the lines that say:


order.GetUpdateCommand(Utility.GetUserName()).ToDbCommand


With this line calling the new function bypassing the subsonic call:


GetDBCommand(order.GetUpdateCommand(Utility.GetUserName()))


The ToDbCommand is the one causing the error and it's a Subsonic function. It is only throwing the error when using the SqlProvider to connect to the DB (from the SubSonic dll). So the new GetDBCommand that I wrote is a workaround that bypasses that function...

Add columns programmatically to a GridView and style the rows

A friend of mine asked me how to programmatically add columns to a GridView and I found this great article which I hope will help some of you too :

http://www.gridviewguy.com/ArticleDetails.aspx?articleID=29

He also asked me how to style the Grids the best possible way and to modify the style of some control in it, maybe just one cell.

As far as the general style is concerned I advise you to use a .skin file in the "Themes" folder of your ASP.NET 2.0 app. In this file the following declaration will map the GridView items to CSS classes :



<asp:GridView SkinID="" runat="server" CellPadding="4" GridLines="Both" CssClass="GridView" Width="100%" BorderColor="#ECECEC" BorderStyle="Solid">
<HeaderStyle CssClass="GridHeader" />
<FooterStyle CssClass="GridFooter" />
<SelectedRowStyle CssClass="GridSelectedRow" />
<AlternatingRowStyle CssClass="GridAlternatingRow" />
<EditRowStyle CssClass="GridEditRow" />
<RowStyle CssClass="GridRow" />
<PagerStyle CssClass="GridPager" />
<EmptyDataRowStyle CssClass="GridEmptyRow" />
</asp:GridView>


In a css file, you can then create the relevant classes like GridHeader, etc.

If you need to modify a row or some element of it when the Grid is being "written" you should do it in the RowDataBound event as follows:



Protected Sub myGridView_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles myGridView.RowDataBound()
If e.Row.RowType = DataControlRowType.DataRow Then
Dim objButton As Button
objButton = CType(e.Row.FindControl("cmdButtonInTheRow"), Button)
If IsDBNull(e.Row.DataItem("MyDataFieldValue")) Then
objButton.Enabled = False
ElseIf e.Row.DataItem("MyDataFieldValue") = "SOME_VALUE" Then
objButton.BackColor = System.Drawing.Color.FromName("White")
Else
objButton.BackColor = System.Drawing.Color.FromName("Green")
e.Row.BackColor = System.Drawing.Color.FromName("Red")
e.Row.Cells(3).BackColor = System.Drawing.Color.FromName("Yellow")
e.Row.Cells(4).ForeColor = System.Drawing.Color.FromName("Pink")
End
End If
End If
End Sub


Hope this helps!

Cheers,

Tuesday, April 10, 2007

The coolest shortcut of them all !...

Hi people,

In the shortcut series, I have found the coolest of them all!
The new ALT+TAB in Vista :

Try the "Windows Key" + TAB and tell me what you think...

If you want more here it is

I am really starting to love Vista, the only thing I don't like about it is that I'm going to have to buy 2 more Gb of RAM...

Oh well... progress hey?

Thanks to Microsoft for a cool OS!

Wednesday, March 28, 2007

NetSpell checker works in medium trust environment using AllowPartiallyTrustedCallersAttribute

Hi all,

just a quickie, I have been using this fantastic open source free spell checker and I am very happy with it as it is completely integrated to the FreeTextBox.

It is called NetSpell and in order to download it you must go to this site :
http://www.loresoft.com/Applications/NetSpell/default.aspx

The problem is when you try to make netspell work in a shared hosting environment that will be more secure than your dev webserver and will more than likely run in medium trust.

The only problem is that NetSpell does not by default allow the assembly to run in partial trust and therefore the only way to get it to work is to add :

[assembly: AllowPartiallyTrustedCallersAttribute()]

line to the AssemblyInfo.cs file of the NetSpell.SpellChecker project

Soooooo....

1. I downloaded the code locally to my C: drive,
The full source is available here using the mighty SVN source code manager :
http://sourceforge.net/projects/netspell/

2. Went to the ..\NetSpell\trunk\NetSpell\src\NetSpell.SpellChecker folder,
3. Edited the AssemblyInfo.cs file to include [assembly: AllowPartiallyTrustedCallersAttribute()]
4. Added a reference at the top of the file to using System.Security;
(required for the AllowPartiallyTrustedCallersAttribute element to work)
5. Recompiled the project
6. Copied the new NetSpell.SpellChecker.dll to my web project and...
7. BINGO! everything worked like a charm on my medium trust environment!!!

Hope those who struggled with this will manage to find my post and solve their problem!

Cheers,
Etienne

Friday, March 09, 2007

New tool!

I just had a look at Wengo Visio and it seems to be amazing...
I will try it a bit more and let you know how it works but it looks amazing!

It's like Skype but Flash based and does not require any client install!!!

Let's try it:




Wednesday, February 21, 2007

Subsonic or ActionPack the zero code DAL

Hi all,

something all the lazy programmers out there have been waiting for :

http://www.codeplex.com/actionpack

This is the heaven of dal coding, the only down side is that you need full trust on your web to use its full features (i.e. custom build providers to automatically generate vb or c# classes to access your database structure).

In other words, the people on shared hosting environments, forget it. However if you have a dedicated server, then the world is your oyster and man this tool is great!

No more boring data access code to write, one class per table is generated and allows you to query your data in a very efficient way!

Thanks guys for this... wonder how it's going to compete with LINQ though?

Cheers!

AJAX 1.0 is here and will tranform the web

I am now working closely with Microsoft AJAX extensions v1.0 and I have to say congratulations to them for developing such a cool programming concept.

I am using it everywhere I can and have been able to design things that I have dreamt of years ago without any hassle.

.NET web developers, go there now and watch all the videos, you won't regret it:

http://ajax.asp.net

Happy programming!

Friday, June 09, 2006

www.netploy.com is here!!!

That's it!!!

My last ASP.NET 2.0 project is finally completed. After 6 months of hard work we finally have something up and running and it works like a breeze.

For those of you you can speak French, here is the future of employment:
http://www.netploy.com

For those who can't, an English version is probably going to be out soon. Otherwise, it's always good to learn a new language, especially one as beautiful as French! :)

netploy is a site where you can find work or people who can do a job and make sure that you can work with them remotely with the tools offered :

  • Microsoft SharePoint Services was integrated to the site in Active Directory creation mode as well as host header mode. That basically means that you can create sites with your own URL like "myurl.share.netploy.com"! This provides the freelancer with a "Virtual Desk" accessible from anywhere in the world.
  • On the other hand we also have integrated a fantastic web conferencing tool called GatherPlace and this provides the employer or employee with online meeting facility. Again the url would be the one you have picked (similar to WebOffice) and like "myvirtualconf.meet.netploy.com"
The future is to be able to work from the comfort of your own home!
I have been doing this for the past 6 months and this site is the result, I have never been that productive in my entire life and I am extremely proud of this achievement as I have done it on my own (no development team whatsoever)!

For those of you who are technical, subscribe to www.netploy.com and have a look at the amazing functionalities in place, for those of you who are interested in working from home, enter you CV and wait for the right project!

There is more to come in the near future as we are already looking at improving some functionalities using ATLAS.

Cheers!
Etienne

Wednesday, November 02, 2005

.NET 2.0 Custom Build Providers

Wow this is soooooooo cool I can't believe it!

How would you fancy NOT having to write a DataAccess layer in your apps but instead to get the ASP.NET 2.0 engine to automatically serve the code to you straight from the Database Structure?

If you don't understand the problem, you need to spend a bit more time creating by hand (not allowed to cheat with CodeSmith or other...):

  • Tables
  • Views
  • Stored Procedures
  • .NET Data Access Code that calls everything and performs SELECT, INSERT, UPDATE and DELETE...

Then you will know what I mean especially if your DB has 250 tables, 150 Views and 640 Stored Procedures!!!

I was lucky enough to come across this article from Fritz Onion and I think it is absolutely awesome. Fritz you're a genius man!

http://pluralsight.com/blogs/fritz/archive/2004/09/06/2188.aspx

Using that idea, I have been able to build a code generator that creates my DataAccess layer automatically from the Database, then in my code I only need to reference the relevant object and call methods against them like:

Dim objProfile as Profile

objProfile.ID = "1"

objProfile.Name = "Test Name"

objProfile.Update

How cool is that!!!

Tuesday, August 23, 2005

HtmlInputFile problem uploading large files!

God I have spent nearly 4 days solid trying to work that one out!

Here is the challenge:
Basically there is by a size limit to the file you can upload to a webserver using the good old HtmlInputFile Input. By default this limit is 4Mb and it is set in the machine.config file on the web server:

httpruntime maxrequestlength="8192"

It is of course possible to override this value in your web.config file and make it web app specific.

The problem occurs when you try to upload something bigger than that... you will get a nasty DNS error because the asp.net worker process got its knickers in a twist on the webserver. It basically reached a memory threshold before it could do anything with the file!

A full explanation can be found here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;295626

Anyway the bottom line is that it displays a nasty error to the user and the people I work for don't like that at all.

As a Google group lover I looked for an answer to that one for a lot longer than I originally thought I would have to and finally found this EXCELLENT article by Jesse Chunn:
http://www.standardio.org/article.aspx?id=213

Jesse you're the man! The little code snippet you posted is awesome in simplicity and it works great.

The trick is to use the global.asax file and to test the file contentLength for every single request made to the web server.

I post the code again:

Sub Application_BeginRequest(ByVal sender As Object, ByVal e As EventArgs)

' Fires at the beginning of each request
Dim i As Integer

'this number is in bytes, NOT kilobytes!!
Dim iMaxFileSize As Integer = 8000000
For i = 0 To Request.Files.Count - 1
If Request.Files.Item(i).ContentLength > iMaxFileSize Then
Response.Redirect("FileToBig.aspx?filesize=" & Request.Files.Item(i).ContentLength)
Exit For
End If
Next

End Sub

A massive thank you to you my friend, you're a star in the developer's world!!!

Friday, August 12, 2005

Enterprise Library, not always the best option!

I had to say it, the Enterprise Library which I think is a brilliant repository of coding practices from Microsoft, is not always the best option!

I struggled a lot with it when trying to deploy it to a shared hosting environment and I finally gave up. I had to write this on the GotDotNet Message board:

"Enterprise Library and shared hosting
Posted on: 08/12/2005 02:11:21

Hi guys, ok I have now developed 2 reasonably big ASP.NET applications built on the Enterprise Library. One of them uses Data Access, Configuration, Caching and Security (DB) and the other one uses the Data Access and Caching. They are both intranets and although it took me quite some time to suss out how to get everything to work and to code/debug my VB.NET calls to the EL, I finally managed to get the sites working very well and I am quite impressed with some of the functionality in EL.

However I have to emphasize on the fact that I did struggle, it is not always developer friendly and you have a few obstacles to overcome (I guess it's still quite new so people are getting used to it!) and even though it is packed with very cool functionality I still think it is a sledgehammer to crack a nut. Compared to the old DAAB and the ever so friendly SqlHelper class, there is quite a big gap! Maybe you should think about the Enterprise Library Lite! (.NET Framework 2.0?)

The Enterprise Library is awesome when it comes to hosting a very complex web app yourself on your very powerful W3K Server on an AD Domain. But when your designing a very simple secure site hosted on a shared hosting environment with a simple SQL server backend, like it is the case 99% of the time (for me anyway), you are in for a big ride!!! No way I could run "InstallServices.bat" on the 3rd party shared hosting network of course, so you get the nice "Access Denied error" when you try to run the blocks because of the Instrumentation and Logging trying to access the EventLog...

I read Tom's blog: http://blogs.msdn.com/tomholl/archive/2005/02/18/376187.aspx

Tried what he suggested but was still getting errors from the Caching block even after turning off the Instrumentation altogether. After many hours of frustration, I just chose to give up, got rid of EL DLLs altogether and replaced them with the good old SqlHelper! Rewrote my data access layer, implemented a simple SQL server authentication mechanism with password encryption and swore I would never use EL again.

So end of story for me, a lot of time wasted, no will to get a dedicated server solution (too expensive) and therefore back to a normal plain old SqlHelper class, which I have to say now I kind of prefer to the EL!

At least it deploys to any server.

Sorry guys but I had to say it! On a different note, I still think the Enterprise Library Code is probably one of the best open source I have seen in terms of architecture and new ways of thinking blocks. Just make sure it is developer friendly and that you can deploy it to any .NET environment, especially remote with limited access rights!

Cheers, Etienne "

Wednesday, May 18, 2005

Crystal reports for .NET

I have just found some extremely useful info on how to implement and easily generate fantastic looking reports from within the VS.NET IDE!

Check this out!
http://aspalliance.com/articleViewer.aspx?aId=265&pId=2

Thanks to Josh Robinson I have also been able to plug the Crystal Report Viewer to the almighty MS Enterprise Library Data Access block!!!

For that you need to use strongly typed datasets and Josh explains how to do that in a very simple and clear way:
http://weblogs.asp.net/josh.robinson/archive/2005/03/30/396311.aspx

Josh you're the man!

Wednesday, April 13, 2005

Classic ASP Datagrid class


Classic ASP Datagrid class
Originally uploaded by Etienne L.
To complete my posting of the ASP.NET User Control datagrid, here is the older version...

This is a classic ASP datagrid implementing a hell of a lot of functionality and making sure everything is in a class and no images are required.

Basically only an include and some dead simple code can display data from a datasource on a webpage.

This example includes:

* Sorting
* Paging
* Styling (CSS)

I will post the code as soon as I have some space somewhere...

ASP.NET User Control Datagrid


ASP.NET User Control Datagrid
Originally uploaded by Etienne L.
This is an example of my latest ASP.NET user control datagrid. I will post the code for it very soon... only need to clean it up a bit.

This is NOT a server control (dll), it's simply an .ascx file. Dead easy. The features I have implemented are:

* Easy column sorting
* Paging (page numbers or triangles, no images required)
* Alternate coloring
* Custom ItemDataBound and ItemCommand events
* CSS Styles for the look and feel

It's not the most amazing one I have ever seen but it does the job extremely well and I use it all over my latest project!

Code will follow very soon...

Tuesday, April 05, 2005

Golden Shortcuts...

As a developer, you constantly have to use keyboard shortcuts to save time and to impress your colleagues ;)

There is the obvious ctrl+x, ctrl+c and ctrl+v that I use 1000 times a day, the ctrl+s (save), alt+tab, alt+shift+tab, ctrl+F4 (close inside window), alt+F4 (close window)... and so on.

Actually let me put a list of the ones I use constantly and tell me if you can think of others:
ctrl+x = cut
ctrl+c = copy
ctrl+v = paste
ctrl+z = undo
ctrl+y = redo
ctrl+b (with text highlighted) = make bold
ctrl+F4 = close inside window
alt+F4 = close window
alt+tab = switch to next app
alt+shift+tab = switch to previous app
shift+click (on URL in IE) = open URL in new window
ctrl+s = save
ctrl+shift+s = save all
F5 (in Query Analyzer) = execute (highlighted text or ALL if nothing highlighted)

But there is also the gold dust, shortcuts that take you years to work out and things you had no idea existed... and today I found one!!!

The first one that I did find about a year ago answers the question "How do you make a field NULL in SQL Server using the entreprise manager manual data edit within table?" the answer is to put the cursor in the relevant field (that you want to blank out) and press ctrl+0 (number "zero"). I have to say, I was pleased to finally get that one after years of "UPDATE tablename SET field = NULL WHERE ID = 11111"!

Today is one of those days where I am happy to add a new addition to my list of favourite shortcuts, the one I'm on about is probably one that VB developers like me will find extremely useful! It is ctrl+k and c or ctrl+k and u! What is it for are you going to ask... well have you ever tried to turn 50 lines of uncommented code to comments in VB?

It takes about 2 minutes to rem it, and 3 to rem it out cause you need to work out what lines are real code and what should remain comments.

ctrl+k and c will comment any highlighted text (multiple lines) in VS.NET!!! The other uncomments it... how brilliant is that!

For those who are anal like me about windows shortcuts, here is a VERY extensive list
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/html/vxurfvisualstudio70defaultshortcutkeys.asp

Hope this helps! Happy shortcutting!...

Friday, March 04, 2005

skmMenu

Have you ever wanted to create a really cool DHTML menu automatically generated from an XML file (treeview) without having to worry about any of the code... but if you wanted to change the code/styles for whatever reason you could!!!

This is an amazing little ASP.NET open source app with an online GotDotNet community that rocks! I wish I had seen this before. It's already in the new project I am working on.

Awesome, brilliant work guys!!!

skmMenu Homepage

Friday, February 25, 2005

Firefox

I am trying Firefox, the alternative browser for the first time today.
It looks good and seems to be packed with cool ideas...

Firefox

I like the "BlogThis" Extension, which I am using to post this blog!

I will keep you up to date with my findings!