My Code Experiments

Asp.net MVC 3 Nested Grid view with Webgrid

noreply@blogger.com (Rajendra) — Tue, 14 Jun 2011 08:33:00 +0000

Introduction: In some cases we need to display data in form of parent child i.e. Order and product scenario for shopping cart web site.I have used Web Grid to display records for my asp net MVC 3 application.

Model classes: I have created two model classes Order and Product

public class Order

{

public int OrderId { get; set; }

public DateTime OrderDate { get; set; }

public List<Product> ProductList { get; set; }

}

public class Product

{

public int ProductId { get; set; }

public string Name { get; set; }

}

Controller:

public class HomeController : Controller

{

public ActionResult NestedGrid()

{

var Orders = new List<Order>();

var products1 = new List<Product>();

products1.Add(new Product { ProductId = 1, Name = "laptop" });

products1.Add(new Product { ProductId = 5, Name = "pen drive" });

Orders.Add(new Order { OrderId = 1, ProductList = products1, OrderDate = DateTime.Now });

var products2 = new List<Product>();

products2.Add(new Product { ProductId = 3, Name = "Hard disk" });

products2.Add(new Product { ProductId = 4, Name = "Mouse" });

Orders.Add(new Order { OrderId = 2, ProductList = products2, OrderDate = DateTime.Now });

return View(Orders);

}

View: I have used Razor view engine.

@model IEnumerable<MvcApplication1.Data.Order>

ViewBag.Title = "NestedGrid";

}

WebGrid topGrid = new WebGrid(source: Model);

}

<h2>NestedGrid</h2>

