Tuesday, 30 December 2014

Enhancing WebGrid with Insert Update and Delete Operations Using Repository Pattern with Entity Framework in ASP.NET MVC 4 Razor

Hi friends, in this article I will explain about How to Enhance the WebGrid with Insert Update and Delete Operations Using Repository Pattern with Entity Framework in ASP.NET MVC 4 Razor.
I already explained in the previous articles about How to Update multiple rows at once Using MVC 4 Razor and Entity FrameworkMVC 4 Razor: Delete multiple rows in WebGrid with CheckBox selection and with confirmation in ASP.NET using C#.NET and MVC 4 Razor: How to Select / Deselect All Checkboxes inside a Webgrid in ASP.NET Application using C#.NET.
Repository pattern is used to create an abstraction layer between the data access layer and the business logic layer. 

Wednesday, 10 December 2014

MVC 4 Razor: Frozen Rows and Columns Webgrid Using jQuery Like Excel Sheet

Hi friends,in this article I will explain about How to make Frozen Rows and Columns Webgrid Using jQuery Like Excel Sheet in MVC 4 Razor 
I already explained in the previous articles about MVC 4 Razor: Bind jQuery DatePicker Calendar in MVC WebGrid Using ASP.NET MVC, C#.NetMVC4 Razor: Handling multiple submit buttons on the same View and MVC 4 Razor: Create Nested WebGrid with Expand/Collapse in ASP.NET MVC4
So for this article first we will create a new ASP.NET MVC 4 application. After creating this application add the model class in you project and add the below code.

Monday, 8 December 2014

Monday, 1 December 2014

MVC4 Razor: How to bind the Checkboxlist from the database || How to create a CheckboxList in MVC4 Razor

Hi friends,in this article I will explain about How to bind the Checkboxlist from the database or How to create a CheckboxList in MVC4 Razor or How to implement Checkboxlist in MVC 4 Razor.
In this article we will go over implementing CheckBoxList in ASP.Net MVC 4 Razor.
Let’s try to understand this with an example. We will be using Courses table in this example as shown in the below figure.

MVC 4 Razor: Inline Editing in WebGrid || WebGrid with inline editing, updating, cancel and delete the record using JSON AJAX

Hi friends,in this article I will explain about Inline Editing in WebGrid using MVC 4 Razor or  WebGrid with inline editing, updating, cancel and delete the record using JSON AJAX.

In this, toggle command is used to swap the data between the two presentations on a line-by-line basis.Get the userdata and pass in to WebGrid.There are two things in each item one is Display mode and second is Edit mode.we Display all Edit Item is Display none at First Time.when click on Edit Button the Edit Item is Shown.

Thursday, 27 November 2014

MVC 4 Razor: Send Email with multiple attachments in ASP.NET using C#

Hi friends,in this article I will explain about How to Send Email with multiple attachments in ASP.NET  MVC 4 Razor:
For sending mail from ASP.NET MVC we use the "System.Net.Mail" namespace. Let's explain how to do this.
I already explained in the previous articles about MVC 4: How to bind dropdownlist inside WebGrid in MVC 4 Razor using C# ,Create/Generat PDF with image Using RazorPDF in ASP.Net MVC and MVC4: Show Multiple Models in a Single View using dynamically created object.

Thursday, 20 November 2014

Monday, 17 November 2014

ASP.NET AJAXControlToolkit SlideShowExtender control without using Web Service example

Hi friends,in this article I will explain about ASP.NET AJAXControlToolkit SlideShowExtender control without using Web Service example.
SlideShowExtender used to how to build image Slide Show by fetching images from Folder or Directory using the ASP.Net AJAX Control Toolkit SlideShow Extender control.

Upload And Read Excel Data/(.csv/.xls)File into DataSet and display in Gridview in Asp.Net using C#/VB.NET

Hi friends,in this article I will explain about how to upload Excel File and then read and import its data into DataSet or DataTable using C# and VB.Net in ASP.Net Web Application.
I already explained in the previous articles about Creating Dynamic CSS Menu From Database SQL Server in ASP.Net Using C#.Net/VB.NETJQuery: Send (Pass) Data (Values) from one page to another using Form Post and Search GridView records (data) on TextBox KeyPress using jQuery in ASP.NET using C#/VB.NET

