Categories
Asp, Asp.net

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:- <%@ […]

Categories
Sql Server

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 […]

Categories
Asp, Asp.net

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)) { […]

Categories
Sql Server

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 […]