@topGrid.GetHtml(columns:

topGrid.Columns(

topGrid.Column("OrderId"),

topGrid.Column("ProductList", format: (item) =>

{

WebGrid subGrid = new WebGrid(item.ProductList);

return subGrid.GetHtml(

columns: subGrid.Columns(

subGrid.Column("ProductId"),

subGrid.Column("Name")

)

);

})

,topGrid.Column("OrderDate")

)

</div>

Result:

Conclusion: So we can easily create nested grid with the help of WebGrid in asp.net MVC 3 application.Hope this will be useful to you.

Thanks

Rajendra

Javascript books for web developers

noreply@blogger.com (Rajendra) — Mon, 27 Dec 2010 07:25:00 +0000

Web developers should know about following Javascript books -

1.Professional JavaScript for Web Developers - Almost 1,000 pages of VERY detailed JavaScript information. Written by Nicholas Zakas, Yahoo!

Principal Front-end Engineer for Yahoo!’s home page and recommended by the

YUI team as well.

2. JavaScript: The Definitive Guide - Considered the Bible of JavaScript for its thorough coverage of JavaScript. You need to have this in your library, even as a reference.

3. DOM Scripting: Web Design with JavaScript and the Document Object Model - This is a good book to get you familiar with the DOM.

4. AdvancED DOM Scripting: Dynamic Web Design Techniques - This book is for intermediate to advanced web designers and developers who already have a reasonable to good knowledge of HTML, CSS, and JavaScript.

5. Beginning JavaScript with DOM Scripting and Ajax: From Novice to Professional (Beginning: from Novice to Professional) - Beginning JavaScript with DOM Scripting and Ajax is an essential guide for modern JavaScript programming; its practical but comprehensive. It covers everything you need to know to get up to speed with JavaScript development to add dynamic enhancements to web pages and program Ajax-style applications.

6. Object-Oriented JavaScript: Create scalable, reusable high-quality JavaScript applications and libraries - his book treats JavaScript as a serious object-oriented language, showing you how to build robust, maintainable, and powerful libraries and applications. Along the way, we cover many of the recent innovations such as AJAX, JSON, and interesting design and coding patterns. After reading this book, you'll be prepared to ace your JavaScript job interview and even impress with some bits that the interviewer maybe didn't know. You should read this book if you want to be able to take your JavaScript skills to a new level of sophistication.

7. JavaScript: The Good Parts - With JavaScript: The Good Parts, you'll discover a beautiful, elegant, lightweight and highly expressive language that lets you create effective code, whether you're managing object libraries or just trying to get Ajax to run fast. If you develop sites or applications for the Web, this book is an absolute must.

8. Learning jQuery 1.3 - This book will give you the tools you need to be on the cutting edge of the web development community.While covering jQuery v1.3, the techniques discussed are still useful and I still recommend the book highly.

9. Pro JavaScript Techniques - John Resig’s famous book on advanced JS techniques.Pro JavaScript Techniques is the ultimate JavaScript book for the modern web developer. It provides everything you need to know about modern JavaScript, and shows what JavaScript can do for your web sites. This book doesnt waste any time looking at things you already know, like basic syntax and structures.

10. Secrets of the JavaScript Ninja - JavaScript expert John Resig reveals the inside know-how of the elite JavaScript programmers. Written to be accessible to JavaScript developers with intermediate-level skills.

11. Ajax Security - Ajax Security systematically debunks today’s most dangerous myths about Ajax security, illustrating key points with detailed case studies of actual exploited Ajax vulnerabilities, ranging from MySpace’s Samy worm to MacWorld’s conference code validator. Even more important, it delivers specific, up-to-the-minute recommendations for securing Ajax applications in each major Web programming language and environment, including .NET, Java, PHP, and even Ruby on Rails.

12. jQuery Cookbook: Solutions & Examples for jQuery Developers (Animal Guide) - Tips & techniques from the jQuery team rolled up in a cookbook style. You can’t go wrong.

13. jQuery in Action, Second Edition - It shows you how to traverse HTML documents, handle events, perform animations, and add Ajax to your web pages. The book's unique "lab pages" anchor the explanation of each new concept in a practical example. You'll learn how jQuery interacts with other tools and frameworks and how to build jQuery plugins.This is now updated for jQuery v1.4.x as well as jQuery UI 1.8.x. Definitely a must-have for jQuery developers.

14. jQuery: Novice to Ninja - Query: Novice to Ninja is a compilation of best-practice jQuery solutions to meet the most challenging JavaScript problems. In this question-and-answer book on jQuery, you'll find a cookbook of ready-to-go solutions to help breathe life into your web page.

15. MooTools 1.2 Beginner's Guide - MooTools is a simple-to-use JavaScript library, ideal for people with basic JavaScript skills who want to elevate their web applications to a superior level. If you're a newcomer to MooTools looking to build dynamic, rich, and user-interactive web site applications this beginner's guide with its easy-to-follow step-by-step instructions is all you need to rapidly get to grips with MooTools.

16. MooTools Essentials: The Official MooTools Reference for JavaScript™ and Ajax Development - Complete reference to the Mootools library.

17. Practical Dojo Projects (Practical Projects) - Dojo is a library like few others: written by some of the best JavaScript coders around today, providing nearly everything you’ll need to write modern Rich Internet Applications, all in one place. From Ajax to widgets, to client–side persistence and language extensions, and many points in between, Dojo has it all.

In Practical Dojo Projects, you’ll learn all about what Dojo has to offer.

18. Mastering Dojo: JavaScript and Ajax Tools for Great Web Experiences (Pragmatic Programmers) - In Mastering Dojo, you'll get the whole story, from basic usage to advanced idioms. Mastering Dojo starts out with a fast moving tutorial that will give you techniques that you can start using right away. You'll learn all about Dojo Core--the foundation on which all things Dojo stand. See how you can modularize your project for development and automatically package your release for optimal download performance.

19. Professional JavaScript Frameworks: Prototype,YUI, ExtJS, Dojo and MooTools (Wrox Programmer to Programmer) - This book is for web developers who are eager to explore the benefits of JavaScript frameworks. A working knowledge of HTML, CSS, and JavaScript is required.

20. YUI 2.8 Learning the Library - The YUI Library is a set of utilities and controls written in JavaScript for building Rich Internet Applications, across all major browsers and independently of any server technology. There's a lot of functionality baked into YUI, but getting to and understanding that functionality is not for the faint of heart. This book gives you a clear picture of YUI through a step-by-step approach, packed with lots of examples.

YUI 2.8: Learning the Library covers all released (non-beta) components of the YUI 2.8 Library in detail with plenty of working examples, looking at the classes that make up each component and the properties and methods that can be used. It includes a series of practical examples to reinforce how each component should/can be used, showing its use to create complex, fully featured, cross-browser, Web 2.0 user interfaces. It has been updated from its first edition with the addition of several chapters covering several new controls and enriched with lots of experience of using them.

Hosting WCF Service with netTcpBinding on IIS7

noreply@blogger.com (Rajendra) — Sat, 25 Sep 2010 10:15:00 +0000

Web.Config should have following configuration settinggs to hosting WCF service on IIS7(WAS):

<!--<security mode="Transport">

</security>-->

</binding>

</netTcpBinding>

</bindings>

Trouble Shooting on IIS7.*

If following exception thrown while adding service reference-

Error: Cannot obtain Metadata from net.tcp://win-2008.cspl:9002/Multibinding/Service1.svc If this is a Windows (R) Communication Foundation service to which you have access, please check that you have enabled metadata publishing at the specified address. For help enabling metadata publishing, please refer to the MSDN documentation at http://go.microsoft.com/fwlink/?LinkId=65455.WS-Metadata Exchange Error URI: net.tcp://win-2008.cspl:9002/Multibinding/Service1.svc Metadata contains a reference that cannot be resolved: 'net.tcp://win-2008.cspl:9002/Multibinding/Service1.svc'. Could not connect to net.tcp://win-2008.cspl:9002/Multibinding/Service1.svc. The connection attempt lasted for a time span of 00:00:02.0374439. TCP error code 10061: No connection could be made because the target machine actively refused it . No connection could be made because the target machine actively refused it

Step1: Make sure following services is enable for net.tcp

a. Net.Tcp Listener Adapter

b. Net.Tcp Port Sharing Service

If not then enable and start both services.

Step2: IIS Manager -> Select Hosted service -> Action pane -> Advance setting ->

See Enable Protocol, by default http protocol there, need to specify net.tcp with comma separated

Step3: Make sure your application pool is running in classic mode

Step4: Right click on Default Website -> Edit bindings

Make sure net.tcp protocol information there

Step5: Check firewall, Create Inbound and out bound rule for port which we are using.

WCF Service Throttling Behavior

noreply@blogger.com (Rajendra) — Sat, 25 Sep 2010 06:57:00 +0000

WCF Service Throttling is a way for you to limit (“throttle”) the throughput of your service so that resources (memory, CPU, network, etc.) are kept at healthy levels.

While it is not a direct instance management technique, throttling enables you to restrain client connections and the load they place on your service. Throttling enables you to avoid maxing out your service and the underlying resources it allocates and uses. When throttling is engaged, if the settings you configure are exceeded, WCF will automatically place the pending callers in a queue and serve them out of the queue in order. If the client's call timeout expires while pending in the queue, the client will get a TimeoutException.

Using the behaviorConfiguration tag, you add to your service a custom behavior that sets throttled values.
<system.serviceModel>
   <services>
      <service name = "MyService" behaviorConfiguration = "ThrottledBehavior">
         ...
      </service>
   </services>
   <behaviors>
      <serviceBehaviors>
         <behavior name = "ThrottledBehavior">
            <serviceThrottling
               maxConcurrentCalls     = "12"
               maxConcurrentSessions = "34"
               maxConcurrentInstances = "56"
            />
         </behavior>
      </serviceBehaviors>
   </behaviors>
</system.serviceModel>

I have done following test on wcf service for service throttling in different scenarios:

If maxConcurrentCalls =2 then I made 3 calls to service it will execute only two calls at a time remaining call put into the queue execute after first two calls. See following program

<serviceThrottling

maxConcurrentCalls="2"

maxConcurrentSessions="34"

maxConcurrentInstances="56"

static void Main(string[] args)

{

System.Threading.Thread th = new System.Threading.Thread(new System.Threading.ThreadStart(test1));

th.Start();

System.Threading.Thread th1 = new System.Threading.Thread(new System.Threading.ThreadStart(test2));

th1.Start();

System.Threading.Thread th2 = new System.Threading.Thread(new System.Threading.ThreadStart(test3));

th2.Start();

Console.ReadLine();

}

static void test1()

{

ServiceReference1.Service1Client o = newConsoleApplication1.ServiceReference1.Service1Client();

Console.WriteLine("Istance1 " + o.GetData(1));

}

static void test2()

{

ServiceReference1.Service1Client o = new ConsoleApplication1.ServiceReference1.Service1Client();

Console.WriteLine("Istance2 " + o.GetData(2));

}

static void test3()

{

ServiceReference1.Service1Client o = new ConsoleApplication1.ServiceReference1.Service1Client();

Console.WriteLine("Istance3 " + o.GetData(3));

}

Result is:

Each call is taking 5 second to complete.In this sample first two calls execute simaultiniiously and remaining one call executes after 5 seconds.

1. Iif maxConcurrentCalls =3 then I made 3 calls to service it will execute simultaneously

<serviceThrottling

maxConcurrentCalls="3"

maxConcurrentSessions="34"

maxConcurrentInstances="56"

Result is:

3. If maxConcurrentCalls =3 and maxConcurrentSessions="2" then only two calls will be executed rest one call is discarded and any exception will not be raised

<serviceThrottling

maxConcurrentCalls="3"

maxConcurrentSessions="2"

maxConcurrentInstances="56"

Result is:

4. If maxConcurrentInstances="2" then same result found

<serviceThrottling

maxConcurrentCalls="3"

maxConcurrentSessions="12"

maxConcurrentInstances="2"

Result is:

Note: Above result is found with default InstanceContextMode and ConcurrencyMode

That is [ServiceBehavior(InstanceContextMode=InstanceContextMode.PerCall,ConcurrencyMode=ConcurrencyMode.Single)]

Consuming webservice using JQuery Asp.Net application

noreply@blogger.com (Rajendra) — Fri, 12 Feb 2010 12:57:00 +0000

Download:Here

The Web Service methods that I will use revolve around client. Having set up a web site in Visual Studio 2008, I have added a new item of type "Web Service" to the project, calling it Common.asmx. The code-behind - Common.cs - is automatically generated within the App_Code folder . The full code for that class file is as follows:

ClientDataContext db = new ClientDataContext();

    public Common()
    {
    }

    [WebMethod]
    [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
    public Client InsertClient(string BizName)
    {
        Client objClient = new Client();
        objClient.BizName = BizName;
        InsertData(objClient);
        return objClient;
    }

    public void InsertData(Client objClient)
    {
        db.Clients.InsertOnSubmit(objClient);
        db.SubmitChanges();
    }
I have used LINQ for database operation Insert client and return Id.

Create dbml file named with Client.

Include JQuery library:

Return result as Json format following attribute will be responsible
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]

and important do not forget to add attribute for webservice class
[System.Web.Script.Services.ScriptService]

Html code is

Now javascript for achieve ajax with Jquery libarary:


Description
adding refrence of JQuery library

Then a click event is registered with the button which will invoke the InsertClient () function

Document.Ready() It makes sure code is executed only when a page is fully loaded. We often place code blocks inside this Document.Ready() event.

$(document).ready(function() {
            $('#Save').click(InsertClient);
        }
    );

After that is the InsertClient() function that is fired when the button is clicked. It makes use of the $.ajax(options) function within jQuery, and accepts an object with a number of optional properties. type specifies the HTTP method, which in this case is POST. url specifies the URL of the Web Service, together with the web method that is being called. This is followed by the parameters, which are applied to the data property. In this case, BizName parameters are being passed, as we are calling the method that retrieves the entire collection of Client. The contentType and dataType MUST be specified. Following this are two further functions: success defines what should be done if the call is successful and get Id of client with msg['d']['Id'], and error handles exceptions that are returned.

You can see that an object with a property - d - is returned and we displaying Id of client.
    $('#status').html('Id: '+msg['d']['Id']);

Summary

With the marching forward of AJAX to the forefront of building rich interactive websites, jQuery as the lightweight yet powerful JavaScript library also gains ever more prominence. Reflecting on the trend of harnessing the best of the web, this article paints in broad strokes some of the characteristics of jQuery and how we can integrate jQuery into ASP .NET.

Share|

Client validation gridview ASP.NET

noreply@blogger.com (Rajendra) — Wed, 16 Sep 2009 10:25:00 +0000

I am going to explain the GridView Control Client Side (Javascript) Validation instead of server side validation controls.

I have a asp.net gridview which have three textboxes and two dropdownlist fields.Following screen shot showing that.

I am checking product code exists or not in database on onblur event

protected void grdBookinStock_RowDataBound(object sender, GridViewRowEventArgs e)
    {
TextBox txtProductCode = (TextBox)e.Row.FindControl("txtProductCode");
txtProductCode.Attributes.Add("Onblur", "IsProductCodeExist(this.value);");
}

Now Javascript method IsProductCodeExist:

function IsProductCodeExist(txtProductCode) {
            if (txtProductCode != "") {
                var IsExistsValue = (AjaxFunctions.IsProductCodeExists(txtProductCode)).value;

                if (IsExistsValue == false)
                    alert('Product Code does not exists');
            }
        }

Html code for gridview:

<asp:GridView ID="grdBookinStock" BackColor="LightGoldenrodYellow" BorderColor="Tan"
                                BorderWidth="1px" CellPadding="2" ForeColor="Black" AutoGenerateColumns="False"
                                ShowFooter="True" runat="server" OnRowDataBound="grdBookinStock_RowDataBound">
                                <Columns>
                                    <asp:TemplateField HeaderText="Product Code">
                                        <ItemTemplate>
                                            <asp:TextBox ID="txtProductCode" runat="server" MaxLength="6"></asp:TextBox>
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Owner">
                                        <ItemTemplate>
                                            <asp:DropDownList ID="ddlOwner" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlOwner_SelectedIndexChanged">
                                            </asp:DropDownList>
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Warehouse">
                                        <ItemTemplate>
                                            <asp:DropDownList ID="ddlWarehouse" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlWarehouse_SelectedIndexChanged">
                                            </asp:DropDownList>
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Bin">
                                        <ItemTemplate>
                                            <asp:TextBox ID="txtBin" runat="server" MaxLength="12" Enabled="False"
                                             autocomplete="off" AutoCompleteType="Disabled"></asp:TextBox>
                                            <cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" ServiceMethod="GetCompletionList"
                                                UseContextKey="True" MinimumPrefixLength="1" CompletionInterval="500" EnableCaching="false"
                                                CompletionSetCount="12" TargetControlID="txtBin">
                                            </cc1:AutoCompleteExtender>
                                            <cc1:FilteredTextBoxExtender ID="FilteredTextBoxExtender2" FilterType="Custom" ValidChars="1234567890-"
                                                TargetControlID="txtBin" runat="server">
                                            </cc1:FilteredTextBoxExtender>
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Quantity">
                                        <ItemTemplate>
                                            <asp:TextBox ID="txtQuantity" runat="server" MaxLength="8" Enabled="False"></asp:TextBox>
                                            <cc1:FilteredTextBoxExtender ID="FilteredTextBoxExtender1" FilterType="Numbers" TargetControlID="txtQuantity"
                                                runat="server">
                                            </cc1:FilteredTextBoxExtender>
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                </Columns>
                                <FooterStyle BackColor="Tan" />
                                <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
                                <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
                                <HeaderStyle BackColor="Tan" Font-Bold="True" />
                                <AlternatingRowStyle BackColor="PaleGoldenrod" />
                            </asp:GridView>
                        </td>
                    </tr>
                    <tr>
                        <td>
                             
                            </td>
                        <td>
                             
                            <asp:Button ID="btnSave" runat="server" CssClass="control"
                                OnClick="btnSave_Click" OnClientClick="return ValidateData();" Text="Save" />
                            <asp:Button ID="btnCancel" runat="server" CssClass="control"
                                OnClick="btnCancel_Click" Text="Refresh" />
                        </td>
                    </tr>
</Table>

Now I am validate data on save button

Client side Javascript method ValidateData():

function ValidateData() {
            var grid = document.getElementById("<%= grdBookinStock.ClientID %>");
            var cellProductCode;
            var cellOwner;
            var cellWarehouse;
            var cellBin;
            var cellQuantity;
            var cellProductCodeValue;
            var cellOwnerValue;
            var cellWarehouseValue;
            var cellBinValue;
            var cellQuantityValue;

            if (grid.rows.length > 0) {
                //loop starts from 1. rows[0] points to the header.
                for (i = 1; i < grid.rows.length; i++) {

                    cellProductCode = grid.rows[i].cells[0];
                    cellOwner = grid.rows[i].cells[1];
                    cellWarehouse = grid.rows[i].cells[2];
                    cellBin = grid.rows[i].cells[3];
                    cellQuantity = grid.rows[i].cells[4];

                    for (j = 0; j < cellProductCode.childNodes.length; j++) {

                        //if childNode type is CheckBox

                        if (cellProductCode.childNodes[j].type == "text") {
                            cellProductCodeValue = cellProductCode.childNodes[j].value;
                            //alert(cellProductCodeValue);

                        }
                    }

                    for (j = 0; j < cellOwner.childNodes.length; j++) {

                        //if childNode type is CheckBox

                        if (cellOwner.childNodes[j].tagName == "SELECT") {
                            cellOwnerValue = cellOwner.childNodes[j].value;
                            // alert(cellOwnerValue);
                        }
                    }

                    for (j = 0; j < cellWarehouse.childNodes.length; j++) {

                        if (cellWarehouse.childNodes[j].tagName == "SELECT") {
                            cellWarehouseValue = cellWarehouse.childNodes[j].value;
                            //alert(cellWarehouseValue);
                        }
                    }

                    for (j = 0; j < cellBin.childNodes.length; j++) {

                        if (cellBin.childNodes[j].type == "text") {
                            cellBinValue = cellBin.childNodes[j].value;
                            //alert(cellBinValue);
                        }
                    }
                    for (j = 0; j < cellQuantity.childNodes.length; j++) {

                        if (cellQuantity.childNodes[j].type == "text") {
                            cellQuantityValue = cellQuantity.childNodes[j].value;
                            // alert(cellQuantityValue);
                        }
                    }

                    if (cellProductCodeValue != "" || cellOwnerValue != "0" || cellWarehouseValue != "" || cellBinValue != "" || cellQuantityValue != "") {
                        if (cellProductCodeValue == "")
                        { alert('Enter product code');return false; }
                        if (cellOwnerValue == "0") {
                            alert('Select owner.'); return false;
                        }
                        if (cellWarehouseValue == "0") {
                            alert('Select warehouse.'); return false;
                        }
                        if (cellBinValue == "") {
                            alert('Enter bin.'); return false;
                        }
                        if (cellQuantityValue == "") {
                            alert('Enter quantity.'); return false;
                        }

                    }
                    function SetWarehouseIdtoHdnField() {
                       var hdn =document.getElementById('ctl00_ContentPlaceHolder1_hdnWarehouseId')

                       AjaxFunctions.SetValueWarehouse(hdn.value);

                    }

                }

            }
            //return true;
            if (confirm("Are you sure, you want to save the data?")) {
                return true;
            }
            else {

                return false;
            }

        }

If you feeling bother about AjaxFunctions then you can see my old post

http://rajendramalav.blogspot.com/2009/07/call-server-side-method-from-client.html

Custom SEO Friendly Paging Datalist ASP.NET

noreply@blogger.com (Rajendra) — Mon, 31 Aug 2009 14:38:00 +0000

Recently I have implemented paging with the Asp.net Datalist .But according to my client this was not good for SEO purposes and send links to the customer by mail and other ways. So I have done lots of googling and implement paging in following way.
you can check asp.net Datalist Paging on following link

http://amberdev.rockschat.co.uk/GemCollector/

I have created a stored procedure that return paged result set.

ALTER Proc [dbo].[DatalistPaging]
@CategoriesString as varchar(5000),
@PageIndex int=0,
@PageSize int=10,
@Sort VARCHAR(100)=''
As
BEGIN

create table #DataList Paging (Description varchar(200)
,RRP decimal(10,4)
,WebPrice decimal(10,4)
,WebText varchar(200)
,LeadColour varchar(20)
,Prefix varchar(25)
,Gemstone varchar(50)
,CountryName varchar(20)
,CutName varchar(25)
,ShapeName varchar(30)
,Width decimal(6,2)
,[Length] decimal(6,2)
,Depth decimal(6,2)
,Colour varchar(35)
,Clarity varchar(30)
,Grade varchar(5)
,Quantity INT
,Carats decimal(10,4)
,Treatment int
,Calibrated bit
,ProductDetailID int
,ProductCode VARCHAR(10) )

