错误例子~~
zen...@gmail.com
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Web;
/// <summary>
/// Summary description for EmployeesDB
/// </summary>
public class EmployeesDB
{
public EmployeesDB()
{
}
/// <summary>
/// 读取全部product的信息
/// </summary>
///
<returns>返回List范型变量，范型以Product类来建立，则必须对应有Product.cs存在</returns>
///
这里下面会采用一种描述方法，即原例子，可改部分，改的例子
/// 如 List<Product> LoadAllProduct,List<*>
LoadAll*，List<Person> LoadAllPerson
/// （*表示可改部分）
///
基本上可以归纳为"Product"这个词都可以改，红色字都可以改。
public List<Employees> LoadAllEmployees()
{
//创建这个List出来
//List<*> *=new List<*>(),List<Person> person=new
List<Person>()
List<Employees> Employees = new List<Employees>();
//连接字符串语句
SqlConnection conn = new
SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
//填写SQL语句
//string commandText="select * from *",string
commandText="select * from Person"
string commandText = "select * from Employees";
//下面是启动并读取数据库
SqlCommand command = new SqlCommand(commandText, conn);
conn.Open();
SqlDataReader dr = command.ExecuteReader();
while
(dr.Read())//一个循环函数，由第一行度到最后一行
{
Employees Em = new Employees();
//Person per=new Person();
//对应Product的字段
Em.em_id = (string)dr["em_id"];
//per.Pno=(varchar)dr["PersonID"];
Em.em_name = (string)dr["em_name"];
Em.sex = (string)dr["sex"];
Em.birth = (string)dr["birth"];
Em.cla = (string)dr["cla"];
Em.depart = (string) dr["depart"];
Em.dorm = (string)dr["dorm"];
Em.do_phone = (string)dr["do_phone"];
Em.handphone = (string)dr["handphone"];
Em.email = (string)dr["email"];
Em.qq = (string)dr["qq"];
Employees.Add(Em);
//调用List<Products>的ADD方法
}
dr.Close();
conn.Close();
return Employees;
}
/// <summary>
/// 负责更新
/// </summary>
/// <param name="pro"></param>
public void UpdateEmployees(Employees Em)
{
SqlConnection conn = new
SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand updatecmd = new SqlCommand("UPDATE Employees set
em_id=@em_id,em_name=@em_name,sex=@sex,birth=@birth,cla=@cla,depart=@depart,dorm=@dorm,do_phone=@do_phone,handphone=@handphone,email=@email,qq=@qq
where em_id=@em_id", conn);
updatecmd.Parameters.Add(new SqlParameter("@em_id", Em.em_id));
updatecmd.Parameters.Add(new SqlParameter("@em_name",
Em.em_name));
updatecmd.Parameters.Add(new SqlParameter("@sex", Em.sex));
updatecmd.Parameters.Add(new SqlParameter("@birth", Em.birth));
updatecmd.Parameters.Add(new SqlParameter("@cla", Em.cla));
updatecmd.Parameters.Add(new
SqlParameter("@depart",Em.depart));
updatecmd.Parameters.Add(new SqlParameter("@dorm", Em.dorm));
updatecmd.Parameters.Add(new SqlParameter("@do_phone",
Em.do_phone));
updatecmd.Parameters.Add(new SqlParameter("@handphone",
Em.handphone));
updatecmd.Parameters.Add(new SqlParameter("@email", Em.email));
updatecmd.Parameters.Add(new SqlParameter("@qq",Em.qq));
conn.Open();
updatecmd.ExecuteNonQuery();
conn.Close();
}
/// <summary>
///删除
/// </summary>
/// <param name="pro">输入类pro</param>
/// <returns>影响函数</returns>
public int DeleteEmployees(Employees Em)
{
SqlConnection conn = new
SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand delcmd = new SqlCommand("delete from employees where
em_id=@em_id", conn);
delcmd.Parameters.Add(new SqlParameter("@em_id", Em.em_id));
conn.Open();
int i=delcmd.ExecuteNonQuery();
conn.Close();
return i;
}
}
zen...@gmail.com
<?xml version="1.0"?>
<configuration>
<connectionStrings>
<add name="Personal" connectionString="Data
Source=.\SQLExpress;Integrated Security=True;User
Instance=True;AttachDBFilename=|DataDirectory|work_weekly_Data.mdf"/>
<!--<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data
Source=.\SQLExpress;Integrated Security=True;User
Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/>-->
</connectionStrings>
<system.web>
<pages styleSheetTheme="White"/>
<customErrors mode="RemoteOnly"/>
<compilation debug="true"/>
<!--<authentication mode="Forms">
<forms loginUrl="Default.aspx" protection="Validation"
timeout="300"/>
</authentication>-->
<authorization>
<allow users="*"/>
</authorization>
<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
<roleManager enabled="true"/>
<siteMap defaultProvider="XmlSiteMapProvider" enabled="true">
<providers>
<add name="XmlSiteMapProvider" description="SiteMap provider which
reads in .sitemap XML files." type="System.Web.XmlSiteMapProvider,
System.Web, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a" siteMapFile="web.sitemap"
securityTrimmingEnabled="true"/>
</providers>
</siteMap>
</system.web>
<!--<location path="Admin">
<system.web>
<authorization>
<allow roles="Administrators"/>
<deny users="*"/>
</authorization>
</system.web>
</location>-->
</configuration>