| .NET Anatomy - ADO.NET in Beta2 : Part 1 |
| DotNetJunkies |
| This article reviews the ADO.NET object model found in Microsoft’s .NET Framework Beta2. The information presented here will be useful both to programmers who worked with Beta1 and also, to those just starting with the framework. |
|
| .NET Anatomy - ADO.NET in Beta2 : Part 2 |
| DotNetJunkies |
| 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 I |
| DotNetJunkies |
| This article is the beginning of a multi-part article that discusses data concurrency in ADO.NET and reviews how the ADO.NET model supports multi-user scenarios where data may be updated at the server while an ADO.NET client is using that data. |
|
| .NET Anatomy - Data Concurrency in ADO.NET, Part II |
| DotNetJunkies |
| 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. |
|
| .NET Anatomy - Data Concurrency in ADO.NET, Part II |
| DotNetJunkies |
| 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. |
|
| A DropDownList, EditItemTemplate, using Access, and HttpSessionState...Part 3 |
| DotNetJunkies |
| Here we are at part three of this article! In this part we will be adding one new feature to the code! Instead of making a call to the database to get the data on each request we are going to be saving the <b>DataSet</b> into session state. We will not only be populating the <b>DataGrid</b> and <b>DropDownList</b> controls from this <b>DataSet</b>, but we will also be saving all the edits done by the user. This means that after the <b>DataSet</b> is initially created and put into session state there will be |
|
| A DropDownList, EditItemTemplate, using Access, and HttpSessionState...Part 4 |
| DotNetJunkies |
| In this article I will demonstrate how you
can save the changes made to the memory resident <b>DataSet</B>. |
|
| A Grouping and Subtotaling Repeater for ASP.NET |
| DotNetJunkies |
| A recent project had a user interface requirement where data could be displayed two ways: either in chronological order or grouped by family member. I solved the "not so easy" grouping by family member requirement by modifying the Repeater control, as you'll see in this article. |
|
| A Truly Excel-like Grid Control |
| MSDN |
| The ASP.NET DataGrid control generates an HTML output that really seems to be the Web counterpart of a Microsoft Excel worksheet. In addition, the control supports features like selection and in-place editing that can only further confirm this similarity. With in-place editing, in particular, the similarities are most clear. You click on a special type of command column and the grid redraws its content using text boxes rather than static text. At the same time, the command column changes the layout, replacing the edit link with two other links—one for saving and one for canceling changes. The overall design looks nearly identical to the Excel name box command bar. |
|
| Abstracting ADO .NET |
| MSDN |
| 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.
|
|
| Adding Items to a DataView and DataTable |
| DotNetJunkies |
| In this article we'll be demonstrating how to add a new row to both a DataTable and a DataView. In the first part of this article we will briefly discuss the differences between a DataView and DataTable, then we'll give a code example and analysis of how to add a new item to each. The code will demonstrate how effecting one, has a direct effect on the other. |
|
| Adding Items to a DataView and DataTable |
| DotNetJunkies |
| In this article we'll be demonstrating how to add a new row to both a DataTable and a DataView. In the first part of this article we will briefly discuss the differences between a DataView and DataTable, then we'll give a code example and analysis of how to add a new item to each. The code will demonstrate how effecting one, has a direct effect on the other. |
|
| ADO .NET for the ADO Programmer |
| MSDN |
| ADO .NET is the latest in a long line of database access technologies that began with the Open Database Connectivity (ODBC) application programming interface (API) several years ago. Along the way, a number of interesting things happened. For example, COM landed at the database territory and started a colonization process that culminated with OLE DB. Next, ActiveX® Data Objects (ADO)—roughly an automation version of OLE DB—has been elected to govern the Visual Basic® and ASP community of Windows®-based database developers. |
|
| Advanced DataGridding: Paging, Sorting, Showing Grid Statistics and Hiding Redundant Controls |
| DotNetJunkies |
| This article takes a look at how to solve some of the most common problems developers encounter when trying to work with the DataGrid. These include DataGrid paging, sorting by columns, showing statistics about result, hiding the pager button and hiding the DataGrid itself when there are no results to display. This article walks you through a solution. |
|
| Alternative way to support Language under C# Framework |
| The Code Project |
| A suggestion to an alternative way to support Language under C# Framework |
|
| Article 2 - Dynamic creation of database |
| The Code Project |
| Display data using Dataset and Data Grid control after the database is created |
|
| Ask the DotNetJunkies : Building a Master/Detail DataGrid |
| DotNetJunkies |
| Question: I have a question regarding DataGrid. Can I bind a column of a DataGrid to another DataGrid? I have a situation where I have to display a few details in the same DataGrid on click of a HyperLink column. Thanks in advance.Regards, Prathibha Sharangapani. The Answer: Prathibha, this can certainly be done. You are describing a master/detail DataGrid. |
|
| Ask the DotNetJunkies : Building a Master/Detail DataGrid Part II |
| DotNetJunkies |
| Building a Master/Detail DataGrid - Great Article! How would a template column be created and included in the DataGrid that appears in the Orders column. GfWeis - The Answer: Well, first off...thanks for the compliment. Now, let's cut to the chase. What you are asking, adding a TemplateColumn to an embedded DataGrid, can certainly be done. We are going to take a slightly different approach for this however. In this tutorial I will show you how to embed a DataGrid in a DataGrid, with a TemplateColumn in the |
|
| Ask the DotNetJunkies: Dynamically Populating An ASP.NET ListBox |
| DotNetJunkies |
| When dynamically populating a list box using listbox.items.add, asp.net generates the same string for the HTML tag OPTION's value and text. In the past, I would put a table key in the value while filling the HTML text with various information. What are methods for splitting the listbox attributes? The .net framework examples do not address this type of dynamic filling of the listbox. Thanks, Ken (your interview on MSDN was great) |
|
| Ask the DotNetJunkies: How do I add a DropDownList to a DataGrid EditItemTemplate? |
| DotNetJunkies |
| I'm working with a DataGrid. When editing a row, I would like to have one
of my fields be a DropDownList. I would much rather be able to bind that DropDownList
to a table in a DataSet so when new key/values are setup in the database they
flow through to my aspx page without having to fuss with it. Please, example
in VB. |
|
| ASP.NET & Databases : Part 7 |
| ASP Alliance |
| Welcome the the seventh part in the series of ASP.NET & Databases. Sadly, this will be the last part in the series as I have decided that I will cover separate topics in other articles (you will see them later). In this part we will go into sorting data in a DataGrid. DataGrid's don't have complete support for sorting built into them, but there are a few features that help you to develop a way to sort your data. |
|
| ASP.NET Data Shaping |
| MSDN |
| 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. |
|
| Binding ASP.NET Controls to Data |
| Windows 2000 Magazine |
| In Microsoft .NET, Web pages consist mostly of server-side controls that make possible a modern, object-oriented programming style. But can you program the controls to make them sensitive to data sources? And, more important, can you do so automatically, with limited programming effort? Of course programmers would heartily welcome a programming-free method for associating rows of data with controls such as drop-down lists and grids. Data-bound controls are .NET’s solution to the growing demand for automatic binding between data sources and controls. |
|
| BookStock v2- Samples to Show Simple OleDb.NET Connectivity |
| Master C# |
| The bookstock example I had previously created for .NET SDK beta1 consisted of 3 samples to show how to perform basic ADO.NET connectivity with a Ms Access 2000 Database and how to Add, View , Edit , Delete records from it. It also demonstrates how to DataBind Textboxes to a DataSet object. |
|
| BUG: DataSet Does Not Load Original Records of DiffGram Correctly (Q319919) |
| Microsoft Support |
| Under the following circumstances |
|