DECLARE @Categories VARCHAR(100)

SET @Categories =RTRIM(LTRIM(@Categories))
INSERT INTO #DataList Paging (Description
,RRP
,WebPrice
,WebText
,LeadColour
,Prefix
,Gemstone
,CountryName
,CutName
,ShapeName
,Width
,[Length]
,Depth
,Colour
,Clarity
,Grade
,Quantity
,Carats
,Treatment
,Calibrated
,ProductDetailID
,ProductCode)

SELECT
ProductDetails.Description
,ProductDetails.RRP
,isnull(ProductDetails.WebPrice ,0) WebPrice
,ProductDetails.WebText
,CategoryLeadColour.LeadColourName AS LeadColour
,CategoryGemstoneVariation.Name as Prefix
,TypeStone.TypeName as Gemstone
,Country.CountryName
,CategoryCut.CutName
,CategoryShape.ShapeName
,ProductDetailGemstone.Width
,ProductDetailGemstone.[Length]
,ProductDetailGemstone.Depth --(if it is > 0)
,CategoryHue.HueName AS Colour
,ISNULL(CategoryClarity.Name,'') AS Clarity
,ISNULL(CategoryClarity.grade,'') as Grade
,ProductDetailGemstone.Quantity
,ProductDetailGemstone.Carats
,ProductDetailGemstone.Treatment
,ProductDetailGemstone.Calibrated
,ProductDetails.ProductDetailID
,ProductDetails.ProductCode

