BD Union

create database Name
use Name

CREATE TABLE tblEmployee
(
  Id int Primary Key,
  Name nvarchar(30),
  Gender nvarchar(10),
  DepartmentId int
)
go

alter table tblEmployee
add constraint fk_tblEmployee
foreign key (DepartmentId)references  tblDepartment(DeptId)
go


drop constraint fk_tblEmployee
CREATE TABLE tblDepartment
(
 DeptId int Primary Key,
 DeptName nvarchar(20)
)

Insert into tblDepartment values (1,'IT')
Insert into tblDepartment values (2,'Payroll')
Insert into tblDepartment values (3,'HR')
Insert into tblDepartment values (4,'Admin')

Insert into tblEmployee values (1,'John', 'Male', 3)
Insert into tblEmployee values (2,'Mike', 'Male', 2)
Insert into tblEmployee values (3,'Pam', 'Female', 1)
Insert into tblEmployee values (4,'Todd', 'Male', 4)
Insert into tblEmployee values (5,'Sara', 'Female', 1)
Insert into tblEmployee values (6,'Ben', 'Male', 3)

select * from tblEmployee


delete from tblEmployee where Id=11
create view Vw_Dep
as
select  Id, Name, Gender, DeptName
from tblEmployee
inner join tblDepartment
on tblEmployee.DepartmentId = tblDepartment.DeptId

Consultas

Consulta Select

SELECT Id,Name,DeptName,DepartmentId,Gender FROM tblEmployee  emp
inner join tblDepartment dep on emp.DepartmentId=dep.DeptId


Update

UPDATE tblEmployee SET Name = @Name, Gender = @Gender, DepartmentId = @DepartmentId WHERE (Id = @Id)

Insert

INSERT INTO tblEmployee(Id, Name, Gender, DepartmentId) VALUES (@Id, @Name, @Gender, @DepartmentId)

Delete

DELETE FROM tblEmployee FROM tblEmployee INNER JOIN tblDepartment ON tblEmployee.DepartmentId = tblDepartment.DeptId WHERE (tblEmployee.Id = @Id)

Java Skrip Condicion

<Columns>
                <asp:CommandField ShowDeleteButton="false" ShowEditButton="true" />
                    <asp:TemplateField HeaderText="">
                        <ItemTemplate>
                            <asp:LinkButton runat="server" OnClientClick="return hpl_eliminar(this,event)"  CommandName="Delete">Eliminar</asp:LinkButton>
                        </ItemTemplate>
                    </asp:TemplateField>
                <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id" />
                <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                <asp:BoundField DataField="DeptName" HeaderText="DeptName" SortExpression="DeptName" />                                  
                <asp:BoundField DataField="Gender" HeaderText="Gender" SortExpression="DepartmentId" Visible="false"/>
            </Columns>

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>

Esteli.css

}
 .mGrid th{
                 background-color:blue;
                 color:white;


          }
 .mGrid tr{

     font-family:Arial;
     font-size:12px;
 
 }

 .mGrid td{

      padding:4px;
      border-color:#c1c1c1;
 }


Clase dataview

 <link href="CSS/Diseño.css" rel="stylesheet" />
 <script src="mensajes.js"></script>

    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="SqlDataSource1" PagerStyle-CssClass="pgr"   CssClass="mGrid">
        <AlternatingRowStyle CssClass="alt" />

</Columns>
            <PagerStyle CssClass="pgr" />
 </asp:GridView>

Mensajes.js

function hpl_eliminar(s, e) {
    if (confirm('¿Proceder a eliminar?'))
        return true;
    else
        return false;
}

Herameintas

/*herramientas para el crud asp.net
- SqlDataSource
- GridView
- DetailView

* En SqlDataSource realizar la conexión a la base de datos
* en GridView habilitar:
paginación
delete
update
* En DetailView habilitar
Inserción

------------------------------------------------------------------------*/

.navbar{ margin-bottom:0; } .jumbotron{ background:#3B81B6; color:#fff; padding:20px 0; margin-bottom:0; } p.diseno { text-align: center; } h1.dis{ text-align: center; } h2.ber{ color: green; text-align: center; } .carousel-inner img.img-responsive { margin-left: auto; margin-right: auto; } .card-text { text-align: center; margin-top: 10px; } /* #jardines .card { position: relative; display: block; margin-bottom: .75rem; background-color: #F8F8F8; border: 1px solid #e5e5e5; border-radius: .25rem; height: 195px; } .card-block { padding: 1.25rem; } */ .card-header:first-child { border-radius: calc(.25rem - 1px) calc(.25rem - 1px) 0 0; } .card-header { padding: .75rem 1.25rem; margin-bottom: 0; background-color: #999; color:#FFF; border-bottom: 1px solid rgba(0,0,0,.125); } .bd-example > .card { max-width: 20rem; } .text-xs-center { text-align: center!important; } .card { position: relative; display: block; margin-bottom: .75rem; background-color: #fff; border-radius: .25rem; border: 1px solid rgba(0,0,0,.125); } div.espacio{ clear: both; margin:30px 0; } footer{ margin-top:50px; background-image: url('http://www.jardinesdelasabana.com.ni/images/homenajeparasiempre.jpg'); background-size: cover; } footer hr { margin-top: 20px; margin-bottom: 20px; border-top: 1px solid #999; } /*.bottombar { background: #000; padding: 8px 0px; }*/ div.bordtop { border-top: 5px solid green; } .card-header:hover{ background: #3B81B6; cursor: pointer; }