当前文件路径：KeXinCrm/date.cs

		            
  1using System;
  2using System.Data;
  3using System.Data.SqlClient;
  4
  5namespace CRMS
  6...{
  7    /**//// <summary>
  8    /// data 的摘要说明。
  9    /// </summary>
 10    public class data
 11    ...{
 12        public data()
 13        ...{
 14            //
 15            // TODO: 在此处添加构造函数逻辑
 16            //
 17        }
 18        public string DbPath()
 19        ...{
 20            return "Data Source=(local);Initial Catalog=CRMS;User ID=sa;Pwd=sa";
 21        }
 22        public static string constr
 23        ...{
 24            get
 25            ...{
 26                data constr=new data();
 27                return constr.DbPath();
 28            }
 29        }
 30
 31        
 32
 33        public bool datareader(string sql)
 34        ...{
 35            SqlConnection Con = new SqlConnection(data.constr);  
 36            SqlCommand addCommand =new SqlCommand(sql,Con);
 37            addCommand.Connection.Open();
 38            SqlDataReader selreader ;
 39            selreader=addCommand.ExecuteReader();
 40            bool ifread;
 41            if (selreader.Read())
 42                ifread=true;
 43            else
 44                ifread=false;
 45            addCommand.Connection.Close();
 46            addCommand.Dispose();
 47            return ifread;            
 48        }
 49
 50        public void moddata(string sql)
 51        ...{
 52            SqlConnection Con = new SqlConnection(data.constr);  
 53            SqlCommand addCommand =new SqlCommand(sql,Con);
 54            addCommand.Connection.Open();
 55            addCommand.ExecuteNonQuery();
 56            addCommand.Connection.Close();
 57            addCommand.Dispose();
 58        }
 59
 60        public DataSet dbbind(string sql)
 61        ...{
 62            SqlConnection Con = new SqlConnection(data.constr);  
 63            SqlDataAdapter objAdapter = new SqlDataAdapter(sql, Con);
 64            DataSet objDataSet= new DataSet() ;
 65            objAdapter.Fill(objDataSet, "mytable");
 66            return objDataSet;
 67        }
 68
 69        public SqlDataReader readrow(string sql)
 70        ...{
 71            SqlConnection Con = new SqlConnection(data.constr);  
 72            SqlCommand objCommand =new SqlCommand(sql,Con);
 73            SqlDataReader objDataReader ;
 74            objCommand.Connection.Open();
 75            objDataReader = objCommand.ExecuteReader();    
 76            if(objDataReader.Read())
 77            ...{
 78                objCommand.Dispose();
 79                return objDataReader;
 80            }
 81            
 82            else 
 83            ...{
 84                objCommand.Dispose();
 85                return null;
 86            }
 87        }
 88//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
 89
 90        public DataTable rdtable(string sql)
 91        ...{
 92            SqlConnection Con = new SqlConnection(data.constr);  
 93            SqlDataAdapter objAdapter = new SqlDataAdapter(sql, Con);
 94            
 95            DataTable mytable=new DataTable();
 96            objAdapter.Fill( mytable);
 97            
 98            return mytable;
 99        }
100
101        public string readout(string sql,int num)
102        ...{
103            string result;    
104            SqlConnection Con = new SqlConnection(data.constr);  
105            SqlCommand objCommand =new SqlCommand(sql,Con);
106            SqlDataReader objDataReader ;
107            objCommand.Connection.Open();
108            objDataReader = objCommand.ExecuteReader();    
109            if(objDataReader.Read())
110            ...{
111                objCommand.Dispose();
112                return result=objDataReader.GetValue(num).ToString();
113            }
114            else 
115            ...{
116                objCommand.Dispose();
117                return "没有该记录";
118            }
119        }
120        //处理网页中的HTML代码，并消除危险字符
121        /**//*
122        private static string HTMLEncode(string fString)
123        {
124            if(fString!=string.Empty)
125            {
126                //替换尖括号
127                fString.Replace("<","&It;");
128                fString.Replace(">","&rt;");
129                //替换引号
130                fString.Replace(((char)34).ToString(),"&quot;");
131                fString.Replace(((char)39).ToString(),"&#39;");
132                //替换空格
133                fString.Replace(((char)13).ToString(),"");
134                //替换换行
135                fString.Replace(((char)10).ToString(),"<BR>");
136            }
137            return(fString);
138        }
139        */
140
141    }
142}
143