da.cs

来自「这是我制作的一个小论坛源码··能够简单实现发表帖子··管理帖子·后台管理等功能」· CS 代码 · 共 81 行

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

namespace da
{
	/// <summary>
	/// da 的摘要说明。
	/// </summary>
	public class da
	{
		String ConnectionString = System.Configuration.ConfigurationSettings. AppSettings["ConnectionString"];
		public da()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public DataSet Select(string sqlstr,string TableName)
		{
			if (sqlstr == null || TableName == null)
			{
				return null;
			}
			else
			{								
				SqlConnection conn = new SqlConnection(ConnectionString);
				SqlDataAdapter objda = new SqlDataAdapter(sqlstr,conn);
				DataSet ds = new DataSet();			
				try
				{
					objda.Fill(ds,TableName);
					return ds;
				}
				catch
				{
					return null;					
				}
				finally
				{
					conn.Close();
					conn.Dispose();
					conn = null;
				}
			}
		}
		public void command(string sqlstr)
		{
							
			SqlConnection conn = new SqlConnection(ConnectionString);
			SqlCommand cmd=new SqlCommand(sqlstr,conn);
						
			try
			{
				if(conn.State!=ConnectionState.Open)
				{
					conn.Open();
				}
				cmd.ExecuteNonQuery();
				
					
					
			}
			catch
			{	
					
				conn.Close();
			}
			finally
			{	
				conn.Close();
				conn.Dispose();
				conn=null;
			}	


		}

	}
}