C#

OleDbConnection conCSV = new OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + dirName + ";Extended Properties='Text;HDR=Yes;FMT=Delimited;IMEX=1'" );<br />
<br />
OleDbDataAdapter daDBF = new OleDbDataAdapter<br />
( "SELECT * FROM " + fileName, conCSV );<br />
<br />
daDBF.Fill( DS, "Bids" );<br />
<br />
DS.WriteXML( TestFilePath );

<br />
        private void btnOpen_Click_1(object sender, EventArgs e)<br />
        {<br />
            OpenFileDialog fdlg = new OpenFileDialog();<br />
            fdlg.Title = "Emu Open File Dialog";<br />
            fdlg.InitialDirectory = @"c:\";<br />
            fdlg.Filter = "Emu Files (*.scp*)|*.scp*|Emu Files (*.scp*)|*.scp*";<br />
            fdlg.FilterIndex = 2;<br />
            fdlg.RestoreDirectory = true;<br />
            if (fdlg.ShowDialog() == DialogResult.OK)<br />
            {<br />
                textBox20.Text = fdlg.FileName;<br />
            }<br />

<br />
unsafe public int GetDlgText(int dlgid, int fldid, int row, int col, [MarshalAsAttribute(UnmanagedType.BStr)] string text){<br />
  int returnvalue = -1;<br />
  try{<br />
    object[] cmds = { dlgid, fldid, row, col, text };<br />
    returnvalue = Convert.ToInt32(Interaction.CallByName(idisp, "GetDlgText", CallType.Method, cmds));<br />
  } //end try<br />
  catch(Exception e) {<br />
    lasterrormessage = "Could not invoke GetDlgText function: " + e;<br />
  } //end catch<br />
  return returnvalue;<br />
} //end method GetDlgText<br />

using ATLServerTest2;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            Device device = new Device();
            IDevice idevice = device as IDevice;
            String s;

            idevice.getName(out s);
        }
    }
}

// IDevice
[
	object,
	uuid("633DB896-4FA1-4E6B-85CF-C1B23BD5FE1C"),
	helpstring("IDevice Interface")
	//pointer_default(unique)
]
__interface IDevice : IUnknown
{
	[helpstring("method getName")] HRESULT getName( [out] BSTR *name );
};


// _IDeviceEvents
[
	dispinterface,
	uuid("67C3F875-3BF5-495C-91AA-469E9EA33C46"),
	helpstring("_IDeviceEvents Interface")
]
__interface _IDeviceEvents
{
};


// Device

[
	coclass,
	//default(IDevice, _IDeviceEvents),
	default("IDevice"),
	threading(apartment),
	//support_error_info("IDevice"),
	//event_source(com),
	aggregatable(never),
	vi_progid("ATLServerTest2.Device"),
	progid("ATLServerTest2.Device.1"),
	version(1.0),
	uuid("AF76CC05-0F41-45EB-AE67-485FDD8AF343"),
	helpstring("Device Class")
]

class ATL_NO_VTABLE Device :
	public IDevice
{
public:
	Device()
	{
	}

	//__event __interface _IDeviceEvents;


	DECLARE_PROTECT_FINAL_CONSTRUCT()

	HRESULT FinalConstruct()
	{
		return S_OK;
	}

	void FinalRelease()
	{
	}

public:
	STDMETHODIMP getName ( BSTR *name ) {
		CComBSTR _name ( "test name" );
		*name = _name.Detach();
		return S_OK;
	}
};