forumdb.cs

一个功能完善的论坛系统,有数据库备分,希望对你有所帮助

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web;

namespace bbs.Components
{
	/// <summary>
	/// ForumDB 的摘要说明。
	/// </summary>
	public class FunctionDB
	{
		
			#region 添加版块
			/// <summary>
			/// 添加版块
			/// </summary>
			public void AddFunction(String FunctionName,String FunctionDesc) 
			{

				
				SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["forum"]);
				string sqltxt="Insert Into bbs_Function(FunctionName,FunctionDesc) ";
				sqltxt+="values(@FunctionName,@FunctionDesc)";
				SqlCommand myCommand = new SqlCommand(sqltxt, myConnection);

				SqlParameter parameterFunctionName= new SqlParameter("@FunctionName", SqlDbType.VarChar,50);
				parameterFunctionName.Value = FunctionName;
				myCommand.Parameters.Add(parameterFunctionName);

				SqlParameter parameterFunctionDesc = new SqlParameter("@FunctionDesc", SqlDbType.VarChar, 200);
				parameterFunctionDesc.Value = FunctionDesc;
				myCommand.Parameters.Add(parameterFunctionDesc);

				myConnection.Open();
				myCommand.ExecuteNonQuery();
				myConnection.Close();	
			}
			#endregion
		
	}
}