FROM ProductDetails
Inner join ProductDetailGemstone on ProductDetails.ProductDetailID=ProductDetailGemstone.ProductDetailId
LEFT JOIN CategoryShape on CategoryShape.ShapeId=Shape
LEFT JOIN CategoryCut on CategoryCut.CutId=Cut
LEFT OUTER JOIN Country On Country.CountryId = ProductDetailGemstone.Country
LEFT OUTER JOIN CategoryClarity ON CategoryClarity.Id = ProductDetailGemstone.Clarity
LEFT OUTER JOIN CategoryTreatment ON CategoryTreatment.Id = ProductDetailGemstone.Treatment
LEFT OUTER JOIN CategoryHue ON CategoryHue.HueId = ProductDetailGemstone.Colour
LEFT JOIN TypeStone on TypeStone.TypeId=ProductDetailGemstone.Gemstone
LEFT JOIN CategoryGemstoneVariation ON CategoryGemstoneVariation.id=ProductDetailGemstone.Variation
LEFT JOIN CategoryLeadColour ON CategoryLeadColour.LeadColourId=ProductDetails.LeadColour
WHERE CategoryShape.ShapeName =@Categories OR
CategoryCut.CutName = @Categories OR
TypeStone.TypeName = @Categories OR
CategoryGemstoneVariation.Name = @Categories
OR CategoryLeadColour.LeadColourName = @Categories

