Nov 26, 2012

My Login Page

I have create login page by altering in PSD file 


-------------------------------------

Nov 20, 2012

How To do Shopping CART In asp.net

There are some links i found on internet for shopping cart website.

http://www.codeproject.com/Articles/17674/GridView-Order-Page-Shopping-Cart-Page-ASP-NET-SQL

http://net.tutsplus.com/tutorials/other/build-a-shopping-cart-in-aspnet/

(free and open source shopping cart )
http://www.nopcommerce.com/default.aspx



( some helpfull code )
http://howtouseasp.net/how-to-do-shopping-cart-in-asp-net-c/

http://www.codeproject.com/Tips/403267/ShoppingCart-using-Gridview-in-ASP-NET

http://www.ajaxprojects.com/ajax/tutorialdetails.php?itemid=423

http://my.safaribooksonline.com/book/web-development/microsoft-aspdotnet/0957921861/building-an-aspdotnet-shopping-cart/aspnet-chp-12

( download ER-Diagrams of Ecommerce website )
http://www.uml-diagrams.org/examples/online-shopping-example.html

(Download Sample)
http://csharpdotnetfreak.blogspot.com/2009/05/aspnet-creating-shopping-cart-example.html

http://www.aboutmydot.net/web-development/shopping-cart-in-aspnet.html

( LIVE  DEMO )
http://www.dotnetcart.com/livedemo.htm

( Demo and Source code)
http://www.znode.com/asp-net-shopping-cart-source-code.aspx

(Sample and Source code)
http://www.codeproject.com/Articles/3765/Easy-ASP-NET-Shopping-Cart

(sample and source code )
http://www.c-sharpcorner.com/UploadFile/ShrutiShrivastava/ASPNetShoppingCart11262005063508AM/ASPNetShoppingCart.aspx


(Sample , source code and link )
http://www.c-sharpcorner.com/forums/thread/160928/developing-a-shopping-cart-in-asp-net.aspx

(download source sample )
http://www.aspfree.com/c/a/c-sharp/creating-an-online-shopping-cart-and-paypal-system/

(Nope commerce free open source)
http://www.nopcommerce.com/default.aspx

Show HTML REPORT in asp.net



------------------------------------------------------------------------------------------------------------

Nov 17, 2012

pivot tables in sql server tutorial

Click on below link

http://www.kodyaz.com/articles/t-sql-pivot-tables-in-sql-server-tutorial-with-examples.aspx

Jun 27, 2012

How to Search Duplicate Records in SQL



SELECT catrefcode, COUNT(*) TotalCount
FROM importedcatref
GROUP BY catrefcode
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC


Jun 8, 2012

Handle Error on Web.Config file.

I prefer to use a generic error page, and redirect from there :

<system.web>
<customErrors mode="On" defaultRedirect="Errors.aspx"/>
</system.web>

And, in errors.aspx :

errors.aspx
-----------------
<html>
<script language="VB" runat="server">
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles 
MyBase.Load
Dim errMessage As String = ""
Dim appException As System.Exception = Server.GetLastError()
If (TypeOf (appException) Is HttpException) Then
Dim checkException As HttpException = CType(appException, HttpException)
Select Case checkException.GetHttpCode
Case 400
errMessage &= "Bad request. The file size is too large."
Case 401
errMessage &= "You are not authorized to view this page."
Case 403
errMessage &= "You are not allowed to view that page."
Case 404
errMessage &= "The page you have requested can't be found."
Case 408
errMessage &= "The request has timed out."
Case 500
errMessage &= "The server can't fulfill your request."
Case Else
errMessage &= "The server has experienced an error."
End Select
Else
errMessage &= "The following error occurred<BR>" & appException.ToString
End If
ErrorMessage.Text = errMessage & "<BR>We're sorry for the inconvenience."
Server.ClearError()
End Sub
</script>
<body>
<hr>
<asp:label id="ErrorMessage" font-size="12" font-bold="true" runat=server/>
<hr>
<p>Return to <a href=http://yourserver.com/>our entry page</a>
</body>
</html>
---------------



What is the use of n-tier architecture and 3-tier architecture?

how to implement 3-tier architecture in asp.net using c#. 3-Tier architecture is also called layered architecture. Some people called it ...