好了,我是新来的这整个MVC-世界,但它似乎是做事情,我试图让在这里工作的pretty的好办法。
Ok, so I'm new to this whole MVC-world, but it seems to be a pretty good way of getting things done and I'm trying to make it work here.
的问题是: 我无法从我在我的SQL数据库表中的数据来对我的注册页面的简单下拉型窗体。
The problem is: I can't get data from my table in my SQL-database to a simple drop-down form on my registration page.
我只是不知道往哪儿放了东西,到哪里code打开表,选择IDS,放在哪里的Response.Write
和我该如何将它发送给看法?
I have just no idea where to put the stuff, where to code to open the table, select the ids, where to put the response.write
and how do I send it to the view?
我的模型是这样的:
public class users
{
public string name {get; set;}
public int user_id {get; set;}
}
我的控制器是这样的:
My Controller is this:
[HttpGet]
public ActionResult ListUser()
{
return View();
}
和我的看法是这样的:
@model Community.Models.users
我GOOGLE了2天了,看着几部影片在YouTube上,但没有用的,我找不到它。请,任何人只要有一些知识在这里?并请点我一些很好的教程和/或论坛,在那里我可以了解更多的问题,我可能有
I have googled for 2 days now and watched several videos on youtube but of no use, I can't find it. Please, anyone with some knowledge here? And please point me to some good tutorials and/or forums where I can browse for more questions I might have
在这个项目上仍然没有运气。
Still no luck on this project..
我要创建一个表单和表单内,我希望有一个DB-环路(的IEnumerable
)。但目前的模式是不是的IEnumerable
。我是pretty的多卡,看了一堆教程和他们都只是列表中的一个连接,如果我想两个型号?
I'm creating a form and within that form, i want a db-loop (IEnumerable
).. But the current model is not a IEnumerable
. I'm pretty much stuck, watched a bunch of tutorials and they all just list ONE connection, what if I want two models?
下面是我的控制,我得到你必须通过一个列表视图,对吧?
Here is my Controller, I get that you must pass a list to the view, right?
public ActionResult Registration()
{
return View(db.users.ToList());
}
我怎么弄个该列表中的在我看来不用其他的的IEnumerable
模式?
@neoistheone,你的例子并没有帮助我很多,我的数据库打开这样的:
@neoistheone, your example didnt help me much, my DB opens like this:
private DataBaseContext db = new DataBaseContext();
和我不知道如何,但它打开的连接。 我试过这么多小时,现在,它只是傻了,还没有睡洙长!
and i don't know how, but it opens the connection. I've tried for so many hours now, its just silly, haven't slept for soo long!
我已经习惯了编程ASP-经典仅供参考,这是我第一次认真尝试升级有关编程的最高最新的语言和OOP我的知识。
I'm used to programming ASP-Classic fyi, and this is my first serious try to upgrade my knowledge about programing an up-to-date language and OOP.
推荐答案
添加的SelectList
到模型:
public SelectList DropDownList { get; set; }
建立类的集合:
build the class for that collection:
public class MyListTable
{
public string Key { get; set; }
public string Display { get; set; }
}
,然后在你的控制器,用于加载从数据库 MyListTable
类中的数据:
var list = new List<MyListTable>();
using (SqlConnection c = new SqlConnection(cString))
using (SqlCommand cmd = new SqlCommand("SELECT KeyField, DisplayField FROM Table", c))
{
using (SqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
list.Add(new MyListTable
{
Key = rdr.GetString(0),
Display = rdr.GetString(1)
});
}
}
}
var model = new users();
model.DropDownList = new SelectList(list, "Key", "Display");
,最后,你需要你的模型发送给视图:
and then finally, you need to send your model to the view:
return View(model);
现在的剃刀可以显示这一点:
Now in the Razor you can display this:
@Html.DropDownListFor(m => Model.DropDownList);
您当然可以命名这些东西更好的名字,但你的想法。
You of course can name these things better names, but you get the idea.
相关推荐
最新文章