helpdb.cs

来自「教务管理系统 基于.net和sqlserver2000的教务管理系统」· CS 代码 · 共 43 行

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();
		}
	}
}