ExamGuru IT/.Net Guru : System.Data.SqlClient.SqlCommand Class [Articles]

.NET Anatomy - Data Concurrency in ADO.NET, Part II

In my last article I reviewed the ADO.NET object model as it is presented in the .NET framework Beta2. To put this information to practical use, this article will provide a walkthrough of how to use Microsoft's newest set of developer tools, found in Visual Studio.NET to create a working Web Application that accesses an SQL database.

.NET Anatomy - Data Concurrency in ADO.NET, Part II

.NET Anatomy - Data Concurrency in ADO.NET, Part III

This is the second article in a series covering the subject of Concurrency in ADO .NET. Concurrency is the method by which many users are able access and change the same data simultaneously without being concerned that they are overwriting each others work. The architects of the .NET Framework made a design decision that the DataSet object assumes that Optimistic Concurrency as the default method of concurrency.

.NET Distributed Transactions on Enterprise Services: a demo

In the two previous articles on this subject we have looked at how the ADO.NET DataSet object contains built-in support for concurrency operations. This functionality helps the developer to build applications that keep users from overwriting each other’s data accidentally. The implementation is open and flexible and so what I will be showing you here can be tailored to your own requirements

.NET Remoting ( A Simple Approach)

This demo shows you how to develop .NET components capable of participating in distributed transactions coordinated by .NET Enterprise Services

C# Help

.NET Remoting provides a powerful and high performance way of working with remote objects. Architecturally, .NET Remote objects are a perfect fit for accessing resources across the network without the overhead posed by SOAP based WebServices. .NET Remoting is easier to use than Java's RMI, but definately more difficult than creating a WebService. In this article, we will create a remote object that will return rows from a database table. For the sake of simplicity i have used the NorthWind database that is packed with the installation of the Microsoft SQL Server.

.NET Remoting - The Interface Approach

C# Help

In this article, we will create a remote object, and access this object using an interface. This method is important when creating a physical separation between business tier and consumer code. In traditional Remoting approaches, to access a remote object, you need a copy of that object on the client machine. With this approach, the metadata is split into a separate library that can be copied to the client machine.

A Practical Guide to .NET DataTables, DataSets and DataGrids - Part 3

A Remedy for DataGrid Vertigo

The purpose of this document is to provide a practical guide to using Microsoft’s .NET DataTables, DataSets and DataGrid

The AlternatingItemStyle can be a wonderful thing. But in many cases I found that I would start to get a feeling like vertigo if I scrolled the page up or down. So I thought back to my days in Manhattan in the financial industry and remembered how I used to prepare reports to be viewed on screen. I alternated the colors of the rows, but I did it every three or five rows (depending on the width of the report, the content of the report, or my own aesthetic taste).

Abstracting ADO .NET

Accessing Data From SQL Server

With the release of Microsoft® .NET just around the corner, developers are gearing up to take advantage ot the many features, increased interoperability, and better data integration that the new framework promotes. While COM and Visual Basic® 6.0 are still widely used and will likely live on for years to come, I've met many developers who are anxious to get moving with the .NET components. Some of the questions I am asked most often regarding .NET are how developing with ActiveX Data Objects (ADO) 2.x will change under ADO .NET and how can you still abstract ADO into a data service component. So, in this month's Data Points column, I'll try to tackle these issues.

C# Help

Among the many things that are changing with .NET is data access. Under the .NET Framework, data access is handled by a set of classes called ADO.NET which are essentially an augmentation of the existing ActiveX Data Objects (ADO).

Adding a "Totals" Field in a DataGrid

Adding a Default ListItem in a Databound Listbox in ASP.NET

Lately one of the questions that has been popping up a lot is, "How do I show column totals in a DataGrid?" Personally I have provided sample code for this question more than a few times, so I thought it would only be appropriate that we here at DotNetJunkies HQ get a tutorial up on the topic.

4Guys from Rolla

In a previous article I showed how to use databinding to automagically populate an ASP.NET's listbox Web control with just a few lines of code. (If you've not already read the past article, be sure to do so now.) I've received a couple of feedback emails from folks since publishing the article asking how to add a default option to the listbox. That is, they want to add a listitem to the listbox, like: -- Please Choose an Option Below--. In this brief article we'll tackle this topic and more!

Adding a Totals Field in a DataGrid

ADO.NET 2.0 Feature Matrix

In this tutorial Doug shows you how to programmatically sum the values of a column in a DataGrid, and display that total in the footer of the DataGrid.

An Evaluation of Stored Procedures for the .NET Developer

ADO.NET 2.0 includes a new base-class provider model, features for all providers, and changes to System.Data.SqlClient. Get an overview of these new features, examples of their use, and a chart of which features are provider-neutral and SqlClient-specific.

ADO.NET Overview

GotDotNet

GotDotNet presents an overview of accomplishing common data access tasks. Extract: "ADO.NET is an evolution of the ADO data access model that directly addresses user requirements for developing scalable applications. It was designed specifically for the web with scalability, statelessness, and XML in mind"

An Extensive Examination of the DataGrid Web Control: Part 1

In this introduction to SQL Server stored procedures for .NET developers you’ll discover the pros and cons of using stored procedures, take a look at related Visual Studio .NET 2003 tools, and more.

ASP.NET - 4GuysFromRolla

This article is the first in a multi-part series on using the DataGrid Web control that will span several weeks. The ASP.NET DataGrid Web control, which displays database information in an HTML table, is highly versitile. In its simplest form (examined in this article) the DataGrid displays a bare-bones HTML table, but it can be enhanced to output a richer UI, to allow for sorting based on the database columns, and to even allow paging of the database results! All of these interesting topics will be covered in future parts of this article series.

An Introduction to Mobile Programming in C#

C#Today

With the expansion of the web away from traditional browsers, current technology has brought the internet into mobile devices. Microsoft has constantly improved its support to such devices, and the introduction of the .NET framework has taken this support a step further. With .NET we can program for a mobile device as a normal web page and the Common Language Runtime and .NET framework will take care of rendering the data in the appropriate format, i.e. as HTML for browsers, as WML for mobile phones, etc. In this article Niranjan Kumar introduces us to programming for Mobile devices using C# and ASP.NET pages. This is illustrated with a Stock List application that accesses a SQL Server database and lists available stocks on either a Mobile device or HTML browser.

Article 2 - Dynamic creation of database

Ask the DotNetJunkies: Using a Pop-Up Calendar and a List Control

Display data using Dataset and Data Grid control after the database is created

In this tutorial Doug Seven shown you how to use a DataGrid and a pop-up calendar / date picker together.

ASP.NET Data Shaping

ASP.NET DataGrid Paging Part 2 - Custom Paging

Is it possible to port this model to Web Forms and get automatic synchronization between two DataGrid server controls? This is the question I will try to answer in this month's column.

ASP.NET Letter Paging Based on Data Content

In this article Doug Seven shows you how to use the DataGrid custom paging feature. The code is in C# and it uses stored procedures in SQL Server 2000.