Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Knowledge Base > ASP.Net > Database
Search:
What's New - What's Hot
Listings for ADO.Net ADO.Net (7)
Listings for SQL Server SQL Server (4)
Listings for Stored Procedures Stored Procedures (3)
 


Caching in ASP.NET with the SqlCacheDependency Class  Version: 0.00     Price: $0.00  
Total Hits: 82  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

ASP.NET allows you to use the SqlCacheDependency class to create a cache item dependency on a table or row in a database. When a change occurs in the table or in a specific row, the item that has a dependency is invalidated and removed from the cache. You can set a dependency on a table in Microsoft SQL Server 7.0, SQL Server 2000, and SQL Server 2005. If you are using SQL Server 2005 you can also set a dependency on a specific record....

How to: Set and Get Parameters for Command Objects  Version: 0.00     Price: $0.00  
Total Hits: 48  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you are using command objects to execute commands against a database, the SQL statements or stored procedures you are executing often require parameters. For example, a simple Update statement that requires parameters might look like the following:...

How to connect to Profile Database of Commerce Server 2009  Version: 0.00     Price: $0.00  
Total Hits: 97  |  Today: 0Author: Prasham Sabadra      Rating:  
Read Reviews | Write Review |  Your Rating: 

For one of my application, I required to get list of all the stores stored in StoreObject table in Profiles database. Here in this blog I will explain detail steps to connect the profile database...

How to use the Olson time zone database in .NET     
Total Hits: 232  |  Today: 0Author: schizoidboy.      Rating:  
Read Reviews | Write Review |  Your Rating: 

Dates, time zones, and overall internationalization are not a programmer's friend, historically. From Julius Caesar in 45 B.C.E. (Julian calendar) through Pope Gregory the XIII in 1582 C.E. (Gregorian calendar), UTC and world-wide calendars, dates and times have shifted to ever-changing politics and new scientific understandings. Although the invention of computing and information exchange is relatively new, many concepts of date and time zone information are not ingrained in the architectures a...

HOW TO find the biggest tables in a database     
Total Hits: 204  |  Today: 0Author: 'Anil' Radhakrishna      Rating:  
Read Reviews | Write Review |  Your Rating: 

Create Table #temp (
table_name sysname ,
row_count int,
reserved_size varchar(50),
data_size varchar(50),
index_size varchar(50),
unused_size varchar(50))
SET NOCOUNT ON
insert #temp exec sp_msforeachtable 'sp_spaceused ''?'''...

HOW TO detect status of a service & manipulate it programmatically     
Total Hits: 239  |  Today: 0Author: Anil' Radhakrishna      Rating:  
Read Reviews | Write Review |  Your Rating: 

This KB article which explains how to detect status of SQL Server Express service & start it programmatically, can also be used to detect any other service by replacing the appropriate service name.
TheSystem.ServiceProcess.ServiceController class is used to detect the status of a service and start it if required.
Labels: HOW TO, SQL Server...

How To: Use SSL to Secure Communication with SQL Server 2000     
Total Hits: 285  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

It is often vital for applications to be able to secure the data passed to and from a SQL Server database server. With SQL Server 2000, you can use SSL to create an encrypted channel. This How To shows you how to install a certificate on the database server, configure SQL Server for SSL and to verify that the channel is secure. You can use the Secure Sockets Layer (SSL) protocol to secure the communication link between clients (direct callers) and Microsoft® SQL Server™ 2000. When you configure ...

How To: Use Forms Authentication with Active Directory     
Total Hits: 305  |  Today: 0Author: J.D. Meier, Alex Mackman, Michael Dunner, and Srin      Rating:  
Read Reviews | Write Review |  Your Rating: 

ASP.NET Forms authentication allows users to identify themselves by entering credentials (a user name and password) into a Web Form. Upon receipt of these credentials, the Web application can authenticate the user by checking the user name and password combination against a data source. This How To describes how to authenticate users against the Microsoft® Active Directory® directory service by using the Lightweight Directory Access Protocol (LDAP). It also describes how to retrieve a list of se...

How To: Use Forms Authentication with SQL Server 2000     
Total Hits: 264  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This How To shows you how to implement Forms authentication against a SQL Server credential store. It also shows you how to store password digests in the database. This How To shows you how to implement Forms authentication against a SQL Server credential store. It also shows you how to store password digests in the database....

How To: Protect From SQL Injection in ASP.NET     
Total Hits: 137  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

This How To shows a number of ways to help protect your ASP.NET application from SQL injection. Techniques include constraining input and using type-safe SQL parameters for data access and using a least-privileged account that has restricted permissions in the database. SQL injection can occur when an application uses input to construct dynamic SQL statements or when it uses stored procedures to connect to the database. Conventional security measures, such as the use of SSL and IPSec, do not pro...

A Quick Comparison of ADO and ADO.NET     
Total Hits: 687  |  Today: 0Author: aspalliance      Rating:  
Read Reviews | Write Review |  Your Rating: 

A review of the fundamental differences between ADO and ADO.NET, using ASP, ASP.NET and C# to both instantiate ADO and ADO.NET classes to show some how the calling conventions to each of these classes differ....

HOW TO: Use a DataSet with the Office XP Chart Component and ASP.NET (Q303016)     
Total Hits: 879  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to create a chart using the Office XP Chart Component with data from a DataSet. The solutions that this article presents use Visual Basic .NET and ASP.NET....

HOW TO: Configure ASP.NET for Persistent SQL Server Session State Management (Q311209)     
Total Hits: 585  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article includes script files that configure Microsoft SQL Server to support ASP.NET SQL Server mode session state management so that session data is persisted outside the tempdb database. This article includes information to download these alternative script files, which are named InstallPersistSqlState.sql and UninstallPersistSqlState.sql....

HOW TO: Create a Master/Detail Page with Web Form Controls (Q308485)     
Total Hits: 1076  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to use Web Form controls to display a list of items or records that are associated with a particular item or record that is selected by a user....

HOW TO: Retrieve and Display Records from an Access Database Using ASP.NET, ADO.NET, and Visual C# .NET (Q308100)      
Total Hits: 1943  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to programmatically retrieve data from a Microsoft Access database, and then present the data to the user. The goal of this article is not to provide every conceivable approach to the issue. It is intended to offer a simplified solution that uses ASP.NET, ADO.NET, and Visual C# .NET as an introduction to the related technologies....

HOW TO: Store Data in Application Scope Using ASP.NET and Visual Basic .NET (Q309018)     
Total Hits: 340  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article demonstrates how to store application-wide data through the Application, Cache, and AppSettings objects. Application-wide data is data that is available to the entire Web application....

HOW TO: Call SQL Server Stored Procedures in ASP.NET     
Total Hits: 6313  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to use ASP.NET and ADO.NET to create and call a Microsoft SQL Server stored procedure with an input parameter and an output parameter. The code sample in this article first checks whether the stored procedure that you will create exists in the database. If the stored procedure does not exist, the code creates a stored procedure that takes one parameter to search the Authors table based on the last name and returns the matching rows and number of rows that are return...



Disclaimer - Privacy
© 2002-2017 DevASP.net