public static bool AddTbmember(Tbmember member, string regip)
{
bool check = false;
try
{
SqlCommand sqlcommnad = new SqlCommand("Pro_AddUsers", sqlconn.GetConn());
sqlcommnad.CommandType = CommandType.StoredProcedure;
//指定参数
sqlcommnad.Parameters.Add("@membername", SqlDbType.VarChar, 50).Value = member.Membername;
sqlcommnad.Parameters.Add("@pwd", SqlDbType.VarChar, 50).Value = member.Pwd;
sqlcommnad.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = member.Eamil;
sqlcommnad.Parameters.Add("@tel", SqlDbType.VarChar, 50).Value = member.Tel;
sqlcommnad.Parameters.Add("@yingyezhizhao", SqlDbType.VarChar, 50).Value = member.Yingyezhizhao;
sqlcommnad.Parameters.Add("@memberturename", SqlDbType.VarChar, 50).Value = member.Memberturename;
sqlcommnad.Parameters.Add("@companyadress", SqlDbType.VarChar, 50).Value = member.Companyadress;
sqlcommnad.Parameters.Add("@callnumber", SqlDbType.VarChar, 50).Value = member.Callnumber;
sqlcommnad.Parameters.Add("@question1", SqlDbType.VarChar, 50).Value = member.Membername;
sqlcommnad.Parameters.Add("@ask1", SqlDbType.VarChar, 50).Value = member.Ask1;
sqlcommnad.Parameters.Add("@question2", SqlDbType.VarChar, 50).Value = member.Question2;
sqlcommnad.Parameters.Add("@ask2", SqlDbType.VarChar, 50).Value = member.Ask2;
sqlcommnad.Parameters.Add("@tuiguang", SqlDbType.VarChar, 50).Value = member.Tuiguang;
sqlcommnad.Parameters.Add("@sortid", SqlDbType.Int, 4).Value = member.Sortid;
sqlcommnad.Parameters.Add("@groupid", SqlDbType.Int, 4).Value = 10;
sqlcommnad.Parameters.Add("@regip", SqlDbType.Char, 15).Value = regip;
sqlcommnad.Parameters.Add("@uid
1. 数据库访问性能优化
数据库的连接和关闭
访问数据库资源需要创建连接、打开连接和关闭连接几个操作。这些过程需要多次与数据库交换信息以通过身份验证，比较耗费服务器资源。ASP.NET中提供了连接池(Connection Pool)改善打开和关闭数据库对性能的影响。系统将用户的数据库连接放在连接池中，需要时取出，关� ......
前台设计页面.aspx
<body>
<form id="form1" runat="server">
<div>
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" />
</div>
......
