Kandy Steps

Pass Table as a Parameter to Sql Procedure. In this article I am Using 3 tier architecture for passing Table as parameter from 1 layer to other ,and finally to Stored procedure. Step 1 : Create Database : (A) Table for data insertion. CREATE TABLE [dbo] . [SETTINGS] (       [Id] [int] IDENTITY ( 1 , 1 ) NOT NULL,       [BusinessId] [int] NULL,       [Year] [int] NULL,       [Month] [int] NULL,       [BudgetAmt] [decimal] ( 6 , 2 ) NULL,       [FiscalForm] [datetime] NULL,       [FiscalTo] [datetime] NULL,       [AustFinYear] [bit] NULL, ) ( B)   User defined table type which will be used as a table valued parameter in the stored procedure. CREATE TYPE dbo . SETTINGS_type AS TABLE (    BusinessId int ,    Year in...

Generate Condition based menu In asp.net. Condition based means,some time we have different type user . May be 2  or  more.so its not practical to show all content to all user. For this we develop  condition based menu.its mean show only useful content to user according to there role. Here I am using aasp.net Menu Control from toolbox .just drag it on your web page.aspx` . < asp : Menu ID ="Menu1" CssClass ="menu" runat ="server" Orientation ="Horizontal"   DynamicSelectedStyle-BackColor ="Brown"   DynamicMenuItemStyle-Font-Size ="12px"   DynamicMenuItemStyle-Font-Names ="Calibri"   DynamicMenuItemStyle-Font-Bold ="false"   DynamicMenuItemStyle-ForeColor ="#FFFFFF "   DynamicHoverStyle-ForeColor ="#ffffcc"   DynamicMenuItemStyle-VerticalPadding ="5px"   StaticMenuItemStyle-Font-Size ="14px"   Static...