DECLARE @PageLowerBound int
DECLARE @PageUpperBound int
DECLARE @RowsToReturn int
-- First set the rowcount
SET @RowsToReturn = @PageSize * (@PageIndex + 1)
SET ROWCOUNT @RowsToReturn
-- Set the page bounds
SET @PageLowerBound = @PageSize * @PageIndex
SET @PageUpperBound = @PageLowerBound + @PageSize + 1
-- Create a temp table to store the select results
CREATE TABLE #PageIndex
(
IndexId int IDENTITY (1, 1) NOT NULL,
ProductDetailID int
)
-- Insert into the temp table
IF @Sort='sorthigh'
INSERT INTO #PageIndex (ProductDetailID)
SELECT ProductDetailID FROM #temp ORDER BY ISNULL(#temp.WebPrice,0) desc --#temp.ProductDetailID
ELSE IF @Sort='sortlow'
INSERT INTO #PageIndex (ProductDetailID)
SELECT ProductDetailID FROM #temp ORDER BY ISNULL(#DataList Paging.WebPrice,0)
ELSE
INSERT INTO #PageIndex (ProductDetailID)
SELECT ProductDetailID FROM #DataList Paging ORDER BY #DataList Paging.ProductDetailID

SELECT ProductCode,
dbo.RoundCaratsWt(Carats) as Carats
,Prefix,Gemstone,Description,RRP
,Convert(decimal(10,2),ISNULL(WebPrice,0)) WebPrice
,WebText
,LeadColour
,CountryName AS Country
,CutName AS Cut
,ShapeName As Shape
,Width
,[Length]
,Depth
,Colour
,Clarity
,Grade
,Quantity
,Treatment
,Calibrated
,#DataList Paging.ProductDetailID
FROM #DataList Paging , #PageIndex PageIndex
WHERE #DataList Paging.ProductDetailID = PageIndex.ProductDetailID AND PageIndex.IndexID > @PageLowerBound AND PageIndex.IndexID < @PageUpperBound ORDER BY PageIndex.IndexID Declare @NoofRows INT Declare @NoofPages INT Select @NoofRows=COUNT(1) FROM #DataList Paging --SET @NoofPages = @NoofRows/@PageSize +1 return @NoofRows END

Now call this Stored procedure and get Dataset to populate records to Asp.net datalist Paging in following way:

public DataTable Get_Datalist_Paging (out int intNoofPage) {
string strConn = GlobalDAL.GetConnection();
try
{
SqlParameter[] paramsToStore = new SqlParameter[5]; paramsToStore[0] = new SqlParameter("@CategoriesString", SqlDbType.VarChar);
paramsToStore[0].Value = CategoriesString;
paramsToStore[0].Size = 5000;
paramsToStore[1] = new SqlParameter("@PageIndex", SqlDbType.Int);
paramsToStore[1].Value = PageIndex;
paramsToStore[2] = new SqlParameter("@PageSize", SqlDbType.Int);
paramsToStore[2].Value = PageSize;
paramsToStore[3] = new SqlParameter("@Sort", SqlDbType.VarChar);
paramsToStore[3].Value = Sort;
paramsToStore[4] = new SqlParameter("Return_Value", SqlDbType.Int);
paramsToStore[4].Direction = ParameterDirection.ReturnValue; DataSet ds = SqlHelper.ExecuteDataset(strConn, CommandType.StoredProcedure, "Gem_GetProductsFromCategories", paramsToStore);
intNoofPage = Convert.ToInt32(paramsToStore[4].Value);
return ds.Tables[0];

} catch (Exception excp)
{
throw excp;
}
}

Call following method on page_Load event to populate records to Asp.net datalist Paging --

DataTable objResult = objProducts.Get_Datalist_Paging(out intNoofRows);
public void BindList(DataTable dt)
{
try
{
dlstProductDetail.DataSource = dt;
dlstProductDetail.DataBind();
}
catch (Exception ex)
{
}
finally
{
dt = null;
}
}

private void UpdatePagingText()
{
if (pageIndex > 1 && pageIndex < intpage1 =" pageIndex" intpage2 =" pageIndex;" intpage3 =" pageIndex" pageindex ="=">= 3)
{
intPage1 = pageIndex - 2;
intPage2 = pageIndex - 1;
intPage3 = pageIndex;
}
else if (pageIndex == 1)
{
intPage1 = 1;
intPage2 = 2;
intPage3 = 3;
}
lbtn1.Text = intPage1.ToString();
lbtn1Bottom.Text = intPage1.ToString();
lbtn2.Text = intPage2.ToString();
lbtn2Bottom.Text = intPage2.ToString();
lbtn3.Text = intPage3.ToString();
lbtn3Bottom.Text = intPage3.ToString();

lbtn1.NavigateUrl = strapplicationurl + "Gemstones/" + strCategoryLogo + "/" + lbtn1.Text + "/" + strPageSetting + "/" + strPageSorting + "/" + strFilter;

lbtn1Bottom.NavigateUrl = strapplicationurl + "Gemstones/" + strCategoryLogo + "/" + lbtn1.Text + "/" + strPageSetting + "/" + strPageSorting + "/" + strFilter;
lbtn2.NavigateUrl = strapplicationurl + "Gemstones/" + strCategoryLogo + "/" + lbtn2.Text + "/" + strPageSetting + "/" + strPageSorting + "/" + strFilter;

lbtn2Bottom.NavigateUrl = strapplicationurl + "Gemstones/" + strCategoryLogo + "/" + lbtn2.Text + "/" + strPageSetting + "/" + strPageSorting + "/" + strFilter;
lbtn3.NavigateUrl = strapplicationurl + "Gemstones/" + strCategoryLogo + "/" + lbtn3.Text + "/" + strPageSetting + "/" + strPageSorting + "/" + strFilter;

lbtn3Bottom.NavigateUrl = strapplicationurl + "Gemstones/" + strCategoryLogo + "/" + lbtn3.Text + "/" + strPageSetting + "/" + strPageSorting + "/" + strFilter;

if (pageIndex < navigateurl =" strapplicationurl" navigateurl =" strapplicationurl" pageindex ="=" visible =" false;" visible =" false;"> 1)
{
lbtnPrev.NavigateUrl = strapplicationurl + "Gemstones/" + strCategoryLogo + "/" + (pageIndex - 1) + "/" + strPageSetting + "/" + strPageSorting + "/" + strFilter;
lbtnPrevBottom.NavigateUrl = strapplicationurl + "Gemstones/" + strCategoryLogo + "/" + (pageIndex - 1) + "/" + strPageSetting + "/" + strPageSorting + "/" + strFilter;
}
else if (pageIndex == 1)
{
lbtnPrev.Visible = false;
lbtnPrevBottom.Visible = false;
}

// ShowPageSettings();
}

