sqlcommand

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

namespace login
{
	/// <summary>
	/// Class1 的摘要说明。本类是用来对数据库进行操作
	/// </summary>
	public class sqlcommand
	{  
		private string strconn;
		SqlConnection conn=new SqlConnection ();
		SqlCommand comm=new SqlCommand ();
		SqlDataAdapter da=new SqlDataAdapter ();
		SqlDataReader dr;
		DataSet ds=new DataSet ();
		public sqlcommand()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		   strconn="server=(local);database=manage;user id=sa;password=";
		    conn=new SqlConnection (strconn);	
			//strconn=strconns;
		}
		public SqlConnection connection()
		{
          
			return conn;
		}
		//以下是对数据库进行删除、插入、更新记录
		public void DIU(string strsqls)
		{
		 
		 conn.Open (); 
		 comm=new SqlCommand (strsqls,conn);
         comm.ExecuteNonQuery();
		 conn.Close ();
		}
		
		string rs;
		//从数据库中读取数据返回为字符型 
		public string selectR( string strsqls,string colname)
		{
			conn.Open ();		
			comm=new SqlCommand (strsqls,conn);			
            dr=comm.ExecuteReader();
			if(dr.Read ())
			{

			 
				rs=dr[colname].ToString ();
			}
			else
			{
				rs="0";
			}
			conn.Close ();
	     	return rs;
			
		}
		//从数据库中读取数据返回为数值型 
		int rsi;
		public int selectRI( string strsqls,string colname)
		{
			conn.Open ();		
			comm=new SqlCommand (strsqls,conn);			
			dr=comm.ExecuteReader();
			if(dr.Read ())
			{

			 
				rsi=(int)dr[colname];
			}
			else
			{
				rsi=-1;
			}
			conn.Close ();
			return rsi;
			
		}
		//从数据库中读取数据并填充到DataSet中并返回该DataSet
		public DataSet fillDataset( string strsqls,string tablename)
		
		{
			
			comm=new SqlCommand (strsqls,conn);
            da.SelectCommand =comm;
			da.Fill (ds,tablename);
            return ds;
          
		}
	

	}
}