SQL Data Sourse

<div>
   
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:AlfaConnectionString %>" DeleteCommand="DELETE FROM tblEmployee FROM tblEmployee INNER JOIN tblDepartment ON tblEmployee.DepartmentId = tblDepartment.DeptId WHERE (tblEmployee.Id = @Id)" InsertCommand="INSERT INTO tblEmployee(Id, Name, Gender, DepartmentId) VALUES (@Id, @Name, @Gender, @DepartmentId)" SelectCommand="SELECT Id,Name,DeptName,DepartmentId,Gender FROM tblEmployee  emp
inner join tblDepartment dep on emp.DepartmentId=dep.DeptId" UpdateCommand="UPDATE tblEmployee SET Name = @Name, Gender = @Gender, DepartmentId = @DepartmentId WHERE (Id = @Id)">
            <DeleteParameters>
                <asp:Parameter Name="Id" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="Id" />
                <asp:Parameter Name="Name" />
                <asp:Parameter Name="Gender" />
                <asp:Parameter Name="DepartmentId" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="Name" />
                <asp:Parameter Name="Gender" />
                <asp:Parameter Name="DepartmentId" />
                <asp:Parameter Name="Id" />
            </UpdateParameters>
        </asp:SqlDataSource>

    </div>