Implementing ODBC in ASP .NET

Conclusion

Where to go from here? Once the Dataset object is set up as shown above, anything goes. Typically, the next step will be to fill the Dataset using the appropriate Data Adapter's Fill method, like this:

odaUser.Fill(this.userData);

The .NET framework will do all the heavy lifting involved in maintaining the appropriate connections and ensuring that updates and other operations proceed as required. When HotQuant migrates its website to a SQL Server back end, this is the only code that need change in order to maintain the functionality of the site. This is the real beauty of the multiple levels of abstraction the .NET Framework interjects between code and data.

As always, HotQuant welcomes any comments or suggestions. E-mail is best; we make every effort to respond to all inquiries.

You might also like...

Comments

About the author

Jason G. Williscroft

Jason G. Williscroft United States

Jason Williscroft is a former Marine and naval officer, and a graduate of the United States Naval Academy, where he studied Systems Engineering. He is currently General Manager of HotQuant, LLC,...

Interested in writing for us? Find out more.

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Brevity is the soul of wit” - Shakespeare