Adam Schroder

FluentValidation Xval Integration

schotime — Sat, 13 Jun 2009 08:31:37 GMT

After a few months of using FluentValidation I asked its author Jeremy Skinner if it were possible to integrate this with xVal. At that time it was not possible because there were no easy way to access the properties needed by xVal. After submitting a few patches, we now have a solution which enables xVal integration with most of the FV validators.

Click here to find out more…

Cheers,

Adam

Integrating xVal Validation with Linq-to-Sql

schotime — Tue, 31 Mar 2009 12:34:47 GMT

In a previous post I showed you how you can use xVal and the IDataErrorInfo class to add validation to your Asp.net MVC website. In this post I will extend that to Linq-to-Sql and the classes it generates.

The northwind database has a suppliers table. The info contained below is using that table with linq-to-sql.

After adding the table to the designer, a Supplier class gets constructed in the background. This class is a partial class which means we can add to it without changing the code auto-generated in the designer.cs file.

Click here to keep reading…

Cheers,
Adam

Custom Validation Attributes

schotime — Tue, 10 Mar 2009 10:12:58 GMT

In my last post I showed you how to use Validation attributes on your model for validation. Today I will show how you can create your own attributes that can provide custom validation for you.

To accomplish this we need to inherit from ValidationAttribute. We'll create an attribute today that will only allow a "Yes" or "No" value to be entered. A pretty bad example however it will still suffice.

Click here to see the how its done.

Adam

Validation with Asp.net MVC, xVal & IDataerrorInfo

schotime — Thu, 05 Mar 2009 11:50:00 GMT

I've been playing around with lots of different Validation concepts recently and I think I have come up with something that will be very useful. Hopefully you will also find it useful.

Firstly I have been looking at Steve Sanderson's new open source project xVal and decided that it was a good place to start. I was mainly looking at server side validation but xVal can also generate script to enable client side validation.

Firstly I'll show you how I integrated the DataAnnotations validation pack that Dynamic data uses and is available to us in 3.5sp1 as far as I know.

public class CustomValidation : IDataErrorInfo
{
    string IDataErrorInfo.Error
    {
        get
        {
            return string.Empty;
        }
    }

    string IDataErrorInfo.this[string columnName]
    {
        get
        {
            List<ErrorInfo> errors = 
                DataAnnotations.GetErrors(this, columnName).ToList();
            return errors.Count > 0 ? errors[0].ErrorMessage : null;
        }
    }
}

Sound interesting...? Click here to keep reading

Cheers,
Adam

Custom Authorization With Asp.net MVC

schotime — Tue, 17 Feb 2009 11:27:00 GMT

The whole advantage with MVC over webforms is extensibility at every point. Extensibility, Extensibility, Extensibility.

Authorization is a very important and every web project has there own needs and requirements. Full customisation is paramount.

Here I will show you a simple way to customise your authorization.

In MVC attributes are used to protect a controller method, so we to get started all we need to do is inherit from the AuthorizeAttribute class.

Click here to see the solution

Happy Coding

Adam

Retrieving Data Without the Dataset With Custom SQL

schotime — Thu, 12 Feb 2009 10:47:00 GMT

In my previous post I used custom sql query and transformed the results into a nested class. However you may have overlooked way I got the data into a class. It quite easy and will work with all database connectors that implement IDbConnection.

Here is how its done. We use the DataContext that came with and used by Linq2Sql.

Click here to see the solution.

Adam

Transforming one-to-many Sql into Nested Class

schotime — Thu, 22 Jan 2009 11:23:00 GMT

Back in the days of Classic ASP, when you had a one too many relationship displaying the data was pretty painful. You would do things like


        var reference_number_old = "$##%@";
        while (recordsExist)
        {
            reference_number = String(rs(0));

            if (reference_number_old != reference_number)
            {
                Response.Write(reference_number);
                reference_number_old = reference_number;
            }

            //Do more stuff
        }

Sooo very very painful, and that's only grouping by one column (reference number).

