dotnet-sai

Whats is Dapper? Dapper.NET is an Open-Source, lightweight ORM developed by the developers of Stack Overflow. They develop this ORM keeping performance in Mind. Dapper is authored by Sam Saffron of Stack Overlfow. One of Common things which is required by most of application is accessing data from relational database. If we are using three layered Architecture that we Use Data access layer (DAL) for getting records from database and Perfoming various CRUD operation. If we are using Entity FrameWork (ORM) Object relationship and mapping then we are using Dbcontext for Creating Connection and getting records from database. Now we are going to see more simple way of access data from Database Using open source ORM called Dapper. It is Easy to use and write as compare to Entity framework. Here is link visit this site and learn dapper ORM . http://www.c-sharpcorner.com/UploadFile/4d9083/performing-crud-operation-with-dapper-in-mvc/  And Also in Performa

For first time learn C# Programming Language in Hindi By :- Shivprasad Koirala sir https://www.youtube.com/watch?v=4ye4LyJolaY

This article provides the procedure for capturing an image from a webcam and store it in folder. http://www.c-sharpcorner.com/UploadFile/4d9083/capturing-image-from-web-cam-in-Asp-Net/ Click here to read more................

Display Date in words in Sql Using User Define Function In this article I will explain how to User Define Function in sql for displaying dates   Click here to read more................

How to get output parameter from store procedure in sql ? In this article I will explain how to get output parameters returns by stored procedure in asp.net.  Click here to read more................

What is DataList Control ? The DataList control is, like the Repeater control, used to display a repeated list of items that are bound to the control. However, the DataList control adds a table around the data items by default. The DataList control may be bound to a database table, an XML file, or another list of items. Here we will show how to bind an XML file to a DataList control. The Templates are as follows: 1) ItemTemplate 2) AlternatingitemTemplate 3) HeaderTemplate 4) FooterTemplate 5) SeperatorTemplate 6) SelectedItemTemplate 7) EditItemTemplate HeaderTemplate: This template is used for elements that you want to render once before your ItemTemplate section. ItemTemplate: This template is used for elements that are rendered once per row of data. It is used to display records AlternatingItemTemplate: This template is used for elements that are rendered every second row of data. This allows you to alternate background colors. It works on even number of records on

  Click Here Download Entire Code   Click here to read more................  

Developing ASP.NET MVC 4 Web Applications for Beginners Create new project -> Select visual C# -> inside that select Web Select [ASP.NET MVC4 Web Application] Enter name as [MyfirstMvcApplication]  Click here to read more................

Learn MVC Basics MVC is model view controller pattern and architectural design principal. That separate components of web application. This separation gives us more control over individual part of application. It lets easily develop modify and tested.  Click here to read more................

What is Repeater Control ? How to bind data to Repeater Control ? Repeater is a Data Bind Control. Repeater Control Is Use for Displaying Records repeated. Repeater control is lightweight and faster to display data when compared with gridview and datagrid. Repeater Control Use: Repeater Control is used to display repeated list of items that are bound to the control and it’s same as gridview and datagridview. Repeater control is lightweight and faster to display data when compared with gridview and datagrid. By using this control we can display data in custom format but it’s not possible in gridview or datagridview and it doesn’t support for paging and sorting. The Repeater control works by looping through the records in your data source and then repeating the rendering of its templates called item template. Repeater control contains different types of template fields those are, 1) ItemTemplate 2) AlternatingitemTemplate 3) HeaderTemplate 4) FooterTemplate 5) S

Developing of RDLC reporting with Dataset in Asp.net What Is RDLC? This is one of tool which comes with Microsoft Visual studio RDLC stands for Report Definition Language Client-side. RDLC can be run completely client-side in the ReportViewer control. This removes the need for a Reporting Services instance, and even removes the need for any database connection whatsoever; but it adds the requirement that the data that is needed in the report has to be provided manually. RDLC reports do not store information about how to get data. RDLC reports can be executed directly by the ReportViewer control. We give this option to users to download there on copy of result what they want from search result. Click here to read more................  

Here I am Explaining all Example of Gridview with various Events What is Gridview ?   Displays the values of a data source in a table where each column represents a field and each row represents a record. The GridView control enables you to select, sort, and edit these items. Click here to read more................ Gridview inside gridview in Asp.net I am going to show you a simple example of a gridview control to show records of parent and child . Means when user clicks on parent records it should all child records regarding that parent record. Here I have taken two tables Click here to read more................   How to assign a dropdownlist box value to textbox in javascript I am going to show you a simple example How to assign a dropdownlist box value to textbox in javascript Click here to read more................  

For Asp.net Beginners: All Gridview Example : Here I am Explaining all Example of Gridview with various Events What is Gridview ?   Displays the values of a data source in a ...

