// GET: Docentes/Delete/5
public ActionResult Delete(int?id)
{
var dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("nombre", typeof(int));
dt.Rows.Add(1, "pedro");
dt.Rows.Add(2, "maria");
var parametros = new SqlParameter("@lst", SqlDbType.Structured);
parametros.Value = dt;
parametros.TypeName = "dbo.DatasPersona"; //tipo de dato
using (var dd = new TestUmgEntities())
{
dd.Database.ExecuteSqlCommand("exec sqlInsertPersona @sql", parametros);
}
/*
* create type{
* id int,
* nombre varchar(50)
* }
*
* create procedure sqlInsertPersona(
* @lst DatosPersona READONLY
* )as begin
* inset into persona (name,cp)
* select * from @sql
* fin
*/
return(View());
}
public ActionResult dropList()
{
List <Docente> ll = null;
using (var ddd = new TestUmgEntities())
{
ll = (from d in ddd.docente
select new Docente
{
Id = d.id,
nombre = d.nombre
}).ToList();
}
List <SelectListItem> items = ll.ConvertAll(d =>
{
return(new SelectListItem
{
Text = d.nombre.ToString(),
Value = d.Id.ToString(),
Selected = true
});
}).ToList();
ViewBag.ll = items;
return(View());
}
