|
|
|
|
|
|
Author Rank:
|
|
Total page views :
1471
|
|
Total downloads :
|
|
|
|
|
|
|
Similar ArticlesMost ReadTop RatedLatest
|
|
|
|
|
|
|
|
|
|
This article has been
excerpted from book "A Programmer's Guide to ADO.NET in C#".
Using Visual Studio .NET, you can import a type library in an application using
the Project > Add Reference menu option. The Add Reference option adds the
assembly namespace to your project.
In this sample, you'll see how to import the ADO type library and use the ADO
recordset to access a database. After that, you'll fill data to a DataSet from
the ADO recordset using a data adapter.
To test this application, create a Windows application and drag a DataGrid
control to the form from the toolbox. To add a reference to a COM type library,
go to the Add reference option from the project menu and select the COM tab in
the Add Reference dialog box. As you can see from figure 10-24, I selected
Microsoft ActiveX Data Objects 2.7 Library. Click select to add the selection to
the selected components list. Now click OK.
Figure 10-24. Adding a reference to a COM library
This action adds the ADODB namespace to the project. You can see this namespace
from the project namespace (see figure 10-25).
Figure 10-25. Namespace after adding ADODB namespace to the project
After adding a reference of a namespace to a project, its members are available
for use in your project. You include this namespace in your application by
calling using. You also should add a reference to the System.Data.OleDb
namespace because you'll use the OleDb data adapter to fill a dataset. So, add
these two namespace references to the project with this:
using
System.Data.OleDb; using ADODB;
Now you can use the ADO recordset and connection to access a database. As you
can see from listing 10-6, I created a Connection object and set the connection
mode and cursor location. After that I called the connectionn's Execute method
to execute a SQL statement that returns the _Recordset object. The Fill method
of data adapter reads data from a recordset and fills data to a dataset. As you
can see, I also created a dataset and data adapter and called the data adapter's
Fill method. The Fill method takes three parameters: a dataset, a recordset, and
a dataset name. After that, bind the dataset to a data grid in order to fill
data from the dataset to the data grid.
Listing 10-6. Using ADODB namespace to access a database
private
void Form1_load(object
sender, System.EventArgs e) { // Create SQL and
Connection strings string ConnectionString =
@"Provider=Microsoft.Jet.OLEDB.4.0;
DataSource=C:/Northwind.mdb"; string sql =
"SELECT CustomerID,CompanyName,ContactName From
Customers";
// Create a
Connection object and open it Connection conn = new Connection(); int connMode = (int)ConnectModeEnum.adModeUnknown; conn.CursorLocation = CursorLocationEnum.adUseServer; conn.Open(ConnectionString, " ",
" ", connMode); object recAffected =
null; int cmdType = (int)CommandTypeEnum.adCmdText; _Recordset rs = conn.Execute(sql, out
recAffected, cmdType);
// Create dataset
and data adapter objects DataSet ds =
new DataSet("Recordset"); OleDbDataAdapter da = new
OleDbDataAdapter();
// Call data
adapter's Fill method to fill data from ADO // Recordset to the
dataset da.Fill(ds, rs, "Customers");
// Now use dataset dataGrid1.DataSource = ds.DefaultViewManager; }
The output of listing 10-6 looks like figure 10-26.
Figure 10-26. Displaying data from an ADO recordset to a data grid
Conclusion
Hope this article would have helped you in understanding Hypertext Markup
Language (HTML), XML, and other Web-related technologies. See other articles on
the website also for further reference.
|
This essential guide
to Microsoft's ADO.NET overviews C#, then leads you toward deeper
understanding of ADO.NET. |
|
|
|
Login
to add your contents and source code to this article
|
|
|
|
|
|
|
|
|
|
|
|
C# Consulting is founded in 2002 by the founders of C# Corner. Unlike a traditional
consulting company, our consultants are well-known experts in .NET and many of them
are MVPs, authors, and trainers. We specialize in Microsoft .NET development and
utilize Agile Development and Extreme Programming practices to provide fast pace
quick turnaround results. Our software development model is a mix of Agile Development,
traditional SDLC, and Waterfall models.
|
|
Click here to learn more about C# Consulting. |
|
|
|
|
|
|
|
Introducing MaxV - one click. infinite control. Hyper-V Hosting from MaximumASP.
Finally – a virtual platform that delivers next-generation Windows Server 2008 Hyper-V virtualization technology from a managed hosting partner you can truly depend on. Visit www.maximumasp.com/max for a FREE 30 day trial. Hurry offer ends soon.
Climb aboard the MaxV platform and take advantage of High Availability, Intelligent Monitoring, Recurrent Backups, and Scalability – with no hassle or hidden fees.
As a managed hosting partner focused solely on Microsoft technologies since 2000, MaximumASP is uniquely qualified to provide the superior support that our business is built on. Unparalleled expertise with Microsoft technologies lead to working directly with Microsoft as first to offer IIS 7 and SQL 2008 betas in a hosted environment; partnering in the Go Live Program for Hyper-V; and product co-launches built on WS 2008 with Hyper-V technology.
|
Dynamic PDF
ceTE software specializes in components for dynamic PDF generation and manipulation. The DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and new content to existing PDF documents from within your applications.
|
Go.NET
Build custom interactive diagrams, network, workflow editors, flowcharts, or software design tools. Includes many predefined kinds of nodes, links, and basic shapes. Supports layers, scrolling, zooming, selection, drag-and-drop, clipboard, in-place editing, tooltips, grids, printing, overview window, palette. 100% implemented in C# as a managed .NET Control. Document/View/Tool architecture with many properties&events. Optional automatic layout.
|
Dundas Software
Dundas Chart for .NET is the most advanced .NET charting package available today. With an extremely complete feature set, elegant architecture and easy implementation, Dundas Chart can quickly add advanced Charting functionality to enhance and transform ASP.NET and Windows Forms applications. Whether you are implementing charting into internal projects, or building applications for clients, Dundas Chart offers advanced technology and advanced results to get the most out of data.
|
60 FREE UI Controls from DevExpress
Register for your FREE copy on over 60 free presentation controls from
DevExpress - Absolutely Free-of-Charge without any royalties or distribution
costs. Visit Devexpress.com/60 today. Free controls include advanced lists box, dropdown calendar, rich text edit, spin
edit, tab control and so much more!
DevExpress engineers feature rich presentation controls and reporting tools for WinForms, ASP.NET, WPF, and Silverlight. Our technologies help you build your best, see complex software with greater clarity and deliver compelling business solutions for Windows and the web in the shortest possible time.
|
Clickatell's SMS Gateway
Clickatell's Developer Solutions allow you to SMS enable any website or
application via a range of API's. Learn More about our API connections.
|
Microsoft Visual Studio 2010
Visualize your workspace with new multiple monitor support, powerful Web development, new SharePoint support with tons of templates and Web parts, and more accurate targeting of any version of the .NET Framework. Get set to unleash your creativity.
|
Nevron Chart for .NET 2010.1 Now Available
The leading .NET charting control now features PDF, Flash and Silverlight export, visualization of large datasets and more. Deliver true charting functionality to your BI, Scorecard, Presentation or Scientific apps. Download evaluation now.
|
Developer-Ready ASP.NET 2.0 Web Hosting with 3 MONTHS FREE
Now supporting .NET 3.0 Framework with Windows Workflow Foundation, Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF), windows CardSpace (WCS)! Providing more flexibility for Developers with Web Services Support and a User/Permission Manger. Also supporting MS SQL 2005/2000 with Real-Time Backups, FREE Automated Attach .MDF Tool, FREE SQL Restore and Shrink SQL DB Tools, and SQL
|
|
|
|
|
|
|
|
|
|
|
|
|