Title: Operation data in asp.net2.0 class and operation data in
墨初 知识笔记 115阅读
The class is at 2.0. There is no additional method for intelligent perception, we can input it manually. At present, the usage of AddRange and AddWithValue has not been tested, and the following tests have passed. Sql database : entity class : users of the system; Use the system. Data; Use the system. Configuration; Use the system. Network use system. Network security; Use the system. Network. UI uses the system. Network. UI。 WebControls uses this system. Network. ui。 Web control. Web parts; Use the system. Network. UI。 html controls/* *///summary///Summarydescriptionforperson////summarypanpublicclasssperson { publicstringpName； publicstringpPwdpublicstringpEmailpublicperson(){///
/ TODO: Add constructor logic here//
}
}
操作类：personOperater
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.Sql;
/// <summary>
/// Summary description for personOperater
/// </summary>
public class personOperater
{
public personOperater()
{
//
// TODO: Add constructor logic here
//
}
public static bool insertPerson(person p)
{
SqlConnection myconn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["laura"].ToString());
myconn.Open();
SqlCommand mycmd = new SqlCommand("insert into users(UserName,UserPwd,UserEmail) values(@pName,@pPwd,@pEmail)", myconn);
SqlParameter para = new SqlParameter("@pName", SqlDbType.VarChar, 20);
para.Value = p.pName;
mycmd.Parameters.Add(para);
para = new SqlParameter("@pPwd", SqlDbType.VarChar, 50);
para.Value = p.pPwd;
mycmd.Parameters.Add(para);
para = new SqlParameter("@pEmail", SqlDbType.VarChar, 50);
para.Value = p.pEmail;
mycmd.Parameters.Add(para);
mycmd.ExecuteNonQuery();
myconn.Close();
return true;
}
}
access数据库：
实体类：同上
操作类：personOperater
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
/// <summary>
/// Summary description for personOperater
/// </summary>
public class personOperater
{
public personOperater()
{
//
// TODO: Add constructor logic here
//
}
public static bool insertPerson(person p)
{
OleDbConnection myconn = new OleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings["lxj"].ToString());
myconn.Open();
OleDbCommand mycmd = new OleDbCommand("insert into users(UserName,UserPwd,UserEmail) values(@pName,@pPwd,@pEmail)", myconn);
OleDbParameter para= new OleDbParameter("@pName",OleDbType.VarChar, 20);
para.Value = p.pName;
mycmd.Parameters.Add(para);
para = new OleDbParameter("@pPwd",OleDbType.VarChar, 50);
para.Value = p.pPwd;
mycmd.Parameters.Add(para);
para = new OleDbParameter("@pEmail", OleDbType.VarChar, 50);
para.Value = p.pEmail;
mycmd.Parameters.Add(para);
mycmd.ExecuteNonQuery();
myconn.Close();
return true;
}
}
