把access的处理函数 换成sql server2005?

Question

public static DataSet ExecuteDataSet(CommandType commandType, string procedureName)
        {
            using (OleDbConnection connection = new OleDbConnection())
            {
                connection.ConnectionString = ConnectionString;
                OleDbCommand command = new OleDbCommand();
                command.CommandText = procedureName;
                command.CommandType = commandType;
                command.Connection = connection;
                connection.Open();
                OleDbDataAdapter adapter = new OleDbDataAdapter();
                adapter.SelectCommand = command;
                DataSet dataSet = new DataSet();
                adapter.Fill(dataSet);
                connection.Close();
                connection.Dispose();
                return dataSet;
            }
        }刚开始是用access,现在用的sql server2005,上述代码如何改？ 

Answer 1

public static DataSet ExecuteDataSet(CommandType commandType, string procedureName)
        {
            using (SqlConnection connection = new SqlConnection())
            {
                connection.ConnectionString = ConnectionString;
                SqlCommand command = new SqlCommand ();
                command.CommandText = procedureName;
                command.CommandType = commandType;
                command.Connection = connection;
                connection.Open();
                SqlDataAdapter adapter = new SqlDataAdapter();
                adapter.SelectCommand = command;
                DataSet dataSet = new DataSet();
                adapter.Fill(dataSet);
                connection.Close();
                connection.Dispose();
                return dataSet;
            }
        }

Answer 2

基本是ole的换成sql 开头的
http://www.cnblogs.com/icedog/archive/2010/08/12/1798495.html

Answer 3

OleDbConnection  改 SqlDBConnection