Q:

How to do a simple C# import?

Okay, this may seem silly. But, I don't know how to do an "import" in C#, in visual studio 2008. I know java, but not C#. Currently, I don't have the time to read a c# book. So, I need some help to get it right. 
I was trying to use the code here - SSIS Getting Execute Sql Task result set object
DataTable dt = new DataTable();
OleDbDataAdapter oleDa = new OleDbDataAdapter();
oleDa.Fill(dt, Dts.Variables["User::objShipment"].Value);

And I get the error - The type or namespace name 'OledDbDataAdapter' could not be found (are you missing a using directive or an assembly reference?)
I tried to do a java style import. But it failed. 
using System.Data.OleDb::OleDbDataAdapter

Full code given below -

using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using System.Data.OleDb;

namespace ST_LongCodeGoesHere.csproj
{

    [System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]
    public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
    {
        #region VSTA generated code
        enum ScriptResults
        {
            Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
            Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
        };
        #endregion

        //To see the comment here, look at beyond end of this code.

        public void Main()
        {
            // TODO: Add your code here
            DataTable table = new DataTable();
            OledDbDataAdapter oleDbA = new OleDbDataAdapter();
            Dts.TaskResult = (int)ScriptResults.Success;
        }
    }
}

The comment was - 
   /*
            The execution engine calls this method when the task executes.
            To access the object model, use the Dts property. Connections, variables, events,
            and logging features are available as members of the Dts property as shown in the following examples.
        To reference a variable, call Dts.Variables["MyCaseSensitiveVariableName"].Value;
        To post a log entry, call Dts.Log("This is my log text", 999, null);
        To fire an event, call Dts.Events.FireInformation(99, "test", "hit the help message", "", 0, true);

        To use the connections collection use something like the following:
        ConnectionManager cm = Dts.Connections.Add("OLEDB");
        cm.ConnectionString = "Data Source=localhost;Initial Catalog=AdventureWorks;Provider=SQLNCLI10;Integrated Security=SSPI;Auto Translate=False;";

        Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.

        To open Help, press F1.
    */

A:

In C#, you don't import individual types, you import whole namespaces. Something like this 
should work:
using System.Data.OleDb;

...

OleDbDataAdapter oleDa = new OleDbDataAdapter();

Or you could create a type alias like this:
using OleDbDataAdapter = System.Data.OleDb.OleDbDataAdapter;

Further Reading

using Directive (C# Reference)

