<form id="hz9zz"></form>
    • <form id="hz9zz"></form>
    

      

      <nobr id="hz9zz"></nobr>
      <form id="hz9zz"></form>
      3.   
          
      明輝手游網中心：是一個免費提供流行視頻軟件教程、在線學習分享的學習平臺！
                   
        
                           
        
                        		  
        
                 
              
                
      C#中數據庫設置
                
                  發表時間：2024-06-10             來源：明輝站整理相關軟件相關文章人氣：          
              
      [摘要]/******************************* * 功能：數據庫操作相關 * 作者：FlashICP * 時間：2005-7-22 * ******************************/using System;using System.Data;using Syst...
        /*******************************
       * 功能：數據庫操作相關
       * 作者：FlashICP
       * 時間：2005-7-22
       * ******************************/
      using System;
      using System.Data;
      using System.Data.SqlClient;
      using System.Web;
      namespace moban
      {
       public class data
       {
        protected static string con="server=[yourserver];database=[yourdata];user id=[your id];password=[youpassword]";
        //數據庫字符串
        protected System.Data.SqlClient.SqlConnection DataConnection;
        //數據庫連接對象
        protected System.Data.SqlClient.SqlDataAdapter DataAdapter;
        //SqlDataAdapter對象
        protected System.Data.SqlClient.SqlCommand DataCommand;
        //SqlCommand對象
        protected System.Data.SqlClient.SqlCommandBuilder DataComBuilder;
        //SqlCommandBuilder對象
        protected System.Data.DataSet DataSet;
        //DataSet對象
        protected System.Data.DataRow DataRow;
        //DataRow對象
        protected System.Data.SqlClient.SqlDataReader DataReader=null;
        //構造函數
        public data()
        {
         DataConnection=DataConn(); 
         
        }
        //連接數據庫參數
        public string Con
        {
         
         get{return con;}
         set{con= value;}
         
        }
        //數據庫連接參數
        public SqlConnection DataConn()
        {
         DataConnection=new SqlConnection(Con); 
         return DataConnection;
         
        }
        //返回數據庫連接對象
        public SqlDataReader DataQuery(string Sql)
        {
         Sql=Sql.Replace("--","");
         Sql=Sql.Replace(";","");
         DataConnection=DataConn();
         DataConnection.Open();
         DataReader=null;
         DataCommand=new SqlCommand(Sql,DataConnection);
         DataReader=DataCommand.ExecuteReader();
         DataCommand.Dispose();
         return DataReader;
        }
        //返回DataSet
        public virtual DataSet DataSetQuery(string Sql,string TableName)
        {
         DataConnection=DataConn();
         DataAdapter=new SqlDataAdapter(Sql,DataConnection);
         DataSet=new DataSet();
         DataAdapter.Fill(DataSet,TableName);
         DataAdapter.Dispose();
         DataConnection.Close();
         DataConnection.Dispose();
         return DataSet;
        }
        //返回DataSet
        public DataSet DataSetQuery(DataSet myds,string TableName,string Sql)
        {
         DataConnection=DataConn();
         DataAdapter=new SqlDataAdapter(Sql,DataConnection);
         DataAdapter.Fill(myds,TableName);
         DataConnection.Close();
         DataConnection.Dispose();
         return DataSet; 
        }
        //返回DataSet
        public DataSet DataSetQuery(string Sql,string TableName,int StarIndex,int Count)
        {
         DataConnection=DataConn();
         DataConnection.Open();
         DataAdapter=new SqlDataAdapter(Sql,DataConnection);
         DataSet=new DataSet();
         DataAdapter.Fill(DataSet,StarIndex,Count,TableName);
         DataConnection.Close();
         DataConnection.Dispose();
         return DataSet;
        }
        public void DataDo(string sqlstr)
        {   
         DataConnection=DataConn();
         SqlCommand mycom=DataConnection.CreateCommand();
         mycom.CommandText=sqlstr;
         DataConnection.Open();
         mycom.ExecuteNonQuery();
         DataConnection.Close();
        }
        //返回DataSet 開始行到結束行
        public bool EditData(string Sql)
        {
         DataConnection=DataConn();
         DataConnection.Open();
         DataCommand=new SqlCommand(Sql,DataConnection);
         try
         {
          DataCommand.ExecuteNonQuery();
          DataConnection.Close();
          return true;
         }
         catch(Exception ex)
         {  
          System.Console.Write(ex.Message.ToString());
          DataConnection.Close();
          return false;
         }
        }
        //執行成功返回真,否則返回假．
        public object ExecuteScalar(string Sql)
        {
         DataConnection=DataConn();
         DataConnection.Open();
         DataCommand=new SqlCommand(Sql,DataConnection);
         try
         {
          object back = DataCommand.ExecuteScalar();
          DataConnection.Close();
          return back;
         }
         catch(Exception ex)
         {  
          System.Console.Write(ex.Message.ToString());
          DataConnection.Close();
          return null;
         }
        }
        //返回一個值的查詢語句
        public DataSet EditData(DataSet DataSet,SqlDataAdapter myda,string TableName)
        {
          
         
         DataComBuilder=new SqlCommandBuilder(myda);
         myda.UpdateCommand=DataComBuilder.GetUpdateCommand();
         myda.DeleteCommand=DataComBuilder.GetDeleteCommand();
         myda.InsertCommand=DataComBuilder.GetInsertCommand();
         myda.Update(DataSet,TableName);
         DataSet.AcceptChanges();
         this.CloseConnection();
         return DataSet;
        }
        //修改DataSet 并且修改數據庫值存儲過程
        public bool DataProcedure(string ProcedureName)
        {
         DataConnection=DataConn();
         DataConnection.Open();
         DataCommand=new SqlCommand();
         DataCommand.CommandText=ProcedureName;
         DataCommand.Connection=DataConnection;
         
            
         DataCommand.CommandType=System.Data.CommandType.StoredProcedure;
         try
         {
          DataCommand.ExecuteNonQuery();
          return true;
         }
         catch(Exception ex)
         {  
          System.Console.Write(ex.Message.ToString());
          return false;
         }
        }
        
        //無參數存儲過程的執行　返回執行真假
        public void CloseConnection()
        {
         if(DataReader!=null)
         {
          DataReader.Close();
          DataReader=null;
         }
         DataConnection.Close();
         DataConnection.Dispose();
        }
        //關閉連接
       
       }
      }




              
              
                 
              
                                            
                              		       
                          
                           		  
        
              
              
      相關文章
              
                        
            
                     		     
      
日韩精品一区二区三区高清