Expertrating - ASP.Net Tutorial, Advance Practical Examples on DataGrid

Home > Courses, Tutorials & eBooks > ASP.NET Tutorial > Advance Practical Examples on DataGrid

ASP.NET Tutorial - Advance Practical Examples on DataGrid

Page 1 of 5

Advance Practical Examples on DataGrid

It is seen that there are many obstacles involved in developing the software of ASP.NET Therefore, this section will discuss some of the professional examples which would be very useful in developing critical movements.

Adding an EditCommandColumn to a DataGrid Control

An EditCommandColumn displays the most common editing commands which can be used to display Edit, Update, and Cancel buttons. This command plays no role in editing, but it displays the user interface for editing a row, which is an important aspect in web programming.

The following example demonstrates it: -

Example 46 ExpertDataGridEditCommandColumn.aspx

<%@ Import Namespace="System.Data.SqlClient" %>

<Script Runat="Server">

Sub Page_Load

If Not IsPostBack Then

BindDataGrid

End If

End Sub

Sub BindDataGrid

Dim conNorthwind As SqlConnection

Dim cmdSelect As SqlCommand

conNorthwind=New SqlConnection( "Server=localhost; UID=sa;PWD= secret;Database=Northwind" )

cmdSelect = New SqlCommand( "Select * From Employees", conNorthwind )

conNorthwind.Open()

dgrdEmployees.DataSource = cmdSelect.ExecuteReader()

dgrdEmployees.DataBind()

conNorthwind.Close()

End Sub

Sub dgrdEmployeesEditCommand( s As Object, e As DataGridCommandEventArgs )

dgrdEmployees.EditItemIndex = e.Item.ItemIndex

BindDataGrid

End Sub

</Script>

<html>

<head><title>ExpertDataGridEditCommandColumn.aspx</title></head>

<body>

<form Runat="Server">

<asp:DataGrid

ID="dgrdEmployees"

OnEditCommand="dgrdEmployeesEditCommand"

AutoGenerateColumns="False"

CellPadding="11"

Runat="Server">

<Columns>

<asp:BoundColumn

HeaderText="Designation Of Employees"

DataField="Title" />

<asp:EditCommandColumn

EditText="Edit!"

UpdateText="Update!"

CancelText="Cancel!" />

</Columns>

</asp:DataGrid>

</form>

</body>

</html>

The output of above example is shown below:

ExpertRating ASP.NET Certification - Get Certified Now!!