ASP.NET 2.0中轻松实现网站换肤 http://dev.yesky.com/msdn/42/2366542.shtml

http://dev.yesky.com/msdn/42/2366542.shtml



     private static string GetConnnectionString()
        {
            //读取配置文件
            System.Configuration.ConnectionStringSettings connString = System.Web.Configuration.WebConfigurationManager.
                ConnectionStrings["NorthwindConnectionString"];
            if (null != connString)
            {
                return connString.ConnectionString;
            }
            else
                return "";
        }

       /// <summary>
        /// 新增加一个用户
        /// </summary>
        /// <param name="UserID">返回新建的用户ID</param>
        /// <param name="FirstName">用户名</param>
        /// <param name="LastName">用户姓</param>
        /// <returns>是否添加成功</returns>
        [DataObjectMethod(DataObjectMethodType.Insert)]
        public static bool InsertUser(out int UserID, string FirstName, string LastName)
        {
            UserID=0;
            SqlConnection conn = new SqlConnection(GetConnnectionString());
            //增加用户信息的SQL语句
            SqlCommand cmd = new SqlCommand("INSERT INTO UserInfo " +
                                                "  (FirstName, LastName) " +
                                                "  Values(@FirstName, @LastName); " +
                                                "SELECT @UserID = SCOPE_IDENTITY()", conn);

            //构建用户信息的参数
            cmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 10).Value = FirstName;
            cmd.Parameters.Add("@LastName", SqlDbType.VarChar, 10).Value = LastName;
            SqlParameter p = cmd.Parameters.Add("@UserID", SqlDbType.Int);
            p.Direction = ParameterDirection.Output;

            try
            {
                conn.Open();

                //执行增加的SQL语句
                cmd.ExecuteNonQuery();
                //返回新增加的用户ID
                UserID = (int)p.Value;
            }
            catch
            {
               
            }
            finally
            {
                conn.Close();
            }

            return true;
        }