What is a Web Service? Web Services are business logic components, which provide functionality via the Internet using standard protocols such as HTTP. Web Services uses Simple Object Access Protocol (SOAP) in order to expose the business functionality. SOAP defines a standardized format in XML, which can be exchanged between two entities over standard protocols such as HTTP. SOAP is platform independent so the consumer of a Web Service is therefore completely shielded from any implementation details about the platform exposing the Web Service. For the consumer it is simply a black box of send and receives XML over HTTP. So any web service hosted on windows can also be consumed by UNIX and LINUX platform

What is Cookies? Reference from :- http://www.c-sharpcorner.com/uploadfile/annathurai/cookies-in-Asp-Net/ Cookiesis a small piece of information stored on the client machine. This file is located on client machines "C:\Document and Settings\Currently_Login user\Cookie" path.  Its is used to store user preference information like Username, Password,City and PhoneNo etc on client machines. We need to import namespace called  Systen.Web.HttpCookie before we use cookie.   Type of Cookies? Persist Cookie - A cookie has not have expired time Which is called as Persist Cookie Non-Persist Cookie - A cookie has expired time Which is called as Non-Persist Cookie How to create a cookie?   Its really easy to create a cookie in the Asp.Net with help of Response object or HttpCookie   Exp 1 :           HttpCookie userInfo = new HttpCookie ( "userInfo" );         userInfo[ "UserName" ] = "Annathurai" ;         userInfo[ "

What is page life cycle in ASP.NET 2.0 ? Refernce from:- http://www.dotnetuncle.com/aspnet/71_page_life_cycle.aspx ASP.NET 2.0 Page Life Cycle - The lifetime of an ASP.NET page is filled with events. A .NET technical interview might begin with this question. A series of processing steps takes place during this page life cycle. Following tasks are performed: 1) Initialization 2) Instantiation of controls 3) Restoration & Maintainance of State 4) Running Event Handlers 5) Rendering of data to the browser The life cycle may be broken down into Stages and Events. The stages reflect the broad spectrum of tasks performed. The following stages take place 1) Page Request - This is the first stage, before the page life cycle starts. Whenever a page is requested, ASP.NET detects whether the page is to be requested, parsed and compiled or whether the page can be cached from the system. 2) Start - In this stage, properties such as Request and Response are set. Its also determin

What is event bubbling? Server controls like Datagrid, DataList, and Repeater can have other child controls inside them. Example DataGrid can have combo box inside datagrid. These child control do not raise there events by themselves, rather they pass the event to the container parent (which can be a datagrid,datalist, repeater), which passed to the page as “ItemCommand” event. As the child control sendevents to parent it is termed as event bubbling.  Refernce from:- .NET Interview Questions 4 th Edition By Shivprasad Koirala

What is difference between dataset and data reader? Following are some major differences between dataset and data reader:- Data Reader provides forward-only and read-only access to data, while the Dataset object can hold more than one table (in other words more than one row set) from the same data source as well as the relationships between them. Dataset is a disconnected architecture while data reader is connected architecture. Dataset can persist contents while datareader cannot persist contents, they are forward only.  Refernce from:- .NET Interview Questions 4 th Edition By Shivprasad Koirala

Create and Implement 3-Tier Architecture in ASP.Net What is a Layer? A layer is a reusable portion of code that performs a specific function. In the .NET environment, a layer is usually set up as a project that represents this specific function. This specific layer is in charge of working with other layers to perform some specific goal. Let’s briefly look at the latter situation first. Click here to read more................  

Create Simple Web Service in Visual Studio 2008 / 2010 /2012 How to create a simple Web service When creating a New Project, under the language of your choice, select "Web" and then change to .NET Framework 3.5 and you will get the option to create an ASP.NET WEB Service Application. Click here to read more................

What is Globalization and Localization in ASP.Net Before starting, let's get these two terms straight. Globalization is the process of designing the application in such a way that it can be used by users from across the globe (multiple cultures). Localization, on the other hand, is the process of customization to make our application behave as per the current culture and locale. These two things go together.   Click here to read more................  

Store and Retrieve Image in Crystal Reports From SQL Database and Folder Using ASP.Net Saving and displaying images in database tables is a common requirement in ASP.NET projects. There are two ways to store images in a database: Store image URLs in the database as a normal string. Store image as binary data. The purpose of this article is: Show how you to upload and save images directly in a SQL Server database table as binary data and display in Crystal Reports. Show how you to store images in a folder and display in Crystal Reports. Use the following procedure to do this. Click here to read more................

How to Export Crystal Report on Button Click in to PDF, Excel, Word, HTML, Rtf in ASP.NET C#. What Is Crystal Reports? "In simplest terms, Crystal Reports is a report design tool that allows you to create reports capable of retrieving and formatting a result set from a database or other data source. In addition to simply reading data from a data source, Crystal Reports has its own formula language for creating calculations and includes a number of features that can be used to turn raw data into presentation-quality reports, with graphs, charts, running totals, and so on." (David McAmis, Professional Crystal Reports for Visual Studio .NET, 2 nd edition ) We give this option to users to download there on copy of result what they want from search result. Click here to read more................