News in the Category: DataSet Subscribe to the rss of this category.

Total posts: 493 | Sort by Views | Sort by Hits

Use DataTable.Rows.Find() Instead of DataTable.Select()

DevX: .NET Feed, January 16, 2007
Views: 17,897 | Hits 2,750

Find out why using DataTable.Rows.Find() is faster than using DataTable.Select() to find records based on a primary key value....

DataView vs DataTable

Bigyan Rajbhandari, September 11, 2006
Views: 9,236 | Hits 1,796

Anyone who has used ADO.Net is familiar with DataTables and Dataviews. These objects bring a whole lot simplicity to data manipulation in .Net. Previously in ADO.Net 1.1 DataSets and DataTables had a ...

GridView and dynamic data sources

mikes web log, February 3, 2006
Views: 9,164 | Hits 1,619

Now and again you want to bind the GridView control not to a data source control or dataset, but just to some data you happen to have hanging around. A typical example, for example, might be that you ...

Export DataSet to Multiple Excel Sheets

The Code Project Latest Articles, December 7, 2008
Views: 10,983 | Hits 1,414

Exporting multiple tables in a DataSet to multiple sheets in an Excel file....

Data Binding to Custom Objects

Mike Christensen: Web Dev Guy, May 18, 2006
Views: 5,749 | Hits 1,000

Im back! I apologize for my lack of recent blogging, but this post should help make up for that.  Well be discussing data binding to custom collection objects.  After reading my blog on buil...

Exporting a Dataset with multiple tables in separate sheets in an Excel file

The Code Project Latest Articles, May 24, 2007
Views: 4,964 | Hits 965

This article describes how to export the data from multiple tables in a Dataset to an Excel file in separate sheets....

Cascading DropDownList Controls -- Insert mode

mikes web log, June 2, 2007
Views: 7,252 | Hits 955

In response to the post about using casccading (dependent) drop-down lists in a FormView control, a number of people have wondered how you can use similar drop-downs in Insert mode in a FormView contr...

Building and Consuming a Dynamic Sitemap in ASP.NET 2.0

The Code Project Latest Articles, September 17, 2006
Views: 5,909 | Hits 884

You need to build a dynamic sitemap right from a dataset because you don't have static content on your website...

Implementing a Generic Data Transfer Object in C#...

DotNetJohn.Com, November 18, 2007
Views: 5,661 | Hits 806

This article discusses implementation of a generic Data Transfer Object that can be used in lieu of passing instances of DataSets or Custom Business Entities from the User Interface Layer to the o...

Dealing with GridView Empty Cells

ASP.NET Daily Articles, January 12, 2006
Views: 5,299 | Hits 731

Consider a situation where you are displaying data in the GridView control and some of the cells does not contain anything and hence does not display anything. In this article we will see that how you...

HttpContext.Cache Viewer (With DataSet Support)

Scott Cate .net Knowledge Base and Weblog, February 5, 2004
Views: 5,157 | Hits 638

Aw, the HttpContext.Cache. Most of the items I place in the Cache are named with GUID's so it's not very helpful to loop through and print out the Cache Item Name. I've built this handy ASPX page that...

MapPoint Uploads with Zip and Chunking

youve been HAACKED, December 18, 2005
Views: 1,680 | Hits 618

As I recently said, you have to be a bit MacGuyver to be a successful consultant. Ive also whined about how difficult hiring is, especially when you want to hire MacGuyver. But then there are times...

Microsoft Access - Bind Dataset with ComboBox New Articles, November 22, 2006
Views: 6,233 | Hits 611

This is a simple article which describes how to bind a dataset to a comboBox. By Ajay Arora...

TableAdapter and Multiple Result Sets

The Visual Basic Team, March 13, 2007
Views: 5,832 | Hits 596

Several people asked me whether TableAdapter can be used to retrieve multiple result sets from stored procedures. The quick answer is... No, you can't do that with TableAdapter.Fill() method that gets...

A Huge Email Misunderstanding

youve been HAACKED, January 6, 2006
Views: 1,647 | Hits 596

