Accessing and Updating Data in ASP.NET 2.0: Accessing Database Data
This article shows how to use the SqlDataSource and AccessDataSource controls to query data from a relational database.
2007-08-27
3,636 reads
Additional Articles
SQL Server 2005 Express Edition - Part 4 - Surface Area Configration
This article demonstrates how you can use Surface Area Configuration utility in order to modify some of the security-related settings that have been applied during installation of SQL Server 2005 Express Edition.
2007-08-27
1,878 reads
SQL Agent - A Job Scheduler Framework
An easy to use .NET solution for Job Scheduling, with pluggable actions, that runs on a Windows Service. Backup your SQL Server Express and much more!
2007-08-24
2,266 reads
SqlCredit Part 6: Exploring EncryptByCert and DecryptByCert
SQL Server 2005 includes support for encrypting and decrypting data for storage using EncryptByCert. Let’s look at how to implement this in the SqlCredit database.
2007-08-24
2,450 reads
13 disasters for production web sites and their solutions
Learn about 13 production disasters that can bring down your business
2007-08-23
4,454 reads
Building Wiki Web Sites with ASP.NET and SQL Server
You can easily build Wiki Web sites with ASP.NET and SQL Server and provide your teams with one of the most powerful ways of collaborating on the Web.
2007-08-23
4,125 reads
Developer Spotlight: Greg Low
Builder AU interviewed Greg via e-mail before the start of Tech.Ed 06 to talk about beta software, free databases, and the future of database development.
2007-08-22
2,376 reads
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 5
Part 5 of "Microsoft Windows PowerShell and SQL Server 2005 SMO" illustrates how to use PowerShell and PowerShell script to create databases.
2007-08-22
2,466 reads
How to Insert Values into an Identity Column in SQL Server
Identity columns are commonly used as primary keys in database tables. These columns automatically assign a value for each new row inserted. But what if you want to insert your own value into the column? It's actually very easy to do.
2007-08-21
5,200 reads
How to link different data sources together
Describes how you can link SQL Server with many different data sources like a directory as Active Directory Application Mode, a Microsoft Indexing Server catalog, a Microsoft Access database and a Microsoft Excel spreadsheet. Also explains how to query linked servers using the OPENQUERY command.
2007-08-21
2,712 reads
Blogs
Catching Up On SQLOrlando
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers