By tag: DataSet
0
kicks
Getting Started with LINQ
In this we’ll continue to discuss how to go about the SQL Server Data Access using various technologies. This post will discuss Microsoft Language Integrated Query, otherwise known as LINQ. I will discuss how it can be used to accomplish the same tasks we have discussed in previous posts. But before...
0
kicks
Convert a LINQ Query Resultset to a DataTable
After a long struggle I find out the way to convert a Linq Query resultset to DataTable object. The attached source code shows how to do it. I am sharing this article with my developer friends and make their life easier.
0
kicks
Export DataSet to Excel Using An Array
The example for writing the data to an array and sending it to a spreadsheet at http://support.microsoft.com/default.aspx?scid=kb;EN-US;306022 is great and where my thinking on this began. It was inadequate however to deal with datasets and the problems encountered in dynamic data.
0
kicks
Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters
In this tutorial, learn how to import data from an Excel Spreadsheet to a Database by creating a tiered application architecture using Visual Studio's Typed DataSets and TableAdapters.
0
kicks
Tips: Using Strong Typed DataSets with Web Services
The articles covers several tips to increase performance when using datasets with web services.
0
kicks
Write dataset contents directly to zip file
This article shows how to write the contents of a dataset (Dataset.WriteXML) directly into a zip file, without creating any temporary file first.
0
kicks
Video: Minimize Code with TableAdapters and Strongly-Typed DataSets
This video of Dan Wahlin's talk at the 2006 ASP.NET Connections conference covers how TableAdapters and Strongly-Typed DataSets can be used to minimize code. Source code and slides from the talk are also available.
0
kicks
Using Typed DataSets with SQL 2005 and stored procedures
I have been a fan of typed datasets since I started using them in VS2005. Using the feature with SQL Express/stored procedures, Express/SQL Statements, SQL Server/SQL Statements all generate my DAL just fine.
However, I have found a couple of problems with them when using them with full SQL Serv...
0
kicks
Using Strongly Typed DataSets and GridViews
A brief overview of using Strongly Typed Datasets with the Gridview object - when using stored procedures these two don't play as well as would be expected
0
kicks
Strongly Typed Table Adapters: autogenerating CRUD statements
A tip about forcing Visual Studio DataSet designer to generate crud statements even when joining tables.
0
kicks
DataGrid Paging and Sorting Using A DataReader
This article will demonstrate two ways one could implement the DataReader to bind a DataGrid, that includes caching, paging and persistent bi-directional sorting, all without the use of a DataAdapter/DataSet at all!