当前文件： BinbinBook/book/App_Code/saveinfo.cs[2K，2009-6-12 11:33:41]，打开代码结构图

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Web;
 5using System.Web.Security;
 6using System.Web.UI;
 7using System.Web.UI.WebControls;
 8using System.Web.UI.WebControls.WebParts;
 9using System.Web.UI.HtmlControls;
10using System.Data.SqlClient;
11/**//// <summary>
12/// saveinfo 的摘要说明
13/// </summary>
14public class saveinfo
15...{
16    public saveinfo()
17    ...{
18        //
19        // TODO: 在此处添加构造函数逻辑
20        //
21    }
22    public static bool savely(book ly)
23    ...{
24        SqlConnection conn = DB.createdb();
25        conn.Open();
26        try
27        ...{
28            //SqlCommand cmd = new SqlCommand("insert into book(username,sex,qq,email,face,adddate,body,ishidden,homepage) values(@username,@sex,@qq,@email,@face,@adddate,@body,@ishidden,@homepage)", conn);
29            SqlCommand cmd = new SqlCommand("insert into book(username,sex,body,qq,email,face,adddate,ishidden,homepage) values(@username,@sex,@body,@qq,@email,@face,@adddate,@ishidden,@homepage)", conn);
30            cmd.Parameters.Add(new SqlParameter("@username", SqlDbType.NVarChar, 20));
31            cmd.Parameters["@username"].Value = ly.username;
32            cmd.Parameters.Add(new SqlParameter("@sex", SqlDbType.NVarChar, 4));
33            cmd.Parameters["@sex"].Value = ly.sex;
34            cmd.Parameters.Add("@body",SqlDbType.NVarChar,500);
35            cmd.Parameters["@body"].Value = ly.body;
36            cmd.Parameters.Add("@qq", SqlDbType.NVarChar, 10);
37            cmd.Parameters["@qq"].Value = ly.qq;
38            cmd.Parameters.Add("@email", SqlDbType.NVarChar, 20);
39            cmd.Parameters["@email"].Value = ly.email;
40            cmd.Parameters.Add("@face", SqlDbType.NVarChar, 10);
41            cmd.Parameters["@face"].Value = ly.face;
42            cmd.Parameters.Add("@adddate",SqlDbType.DateTime,8);
43            cmd.Parameters["@adddate"].Value = System.DateTime.Now.ToLongTimeString();
44         
45            cmd.Parameters.Add("@ishidden",SqlDbType.Bit,1);
46            cmd.Parameters["@ishidden"].Value =ly.ishide;
47            cmd.Parameters.Add("@homepage", SqlDbType.NVarChar, 20);
48            cmd.Parameters["@homepage"].Value = ly.homepage;
49            cmd.ExecuteNonQuery();
50            conn.Close();
51            return true;
52        }
53        catch
54        ...{
55            conn.Close();
56            return false;
57        }
58    }
59}
60