Data Access

ok..gud one

brutal!

This tutorial helps a lot

Linq article is nice

hope see more videos about LINQ

great one..

good way of learning.

Good wiki.

great work!

Nice article..good job

Dear All, can someone suggest me where I can find good online learning webcast for ms sql server 2008.. with regards, Rama

Dears hello, can somebody explain me regarding asp.net 2.0 with oracle 10g so my project web-based access reporting (CDR) using asp.net 2.0 and oracle 10g as back-end,that oracle database large Db when I connect asp.net page with oracle db the is opening but very slowly what is the problem ? .. thanks

Connection String

The connection string specifies information about how to initialize a connection to a data store. It contains keyword/value pairs. the first pair is always the Provider or Driver. The following pairs will correspond with the data required to initialize the

Dynamic Data

ASP.NET Dynamic Data is a web application scaffolding framework that shipped with Service Pack 1 of .NET 3.5. Using either LINQ to SqL or LINQ to entities, it exposes tables in a database by encoding it in the URI of the ASP.NET web service. The data table

ADO.NET

ADO.NET stands for ActiveX Data Objects for .NET. It refers to the suite of data access technologies used to manipulate databases. ADO.NET is part of the .NET Framework.. ADO.NET provides access to datasources starting from SQL Server / Oracle to XML based

Serialization

The process of serialization converts an object into a form so that it can be transported across the network or can be placed in a storage location. The storage location could be a physical file, database or ASP.NET Cache. The state of the Object is preserved

Export Image to Excel using c#

Here am trying to show how we can export an image to excel file. References Used: Microsoft.Office.Interop.Excel; Link for downloading the dlls and install: Office XP PIAs Add Microsoft.Office.Interop.Excel.dll to the bin folder. Add office.dll to the bin

Shuffle DataRow in DataTable

We all know that we can sort the rows in DataTable by making a simple use of DefaultView. But now if i want a few conditional rows to be shuffled in the table; i dont have anything inbuilt in .net.Now if I want to select a few conditional rows in the table

Writing RssHandler base on sql database...c#

%@ WebHandler Language="C#" Class="RssHandler" %>using System;using System.Web;using System.Data.Common;using System.Configuration;using System.Data;using System.Xml;public class RssHandler : IHttpHandler { bool IHttpHandler.IsReusable

Using ASP.NET MVC and OpenXML api to stream Excel files.

I’ve been heads down for the last several weeks Scrumming and it has been a while since I’ve updated my blog so I figured if I was going to keep your interest I should give you something really useful. We’ve been transitioning from web forms to ASP.NET MVC

Azure - Learn materials

Abstract: Here we list the materials which can help you know more about Azure and start it quickly. Welcome anyone add more if you have interesting materials here. Thanks. Keywords: WindowsAzure, SQLAzure Azure official web site Windows Azure Tools for Microsoft

Uploadind files to database from ASP.NET pages

This example will show how is possible to upload files to SQL server database using C# and asp.net. For demostration purposes database will have only one table named File with colums: FileId, Filename, Extension, ContentType, Document. FileId serves as primary

Books and Help Resources on Entity Framework

Programming theMicrosoft® ADO.NET Entity Framework by David SceppaPublisher : MicrosoftProgramming EntityFrameworkBuilding Data Centric Apps with the ADO.NET Entity FrameworkBy Julia LermanPublisher: O'Reilly MediaReleased: January 2009 Pages: 832 Entity

Entity framework

What is Entity Framework?ADO.NET Entity Framework is an object-relational mapping (ORM) framework for the .NET Framework. Basically it represents the relational (logical) schema of the data that is stored in a database and presents its conceptual schema to

Create Excel file from DataTable

Here is a simplified class to create Excel file from DataTable just Pass DataTable and Preferred location on server to generate. Call the method in your Page by ExcelHelper.Instance.Create(Dt,StrPath); use this class using System; using System.Collections

Connecting to SAP data from ASP.NET

Articles:What is SAP?SAP is a leading ERP (Enterprise Resource Planning) in the market. This enterprise resource planning (ERP) software product capable of integrating multiple business applications, with each application representing a specific business area

Export To CSV file

First let’s see what the CSV file is: CSV file is a text based file in which data are separated by comma. It can be opened by excel so you can use excel functionality. Each row of data including the title is in separate line. Meanwhile, each row has data separated

LINQ

From MSDN: "The LINQ Project is a codename for a set of extensions to the .NET Framework that encompass language-integrated query, set, and transform operations. It extends C# and Visual Basic with native language syntax for queries and provides class

Data Binding

Nearly all the controls in ASP.NET have properties that can be databound to. Articles Jesse Liberty has a fine article on Data Binding in ASP.NET 2.0 over on O'Reilly from 2005. John Papa talks about Data-Bound Controls in his MSDN Article from 2005. Tutorials

DataSource Controls

FromScottGu:Scott Mitchell is also writing some great data articles on using the ASP.NET 2.0 DataSource controls for the excellent www.4GuysFromRolla.com ASP.NET site. If you don't visitwww.4GuysFromRolla.com, I highly recommend checking it out (it has

Web Services

A Web service is defined by the W3C as "a software system designed to support interoperable Machine to Machine interaction over a network." Web services are frequently just Web APIs that can be accessed over a network, such as the Internet, and executed

Active Directory & LDAP

There are many questions that come up regularly in the forums. These recipes address some of those questions. RecipesAccessing Active DirectoryHow to query Active Directory without hard-coding the domain name - in C# and VB.Net Testing your directory access