Handling for above navigate url I have created a
HttpModule for url rewrite-

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;

namespace GemsCollectorBAL.Categories
{
class CategoryModule : IHttpModule
{
public void Init(System.Web.HttpApplication context)
{
context.BeginRequest += new EventHandler(OnBeginRequest);
}
private void OnBeginRequest(object sender, EventArgs e)
{
string strCategrories = string.Empty;
string strPageIndex = string.Empty;
string strPageSetting = string.Empty;
string strSorting = string.Empty;
string strFilter = string.Empty;

int temp = 0;
HttpApplication app;
string requestUrl;

app = sender as HttpApplication;
requestUrl = app.Request.Url.ToString();

strCategrories += "PageIndex=" + strPageIndex + "&";
strCategrories += "PageSetting=" + strPageSetting + "&";
strCategrories += "PageSorting=" + strSorting + "&";
strCategrories += "Filter=" + strFilter ;

}
}

}

String strCurrentPath;
String strCustomPath;
strCurrentPath = app.Request.Path.ToLower();
if (strCurrentPath.IndexOf("/gemstones/") >= 0)
{
strCustomPath = "~/Categories/CategoryDetails.aspx?" + strCategrories;
// rewrite the URL
app.Context.RewritePath(strCustomPath);
}

}

public void Dispose()
{
}
}
}

Register this HttpModule to web.config to Rewrite Url:

<httpModules>

      <add name="CategoryModule" type="GemsCollectorBAL.Categories.CategoryModule,GemsCollectorBAL"/>

    </httpModules>

UI Code Looks like in this way for Asp.net Datalist Paging:

<tr id="trPaging" runat="server">
                <td class="topSubMenu">
                    <table cellpadding="0" cellspacing="0">
                        <tr>
                            <td style="width: 100px" id="tdPageof" runat="server" enableviewstate="false">
                                <b>Page
                                    <%=pageIndex %>
                                    of
                                    <%=Noofpages %>
                                </b>
                            </td>
                            <td id="tdPaging" runat="server" style="width: 425px">
                                <asp:HyperLink ID="lbtnPrev" runat="server" CssClass="topSubMenu"
                                    EnableViewState="False" >Previous</asp:HyperLink>
                                  
                                <asp:HyperLink ID="lbtn1" runat="server" Visible="false" CssClass="topSubMenu" enableviewstate="false">1</asp:HyperLink>
                                  
                                <asp:HyperLink ID="lbtn2" runat="server" Visible="false" CssClass="topSubMenu" enableviewstate="false">2</asp:HyperLink>
                                  
                                <asp:HyperLink ID="lbtn3" runat="server" Visible="false" CssClass="topSubMenu" enableviewstate="false">3</asp:HyperLink>
                                  
                                <asp:HyperLink ID="lbtnNext" runat="server" CssClass="topSubMenu"
                                    EnableViewState="False" >Next</asp:HyperLink>   
                                <asp:HyperLink ID="lbtnShowPaging" runat="server" CssClass="topSubMenu"
                                    EnableViewState="False" >Show All</asp:HyperLink>
                            </td>
                            <td align="right">
                                <b>Sort By:</b>   
                                <asp:HyperLink ID="lbtnHighestPrice" runat="server" CssClass="PagingLinks"
                                    EnableViewState="False">Highest price</asp:HyperLink>   
                                <asp:HyperLink ID="lbtnLowestPrice" runat="server" CssClass="PagingLinks"
                                    EnableViewState="False">Lowest price</asp:HyperLink>
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
        </table>
        <div style="width: 800px">
            <asp:DataList ID="dlstProductDetail" runat="server" RepeatDirection="Horizontal"
                OnItemDataBound="dlstProductDetail_ItemDataBound" RepeatColumns="4"
                EnableViewState="False">
                <ItemTemplate>
                    <table class="ItemBorder" cellpadding="0" cellspacing="0" border="0">
                        <tr id="trTitle" runat="server"   EnableViewState="false">
                            <td align="left" class="ItemTop" colspan="2" runat="server" id="tdView" onserverclick="tdView_Click" EnableViewState="false">

                                    <asp:HyperLink ID="lbtnProductHeader" Width="100%" ForeColor="White" NavigateUrl="" runat="server" enableviewstate="false"></asp:HyperLink>
                            </td>

                        </tr>
                        <tr>
                            <td colspan="2" align="center" style="padding-top: 5px">

                                    <asp:HyperLink ID="imgProducts" ToolTip='<%# DataBinder.Eval(Container.DataItem, "ProductCode")%>' CssClass="ProductImage" runat="server" Height="100px" Width="100px" enableviewstate="false"></asp:HyperLink>
                            </td>
                        </tr>
                        <tr>
                            <td valign="top">
                                <table cellpadding="0" cellspacing="0">

                                </table>
                            </td>
                            <td align="right">

                            </td>
                        </tr>

                        <tr>
                            <td style="width: 20px">
                                 
                            </td>
                            <td style="padding-top: 10px; width: *" align="right">
                                <span class="webprice" enableviewstate="false">£<%# DataBinder.Eval(Container.DataItem, "WebPrice")%></span>
                            </td>
                        </tr>

                    </table>
                </ItemTemplate>
            </asp:DataList>
        </div>

Summary : So we can use this mechanism to all Asp.net binding controls.

ASP.NET Performance Improvement Techniques(GZIP)

noreply@blogger.com (Rajendra) — Fri, 17 Jul 2009 09:57:00 +0000

Now a days lot of web applications have many performance issues. We can easily come out these by implementing some techniques. One of them GZip compression is very important.

The beauty of this new GZip support is how easy it is to use in your own ASP.NET code. For example the the cached RSS feed is GZip encoded which uses GZipStream on the Response.OutputStream fed to an XmlWriter():

Response.ContentType = "text/xml";

Stream Output = Response.OutputStream;

if (Westwind.Tools.wwWebUtils.IsGZipSupported())

{

GZipStream gzip = new GZipStream(Response.OutputStream, CompressionMode.Compress);

Response.AppendHeader("Content-Encoding", "gzip");

Output = gzip;

}

Encoding Utf8 = new UTF8Encoding(false); // No BOM!

