ASP.Net Project Using ToolBox DataSources 1

[Skittle]

I am in the process of updating my VB.Net skills from Visual Studio 2003 ( really! ) to Visual Studio 2010.
In a ASP.Net project you can drag and drop a data source control from the toolbox on to a form and configure it
before binding it to a datagrid, combox box or whatever.

There are a number of data source controls available from the toolbox such as SQLdataSource, AccessDatasource, ObjectDataSource, LinqDataSource etc.
However there is none for ODBCdataSource or OLEDBDatasource.
Are these options simply not available via this drag and drop approach or should I use ObjectDataSource instead?



Dazed and confused.

Remember.. 'Depression is just anger without enthusiasum'.

 

[Dashley]

Skittle,

Drop the SQLDataSource on your page.
Click the ">" to open the dialog box
click new connection
In the DataSource area select the change button
A Change data source window appears and you can pick ODBC from there.
I'm using vs2012 but I'm pretty sure it was the same in 2010.

 

[Dashley]

P,S. You might want to change the provider to "Net FrameWork Data provider OLE DB> It's right below the datasource selection

 

[Skittle]

Brilliant!

Thanks.

Dazed and confused.

Remember.. 'Depression is just anger without enthusiasum'.