温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:最简单,最适合入门学习的三层架构例子
当前文件:
MVCTest/DAL/userdb.cs,打开代码结构图
MVCTest/DAL/userdb.cs,打开代码结构图1using System; 2
using System.Collections.Generic; 3
using System.Linq; 4
using System.Text; 5
using System.Data.SqlClient; 6
using System.Configuration; 7
//该源码下载自www.51aspx.com(51aspx.com) 8
//首发地址:http://bbs.51aspx.com/showtopic-3620.html 9
10
namespace DAL 11
{ 12
public class userdb 13
{ 14
public bool adduser(Model.user model) 15
{ 16
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString); 17
con.Open(); 18
using (SqlCommand cmd = new SqlCommand("INSERT INTO qzzm_user(Name) VALUES(@Name)", con)) 19
{ 20
cmd.Parameters.AddWithValue("@Name", model.Name); 21
if (cmd.ExecuteNonQuery() > 0) 22
return true; 23
else return false; 24
} 25
} 26
} 27
} 28





}
}