SoFunction
Updated on 2025-03-07

SQL operation class instance of C#

using System;
using ;
using ;
using ;
using ;
using ;
namespace yjgl
{
    /// <summary>   
/// Data Access Basic Class (SQL)
    /// </summary>
    class BaseOperate
    {
#region Establish a database connection
        /// <summary>
/// Establish a database connection.
        /// </summary>
/// <returns>Returns SqlConnection object</returns>
        public SqlConnection getcon()
        {
string M_str_sqlcon = "Data Source=PC-200201010009 ;Database=db_yjzl;User ID=sa;PWD=123";//Connection string
SqlConnection mycon = new SqlConnection(M_str_sqlcon);       //Create a connection object
            return mycon;
        }
        #endregion
#region Execute the SqlCommand command
        /// <summary>
/// Execute SqlCommand
        /// </summary>
/// <param name="M_str_sqlstr">SQL statement</param>
        public void getcom(string M_str_sqlstr)
        {
SqlConnection sqlcon = ();   //Get the connection string
();          //Open the connection
            try
            {
SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon); //Create command objects through SQL statements and connection objects
();                   ();     //Execute SQL statements on sqlcon and return the number of affected rows
();                                                                                                                              �
            }
            catch (SqlException e)
            {
((), "Information prompt", , );
            }
            finally
            {
                ();
                ();
            }
        }
        #endregion
#region Create DataSet object
        /// <summary>
/// Create a DataSet object
        /// </summary>
/// <param name="M_str_sqlstr">SQL statement</param>
/// <param name="M_str_table">table name</param>
/// <returns>Returns DataSet object</returns>
public DataSet getds(string M_str_sqlstr, string M_str_table) //Query
        {
            SqlConnection sqlcon = ();
            SqlDataAdapter sqlda = new SqlDataAdapter(M_str_sqlstr, sqlcon);
            DataSet myds = new DataSet();
            (myds, M_str_table);
            return myds;
         }
        #endregion
#region Create SqlDataReader object
         /// <summary>
/// Create a SqlDataReader object
         /// </summary>
/// <param name="M_str_sqlstr">SQL statement</param>
/// <returns>Returns SqlDataReader object</returns>
        public SqlDataReader getread(string M_str_sqlstr)
        {
            SqlConnection sqlcon = ();
            SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);
            ();
            SqlDataReader sqlread = ();
            return sqlread;
           
         }
        #endregion
    }
}