|
|
|
|
|
Total Hits: 11 | Today: 0
|
Author: John Papa
|
Rating:
|
|
Someone once said to me that the hallmark of a good developer is the desire to spend time efficiently. Developers are continually pursuing ways to make coding easier and faster, and to reduce the number of errors. Using strongly typed DataSet objects in ADO.NET can help you do just that. This month I will discuss the pros and cons of developing a Microsoft® .NET Framework-based application using strongly typed DataSet objects. I will begin by discussing what a typed DataSet is and how it extends...
|
|
|
|
Total Hits: 1 | Today: 0
|
Author: Nancy Michell
|
Rating:
|
|
Back in ADO, Remote Data Service (RDS) allowed a developer to write a query to join tables, make changes to the data which was returned, and then send the changes back to the database with a simple call. In other words, it figured out which columns came from which table and made the changes to the right table. Does ADO.NET only support "smart" updates for queries of single tables, not queries involving joins? Yes, that's the case. DataAdapter can send changes from a DataSet/DataTable to a back-e...
|
|
|
|
Total Hits: 12 | Today: 0
|
Author: Dino Esposito
|
Rating:
|
|
In software, five years is like a geological era. Five years ago, the Microsoft® .NET Framework had just been announced. Since then, the DataSet has emerged as the key object for performing a variety of data-related tasks in .NET-based applications. Five years ago, the DataSet was hailed as a greatly enhanced version of the ADO Recordset. How would you have designed a data access layer (DAL) before the advent of the .NET Framework? I'm sure you would have built it around ADO and its almighty Rec...
|
|
|
|
Total Hits: 11 | Today: 0
|
Author: John Papa
|
Rating:
|
|
ADO.NET 2.0 sports some exciting enhancements to the core classes found in ADO.NET 1.x and introduces a variety of new classes, all of which promise to improve performance, flexibility, and efficiency. There have even been some major changes throughout the lifecycle of the pre-beta and beta versions of ADO.NET 2.0, such as the improvements to the new batch updating process. With the final release of ADO.NET 2.0 fast approaching and the feature set becoming more stable, it's time to take a closer...
|
|
|
|
Total Hits: 11 | Today: 0
|
Author: John Papa
|
Rating:
|
|
The Entity Framework is an exciting new technology being developed for ADO.NET. It allows developers to view data using a logical model instead of a physical model, offering more flexibility. I gave a detailed overview of the Entity Framework (which is due in the first half of 2008) in the July 2007 installment of Data Points. If you're not yet familiar with the Entity Framework, you can read my overview at msdn.microsoft.com/msdnmag/issues/07/07/DataPoints....
|
|
|
|
Total Hits: 15 | Today: 0
|
Author: Nannette Thacker
|
Rating:
|
|
In Building the Importer Web Page and Uploading the Excel Spreadsheet we created an interface for users to upload an Excel spreadsheet to the web server with the end goal being that a user could import the uploaded spreadsheet's data into the application database. Before importing the data, it would be prudent to display the contents of the uploaded Excel spreadsheet to give the user one last time to look over the data and verify that they want to import it. The contents of an Excel spreadsheet ...
|
|
|
|
Total Hits: 12 | Today: 0
|
Author: Nannette Thacker
|
Rating:
|
|
In most data-driven Web applications, users add data to the database by entering it through a web page. While this works well for most scenarios, there are times when the user has already collected the data to enter elsewhere, and having them tediously re-enter it through a web page is not only inefficient but prone to typos. In this multi-part series we will examine how to import data from a Microsoft Excel spreadsheet into a database from a web page. Specifically, we will build a tiered applic...
|
|
|
|
Total Hits: 21 | Today: 1
|
Author: SheoNarayan
|
Rating:
|
|
Here is the working example of looping through all rows of the DataTable. You can download the code and simply run it by placing to your IIS root folder. Let me explain you looping through all rows of the DataTable step wise....
|
|
|
|
Total Hits: 26 | Today: 0
|
Author: Suhailnabi
|
Rating:
|
|
I recently needed to do some "screen scraping" from a locally installed 3rd party web application and then do some data manipulation based on the results. The application in question wrote the results out to the page inside table tags and there were several of these tables on the page. I decided that the approach I would take would be to read all of these HTML tables, identifying them with a Regular Expression, and then convert them into one DataSet where I could then perform the required manipu...
|
|
|
|
Total Hits: 19 | Today: 0
|
Author: SheoNarayan
|
Rating:
|
|
My problem was that I had a Sql Server database at my webserver and I had to migrate its data for any reason to my MySql database table that had the same table structure as the Sql Server had. As I didn't had enough permission on Server to use DTS or other type of services to directly transfer my data to MySql so I had one option left that is to write a code that can get all data from Sql Server and transfer into MySql database....
|
|
|
|
Total Hits: 44 | Today: 1
|
Author: Zak Ruvalcaba
|
Rating:
|
|
Most dynamic Web applications are created for the sole purpose of making money on the Web. Let's face it: why would you go through all the work of creating a dynamic Web application if you don't plan to make money through it? Sure, companies employ dynamic intranet sites and there are still some -- although very few -- free Web applications you can use....
|
|
|
|
Total Hits: 22 | Today: 1
|
Author: Rakotomalala Andriniaina
|
Rating:
|
|
his article provides two files that contain a Membership provider and a Role provider for ASP.NET v2.0. Microsoft provides a Membership provider in the framework but only for SQL Server. The class does not seem to work for MySQL so I decided to write a new provider from the ODBC provider sample code included in the framework SDK. To use these classes, you will need the latest MySQL .NET Connector. You might need to recompile it with the new C# compiler for v2.0 (but the new framework should norm...
|
|
|
|
|
|