Friday, 14 November 2014

MVC Export Data to Excel using C# || Export Data from Database Table to Excel File in MVC ASP.NET

Hi friends,in this article I will explain about how to Export Data to Excel using MVC || Export Data from Database Table to Excel File in MVC ASP.NET.
Let us start with an example user details. Add User_id, User name, Gender, Country to the database then we can export it to the excel sheet.

Thursday, 6 November 2014

Friday, 24 October 2014

Creating Dynamic CSS Menu From Database SQL Server in ASP.Net Using C#.Net/VB.NET

Hi friends,in this article I will explain about How to Create Dynamic menu is one of the most important parts if a website development. So today I will show you how you can create dynamic css menu with database(SQL Server using in ASP.NET using CSS.
First we will search for the menu which we want to implement dynamically. 
After this we will create table in which we will add the menu item detail. In this article I have used two table one for parent and other for child table. In this child table contains the reference of parent table.

Tuesday, 21 October 2014

MVC:JQuery UI Datepicker Calender Control In Asp.Net Mvc Application || How to Use jQuery Calender In MVC3

Hi friends,in this article I will explain about How to use Datepicker Calender Control In Asp.Net Mvc Application || How to Use jQuery Calender In MVC3.
Datepicker is a nice and cool plugin for displaying the calendar with ease. It is very easy to use JQuery plugin, it comes as part of JQueryUI library, so if you want to use this – first download JQueryUI from http://jqueryui.com/download and also download JQuery(http://docs.jquery.com/Downloading_jQuery) if you haven’t done so yet.

Friday, 17 October 2014

JQuery: Send (Pass) Data (Values) from one page to another using Form Post

Hi friends,in this article I will explain about How to send Data (Values) from one page to another using Form Post.
The Source Page has an HTML Button with a jQuery Click event handler. When the Button is clicked, an HTML Form is created and appended to the BODY Tag of the page. The action is set to the Destination page (Destinationpage.aspx). Using the AddParameter function values of the Name TextBox ,Qualification TextBox and the Technology DropDownList is appended to the Form as Hidden Fields and then the Form is submitted

Friday, 10 October 2014

Search GridView records (data) on TextBox KeyPress using jQuery in ASP.NET using C#/VB.NET

Hi fiends,in this article I will explain about How to Search GridView records (data) on TextBox KeyPress using jQuery in ASP.NET using C#/VB.NET

For searching Gridview records I used the jQuery QuickSearch Plugin.
The jQuery QuickSearch Plugin is applied using the jQuery CSS class selector for each TextBox inside the GridView Header Row.

Thursday, 9 October 2014

MVC 3:How to pass or send List from Controller to View in ASP.NET using C#

Hi friends,in this article I will explain about How to pass or send List from Controller to View
At first we will create model class and pass list of model class object from controller to view.
Our model class is very simple. It contains only two properties called user_Id , userName  and country. User_Id is int type userName  and country both are string type.

Wednesday, 8 October 2014

Split and convert Comma Separated String or any Delimited String to Table in SQL Server

Hi friends,in this article I will explain about How to Split and convert Comma Separated String or any Delimited String to Table in SQL Server
In this article I will explain with examples, how to split and convert a comma separated / delimited string to a table using Split function in SQL Server 2005, 2008 and 2012 versions. The string containing words or letters or numbers separated (delimited) by comma or underscore or  plus(+) ,etc,. will be split into Table values.
I will also explain how to use the Split function to split a string in a SQL Query or Stored Procedures in SQL Server 2005, 2008 and 2012 versions.

Thursday, 2 October 2014

Ajax ColorPickerExtender example in ASP.NET or how to use ColorPicker extender in ASP.NET

HI Friends,in this article I will explain about Ajax ColorPickerExtender example in ASP.NET or how to use ColorPicker extender in ASP.NET
First you will have to download the latest binary of the AJAX Control Toolkit from CodePlex site. To download click here.
Once that is done you will need to Add Reference of the Ajax Control Toolkit DLL as shown in figure below figure

Tuesday, 30 September 2014

How to disable/Prevent/Don’t allow the User from Entering HTML tags in Textbox/TextArea

Hi Friends,in this article I will explain about How to disable/Prevent/Don’t allow the User from Entering HTML tags in Textbox/TextArea.
When you enter html tags as shown below figure and click on submit button 

Friday, 26 September 2014

Custom paging for GridView using DataList in ASP.NET using C#/VB.NET to increase SQL perfomance

Hi friends,in this article I will explain about How to do Custom paging for GridView using DataList in ASP.NET using C#/VB.NET to increase SQL perfomance
When there are bulk records to show in the GridView, developers often use paging to distribute the complete records with multiple pages to show the records in the GridView. This means that, when you change the page index, the GridView is bound everytime  from the database to show the next records.

How to Send (Pass) Data (Values) from one page to another using jQuery with QueryString

Hi friends,in this article I will explain about How to Send (Pass) Data (Values) from one page to another using jQuery with QueryString
The page PassDataJQueryQueryString.aspx (Source Page), this is the page from where we want to pass (send) data. This page consists of an TextBox for Name ,TextBox for Qualification and DropDownList for Technology whose values we need to pass (send) to the other page(DestinationPage.aspx).

Tuesday, 23 September 2014

Validate (check) File Size before upload using jQuery in ASP.NET

Hi friends,in this article I will explain about How to validate (check) File Size before upload using jQuery in ASP.NET.
The below code will help you to get the  File Size before upload using jQuery in ASP.NET and restrict or validation for the max file size.

Monday, 22 September 2014

Export GridView selected rows to Excel or word in ASP.NET using C#/VB.NET

Hi friends,in this I will explain about how to Export GridView selected rows to Excel or word in ASP.NET using C#/VB.NET
To explain further about how to export selected row data from asp.net gridview, we need to create database table to read data and bind retrieved resultset to gridview, so simply execute following script to sql query editor to create database table and then add few records manually or download complete example code with script at the end of the page.

Sunday, 21 September 2014

Preview image before upload using FileUpload control and jQuery in ASP.NET

Hi friends,in this article I will explain about how to preview image before upload using FileUpload control and jQuery in ASP.NET
                    While for the browsers that support HTML5 i.e. Internet Explorer 10 and 11+, Mozilla FireFox, Google Chrome and Opera, the image preview is displayed usingHTML5 FileReader API.

Friday, 19 September 2014

Disable Button Double Click to prevent multiple postbacks in ASP.NET using C#/VB.NET Or Prevent button double-click

Hi friends,in this article I will explain about How to Disable Button Double Click to prevent multiple postbacks in ASP.NET using C#/VB.NET  Or Prevent button double-click.
Most of the times we wish to disable the asp.net button control just after the first click so that we may prevent multiple postbacks.

Wednesday, 17 September 2014

URL Routing ASP.NET using C#/VB.NET or How to Implement URL Routing in ASP.Net Web Forms 4.0

Hi friends,in this article I will explain about URL Routing ASP.NET using C#/VB.NET or How to Implement URL Routing in ASP.Net Web Forms 4.0
URL Routing is supported in .Net 3.5 SP1 or higher frameworks, if you want to use it in Visual Studio 2008 you will need to install .Net Framework 3.5 Service Pack 1.

Tuesday, 16 September 2014

How to Capture Screenshot (Snapshot) Image of Website (Web Page) in ASP.Net using C# and VB.Net

Hi friends,in this article I will explain about How to Capture Screenshot (Snapshot) Image of Website (Web Page) in ASP.Net using C# and VB.Net
To capture the screenshot (snapshot) of a Website web page, I am making use of WebBrowser control of Windows Forms Application.

Friday, 5 September 2014

How to display SubTotal and Grand Total in ASP.Net GridView using C#/VB.NET

Hi friends,in this article i will explain about How to display SubTotal and Grand Total in ASP.Net GridView using c#/VB.NET.

I already explained in the previous articles about How to Edit GridView using BoundField Column in ASP.Net using C#/VB.NETCode First Approach using Entity Framework 4.0 Sample example and How to create PDF document in ASP.NET with C#/VB.NET using iTextSharp

The records are divided into Groups and then SubTotal is calculated for each Group and then displayed using a dynamic Row in GridView.

Thursday, 4 September 2014

How to Edit GridView using BoundField Column in ASP.Net using C#/VB.NET

Hi friends,in this article I will explain about How to Edit GridView using BoundField Column in ASP.Net using C#/VB.NET.
I already explained in the previous articles about Code First Approach using Entity Framework 4.0 Sample exampleHow to create PDF document in ASP.NET with C#/VB.NET using iTextSharp and Telerik RadGrid Grouping -Drag and Drop a column header to group by that column in ASP.NET using C#/VB.NET

When the GridView Row enters Edit Mode, the BoundField column gets converted to a TextBox dynamically to allow user modify the values.

Saturday, 23 August 2014

How to Backup All Databases in SQL Server

Hi friends,in this article I will explain about How to Backup All Databases in SQL Server.
Below  is a SQL script to get all Databases Backup in specified folder.
Backup file name will be like "DataBaseName_{Date}-{Month}-{Year}.bak"

Friday, 22 August 2014

How to create PDF document in ASP.NET with C#/VB.NET using iTextSharp

Hi friends,in this article I will explain about How to create PDF document in ASP.NET with C#/VB.NET using iTextSharp.
What is iTextSharp:
iTextSharpopen source Java library for PDF generation and manipulation. It can be used to create PDF documents from scratch, to convert XML to PDF (using the extra XFA Worker DLL), to fill out interactive PDF forms, to stamp new content on existing PDF documents, to split and merge existing PDF documents, and much more.
          Here I’m going to explain how to create PDF document in ASP.NET using iTextSharp. First we have to download iTextSharp.dll class library and include to our project.  

Monday, 7 July 2014

Friday, 13 June 2014

How to get Distinct Count across Multiple Tables in SQL Server

Hi Friends,in this article I will explain about  How to get Distinct Count across Multiple Tables in SQL Server.
I already explained in the previous articles about How to Remove/Delete duplicate records/Rows from a table in SQL Server,SQL Server 2008 : How to Remove Special Characters in a String , STUFF and PATINDEX Examples and How to alter primary key column for existing table in sql server 2008
Before knowing How to get Distinct Count across Multiple Tables first know about UNION ALL Operator.

Thursday, 10 April 2014

Filter and Sorting in GridView using DataView in ASP.NET using C#/VB.NET

Hi friends,in this article i will explain about Filter and Sorting in GridView using DataView.
I already explained in the previous articles about Create your own captcha image generator in ASP.NET using C#.NET/VB.NET,How to create a RDLC report using asp.net with c# /VB.NET and Create ,list and Alter the trigger associated with a table with SQL Server?

Create your own captcha image generator in ASP.NET using C#.NET/VB.NET

Hi friends,in this article i will explain about Create your own captcha image generator in ASP.NET using C#.NET/VB.NET.
In previous articles i explained about How to Create Simple RDLC Report in ASP.NET,Create ,list and Alter the trigger associated with a table with SQL Server? and Binding and Sorting Grid in ASP.NET MVC using Jquery.

How to create a RDLC report using ASP.NET with C# /VB.NET

Hi friends,in this article I will explain about How to Create Simple RDLC Report in ASP.NET.
I already explained in the previous articles about Filter and Sorting in GridView using DataView in ASP.NET using C#/VB.NET,How to Maintain selected Checkboxes state while paging in GridView? and Create your own captcha image generator in ASP.NET using C#.NET/VB.NET
In ASP.NET page add the below lines in the top of the page after page directive.

Saturday, 22 March 2014

How to send emails using HTML Templates in ASP.NET using C#/VB.NET

Hi Friends,in this article i will explain about Send Email using HTML template or HTML formatted email in ASP.NET.
I already explained in the previous articles about How to Create Simple RDLC Report in ASP.NET,Create your own captcha image generator in ASP.NET using C#.NET/VB.NET and Filter and Sorting in GridView using DataView.

Write the following lines in web.config file.

Friday, 21 February 2014

Thursday, 6 February 2014

SQL SERVER – Simple Example of Cursor.

Hi Friends,in this article I will explain about SQL SERVER – Simple Example of Cursor..
I already explained in the previous articles about How to Scroll Page Automatically by few pixels after every few seconds using JQuery,VS Shortcuts | Shortcut keys for Visual Studio and JQuery:How to Disable Cut,Copy and Paste of TextBox in ASP.NET

Wednesday, 8 January 2014

© 2012-2014 Aspdotnet-Kishore.blogspot.com. All Rights Reserved.
The content is copyrighted to Kishore and may not be reproduced on other websites without permission from the owner.