查询SQL Server表数据,使用不同的方法返回结果集。

Question

请问您除了一下两种方案，您能写出余下至少8种实现方案吗？!（注：不足8种也可以写出来大家一起分享.） static string connectionString = ConfigurationManager.ConnectionStrings["Tconnection"].ConnectionString;
        
        /// <summary>
        /// 依据SQL语句将查询出来的数据填充到数据集返回DataSet 
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static DataSet SearchQuery(string sql) 
        {
            using (SqlConnection Tconnection = new SqlConnection(connectionString))
            {
                using(SqlDataAdapter sda = new SqlDataAdapter(sql,Tconnection))
                {
                    using(DataSet ds =new DataSet())
                    {
                        sda.Fill(ds);
                        return ds;
                    }
                }
            }
        }        
        /// <summary>
        /// 依据SqlCommand对象创建适配器,填充数据集.返回DataSet
        /// </summary>
        /// <param name="sqlQuery"></param>
        /// <returns></returns>
        public static DataSet RunQuery(SqlCommand sqlQuery) 
        {
            using(SqlConnection DBConnection = new SqlConnection(connectionString))
            {
                SqlDataAdapter dbAdpter = new SqlDataAdapter();
                dbAdpter.SelectCommand = sqlQuery;
                sqlQuery.Connection = DBConnection; ;
                DataSet resultDataSet = new DataSet();
                try
                {
                    dbAdpter.Fill(resultDataSet);
                }
                catch (Exception e)
                {
                    throw new ApplicationException("错误异常：" + e);
                }
                return resultDataSet;
            }
        }

Answer 1

    SqlCommand cmd = new SqlCommand(sql, con);
                    cmd.CommandTimeout = 20;
                    this.Open();
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    adapter.Fill(ds);