c#操作数据类之一

来源:互联网 发布:一维数组的表达方式 编辑:程序博客网 时间:2024/05/29 17:09
    /// <summary>     /// 返回指定Sql语句的DataSet     /// </summary>     /// <param name="sqlstr">传入的Sql语句</param>     /// <returns>DataSet</returns>     public static DataSet dataSet(string sqlstr)    {        DataSet ds = new DataSet();        OleDbDataAdapter da = new OleDbDataAdapter();        try        {            openConnection();            comm.CommandType = CommandType.Text;            comm.CommandText = sqlstr;            da.SelectCommand = comm;            da.Fill(ds);        }        catch (Exception e)        {            throw new Exception(e.Message);        }        finally        {            closeConnection();        }        return ds;    }    /// <summary>     /// 返回指定Sql语句的DataSet     /// </summary>     /// <param name="sqlstr">传入的Sql语句</param>     /// <param name="ds">传入的引用DataSet对象</param>     public static void dataSet(string sqlstr, ref DataSet ds)    {        OleDbDataAdapter da = new OleDbDataAdapter();        try        {            openConnection();            comm.CommandType = CommandType.Text;            comm.CommandText = sqlstr;            da.SelectCommand = comm;            da.Fill(ds);        }        catch (Exception e)        {            throw new Exception(e.Message);        }        finally        {            closeConnection();        }    }

原创粉丝点击