本文整理汇总了C#中System.Data.SqlHelper.Sql2Table方法的典型用法代码示例。如果您正苦于以下问题：C# SqlHelper.Sql2Table方法的具体用法？C# SqlHelper.Sql2Table怎么用？C# SqlHelper.Sql2Table使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlHelper的用法示例。
在下文中一共展示了SqlHelper.Sql2Table方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Contact
public ActionResult Contact()
{
ViewBag.Message = "與我們聯絡";
/*
List<string> DepartmentList = new List<string>();
DepartmentList.Add("業務部");
DepartmentList.Add("創意部");
DepartmentList.Add("行銷部");
ViewBag.DepartmentList = DepartmentList;
return View();
*/
List<department> departmentlist = new List<department>();
SqlHelper hp = new SqlHelper();
DataTable tb = hp.Sql2Table("select id,cname from dep");
department depobj;
foreach(DataRow r in tb.Rows)
{
depobj = new department();
depobj.id = r["id"].ToString();
depobj.departmentName = r["cname"].ToString();
departmentlist.Add(depobj);
}
//return View(departmentlist);
departmentlist.Clear();
depobj = new department();
depobj.id = "a001"; depobj.departmentName = "業務部";
departmentlist.Add(depobj);
depobj = new department();
depobj.id = "a002"; depobj.departmentName = "創意部";
departmentlist.Add(depobj);
depobj = new department();
depobj.id = "a003"; depobj.departmentName = "行銷部";
departmentlist.Add(depobj);
return View(departmentlist);
}示例2: Index
// GET: Department
public ActionResult Index(string departmentid)
{
//ViewBag.departmentid = departmentid;
SqlHelper hp = new SqlHelper();
DataTable tb = hp.Sql2Table("select id,cname from dep where id=" + departmentid);
department depobj = new department();
if (tb.Rows.Count==1)
{
depobj.id = tb.Rows[0]["id"].ToString();
depobj.departmentName = tb.Rows[0]["cname"].ToString();
}
else
{
ModelState.AddModelError("","無此編號的部門存在");
}
return View(depobj);
}