Lav et dataset

CSharp kode 

 DataSet ds = new DataSet();
 using(OleDbDataAdapter adapter = new OleDbDataAdapter(cmd)) // cmd er dit OleDbCommand objekt
 {
     adapter.Fill(ds);
 }

Kode 

    Public Function db_makedataset(ByVal con_string)
        Try
            Dim connect As New OleDb.OleDbConnection("Provider=SQLOLEDB;Data Source=" & Servername & ";Initial Catalog=" & Databasename & ";User Id=" & dbUsername & ";Password=" & dbPassword)
            Dim ds As New DataSet
            Dim da As New OleDb.OleDbDataAdapter(con_string, connect)
            'Then my transactions execute, and all is good

            da.Fill(ds)
            da.Dispose()

            'output data from Dataset
            Return ds.Tables.Item(0)
        Catch
            err_msg()
        End Try
    End Function

Kode 

		/// <summary>
		/// Get Dataset from cmdText
		/// </summary>
		/// <param name="cmdText">The Query (T-SQL) to run.</param>
		/// <returns>Dataset</returns>
		public DataSet GetDataSetFromCommandText(string cmdText)
		{
			DataSet ds = new DataSet();
			System.Web.HttpContext.Current.Trace.Write("DB", "Executing \"" + _commandText + "\"");
			try
			{
				using (SqlConnection sqlCon = new SqlConnection(_connectionString))
				{
					_sqlAdap = new SqlDataAdapter(cmdText, sqlCon);
					_sqlAdap.Fill(ds);
				}
				System.Web.HttpContext.Current.Trace.Write("DB", "Finished, returned: Rows " + ds.Tables[0].Rows.Count);
			}
			catch (Exception exp)
			{
				ErrorHandler EH = new ErrorHandler(exp);
			}

			return ds.Tables.Count > 0 ? ds : null;
		}