<%@ Page Language="C#" %>
<html xmlns="http://www.w3.org/1999/xhtml" >
<body>
<form id="Form1" runat="server">
<asp:SqlDataSource ID="DataSrc1" runat="server" ConnectionString=
"server = localhost; uid=sa ; pwd =; database = ORGANIZATION"
SelectCommand="SELECT * FROM EMPLOYEES" />
<asp:GridView ID="MyGrid" DataSourceID="DataSrc1" runat="server"
DataKeyNames="EmployeeId" SelectedIndex="0"
AutoGenerateSelectButton="true" />
<asp:SqlDataSource ID="DataSrc2" 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 EmployeId = @Original_EmployeId"
DeleteCommand="DELETE EMPLOYES WHERE EmployeeId=@Original_EmployeeId"
InsertCommand="INSERT INTO EMPLOYES (DepID,SurName,FirstName,Phone)
VALUES(@DepID,@SurName,@FirstName,@Phone)"
FilterExpression="EmployeeId={0}"
OnDeleted="OnChgData" OnInserted="OnChgData" OnUpdated="OnChgData" >
<FilterParameters>
<asp:ControlParameter Name="EmployeeId" ControlID="MyGrid"
PropertyName="SelectedValue" />
</FilterParameters>
</asp:SqlDataSource>
<asp:DetailsView ID="MyDetails" DataSourceID="DataSrc2"
runat="server" DataKeyNames="EmployeeId"
AutoGenerateDeleteButton="True"
AutoGenerateEditButton="True"
AutoGenerateInsertButton="True"/>
</form>
</body>
</html>
<script language="C#" runat="server">
void OnChgData(Object sender, EventArgs e) { MyGrid.DataBind(); }
</script>