| .NET Remoting ( A Simple Approach) |
| 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 Remedy for DataGrid Vertigo |
| DotNetJunkies |
| 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). |
|
| Adding a "Totals" Field in a DataGrid |
| DotNetJunkies |
| 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. |
|
| Adding a Default ListItem in a Databound Listbox in ASP.NET |
| 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 |
| DotNetJunkies |
| 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. |
|
| ADO.NET 2.0 Feature Matrix |
| MSDN |
| 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. |
|
| Advanced Data Mapping in .NET |
| DotNetJunkies |
| In this article, Tin demonstrates 3 automated mechanisms for data mapping: mapping from Database table columns to object properties, mapping from HTML form fields to object properties, mapping from ASP.NET Web controls to object properties. |
|
| 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. |
|
| ASP.NET Letter Paging Based on Data Content |
| The Code Project |
| Paged table data display in DataGrid by selecting letter from a letter list which is derived from existing data. |
|
| ASP.NET/COBOL.NET Database Access Example |
| ASP Alliance |
| One of the features of the .NET framework is its ability to handle multiple languages. Third party compiler vendors can create and implement a compiler targeted for the .NET runtime. In fact, over the course of the next year, you can expect to see some 28 languages ported to the .NET runtime. This will allow companies with a huge codebase in a "non-Microsoft language" to continue building onto their investment. |
|
| Asynchronous Command Execution in ADO.NET 2.0 |
| MSDN |
| Get an overview of the new asynchronous execution functionality in ADO.NET 2.0, the scenarios it was developed to enable, plus some of the issues to keep in mind when using this feature. |
|
| Audio-Video Module for ASP.net Community Starter K |
| http://www.paul-abraham.com/ |
| Audio-Video Module for ASP.net Community Starter K |
|
| Automated Generation of Table Columns, Class Properties, and Form Field Mapping with C# Reflection |
| C#Today |
| In this article, Tin Lam shows how to use reflection to help us with complex mappings. Reflection allows us to examine assemblies and types at runtime, and find out everything about that type. We will also see how to dynamically extract the type information, and then carry out automated mappings between database table columns, HTML form fields and class properties. |
|
| BETA-PRB: DataReader Has No RecordCount Property in Visual Basic .NET (Q308050) |
| Microsoft Support |
| When using the OleDbDataReader or SqlDataReader class, there is no RecordCount property to tell how many records are being fetched. |
|
| BETA-PRB: No Method in DataReader Closes Its Underlying Connection (Q310369) |
| Microsoft Support |
| The DataReader object does not include a property to retrieve its underlying connection. Although you can close DataReader and then close the OleDbConnection or SqlConnection object on which DataReader was opened, DataReader does not have a built-in connection. Thus, if you retrieve a DataReader from a component method, you cannot close the underlying connection. That is, if you retrieve a DataReader object from a component, the DataReader stays connected, and there is no way to disconnect it.
|
|
| BETA-PRB: Output Parameters Not Returned When You Run an ADO.NET Command in Visual Basic .NET (Q308051) |
| Microsoft Support |
| Output parameters do not appear to be initialized or return a wrong value when executing an ADO.NET command. |
|
| BUG: SQLClient: SQLReader Doesn't Propagate Deadlock Exceptions (Q316667) |
| http://www.kbalertz.com/ |
| When you execute the |
|
| Build a Universal DAL Component |
| DotNetJunkies |
| Think about the possibilities of a component in the data access layer (DAL) of your application that didn't care what .NET Data Provider you were using. It could work just as easily with the SQL Server Data Provider or the OleDb Data Provider, or any other potential .NET Data Providers that could surface in the future. A DAL component that you could use against an Access 2000 database in development, and against a SQL Server database in production. In this tutorial, Doug shows how to build a universal data |
|
| Building a DataNavigator Control |
| MSDN |
| The list of ASP.NET rich data-bound controls is a long one, but it's not all-encompassing. You won't find any Microsoft® .NET counterpart for the Data control—a scrollable and updateable binding context that data-bound controls could rely on to refresh their user interface. The original Data control allowed for simple movements—first, next, previous, and last. It worked on top of a Recordset object and exposed the UpdateRecord method to save changes according to the capabilities of the currently selected type of cursor. While not the perfect programming tool, the Data control was especially good at building simple user interfaces for tables used internally for administrative purposes. |
|
| Building a Moderated Discussion Forum in C# |
| C#Today |
| In this article Juan Martinez tackles one of the most common features on a website: A discussion forum. Forums are a primary tool for building online communities and driving traffic to the website. We will step through the development of a moderated discussion forum from scratch. Analysis, design, implementation and deployment will be covered to furnish a working moderated forum in C#. |
|
| Building a Universal DAL Component |
| DotNetJunkies |
| Think about the possibilities of a component in the data access layer (DAL) of your application that didn't care what .NET Data Provider you were using. It could work just as easily with the SQL Server Data Provider or the OleDb Data Provider, or any other potential .NET Data Providers that could surface in the future. A DAL component that you could use against an Access 2000 database in development, and against a SQL Server database in production. |
|
| Building a Web Application Hit Counter |
| DotNetJunkies |
| In this tutorial Doug Seven shows you how to build a basic Web Application Hit Counter using Visual Basic .NET and SQL Server. The code is shown and available for download in Visual Basic .NET. |
|
| Building an Online Shopping Cart Using C# Part 2 |
| C#Today |
| n this article, Juan Martinez continues his work in building an online shopping cart application. In part one, he discussed the basic framework of the application, now the time has come to increase the features of the shopping cart and have a complete system for online use. These enhancements will demonstrate how easy it is to add new functionality to the framework, by adding a customer rating control for the available items. He will also build an administration console, which will enable us to manage the online store through the web, and will discuss the security issues on the web, and how to implement SSL in you server for encryption. Finally he will briefly discuss the various payment services available on the web. |
|
| Building Editing Capabilities into the SqlDataNavigator ASP.NET Control |
| MSDN |
| In last month's column I began an ambitious project: building a SQL Server™-specific DataNavigator control that supports two-way data binding. The control I'll present in this column, SqlDataNavigator, is just an extension of last month's DataNavigator. The SqlDataNavigator ASP.NET control described here is meant to be the Microsoft® .NET counterpart of the Data control—an old Visual Basic® control that caused its share of headaches. The control moves from one record to the next according to a given order and displays each data row using a dynamically generated template. Last month I focused on the DataNavigator control's architecture and tackled some programming issues related to connectivity and data display. This month, I'll add editing capabilities to the control, making SqlDataNavigator actually support the "writing" channel of .NET data binding. |
|
