helpdb.cs

电子选课系统 电子选课系统电子选课系统电子选课系统

using System;
using System.Data;
using System.Data.SqlClient;

namespace Park.Common
{
	/// <summary>
	/// HelpDB 的摘要说明。
	/// </summary>
	public class HelpDB
	{
		public static string GetHelp(string content)
		{
			SqlConnection myConnection=Utils.GetConnection();

			SqlCommand myCommand = new SqlCommand("Help_Get_HelpFile", myConnection);

			// Mark the Command as a SPROC
			myCommand.CommandType = CommandType.StoredProcedure;

			// Add Parameters to SPROC
			SqlParameter Content = new SqlParameter("@content", SqlDbType.VarChar, 50);
			Content.Value = content;
			myCommand.Parameters.Add(Content);

			// Add Parameters to SPROC
			SqlParameter retval = new SqlParameter("@helpfile", SqlDbType.VarChar, 50);
			retval.Direction = ParameterDirection.Output;
			myCommand.Parameters.Add(retval);

			// Execute the command
			myConnection.Open();
			myCommand.ExecuteNonQuery();
				
			myCommand.Dispose();
			myConnection.Dispose();

			return  retval.Value.ToString();
		}
	}
}