当从mvc3的下拉列表中选择特定的表名时,如何列出带有复选框的表的所有字段
本文关键字:何列出 复选框 字段 下拉列表 mvc3 选择 当从 | 更新日期: 2023-09-27 18:03:59
当在下拉列表中选择特定的表名时,我需要获得所有表字段列表以及复选框。
我已经完成了编码,以获得所有的表名下拉列表是
public ActionResult Dropdown()
{
List<string> results = new List<string>();
using (var etm = new MovieDBEntities())
{
results = etm.ExecuteStoreQuery<string>("SELECT name FROM sys.tables ORDER BY name").ToList();
}
ViewBag.results = results;
return View();
}
1。获取表的名称和对象id
using (var etm = new MovieDBEntities())
{
results = etm.ExecuteStoreQuery<Dictionary<string,string>>("SELECT name,object_id FROM sys.tables ORDER BY name");
}
2。编写代码将对象id发送给新动作方法
ActionResult GetColumns(int object_id)
{
List<string> cols = new List<string>();
using (var etm = new dbStudentsInfoEntities())
{
cols = etm.ExecuteStoreQuery<string>("SELECT name FROM sys.columns where object_id=" + object_id + " ORDER BY name").AsQueryable().ToList();
}
ViewBag.Output=cols ;
}
3。查看页面
foreach (string a in ViewBag.Output)
{
<input type="checkbox" value="@a" name="chk" /> @a
}