mysqlhelper.cs

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
namespace Mysql
{
    class Sqlhelper
    {
        static SqlConnection conn = null;
        public static void Connection(String server, String database, String username, String password)
        {
            try
            {
                String ConnectionString = @"server=" + server + ";database=" + database + ";uid=" + username + ";pwd=" + password;
                conn = new SqlConnection(ConnectionString);
                conn.Open();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex);
            }
        }
        #region 返回行数
        public static Object ExecuteScalar(SqlCommand cmd)
        {
            cmd.Connection = conn;
            return cmd.ExecuteScalar();
        }
        public static Object ExecuteScalar(String cmdText)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = cmdText;
            cmd.Connection = conn;
            return cmd.ExecuteScalar();
        }
        public static object ExecuteScalar(String cmdText, CommandType cmdType)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = cmdText;
            cmd.CommandType = cmdType;
            cmd.Connection = conn;
            return cmd.ExecuteScalar();
        }
        #endregion
        #region 返回结果集
        public static object DataReader(SqlCommand cmd)
        {
            return cmd.ExecuteReader();
        }
        public static object DataReader(CommandType cmdType, String cmdText)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = cmdText;
            cmd.CommandType = cmdType;
            cmd.Connection = conn;
            return cmd.ExecuteReader();
        }
        public static object DataReader(CommandType cmdType, String cmdText, SqlCommand cmd)
        {
            cmd.CommandText = cmdText;
            cmd.CommandType = cmdType;
            cmd.Connection = conn;
            return cmd.ExecuteReader();
        }
        public static object DataReadershow(CommandType cmdType, String cmdText)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = cmdText;
            cmd.CommandType = cmdType;
            cmd.Connection = conn;
            SqlDataReader reader = cmd.ExecuteReader();
            int n = reader.FieldCount;
            Object[] row = new object[n*2];
            while (reader.Read() == true)
            {
                reader.GetValues(row);//返回所有字段的内容，并将其存入row数组中，数组大小与字段相同
            }
            return row;
        }
        #endregion
        #region 返回数据表
        public static DataTable ExecuteDt(String cmdText)
        {
            SqlDataAdapter da = new SqlDataAdapter(cmdText, conn);
            DataTable dt = new DataTable();
            da.Fill(dt);
            return dt;
        }
        public static DataSet ExecuteDs(String cmdText)
        {

            SqlDataAdapter da = new SqlDataAdapter(Sqlstr, conn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            return ds;
        }
        #endregion
        public static void Close()
        {
            conn.Close();
        }
    }
}