XmlTextWriter Writer = new XmlTextWriter(Output,Utf8);

Writer.Formatting = Formatting.Indented;

Writer.WriteStartElement("rss");

…

Writer.WriteEndElement(); // rss

Writer.Close();

Response.End();

GZipStream is a stream acts like a stream filter so you can assign it to an existing stream like ResponseStream can intercept all inbound data then write the updated data into the actual Response stream. It’s super easy to do.

You should always check however if GZip is enabled which is done by this helper method IsGZipSupported() which looks like this:

///

/// Determines if GZip is supported

///

///

public static bool IsGZipSupported()

{

string AcceptEncoding = HttpContext.Current.Request.Headers["Accept-Encoding"];

if (!string.IsNullOrEmpty(AcceptEncoding) &&

AcceptEncoding.Contains("gzip") || AcceptEncoding.Contains("deflate") )

return true;

return false;

}

This ensures that you don’t encode content when the client doesn’t understand GZip and would be unable to read the encoded GZip content. Note that the code checks for either gzip or deflate so this assumes before encoding you’ll pick the right encoding algorithm.

GZip in Page Content

Speaking of encoding - above was XML and raw ResponseStream encoding, but you can also apply GZip content very, very easily to your page level or any ASP.NET level code (such as in an HTTP handler). In fact, you can use a very generic mechanism to encode any output by using a Response.Filter which the following helper method (also in wwWebUtils) demonstrates:

///

/// Sets up the current page or handler to use GZip through a Response.Filter
/// IMPORTANT:
/// You have to call this method before any output is generated!
///

public static void GZipEncodePage()
{
HttpResponse Response = HttpContext.Current.Response;

if (IsGZipSupported())
{
string AcceptEncoding = HttpContext.Current.Request.Headers["Accept-Encoding"];
if (AcceptEncoding.Contains("deflate"))
{
Response.Filter = new System.IO.Compression.DeflateStream(Response.Filter,
System.IO.Compression.CompressionMode.Compress);
Response.AppendHeader("Content-Encoding", "deflate");
}
else
{
Response.Filter = new System.IO.Compression.GZipStream(Response.Filter,
System.IO.Compression.CompressionMode.Compress);
Response.AppendHeader("Content-Encoding", "gzip");
}
}

// Allow proxy servers to cache encoded and unencoded versions separately
Response.AppendHeader("Vary", "Content-Encoding");
}

You can now take this helper function and use this in page level code. For example, the main page in my blog which is HUGE (frequently around 500k) uses it like this:

protected void Page_Load(object sender, EventArgs e)

{

wwWebUtils.GZipEncodePage();

Entry = WebLogFactory.GetEntry();

if (Entry.GetLastEntries(App.Configuration.ShowEntryCount, "pk,Title,Body,Entered,Feedback,Location") < 0)

throw new ApplicationException("Couldn't load WebLog Entries: " + Entry.ErrorMessage);

this.repEntries.DataSource = this.Entry.EntryList;

this.repEntries.DataBind();

}

That’s it. One line and the page will now conditionally GZip encode if the client supports it.

If you really wanted to you can take this even one step further and create a module that automatically sets the Response.Filter early in the pipeline and based on that automatically compresses all content.

However, remember GZip encoding applies compression on the fly so there’s some overhead in the GZip encoding – you are basically adding more CPU processing to your content to reduce the output size. If your content is not that large to start with there’s probably not that much sense in compressing in the first place so I don’t think that whole-sale compression of dynamic content is a good idea.

Caching

But one thing that can mitigate the overhead of GZip compression is caching.

both the RSS feed and the home page are usually heavily cached – the content doesn’t change all that frequently so there’s no reason to keep re-generating it right? If you use GZip on your content you have to be careful to cache both the GZipped content and the non-encoded content or else you’ll feed garbage to clients that don’t understand GZip.

So for example the default page has:

<%@ OutputCache Duration="60" VaryByParam="none" VaryByCustom="GZIP" %>

And then a custom Global.asax handler that looks like this:

public override string GetVaryByCustomString(HttpContext context, string custom)

{

if (custom == "GZIP")

{

if (Westwind.Tools.wwWebUtils.IsGZipSupported())

return "GZip";

return "";

}

return base.GetVaryByCustomString(context, custom);

}

Which results in possibly two different versions of the GZipped page being cached.

And there you have it - GZipped content is easy to create now in ASP.NET 2.0/.NET 2.0 and if judiciously applied it can save some significant bandwidth. On my homepage which is close to 500k of blog text content the GZipped size is 55k or so – nearly a 90% reduction in size. I’d say that’s plenty of worth it, especially when caching is added.

Bookmark this on Delicious

Bind data to dropdownlist from client side javascript

noreply@blogger.com (Rajendra) — Tue, 07 Jul 2009 06:27:00 +0000

var ddlFromWarehouseClientId = document.getElementById("ctl00_ContentPlaceHolder1_grdStockTransfer_ctl01_ddlFromWarehouse");

ddlFromWarehouseClientId.innerHTML = "";
var res1 = (AjaxFunctions.GetStockTranseferData()).value;
ddlFromWarehouseClientId.options.add(new Option("Select", "0", false, false));
var i = 0;
if (res1.Rows.length > 0) {
//CId.options.length = 0;
for (i = 0; i <= res1.Rows.length - 1; i++) {

ddlFromWarehouseClientId.options.add(new Option(res1.Rows[i].Name, res1.Rows[i].Id, false, false));
}
}

Name and Id are database field name

How to call ajax function from client side see my earlier post
http://rajendramalav.blogspot.com/2009/07/call-server-side-method-from-client

Call server side method from client script through Ajax

noreply@blogger.com (Rajendra) — Mon, 06 Jul 2009 07:39:00 +0000

1.Create a class under App_Code folder

public class AjaxFunctions
{

[Ajax.AjaxMethod]
public bool IsNumber(int i)
{
if(i==1)
return true;
else
return false;
}
}

2.Register this class on page_load event of page

Ajax.Utility.RegisterTypeForAjax(typeof(AjaxFunctions));

3. Java script function
function OnChangeFromOwner() {
var res1 = (AjaxFunctions.IsNumber()).value;
}

Access image through url and render as jpeg in asp.net

noreply@blogger.com (Rajendra) — Tue, 30 Jun 2009 14:53:00 +0000

