Calling from Controller
public ActionResult Index()
{
//join use
//change view model.
String sql = "SELECT * FROM faculties ";
db.List(sql);
var dt = db.List(sql);
var model = new Faculty().List(dt);
return View(model);
}
public ActionResult Index()
{
//join use
//change view model.
String sql = "SELECT * FROM faculties ";
db.List(sql);
var dt = db.List(sql);
var model = new Faculty().List(dt);
return View(model);
}
Add a method to class
List<Faculty> list = new List<Faculty>();
public List<Faculty> List(DataTable dt)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Faculty fac = new Faculty();
fac.FacultyId = Convert.ToInt32(dt.Rows[i]["FacultyId"]);
fac.Name = dt.Rows[i]["Name"].ToString();
fac.Description = dt.Rows[i]["Description"].ToString();
list.Add(fac);
}
return list;
}
Comments
Post a Comment