Now however with OO programming and the advance of Linq there is a much nicer and easier way to deal with this Master-Detail type one-to-many relationship.

Lets see how we do it now, still using our own custom sql.

Click Here to Keep Reading...

Cheers
Schotime

Running ASP.NET MVC Applications Under IIS6

schotime — Sat, 18 Oct 2008 10:18:14 GMT

Yes...Finally...I have full control of my HTML again, but am still able to work with a great language like C#. MVC is here and its great. I'm absolutely loving it. But how the heck do you get it to work under IIS6. What if I want extensionless URL's? Here is a few options for you.

Click Here to read on.....

Schotime

Returning a Dataset, Datatable in Json

schotime — Mon, 28 Jul 2008 11:05:30 GMT

After my previous posts about returning data in JSON, I decided to have a go at returning a generic Datatable. This however is not as easy as simple returning a Datatable in your code behind method or web service. There a solution though and here it is.

If you break a Datatable down it is really only a List of Dictionary objects so that's how we'll approach this problem. This is compatible with .NET 2.0 and above, with the Ajax installed.

I'd like to acknowledge RichardD for the idea.

Click here to view the simple solution.

jQuery Plugin for ASP.net Ajax (jMsAjax)

schotime — Tue, 01 Jul 2008 13:29:12 GMT

After my recent post on jQuery, JSON and dates in asp.net I decided that there must be a better solution so I set out writing my first jQuery plugin. And after a few hours I had it working to my delight.

It not only accepts a raw JSON object as input for method parameters, but safely parses and stringify's the object using Crockford's implementation (http://www.json.org/js.html). The syntax of the call doesn't change if it is a "POST" or a "GET" as it is all handled inside the plugin. It also returns Dates without a problem.

Click here to keep reading....

Schotime

jQuery, AJAX, ASP.NET and Dates

schotime — Thu, 19 Jun 2008 09:39:38 GMT

Just recently I discovered jQuery and I have to say....I'm a huge fan already. So I decided to setup my first AJAX call through jQuery and call a page method. After some playing around I finally had it. Thanks also go out to www.encosia.com. Thanks Dave. The only problem was that I could not parse Dates.

So here I show you my solution which works pretty well and suits my needs. Maybe you might find it useful.

Click here to see my solution

Slow TcpClient Connection (sockets)

schotime — Tue, 27 May 2008 03:28:03 GMT

Recently I have been experimenting with Sockets and trying to communicate with a windows service both with a console app and a website.

After managing to get some lines of communication going between the client and server applications, I couldn't help but notice that it was taking a little bit longer than it probably should have. I decided to have a closer look.

Click here to keep reading...

Binding A String to a Checkbox

schotime — Wed, 02 Apr 2008 06:13:25 GMT

In a recent project I was attempting to list data from a configuration settings database table. The values were boolean but stored as a 'Y' or a 'N' so that only one set of SQL's was needed to be written, as the product supports both Oracle and SQL Server.

When I first put the GridView together, I was surprised to find that there was no Value property for the asp:checkbox nor could you bind any other column in a database but a 'bit' column to it.

The only solution I could come up with was to create a custom Checkbox and implement the feature.

Click here to keep reading and get the code...

Importing Data Files with Linq

schotime — Tue, 18 Mar 2008 12:24:46 GMT

In my previous Linq post I discussed using Linq with Regular expressions and how much less code was needed. In this post we'll again see how Linq can be used to speed up and simplify development.

There are many situations where you need to read data into memory or a database. Lets consider this scenario.

We have a tab delimited data file that has been exported from some web or windows application etc......

Click here to continue reading!

Select All (ctrl+A) For A TextBox

schotime — Wed, 12 Mar 2008 04:34:00 GMT

Have you ever tried to push ctrl+A on a multi-line or single line textbox in a Dot Net Windows Forms application to select all of the text? If you have you would know that it doesn't work. That's right, standard windows functionality doesn't work for the TextBox control. So here's how to fix it using a custom control.

Click here to read more..