class ImageProcessingModule : IHttpModule
{
public void Init(System.Web.HttpApplication context)
{
context.BeginRequest += new EventHandler(OnBeginRequest);
}
private void OnBeginRequest(object sender, EventArgs e)
{
HttpApplication app;
string requestUrl;

app = sender as HttpApplication;
requestUrl = app.Request.Url.ToString();
//requestUrl=requestUrl.Replace("https://", "http://");

//if (!requestUrl.ToLower().Contains("products")) { return; }
string[] strUrl = requestUrl.Split('/');
string ProductCode = string.Empty;
string Size = string.Empty;

for (int i = 0; i < strUrl.Length; i++)
{
if (strUrl[i].ToLower() == "images" && strUrl[i + 1].ToLower() == "products")
{
if ((i + 2) < strUrl.Length)
ProductCode = strUrl[i + 2];
if ((i + 3) < strUrl.Length)
Size = strUrl[i + 3];

string serverDirectory = app.Server.MapPath("~/UploadImages/" + Size);
string FilePath = System.IO.Path.Combine(serverDirectory, ProductCode) + ".jpg";
//app.Server.Transfer("~/ImageSystem/RetreiveImages.aspx?productcode=" + ProductCode + "&size=" + Size + "",false);
// app.Response.Redirect ("~/UploadImages/" + Size + "/" + ProductCode + ".jpg");

byte[] photo = null;
if (System.IO.File.Exists(FilePath))
{
photo = ReadImage(app.Server.MapPath( "~/UploadImages/" + Size + "/" + ProductCode + ".jpg"));//FilePath;
}
else
{
photo = ReadImage(app.Server.MapPath("~/UploadImages/" + Size + "/Missing.jpg"));//FilePath;

}
if (photo != null)
{
app.Response.ContentType = "image/jpeg";
app.Response.Cache.SetCacheability(HttpCacheability.Public);
app.Response.BufferOutput = false;
app.Response.OutputStream.Write(photo, 0, photo.Length);
}

}
}
// app.Response.Write(ProductCode+" hi "+ Size);

}

public void Dispose()
{
}
private static byte[] ReadImage(string p_postedImageFileName)
{
// bool isValidFileType = false;
try
{
FileInfo file = new FileInfo(p_postedImageFileName);

FileStream fs = new FileStream(p_postedImageFileName, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
byte[] image = br.ReadBytes((int)fs.Length);
br.Close();
fs.Close();
return image;

// return null;
}
catch (Exception ex)
{
return null;
//throw ex;
}
}
}

Web.Config settings
register http module

Integrating BlogEngine into an existing website

noreply@blogger.com (Rajendra) — Fri, 29 May 2009 05:44:00 +0000

Introduction to Blog Engine.Net -

BlogEngine.NET is open source .BlogEngine.NET is a full-featured blogging platform that is a breeze to set up, customize, and use. BlogEngine.NET works with your choice of data source; you may use SQL Server, or you may take the plug'n'play approach using XML files.

Plug 'n' Play
BlogEngine.NET is very easy to setup and customize. To make it work, just upload the files to an ASP.NET 2.0 webserver and you're ready to start writing. No database configuration, just plug'n'play.

Full Featured
BlogEngine.NET comes with all the features you would expect from a modern blog engine as well as new unique features such as AJAX comments and screenshot trackbacks.

Web 2.0
BlogEngine.NET features social bookmarks, OpenSearch support, XFN tags, AJAX, Microsummaries, Gravatars, coComments, tag cloud, Google sitemap and other so-called Web 2.0 features.

Cool Themes
BlogEngine.NET comes with some very cool themes for you to choose from. If you want to modify or create a new theme you can do so easily with just a basic understanding of HTML and CSS.

XHTML Compliance
All the controls in BlogEngine.NET are 100% XHTML 1.0 compliant. All posts you write automatically becomes compliant thanks to the tinyMCE text editor.

Extendable
BlogEngine.NET is built from the ground up using nothing but C# and ASP.NET 2.0 all with simplicity in mind. It means that you can write new controls and themes by using the skills you already have as a .NET developer.

Above information about BlogEngine I have picked from http://www.asp.net/ website.I don't want to describe more about information regarding blog my concern only how to integrate it to existing website.

BlogeEngine support three kinds of membership providers-

We have to change setting in web.config according to your requirement .First of all change setting in custom section blogprovider .

</sectionGroup>

</configSections>

</providers>

</blogProvider>

</BlogEngine>

XmlMembershipProvider: - All data store in App_Data directory of Asp.net .so full rights must be applied on this folder.

Web.Config setting –

</providers>

</membership>

</providers>

</roleManager>

SqlMembershipProvider :- If your application using AspnetMembership then this option will be more useful.

Web.Config setting –

</providers>

</membership>

</providers>

</roleManager>

DbMembershipProvider : - If your website using your on authentication using rather than aspnetmembership then this option will be best.

Web.config settings :

</providers>

</membership>

</providers>

</roleManager>

All of three them I want to describe DbMembershipProvider because other two no need to describe more here. lot of websites using own authentication mechanism so DbMembershipProvider will be best way to integration in my opinion.

Following changes should be made in BlogEngine.Core assembly:-

DB Provider classes are shown in following diagram:-

Change table prefix in DbMembershipProvider.cs . Either set your table prefix or blank

Change table name and field name according to your database in DbMembershipProvider.cs class

Change table prefix , table name and field name according to your database in DbMembershipProvider.cs class

Define roles according to your database entries in web.sitemap

Summary:- BlogEngine.Net is best open source blog application that provide very simple integration providers

We can also implement DBMebershipProvider for custom provider in our application.

Easy steps to create an asp.net website

noreply@blogger.com (Rajendra) — Tue, 14 Apr 2009 13:40:00 +0000

Following tricks which have help to develop an asp.net website in quick way-
1.Form Authentication:
This is a cookie based authentication system where the username and passport is stored in a text file or a database. We will be focusing on this authentication model in this tutorial.
WEB.CONFIG

FormsAuthentication.AuthenticateThe single login button on the webpage calls the Login_Click method when clicked. In this method, we use the FormsAuthentication.Authenticate(username,password) to get ASP.NET to check the credentials of the user. The parameters for this method is pretty straightforward and it just returns a boolean value. FormsAuthentication.RedirectFromLoginPageIf the user is providing proper credentials, then we'll use the FormsAuthentication.RedirectFromLoginPage method. The parameters of this method are a username string and a boolean value. The first parameter is a username string and it is a name of the user for cookie authentication purposes. The value you put in there will be the user name that the client is associated with. It does not need to match the username used in the FormsAuthentication.Authenticate method but it is advisable to set the cookie to the username that was used to log in. The second parameter is a boolean value and it specifies whether or not a durable cookie (one that is saved across browser sessions) should be issued.If you remember, when a user requests a page without proper authentication, they are redirected to the login page. After setting the cookie, the RedirectFromLoginPage will then send the user back to the page they came from.
2.Use Free Tempalates:
Lot of web sites provide us free tempalte for diffrent layout.We can use easily CSS,HTML for our website.
3.Use Log4Net: Log4net is an open source library that allows .NET applications to log statements to a variety of targets.
4.Use Website Starterkits:
To find out starterkit following links should be useful-
http://www.asp.net/community/projects/