<%@ Page Language="C#" %>
<html xmlns="http://www.w3.org/1999/xhtml" >
<body>
<form id="Form1" runat="server">
<asp:SqlDataSource ID="DataSrc" runat="server" ConnectionString=
"server = localhost; uid=sa ; pwd =; database = ORGANIZATION"
SelectCommand="SELECT * FROM EMPLOYEES"
UpdateCommand= "UPDATE EMPLOYEES SET
DepID = @DepID, SurName = @SurName,
FirstName = @FirstName, Phone = @Phone
WHERE EmployeeId = @Original_EmployeeId"
DeleteCommand= "DELETE EMPLOYEES WHERE
EmployeeId = @Original_EmployeeId" />
<asp:GridView ID="MyGrid" DataSourceID="DataSrc" runat="server"
AutoGenerateEditButton="true"
AutoGenerateDeleteButton="true"
DataKeyNames="EmployeeId"/>
</form>
</body>
</html>