How To Export Gridview To Excel in Asp.Net

How To Export Gridview To Excel in Asp.Net In this tutorial i am explaining How To Export Gridview To Excel In Asp.Net  using C#. In this tutorial i am not exporting Gridview with Paging in Excel.Here i have used XML File a Data Source for Gridview. How to Export Gridview To Excel In Asp.Net using c# helps us

How to Redirect to Another Page by Click on LinkButton in GridView

How to Redirect to Another Page by Click on LinkButton in GridView In this tutorial i will let you know that how can you pass value from GridView Row data value to another page.Here i used Linkbutton for this inside GridView, When you get redirected to the new page you can get the id in the query

Gridview Edit Delete Update

Gridview Edit Delete Update In this tutorial i will let you know about the Edit, Delete, Update functionality in Gridview using C#.In this we are using Gridview Events like Gridview_updating, Gridview_Deleteing, Gridview_CancelingEdit. For this we start from creating a connection.How to create a connection in asp.net you can find that on following post here. Design View:- <%@

DELETE Trigger in SQL Server

DELETE Trigger in SQL Server A DELETE trigger is a kind of stored procedure that executes itself when a DELETE statement deletes data from a table or view on which the trigger has been configured. When a DELETE trigger is fired, deleted rows from the affected table are placed in a special table i.e (deleted

How To Check Leap Year In Asp.Net

How To Check Leap Year In Asp.Net In this post i am going to explain that how to check that current year is Leap or not in Asp.Net.It is very simple and having just a few lines of code. Method 1:- protected void Page_Load(object sender, EventArgs e) { Int32 Year = DateTime.Now.Year; if (DateTime.IsLeapYear(Year)) {

SQL Server IDENTITY Reset

SQL Server IDENTITY Reset In this tutorial i will let you know about SQL Server IDENTITY Reset.In SQL server table that have IDENTITY property are auto incremented according to IDENTITY incremental value set by us.You have noticed that whenever you deleted all records from your table, next insert start IDENTITY column not from 0 or 1.To