Yesterday I received a call from my very exasperated father who recently has been helping my Korean mother learn how to use the web and web-based email. dl.dialog {float: left; width: 500px; display:...

Why Services Are Not Components, and Vice Versa

WebServices.Org Weblogs, November 25, 2005
Views: 1,457 | Hits 591

While no clear boundaries exist, service-oriented architecture and component-based architectures are two different animals that address very different problems....

A Faster Way to Search Through a DataTable

DevX: .NET Feed, January 30, 2007
Views: 4,543 | Hits 584

Find out how DataView can help you perform faster searches through a DataTable....

LINQ Query to DataTable (DataRows)

TheChaseMans Frenetic SoapBox, June 6, 2009
Views: 6,532 | Hits 582

Interested in writing a LINQ query to fill a DataTable? Normally I don't condone writing ugly code but let's have some fun. In this example, an anonymous type array is created followed by a DataTable...

DataView Trivia - DataTable must be set prior to using DataView

MrDaves (David Yack) Blog!, June 29, 2005
Views: 13,228 | Hits 564

In case you were wondering – if you set a Dataview on a table that does not exist in a dataset it will create the instance of the DataView but not allow any operation on it DataSet ds = new Data...

Working with GridView without using Data Source Controls

DotNetJunkies Just Published, July 15, 2006
Views: 3,610 | Hits 501

There are many articles and tutorials around that illustrate the use of GridView control along with the new Data Source Controls. When attached with a Data Source control GridView performs tasks such ...

Designing N-Tiered Data Access Layer Using Datasets - Part 1 Features, January 3, 2008
Views: 4,250 | Hits 495

In the first part of this three part series on designing an N-tiered data access layer using datasets, David Catherman discusses the pros and cons of using datasets and examines how the dataset genera...

Simple DataSet for Paging Instead of ObjectDataSource New Articles, January 27, 2007
Views: 4,731 | Hits 458

I wasted around 3 days searching how to implement a paging results for my search pages, then I think why did not i use the asp table instead of gridview, and use the DataAdapter.fill to fill the datat...

Using AJAX with ASP.NET - Working with DataSet (Part 2) Latest Articles, September 18, 2005
Views: 3,793 | Hits 452

In the previous article I explained the overall concept of AJAX and how it can save you server post backs. Our last example was a simple "hello world" kind of example. In this part I will explain ho...

How LINQ to Dataset works in VB (Jonathan Aneja)

The Visual Basic Team, May 14, 2008
Views: 4,535 | Hits 438

LINQ at its core requires any data source to be queryable, which basically means it must implement IEnumerable.  (Its actually a bit more complicated than that, for a full explanation see section...

How to : Get Excel data into a .NET DataSet object

GotDotNet: New resources, December 22, 2005
Views: 4,385 | Hits 430

There may be requirement where in data in an Excel sheet has to be manipulated inside .NET Applications. Although there are many ways to achieve this (like using Excel object of COM), the most preferr...

Issue With Web Service as Data Source for Reporting Services

Corporate Coder, February 23, 2006
Views: 4,069 | Hits 429

Something interesting I found utilizing the BI stuff available in Visual Studio 2005 and SQL Server 2005.  Another developer and I were asked to create a quick demo version of a report, that sour...

LINQ to DataSet

The Moth, July 26, 2007
Views: 4,854 | Hits 398

Another LINQ implementation that will ship with Fx 3.5 is LINQ to DataSet (not to be confused with LINQ to SQL).LINQ to DataSet is about offering a strongly typed in-memory query language for DataSets...

An ASP.NET Custom Control for Dynamically Filtering Data - DataSetFilter

Brendan Tompkins, July 26, 2005
Views: 3,611 | Hits 392

A common need for web-based reporting is to create a UI to allow the user to apply filter criteria to a set of data.  Usually, this involves coding a fairly complicated UI, and associated co...

Automating Reports with diverse data sources using Business Objects Enterprise Server - Part 1 - The #1 ASP.NET Community, April 10, 2006
Views: 1,642 | Hits 389

In this article, Eric demonstrates how to automate a report with a remote XML datasource and Crystal Reports XI. The article also shows how to use Business Objects Enterprise Server to send the report...

Creating Dynamic DataSets for Crystal Reports in ASP.NET 2.0 - The #1 ASP.NET Community, February 28, 2006
Views: 2,549 | Hits 374

This article describes how to use the CrystalReportsViewer and Crystal Report Template components within VS 2005 and how to populate a report from a dynamically generated DataSet at runtime without lo...

How to get a return and ouput value form a data source command. - UPDATED

Fredrik Norméns Blog, May 31, 2005
Views: 2,561 | Hits 348

In my previous post about ”How to get a return and ouput value form a data source command.” was written before beta 2 was released. This post is an update of the previous post.   Some...

Custom Class/Collection versus DataSet Pt. V

TheChaseMans Frenetic SoapBox, January 16, 2006
Views: 2,457 | Hits 346

Brian Noyes has a really great article on TheServerSide.NET. I don't want to steal his thunder, but this is a topic and delima that I've had for years. When .NET 1.0 first went RTM, I thought type...

Implicit and Explicit Operators in C#

<Rolog>, May 24, 2007
Views: 4,932 | Hits 334

For a side project I'm working on, explicit operators have come in handy in the data layer. With explicit operators, you can convert from one class to another using a user-defined conversion opera...

Custom configuration Data from DataSets: Less is More New Articles, December 15, 2007
Views: 1,907 | Hits 332

Sometimes it's easier and faster to do things "the easy way" with custom configuration data saved from a DataSet instead of slaving over Custom ConfigurationSections in the App.Config or web.config ...

Client-side DataSets with Ajax.NET Pro

ASP.NET Daily Articles, February 24, 2006
Views: 3,218 | Hits 328

Everybody loves .NET's DataSets. They provide the most simple yet powerful way to manipulate in-memory tables and data collections on the server-side. Good news for hardcore AJAX web developers: usi...

Object Data Source Adapter New Articles, January 29, 2007
Views: 2,507 | Hits 323

In this brief article I want to mention two techniques that I use to allow for mapping GridViews to DataTables that are built upon existing middle tier objects. I tend to think of this as a pseudo ad...

DataSet enhancements in VS2008

The Moth, December 11, 2007
Views: 2,915 | Hits 321

For those of you using the DataSet, you'll be happy to know that there are enhancements to it, including these three:1. Hierarchical Updates: Read.2. Separate DataSets and TableAdapters for multi-tier...

Currency Conversion rates via a Web Service

Sonu Kapoors WebLog, January 3, 2005
Views: 2,020 | Hits 319

Some time ago I found the following Web Service, which provides the currency conversion rates for free. The WebSite also provides some other very nice services. I thought it would be interesting ...

Building a Rationale for a Dictatorship

Miguel de Icaza, December 22, 2005
Views: 1,343 | Hits 313

Nat pointed me to Bruce Schneier weights in on the new administration self-appointed rights: This is indefinite dictatorial power. And I don't use that term lightly; the very definition of a dictator...

"Have we not heard the chimes at midnight?"

Wallace B. McClure, January 12, 2006
Views: 1,389 | Hits 312

I listened to CNBC the other day.  It seems that many analysts are just falling all over themselves with this Web 2.0 hysteria.  Have we not been down this path before?  "Have we not h...

Working with DataSet Objects and XML - The #1 ASP.NET Community, June 6, 2006
Views: 2,104 | Hits 311

In this article, Sanjit highlights the CRUD (Create, Read, Update, and Delete) operations on a DataSet with an XML file as the repository and C# as the programming language....

DataSet and DataAdapter in ASP.NET 2.0 - Part 2 of 2

GotDotNet: New resources, July 20, 2006
Views: 2,832 | Hits 307

Explains how to work with multiple tables, handle errors and how DataSet tracks modified table rows....

Class to transform ofx (Microsoft Money) file into DataSet

The Code Project Latest Articles, June 8, 2006
Views: 3,107 | Hits 304

A small class that transforms the contens of an ofx file into a DataSet...

Are you a Business Object person, or a DataSet person?

Sahil Malik -, June 2, 2006
Views: 2,620 | Hits 288

p.MsoNormal {margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:0in; line-height:115%; font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black; } What is a...