webdataaccess.cs

来自「基于Asp.net、MS sql sever 2000、C# 汽车交易系统源码」· CS 代码 · 共 222 行

using System;
using System.Data.SqlClient;

using System.Data;
namespace WebDataAccess
{
	/// <summary>
	/// MARKET 数据访问处理层
	/// </summary>
	public class WebDataAccess
	{
		public string Ax1001="请登陆以后再进入后台";
		

		public string connString;

		DataTable dt=new DataTable ();

		//DataStaticBase Base=new DataStaticBase();


		public  string Connstring
		{
		

			set
			{
				connString="server=127.0.0.1;database=market;uid=yy;pwd=123";
			}
			get
			{

				return connString;

			}
		}

		public DataTable GetNo(string SqlString)
		{


			dt.Clear();

			dt.Dispose();
			

			SqlConnection conn=new SqlConnection(Connstring);

			conn.Open();

			//SqlCommand Command=new SqlCommand(SqlString,conn);

			//Command.ExecuteNonQuery();

			SqlDataAdapter Ad=new SqlDataAdapter(SqlString,conn);

			Ad.Fill(dt);

			conn.Close();

			return dt;


		}

		public DataTable  Select(string SqlString)
		{
			
			dt.Clear();

			dt.Dispose();
			

			SqlConnection conn=new SqlConnection(Connstring);

			conn.Open();

			//SqlCommand Command=new SqlCommand(SqlString,conn);

			//Command.ExecuteNonQuery();

			SqlDataAdapter Ad=new SqlDataAdapter(SqlString,conn);

			Ad.Fill(dt);

			conn.Close();

			return dt;

		
		}

		public string  Insert(string SqlString)
		{
			try
			{


				SqlConnection conn=new SqlConnection(Connstring);

				conn.Open();

				SqlCommand Command=new SqlCommand(SqlString,conn);

				Command.ExecuteNonQuery();

				conn.Close();

				return "1";//success



			}

			catch(Exception ex)
			{

				
				return ex.Message;//error

			}

			
		}
		public string  Delete(string SqlString)
		{
			try
			{


				SqlConnection conn=new SqlConnection(Connstring);

				conn.Open();

				SqlCommand Command=new SqlCommand(SqlString,conn);

				Command.ExecuteNonQuery();

				conn.Close();

				return "1";//success



			}

			catch(Exception ex)
			{

				
				return ex.Message;//error

			}
			
		}
		public string  Modify(string SqlString)
		{
			try
			{


				SqlConnection conn=new SqlConnection(Connstring);

				conn.Open();

				SqlCommand Command=new SqlCommand(SqlString,conn);

				Command.ExecuteNonQuery();

				conn.Close();

				return "1";//success



			}

			catch(Exception ex)
			{

				
				return ex.Message;//error

			}

		}
		public string  Login(string SqlString)
		{
			try
			{


				SqlConnection conn=new SqlConnection(Connstring);

				conn.Open();

				SqlCommand Command=new SqlCommand(SqlString,conn);

				Command.ExecuteNonQuery();

				conn.Close();

				return "1";//success



			}

			catch(Exception ex)
			{

				
				return ex.Message;//error

			}


			
		}
	}
}