How to Access DB as datasource through ASP.Net page

[garfield1]

I am using MS.Access database and ,binding the gridview with Access datasource, I am trying to update the multiple fields in a particular row ,but it is not supporting, another thing is that I want to have a drop-down menu where users can click to select different customers within the DB and have it load their respective data. If anyone has done or comes across this please let me know.

Any suggestions would be appreciated

[Sachit]

You can write code to access data using classes from the System.Data namespace (commonly referred to as ADO.NET) and from the System.Xml namespace. you should do some of those things if you want to build a proper n-tier system with separate data access and business tiers. You need to make a Customer.cs class within C# with public fields for each column in the Customers table in the DB, and somehow use it to create a Customer object that will contain the information about the selected customer.

[Timothi]

reate the connection to the database in the Page_Load subroutine. ASP.NET includes two types of server controls that participate in the declarative data binding model: data source controls and data-bound controls. A new OleDbConnection class with a connection string which identifies the OLE DB provider and the location of the database.

<script runat="server">
sub Page_Load
dim dbconn
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
data source=" & server.mappath("northwind.mdb"))
dbconn.Open()
end sub
</script>

[Sachit]

ObjectDataSource Enables you to work with a business object or other class and create Web applications that rely on middle-tier objects to manage data. Then you put your actual database code in a class that meets the Object data source contract requirements. Data source controls are ASP.NET controls that manage the tasks of connecting to a data source and reading and writing data. Data source controls do not render any user interface, but instead act as an intermediary between a particular data store.