ASP.NET

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using Ninject.Core;
using SportsStore;
using SportsStore.WebUI.Controllers;
using System.Web.Routing;
using Ninject.Modules;
using Ninject.Core.Modules;
using SportsStore.Domain.Abstract;
using System.Configuration;
using SportsStore.Domain.Concrete;

namespace SportsStore.WebUI.Infrastructure
{
    public class NinjectControllerFactory : DefaultControllerFactory
    {
        // A Ninject "kernel" is the thing that can supply object instances
        private IKernel Kernel = new StandardKernel(new SportsStoreServices());


        // ASP.NET MVC calls this to get the controller for each request
        protected override IController GetControllerInstance(RequestContext context,Type controllerType)
        {
            //if (controllerType == null)
            //    return null;
            //return (IController)Kernel.Get(controllerType);

            return controllerType == null ? null
                                         : (IController)Kernel.Get(controllerType);
        }

        // Configures how abstract service types are mapped to concrete implementations
        private class SportsStoreServices : StandardModule
        {
            public override void Load()
            {
                //registered any IProductsRepository with the DI container.
                Bind<IProductRepository>().To<SqlProductRepository>().WithConstructorArgument
                    ("connectionString", ConfigurationManager.ConnectionStrings["AppDb"].ConnectionString);
                
            }
        }
    }
}

protected override IController GetControllerInstance(RequestContext context,Type controllerType)<br />
        {<br />
            //if (controllerType == null)<br />
            //    return null;<br />
            //return (IController)Kernel.Get(controllerType);<br />
<br />
            return controllerType == null ? null<br />
                                         : (IController)Kernel.Get(controllerType);

CREATE TABLE [dbo].[tblFiles](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NULL,
	[ContentType] [varchar](50) NULL,
	[Data] [varbinary](max) NULL,
 CONSTRAINT [PK_tblFiles] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

CREATE PROCEDURE [dbo].[viewtblFiles] 
	
	@ID int
	
	
AS
BEGIN TRANSACTION
	
select Name, ContentType, Data from tblFiles where id=@id

COMMIT TRANSACTION

SqlConnection cnx1 = new SqlConnection(connection.strCnx);
SqlCommand cmd1 = new SqlCommand("viewtblFiles",cnx1);
SqlDataAdapter sda = new SqlDataAdapter();

cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add("@id", SqlDbType.Int).Value = 4;

DataSet dt = new DataSet();
try
{

    cnx.Open();

    sda.SelectCommand = cmd1;

    sda.Fill(dt,"tblFiles");
    GridView1.DataSource = dt;
    GridView1.DataBind();


}

catch (Exception ex)
{
    string s = ex.ToString();


}

finally
{

    cnx.Close();

    sda.Dispose();

    cnx.Dispose();

}

tr.Attributes.Add("onmouseover", "this.style.backgroundImage='url(images/pagebg.jpg)';this.style.cursor='pointer';");
                    tr.Attributes.Add("onmouseout", "this.style.backgroundImage='url(images/tagcontent.gif)';this.style.cursor='pointer';");