Hello,
       How to bind DetailsView with d/b using ADODB.Connection?

Please help me out in this matter.I would be eagerly waiting for positive responses...



Thanks,
Aekta

You could create a custom class that exposes your data as properties. Then you can have a method, like GetItem in that class that uses your connection through COM Interop to get the data, fill the properties and return the object.
Finally, you can connect your DetailsView to your own class through an ObjectDataSource control.

AFAIK, there are no direct ways to use ADODB.Connection objects in your pages.

But why would you want to do this? Why do you have a need to use an ADODB.Connection?

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Thanks for ur reply.I have already bind data from SQl Server d/b with DetailsView Dynamically by using OledbConnection.
Example:
ID of DetailsView is d1,I execute the sql query using Executereader.Then,d1.Datamember="name"(where "name" is a field in table of d/b).Then i bind it using d1.databind().It only displayed me one record from d/b.

Can u please tell me how to display all the records from d/b.Remember,I waNT IT DYNAMICALLY.

If possible then explain me through example.

Thanks,
Aekta

The DetailsView shows one record at a time. This is by design. You can page through the data if you want.

You may want to look at the GridView instead.

This isn't really about using the ADODB.Connection, is it??

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Yaa.. that's true.I can use GridView to display records.But How could i do update,delete,add operations in DetailsView dynamically.bcoz...i could not put any loops as Executereader() will execute my query.can u suggest me how to do it?This is very important part of my project.

Controls like DetailsView work best with *DataSource controls, like the SqlDataSource or the ObjectDataSource. Usually you define methods or SQL statements for insert, update and other CRUD methods.

However, if your SQL is dynamic you can't really use them as is. The SqlDataReader is read-only, forward only. So, although you can use it to build up a DetailsView on the fly, you can't use it for updates.

Instead, you should somehow handle the Inserting / Updating events, get references to the controls inside your DetailsView and then manually construct a SQL statement for the insert / update.

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.