1.创建数据库,创建数据表,并添加测试数据(按要求添加主外键)
2.在Visual Studio创建项目
3.添加Model数据模型
4.创建视图窗体
5.为下拉框绑定数据(从数据库)
protected void Page_Load(object sender, EventArgs e)
{
ChangeDBEntities db = new ChangeDBEntities();
var result = (from a in db.Catelog select a).ToList();
if (!IsPostBack)
{
this.DropDownList1.DataSource = result;
this.DropDownList1.DataTextField = "Name";
this.DropDownList1.DataValueField = "id";
this.DropDownList1.DataBind();
}
}
6.添加数据
protected void Button1_Click(object sender, EventArgs e)
{
//实例化数据库
ChangeD