.NET Articles
New Security Features in Visual Studio 2005 29 Sep 2005 22:44 GMTVisual Studio 2005 makes it easier for developers to write secure applications. Microsoft Security Content Strategist Brian Johnson shows off some of the new security tools built right in to the IDE. Source: MSDN Displaying RSS Feeds - A Look at RssFeed Version 1.9 28 Sep 2005 00:00 GMT
Over the past several years one of the growing trends in the Internet space has been syndication, the process of
providing a site's content through a machine-readable file (i.e., an XML-formatted file). Once a site's content is marked up in a machine-readable
format, there are a multitude of ways that that data can begin to be utilized. The most common way is through aggregators,
which are programs designed to periodically cull through a list of syndication feeds and download any new content. (There are
a variety of aggregator programs, from desktop based ones like RssBandit to online
ones like BlogLines and My Yahoo!.) More interestingly,
the site content, now able to be parsed by a program, can more easily be searched,
customized, categorized, and analyzed.
And, as we'll see in this article, content from another site can easily be injected into your own site by having your ASP.NET
pages retrieve the remote syndicated content, parse it, and display it.
Site syndication has been an idea that has been around for over
a decade, but didn't enjoy wide-spread adoption until bloggers started using it to make it easier for their friends and
readership to easily receive new content. Since then, many large websites have jumped on the syndication bandwagon, including
ABC News, ESPN, Yahoo! News, Microsoft MSDN, and so on. There are a couple of syndication standards used, the most popular
(at this time) being RSS version 2.0, where RSS stands for Really Simple
Syndication. There are other syndication formats, however, which are discussed briefly further on in this article.
In a previous article on mine, A Custom ASP.NET Server Control for
Displaying RSS Feeds, I looked at using a free, open-source ASP.NET server control that I created in order to display syndicated
content from another site on an ASP.NET website. This server control, called RssFeed,
has recently been updated to include some new, neat, snazzy features. In this article we'll take a quick look at RssFeed
and then highlight some of its new features. Read on to learn more!
Read More > Source: 4GuysFromRolla Web Solutions Platform 27 Sep 2005 00:44 GMTThis paper proposes a Web solutions platform that will integrate tasks and enable Web solutions through customer information, content management, and business intelligence (Web analytics) for improved customer relations management (CRM). Source: MSDN ClickOnce Deployment: Customizing SQL Server Express 26 Sep 2005 00:00 GMTClickOnce Deployment, new to Visual Studio 2005, allows you to deploy your Windows Forms application to a web server from which a user can download and install the application. If SQL Server Express is included in the install, its authentication will default to the sa user with an unknown password. Terry Voss shows how to customize the installation of SQL Server Express. Source: AspAlliance Returning a Comma-Delimited List of Related Records 21 Sep 2005 00:00 GMT
In any non-trivial database design, there are related entities within the system. Some entities may share a one-to-many
relationship, others a many-to-many relationship. For example, a student database may have a Faculty table
that lists its teachers, along with a Students table that contains a row for each student. The Students
table may have an AdvisorID, which serves as a foreign-key back to the Faculty table, indicating the
student's academic advisor. In such a case there's a one-to-many relationship between faculty and students - a faculty member
may have an arbitrary number of students that she's advising. Additionally, there may be many-to-many relationships, such
as a Classes table that enumerates the classes offerred, along with an Enrollments table that maps
students to classes. The Enrollments table provides a many-to-many relationship between students and classes,
since each student may be enrolled in multiple classes and each class may have multiple students enrolled.
In either type of relationship, there are times when we may need to provide a comma-delimited list of related records.
For example, the dean may want to see a report that lists each faculty member followed by a comma-delimited list of students
she is advising; a professor may want a print out of the list of classes he's teaching, followed by a comma-delimited list of
students taking the course that semester; an accountant for the school might want to see a list of students, showing a comma-delimited
list of each class that student is currently taking. For example, the dean's report may have the following output:
| Faculty | Students Advising |
|---|
| Scott | John, Paul, George, Ringo | | Jisun | Tito, LaToya, Michael, Janet | | Sam | Carl, Johann, Christoph | | Dave | Not advising any students |
To provide such functionality there's basically two approaches that can be taken:
- Retrieve the data using the typical
JOIN notation, returning a row for each pair of matching results.
Then, in the 'client' (i.e., your server-side web application), combine the returned data into a comma-delimited list, or - Formulate the comma-delimited list in SQL
In this article we'll briefly examine the first approach and then delve more deeply into the second. Read on to learn more!
Read More > Source: 4GuysFromRolla Enhancing the DataGrid with Grouped Rows and Subheadings 21 Sep 2005 00:00 GMTThe ASP.NET DataGrid control provides no methods by which to group related items. Michelle Beall presents three simple techniques to enhance a DataGrid by grouping related rows and adding subheadings. Source: AspAlliance TableAdapters in Visual Studio 2005 20 Sep 2005 23:36 GMTVisual Studio 2005 expands typed data access with TableAdapter, a new object that greatly simplifies interacting with data objects on the client machine and sending updates to a database. Source: MSDN
|
|
|