【转】将常用ADO调用封装成类

//该类主要用于封装自己常用的一些ADO连接,数据,方法
//其主要使用静态方法,可以直接调用而无需实例对象

//Con 用于返回制定好的Sql服务器连接
//MyGetTable(string TableName) 返回TableName的整张数据表,或根据条件返回Table
//Validate(string TableName,string UserName,string Password) 简单效验用户名和密码是否与数表中的匹配.如用户名不存在则返回-1,密码错误返回0,效验通过返回1

 

using System;
using System.Data.SqlClient;

namespace GuestBook
{
 /// <summary>
 /// MyData 的摘要说明。
 /// </summary>
 public class MyData
 {
  public MyData()
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
  }
  public static SqlConnection Con()
  {
   return new SqlConnection("server=.;database=mydata;uid=sa;password=network");
  }
  public static System.Data.DataTable MyGetTable(string TableName)
  {
   System.Data.DataTable Table = new System.Data.DataTable(TableName);
   System.Data.SqlClient.SqlCommand MyCommand = new System.Data.SqlClient.SqlCommand("select * from "+TableName,Con());
   System.Data.SqlClient.SqlDataAdapter MyAdapter = new System.Data.SqlClient.SqlDataAdapter(MyCommand);
   MyAdapter.Fill(Table);
   return Table;   
  }
  public static System.Data.DataTable MyGetTable(string TableName, string CommandFilter)
  {
   System.Data.DataTable Table = new System.Data.DataTable(TableName);
   System.Data.SqlClient.SqlCommand MyCommand = new System.Data.SqlClient.SqlCommand("select * from "+TableName+" where "+CommandFilter,Con());
   System.Data.SqlClient.SqlDataAdapter MyAdapter = new System.Data.SqlClient.SqlDataAdapter(MyCommand);
   MyAdapter.Fill(Table);
   return Table;           
  }
  public static int Validate(string TableName,string UserName,string Password)
  {
   System.Data.DataTable Table = new System.Data.DataTable(TableName);
   System.Data.SqlClient.SqlCommand MyCommand = new System.Data.SqlClient.SqlCommand("select username,password from "+TableName+" where username='"+UserName+"'",Con());
   System.Data.SqlClient.SqlDataAdapter MyAdapter = new System.Data.SqlClient.SqlDataAdapter(MyCommand);
   MyAdapter.Fill(Table);
   if(Table.Rows.Count == 0) return -1;
   else if(Table.Rows[0][1].ToString().TrimEnd() == Password) return 1;

   else return 0;
  }
 }
}

http://blog.csdn.net/showwin/archive/2006/09/03/1172130.aspx