newskind.cs

面向.net的WEB应用程序设计-----C#语言

using System;
using System.Data;
using System.Data.SqlClient;
using NewsKindAdmin.DBase;

namespace NewsKindAdmin.Operate_DB
{
	/// <summary>
	/// NewsKind 的摘要说明。
	/// </summary>
	public class NewsKind
	{
		public NewsKind()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public SqlDataReader GetNewsKindData()
		{
			DB db=new DB();
			SqlConnection Con=db.GetConnection();
			string Sql="select * from newstable";
			SqlCommand Cmd=new SqlCommand(Sql,Con);
			Con.Open();
			SqlDataReader Sdr=Cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
			return Sdr;

		}
		public bool AddNewsKindData(string kindname)
		{
			DB db=new DB();
			SqlConnection Con=db.GetConnection();
			string Sql="insert into newstable(NKindName)values('"+kindname+"')";
			SqlCommand Cmd=new SqlCommand(Sql,Con);
			try
			{
				Con.Open();
				Cmd.ExecuteNonQuery();
				return true;
			}
			catch
			{
				return false;
			}
		}
		public bool updateNewsKindData(int kid,string kindname)
		{
			DB db=new DB();
			SqlConnection Con=db.GetConnection();
			string Sql="update newstable set NKindName='"+kindname+"'where KId="+kid.ToString();
			SqlCommand Cmd=new SqlCommand(Sql,Con);
			try
			{
				Con.Open();
				Cmd.ExecuteNonQuery();
				return true;
			}
			catch
			{
				return false;
			}
		}
		public bool DelectNewsKindData(int kid)
		{
			DB db=new DB();
			SqlConnection Con=db.GetConnection();
			string Sql="delete newstable where KId="+kid.ToString();
			SqlCommand Cmd=new SqlCommand(Sql,Con);
			try
			{
				Con.Open();
				Cmd.ExecuteNonQuery();
				return true;
			}
			catch
			{
				return false;
			}
		}

	}
}