rETURN JSON FROM SQLSERVER STORED PROC

http://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/

http://weblogs.asp.net/thiagosantos/archive/2008/11/17/get-json-from-sql-server.aspx

Imp links UI

http://www.delldesignlibrary.com

http://www.hanselman.com/blog/WhatGreatNETDevelopersOughtToKnowMoreNETInterviewQuestions.aspx

OB Bugs

Cats to Add
-----------------------------
(1) Opticals
(2) Paying guest
(3) Lodge

(5) IE 8 view damging on MyProfile

(7) No Image is showing in master not in detail popup

(8) Remove Adv top brd
(9) Make the header text attractive and with logo
(10) When clicking "home" it should not show index.aspx.
(11) page should not be selectable

padding-left:15px;width:100%;height:22px;font-size:12px;font-weight:bold;color:#94140f

to

padding-left:15px;width:100%;height:auto;font-size:12px;font-weight:bold;color:#94140f

set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO --exec [dbo].[GetJSON] usermaster,100 ALTER procedure [dbo].[GetJSON] ( @table_name varchar(50), @registries_per_request smallint = null ) as begin if((select count(*) from information_schema.tables where table_name = @table_name) > 0) begin declare @json varchar(max), @line varchar(max), @columns varchar(max), @sql nvarchar(max), @columnNavigator varchar(50), @counter tinyint, @size varchar(10) if (@registries_per_request is null) begin set @size = '' end else begin set @size = 'top ' + convert(varchar, @registries_per_request) end set @columns = '{' declare schemaCursor cursor for select column_name from information_schema.columns where table_name = @table_name open schemaCursor fetch next from schemaCursor into @columnNavigator select @counter = count(*) from information_schema.columns where table_name = @table_name --exec [dbo].[GetJSON] usermaster,100 while @@fetch_status = 0 begin set @columns = @columns + '"' + @columnNavigator + '":"' + ''' + convert(varchar, ' + ISNULL(@columnNavigator,' ') + ') + ''"' set @counter = @counter - 1 if(0 != @counter) begin set @columns = @columns + ',' end fetch next from schemaCursor into @columnNavigator end set @columns = @columns + '}' close schemaCursor deallocate schemaCursor set @json = '[' set @sql = 'select ' + @size + '''' + @columns + ''' as json into tmpJsonTable from ' + @table_name exec sp_sqlexec @sql select @counter = count(*) from tmpJsonTable declare tmpCur cursor for select * from tmpJsonTable open tmpCur fetch next from tmpCur into @line while @@fetch_status = 0 begin set @counter = @counter - 1 set @json = @json + @line if ( 0 != @counter ) begin set @json = @json + ',' end fetch next from tmpCur into @line end set @json = @json + ']' close tmpCur deallocate tmpCur drop table tmpJsonTable select @json as json end end

mvc

http://www.codeproject.com/Articles/54576/Understanding-ASP-NET-MVC-Model-View-Controller-Ar


BEST TUTORIAL
http://msdn.microsoft.com/en-us/vs2010trainingcourse_aspnetmvc3fundamentals_topic7

MVC jQuery UI

http://www.codeproject.com/Articles/344292/ASP-NET-MVC3-Razor-With-jQuery-For-Beginners