// 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()); }