|
|
|
|
|
Total Hits: 283 | Today: 0
|
Author: Pankaj kr. Gupta
|
Rating:
|
|
This article is written for how to get distinct rows in a dataset....
|
|
|
|
Total Hits: 654 | Today: 0
|
Author: MSDN
|
Rating:
|
|
If your client application uses an ADO.NET DataSet object to store changes that are made to data or to add new records, you can use a Transaction object, a DataSet object, and a DataAdapter object to roll back any changes if an error occurs. If you use a CommandBuilder object to generate INSERT, UPDATE, and DELETE commands, you must set the Transaction property of the SELECT command of the DataAdapter....
|
|
|
|
Total Hits: 64 | Today: 0
|
Author: Jason Witty
|
Rating:
|
|
In this article I walk through an example that binds a gridview control to an ObjectDataSource and uses Linq queries to paginate to achieve true data pagination.When SQL server first launched I wrote about using ROW_NUMBER() to paginate your data with SQL Server 2005. Today I am going to look at an alternate approach on the same subject. In this article I will review data pagination using a grid view bound to an ObjectDataSource that is persistant in memory....
|
|
|
|
Total Hits: 21 | Today: 0
|
Author: Ken Getz ,Paul D. Sheriff
|
Rating:
|
|
In the first two articles of this three-article series, you learned how to convert an existing Visual Basic 6 data-oriented application into a Visual Basic 2005 application—Part 1 walked through the conversion process, and Part 2 demonstrated how to replace ADO code with the corresponding ADO.NET code. Although the converted application ran, it was far from perfect, and still required almost as much as code as the converted Visual Basic 6 application. It doesn't have to be that hard, however. In...
|
|
|
|
Total Hits: 28 | Today: 0
|
Author: daffrey.
|
Rating:
|
|
Have you ever had to deploy a SQL Server database to a customer? If you have, then you will know that it is certainly not as simple as deploying an application that uses an MS Access database.
With SQL Server databases, you have 3 deployment options that I know of:
1. Distribute your .mdf and .ldf files to your customer and attach the database to their SQL Server instance using the system stored procedure sp_attach_db (or sp_attach_single_file_db). The downside is that the SQL S...
|
|
|
|
Total Hits: 110 | Today: 0
|
Author: Sanjay David
|
Rating:
|
|
This article demonstrates the transaction using the DataAccess objects....
|
|
|
|
Total Hits: 3205 | Today: 1
|
|
Rating:
|
|
DataSet objects, a key part of data access in the Microsoft .NET Framework, are in-memory objects that can hold tables, views, and relationships. This article demonstrates how to take a DataSet that contains data (which is loaded from a database), modify that data, and then send it back to the database to update the original source....
|
|
|
|
Total Hits: 53 | Today: 0
|
Author: Rohant Kunnat
|
Rating:
|
|
This code helps to retrieve the unique values from the DataSet. This is useful, if you are using filter, to get the unique values out of the DataSet. I have used the readymade DataGridView of the vb.Net 2005. I have a table with a very simple schema. I have included the code to create the table. And also I have given the code snippet in vb .Net...
|
|
|
|
Total Hits: 26 | Today: 0
|
Author: Steven Smith
|
Rating:
|
|
The DataReader and the DataSet are two very different ways to access data using ADO.NET. The DataReader provides a direct one-way connection to the data and is the fastest way to read data from a database. The DataSet is essentially a collection, and has a lot of functionality to support working with relational data. A DataSet will always perform worse than a DataReader (albeit perhaps unnoticeably so), due to its size and the simple fact that it uses a DataReader to populate itself. For most da...
|
|
|
|
Total Hits: 32 | Today: 0
|
Author: Code24.com
|
Rating:
|
|
Business software’s have been a big thing for the industry. Building nice and smart applications connected with databases using Server Query Language (SQL) is a smart thing. The software industry has in many years been developing smart systems using many types of database systems. The NET-Framework system is a smart thing you could use if you want to build business-integrated applications. Microsoft® is one of the companies which are working with coming up with new systems and smart ways that co...
|
|
|
|
Total Hits: 56 | Today: 0
|
Author: arapallo
|
Rating:
|
|
I had problems posting this article, here I go again, basically this article is a small pilot I wrote to test 3 ways to convert a List(Of Any Class) into a DataSet. I also included some Performance Images to show which methods appears to be better....
|
|
|
|
Total Hits: 50 | Today: 1
|
Author: Ranjith Pitton
|
Rating:
|
|
Very frequently one might need to create a report in Excel. To my dismay, I found out that there is still no option to create an Excel file with some simple formatting along with formula fields etc. Hence I decided to make an assembly which accepts a Dataset and fields to be summarized. It returns an Excel which automatically adjusts width and data formatting etc....
|
|
|
|
Total Hits: 24 | Today: 0
|
Author: Joe Cleland
|
Rating:
|
|
One of my ongoing frustrations has been that, in order to populate an object with private data from a data source you have to expose members publicly or create a class method that accepts the data and internally fills member values with the data. In the former case the member values are exposed to accidental corruption by developers and the concept of encapsulation is defeated. In the latter case the data gets too tightly coupled to the data source. It occurred to me that, by using reflection, I...
|
|
|
|
Total Hits: 37 | Today: 0
|
Author: Jesse Liberty
|
Rating:
|
|
If you're used to Visual Basic 6.0 and you're making the transition to Microsoft .NET, you will find that error handling is quite different from what you've used for years. Visual Basic .NET uses a more object-oriented solution to signaling and responding to unexpected problems while your program is running. This approach, called structured exception handling, has a number of advantages over the On Error statements provided in previous versions of Visual Basic. For instance, exceptions give you ...
|
|
|
|
Total Hits: 3301 | Today: 1
|
Author: MSDN
|
Rating:
|
|
This step-by-step article describes how to transform a DataSet to Spreadsheet XML that can be rendered in Excel. The Excel Spreadsheet XML format supports element tags and attributes for Excel functionality such as multi-sheet workbooks, formulas, and cell formatting....
|
|
|
|
Total Hits: 1409 | Today: 0
|
Author: MSDN
|
Rating:
|
|
ADO.NET provides new flexibility in how you update your data source. This article describes how you can update a data source that is different from the original data source that you use to create the DataSet object....
|
|
|
|
Total Hits: 637 | Today: 0
|
Author: MSDN
|
Rating:
|
|
This article demonstrates how to read Extensible Markup Language (XML) data into an ADO.NET DataSet object....
|
|
|
|
Total Hits: 15 | Today: 0
|
Author: Ken Getz ,Paul D. Sheriff
|
Rating:
|
|
Part 2 of this article series focuses on the data features of converting code from ADO to ADO.NET. ADO.NET operations require less code, and replacing the COM interop features will make your application more efficient....
|
|
|
|
Total Hits: 18 | Today: 0
|
Author: Ken Getz
|
Rating:
|
|
Most Visual Basic 6 applications involve data in some way or another, and most Visual Basic 6 developers are comfortable working with ADO in order to solve their data-handling tasks. It's likely that if you're currently an expert Visual Basic 6 developer, you're interested in moving your skills to the world of .NET, using Visual Basic 2005 as your development language. This skill transfer isn't nearly as simple as you might like, and, to be honest, you've got real work to do....
|
|
|
|
Total Hits: 29 | Today: 0
|
Author: rmortega77
|
Rating:
|
|
There are many tools, such as Orca, for tampering with the Microsoft Installer Database .msi files. This sample shows how to build a MSI database file reader. Though it does not allow to modify it, it will be helpful to those who want to get some insights in to the structure of an MSI....
|
|
|
|
|
|
