Getting Started with LINQ(beyondrelational.com)

submitted by DPalkar(228) 1 year, 9 months ago

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 that it surely requires a good introduction to start with. LINQ was introduced with .net 3.0 as one of the language enhancements. It uses generics, which was introduced in .net 2.0, thoroughly to accomplish what it was designed to do. LINQ is designed to query virtually any kind of data source which implements IEnumerable<T> interface. It allows you to query the data by emulating the SQL query expressions using any .net language you are comfortable with. Isn’t that amazing!! read more...

add a comment |category: Linq |Views: 344

tags: SQL Query getting Expressions Started another

Convert a LINQ Query Resultset to a DataTable(c-sharpcorner.com)

submitted by beckelmw(2755) 3 years, 4 months ago

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. read more...

add a comment |category: Linq |Views: 659

tags: DataTable DataSet LINQ another

Export DataSet to Excel Using An Array(kellychronicles.spaces.live.com)

submitted by scorpion53061(85) 3 years, 6 months ago

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. read more...

add a comment |category: VB.NET |Views: 267

tags: DataSet array VB.NET Excel another

Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters(aspnet.4guysfromrolla.com)

submitted by Moondusk(15) 3 years, 11 months ago

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. read more...

add a comment |category: ASP.NET |Views: 70

tags: DataSet TableAdapter ASP.NET Excel another

VB.NET/ASP.NET XML String to Dataset(dennylove.blogspot.com)

submitted by superghost(2260) 4 years, 10 months ago

XML String to Dataset read more...

add a comment |category: ASP.NET |Views: 270

tags: DataSet Denny.NET XML VB.NET ASP.NET another

Tips: Using Strong Typed DataSets with Web Services(keithelder.net)

submitted by TheElder(490) 4 years, 11 months ago

The articles covers several tips to increase performance when using datasets with web services. read more...

add a comment |category: Web Services |Views: 14

tags: WebService DataSet another

Write dataset contents directly to zip file(papadi.gr)

submitted by papadi(310) 5 years, 1 month ago

This article shows how to write the contents of a dataset (Dataset.WriteXML) directly into a zip file, without creating any temporary file first. read more...

add a comment |category: ADO.NET |Views: 12

tags: zip stream XML DataSet another

Video: Minimize Code with TableAdapters and Strongly-Typed DataSets (blogs.interfacett.com)

submitted by dwahlin(1450) 5 years, 2 months ago

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. read more...

add a comment |category: ADO.NET |Views: 199

tags: DanWahlin TableAdapter Video DataSet another

Using Typed DataSets with SQL 2005 and stored procedures(geekzilla.co.uk)

submitted by fatdaveh(1420) 5 years, 4 months ago

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 Server 2005 and stored procedures. read more...

1 comment |category: Database |Views: 8

tags: Wizard Bug GeekZilla Database SQL another

Using Strongly Typed DataSets and GridViews(geekzilla.co.uk)

submitted by fatdaveh(1420) 5 years, 5 months ago

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 read more...

add a comment |category: ASP.NET |Views: 16

tags: GeekZilla DataSet GridView another

Strongly Typed Table Adapters: autogenerating CRUD statements(dotnetslackers.com)

submitted by simoneb(5450) 5 years, 6 months ago

A tip about forcing Visual Studio DataSet designer to generate crud statements even when joining tables. read more...

add a comment |category: Visual Studio |Views: 45

tags: CRUD DataSet simoneb ADO.NET DataBinding another

DataGrid Paging and Sorting Using A DataReader(developerfusion.co.uk)

submitted by james_crowley(315) 6 years ago

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! read more...

add a comment |category: ADO.NET |Views: 317

tags: Sorting Caching dataadapter DataReader DataGrid another