Cannot find OleDbConnection

[cmrhema]

Hello
I am migrating from vb.net to C#.net

I am supposed to drag and drop a Oledbconnection.

I Cannot find it. I searched in the tool bar thoroughly.

Where's it located?

Thanks

[kenobewan]

I believe that's because its not there. There are not as many objects supplied to C# programmers in VS. So that's is why they believe that they are smarter then we are ;).

[RoninZA]

Hi cmrhema,

C# developers ARE smarter than VB developers! ;)

You'll have to use the OleDbConnection in code, instead of dragging it onto the form. You can find it in the System.Data.OleDbClient namespace.

Use as follows:

System.Data.OleDbClient.OleDbConnection cn = new System.Data.OleDbClient.OleDbConnection(connectionString);
try
{
    cn.Open();
    if (cn.State == System.Data.ConnectionState.Open)
        MessageBox.Show("Connection Opened successfully.");
}
catch
{
    MessageBox.Show("Connection failed to open.");
}
finally
{
    cn.Close();
}
 

[Plater]

The OLEDBConnection object is not defaultly on your toolbar.
However, if you right click and choose to add components(or analogue), you can then select it from the .NET list.

Oh you VB developers, always wanting to make non UI components be on the drag and drop :-P


This might be my new signature...

C# developers ARE smarter than VB developers! ;)

[kenobewan]

Being clever is the idiot's version of being interesting ;). We VB programmers are well rounded individuals. C# programmers avoid other people interferring in their personal lives by cleverly having none (oops thats a stereotype ;).

[Plater]

I hate programming :-D