2005 Resources

Share

Related resources for 2005

Intersect and Except in SQL Server 20056/6/2024 11:46:34 AM. Learn how to leverage Intersect and Except operators in SQL Server 2005 for efficient data manipulation. Discover their role in set operations, querying, and database management. Master T-SQL syntax f
Common Table Expression(CTE) in SQL Server5/30/2024 12:12:43 PM. Learn about CTE, a SQL Server 2005 feature replacing temp tables. Understand its efficiency over temp storage methods, essential syntax, and diverse applications in query optimization. Examples illust
How to Enable Remote Connections in SQL Server 20053/5/2024 10:39:30 AM. This article provides guidance on enabling remote connections in SQL Server 2005, addressing the common error message encountered when attempting a remote connection. It outlines the security precauti
Writing Managed Stored Procedures using C#9/18/2023 10:43:36 AM. This article is trying to explain the simple and required steps that are require starting the creation of Manage Stored Procedure using C# and using them.
Thread Synchronization using VS.NET 20059/12/2023 6:12:52 AM. When two or more threads need access to a shared resource, they need some way to ensure that the resource will be used by only one thread at a time. The process by which this is achieved is called syn
Creating a Basic RogueLike Game in C# (Version 0.1)9/11/2023 11:57:03 AM. Want to build a Roguelike game with C# in 5 minutes? The following is a really quick game I built in about 2 hours and shows how easy it is to get a simple game going.
Easily Find Tags and Values in a Large Xml Document Using XmlTextReader in C#9/1/2023 4:09:34 AM. Parsing large XML documents efficiently can be a challenge due to memory constraints. This approach utilizes the XmlTextReader class in C# to extract specific tags and their corresponding values from
Fetching the Records Through Cursor in Sql Server 20052/13/2023 10:00:26 AM. In this article I explain how to create and use a cursor in SQL, and also how to fetch the records from the table using the cursor.
Combining More Than One Rows Into a Single Row in SQL Server 20052/3/2023 8:22:33 AM. In this article, I will explain how to merge multiple rows into a single row using SQL 2005.
How to Store Date and Time in Separate Columns in SQL Server 20051/24/2023 8:58:40 AM. In this article I will explain how to store Date and Time in SQL Server 2005 using a User Defined Type.
How to Use the EXCEPT and INTERSECT Operators in SQL Server1/17/2023 11:06:55 AM. This sample shows how to use EXCEPT and INTERSECT operators in SQL Server 2005.
CLR Function in SQL Server 1/14/2023 12:35:44 PM. In SQL Server 2005 and later version of it, database objects like function, store Procedure, etc can be created which are already created in CLR.
Table Valued CLR Function in SQL Server1/14/2023 11:52:35 AM. In SQL Server 2005 and later versions of it, database objects such as functions, Stored Procedures, etc. can be created which are already created in CLR.
Cascading Deletes in LINQ to SQL1/10/2023 6:16:15 AM. This article will discuss alternative methods for performing cascading deletes using LINQ to SQL. Cascading delete refers to the action of removing records associated by a foreign key relationship to
Asynchronous Triggers Using SQL Broker1/3/2023 9:51:21 AM. In this article we learn how to use Service Broker and triggers to capture data changes.
Using Temp Table in SQL Server And Adding Columns Dynamically12/29/2022 8:34:12 AM. In this article we'll see how to use the Temporary tables, what are the necessary step to be taken while using them and moreover sometimes it's required to add column in Temporary tables dynam
Joins in SQL Server12/26/2022 1:43:24 PM. This article discusses how to use Joins in SQL Server 2005.
Application Development using ClickOnce in Visual Studio 20058/29/2022 6:51:10 AM. This article is an introduction for deploying application using ClickOnce in Visual Studio 2005.
Create Your Own Custom File Type3/2/2022 9:01:26 AM. This article describes a simple approach to creating a custom file type.
Resource Files in ASP.NET1/31/2022 11:15:49 AM. This article explains you the use of resource files in ASP.NET 2.0.
Generic 'T, K' Database Component11/26/2020 12:08:25 AM. I have written a C# 2.0 (Visual Studio 2005), Generic <T, K> Database component, The component has simplified the architecture and the implementation by allowing me to keep the number of overlo
Multiple Active Result Sets (MARS)10/29/2020 6:54:50 AM. This article gives you information about the Mars a feature supported by MSSqlServer 2005 and .Net 2.0/3.x, which is a feature to execute more than one query with one single connection to database.
Simplified Courier Tracking System7/16/2020 5:59:22 AM. The system is used for daily activities, such as booking, nondelivery, out return, company details, hub rates, and pickup centers. It is very difficult to do this process manually. Hence it is recomme
SQL Server Database Mirroring: Part 37/18/2019 12:08:48 AM. Here you will see SQL Server Database Mirroring. Database Mirroring is used to move the database transactions from one SQL Server database (Principal database) to another SQL Server database (Mirror d
SQL Server Database Mirroring: Part 17/18/2019 12:02:35 AM. In SQL Server Log Shipping and Mirroring can work together to provide solutions for high availability and disaster recovery. Database Mirroring is used to move the database transactions from one SQL S
Take Backup of a DataBase By Coding7/15/2019 3:30:47 AM. In this article, I am going to show how we can show all Data Server in a network and on selecting a Data Server, how to show all DataBase of that selected Data Server and how to take backup of selecte
Differences Among SSIS 2005, 2008 and 20127/15/2019 2:07:05 AM. This article explains the basic differences among SSIS 2005, SSIS 2008 and SSIS 2012.
Openxml - XML Integration with SQL Server7/5/2019 6:14:02 AM. In this article we will know about Openxml and how to perform operation using it.
Views in SQL Server7/3/2019 11:53:22 PM. Views in SQL Server. This article explains about views in SQL server with sample SQL queries.
A Brief Introduction to Expressions in SQL Server Reporting Services6/18/2019 4:34:44 AM. This article shows how you can use expressions in SSRS reports to generate dynamic content based on the data within your report queries.
Query Optimization in SQL Server6/7/2019 5:05:09 AM. This article offers suggestions on how to optimize query performance in SQL Server 2005.
Creating Drilldown Hierarchical Report using SSRS6/6/2019 3:49:20 AM. In this article, you will see how to create drill down hierarchical report using SQL Server reporting services 2005.
Functions in SQL Server6/5/2019 5:51:05 AM. SQL Server Functions. In this article, I am going to explain about some SQL Server 2005 functions with examples. Here are going to discuss about some string functions, numeric functions and date/time
Creating and Managing Triggers in SQL Server6/3/2019 6:00:10 AM. In this article you will see how to Create and manage Triggers in SQL Server 2005/2008.
Building Reports from a DataSet using ReportViewer5/13/2019 4:33:54 AM. In this step-by-step tutorial, you will learn how to create reports from a Database using a DataSet, the ReportViewer control and Visual Studio 2005. Create reports using ReportViewer control.
Send Text Message to Cell Phones from a C# Application5/7/2019 5:45:03 AM. This article describes a simple way to send text messages to a cellular phone from within a C# desktop application. The source code provided includes a relatively good list of carriers to simplify th
Using the BackgroundWorker Component in .NET 2 Applications9/17/2018 1:40:13 AM. In this article I will show (step-by-step) how you can use the BackgroundWorker Component in .NET 2 applications to execute time-consuming operations.
Data mining and SQL Server 200510/3/2017 6:24:09 AM. Data mining is a key member in the Business Intelligence (BI) product family in SQL Server 2005 . Data mining is about analyzing data and finding hidden patterns using automatic or semiautomatic means
Installation of SQL Server 20056/26/2017 1:38:08 AM. Using Windows 7 Ultimate, after installation of SQL Server 2005, an error occurrs regarding Connection. (Settings for Database Engine) Login failed for user Admin\vilas. (Microsoft SQL Server, Error :
Enabling SQLCLR in SQL20054/21/2016 7:30:27 AM. This video shows enabling SQLCLR through, Surface area configuration tool.
Using the In-Line Table-Valued Function12/1/2015 10:54:49 AM. This video shows how one can use the In-Line function that returns a table.
Using the Multi-Line Table-Valued Function12/1/2015 10:54:08 AM. The video shows using the Multi-line function created in the Previous video
Creating Simple Table-Valued Function11/30/2015 5:25:37 AM. This video shows creating a simple table-valued function in SQL Server 2005
Query Management Studio in .NET4/12/2015 4:52:09 PM. In this article we will see how QMS allows you to connect your server online and manage the table like Select, Insert, Update and Delete statements.
Differences Among SQL Server 2000, 2005 and 20089/26/2014 9:19:38 AM. This article explains the main differences among SQL Server 2000, 2005 and 2008.
Add and handle connection strings in an application configuration file: Part I9/4/2014 1:09:11 AM. There are two ways to save data and parameters. In this case we save application parameters like information entered by the user during the installation process.
The Architecture of Visual SourceSafe 200510/24/2013 1:34:36 PM. In this article, I want to take a look at the architecture of Visual SourceSafe 2005; an important package which can be used in software development projects as a source control system.
Converting Numeric Dollar Values to Text in VB.NET12/1/2012 4:50:42 AM. The article describes an easy approach to converting a numeric dollar value into its text equivalent; the primary purpose for such a mechanism would be to express the amount displayed on a check as a string within the ‘Amount’ section typical to most checks.
Text to Speech in Visual Basic 2005 with VB.NET12/1/2012 4:11:07 AM. This article describes an application used to exercise some of the Text To Speech features available to .NET developers through the Microsoft Speech 5.1 SDK.
Forecast the Weather with a Custom Control in VB.NET12/1/2012 3:10:19 AM. This article describes the construction of a custom control used to display a three day weather forecast based upon a designated zip code. The control is driven by a public, free web service that returns the seven forecast for any area in the United States by zip code or location. This demonstration only uses the first three days of the seven day forecast and it implements only the zip code based request for forecast data.
Use of the HtmlTextWriter Class to Render Custom Controls in VB.NET12/1/2012 2:55:22 AM. This article will address the use of the HtmlTextWriter class and the role is plays in the construction of custom server controls. As custom server control development is accomplished without a visual designer, the HtmlTextWriter class provides a mechanism for precisely defining the output of the custom control directly within the code and in absence of the designer.
Embed PDFs into a Web Page with a VB Built Custom Control in VB.NET12/1/2012 2:51:27 AM. This article describes a simple approach to embedding and displaying PDF documents in a web page through the use of a simple ASP.NET 2.0 VB built custom server control.
NetMassDownloader in VB.NET12/1/2012 2:18:05 AM. With this tool you can download whole .Net Framework Source Code at once, and enjoy offline browsing With it , you can have whole the source code without any Visual Studio Product Installed.
How to run Dynamic Crystal Report using Crystal Report Viewer in VS.NET 200511/23/2012 8:58:43 PM. This article will explain about Dynamic Crystal Report using Crystal Report Viewer.
How to build Multi-Language Web Sites with ASP.NET 2.0 and VB.NET 200511/10/2012 3:09:09 AM. In this article, we will explore the necessary details for working with resources in ASP.NET applications.
Cascading Deletes in LINQ to SQL with Visual Basic11/9/2012 10:22:52 AM. This article will discuss alternative methods for performing cascading deletes using LINQ to SQL. Cascading delete refers to the action of removing records associated by a foreign key relationship to a record that is the target of a deletion action.
Prevent CD Autoplays in VB.NET11/9/2012 10:11:22 AM. This article describes the approach used programmatically to prevent a CD from going into auto play mode.
Power pack drawing primitives for VB.NET11/9/2012 9:25:46 AM. This kit contains a collection of drawing primitive controls in the form of an oval, rectangle and a line shape.
Transparent Borderless Forms in Visual Basic 200511/9/2012 8:03:13 AM. This article describes an approach to display transparent forms in a Windows application.
Fade a Form in Visual Basic 200511/9/2012 7:47:51 AM. This article describes a simple approach to fading out a form.
Upload any type of file through a Visual Basic 2005 Web Service11/9/2012 7:36:08 AM. This article shall describe an approach that may be used to upload any sort of a file through a web service from a Windows Forms application. The approach demonstrated does not rely on the ASP.NET file uploader control and allows the developer the opportunity to upload files programmatically and without user intervention.
Add a daily Dilbert Comic with a Custom Control in VB.NET11/9/2012 6:36:18 AM. This article describes the construction of a custom control used to display a daily Dilbert comic on a site.
Simple Web and RGB Color Picker Utility in VB.NET11/8/2012 9:38:58 AM. The article addresses the construction of a simple utility application useful for selecting an RGB or web color; the application allows the user to key in RGB values or use RGB slider controls to select a color. Whenever the current color is updated, the text boxes at the bottom of the form are dynamically updated to show the current web and RGB color values set for the current color.
Create User Defined Controls in C#10/13/2012 5:35:26 AM. In this article you will learn how to create User Defined Controls in C#.
Reincarnation of DataTable in ADO.NET 2.010/13/2012 5:00:33 AM. The DataTable in ADO.NET 2.0 is a much improved and powerful than previous versions of ADO.NET. In this article, I will talk about new improvements and features added to the DataTable and how to use them in your applications.
Building the ListBoxesFT_C ASP.NET Web User Control in Visual Studio 2005: Part V10/13/2012 3:44:31 AM. In multi-part article, I share how you can build your own ASP.NET web user control.
Enabling Membership Provider for SQL Server 200510/13/2012 2:53:02 AM. ASP.NET 2.0 brings an important concept called provider model which is used for many new feature i.e. Membership Management, Role Management, Profiles, Web Parts Personalization etc.
How to Build Multi-Language Web Sites with ASP.NET 2.0 and VS.Net 200510/4/2012 10:27:26 AM. In this article, we will explore the necessary details for working with resources in ASP.NET applications and for creating international ASP.NET applications based on embedded resources and the integrated localization support.
Utilize the Full Functionality of the Whidbey File Management10/4/2012 9:39:34 AM. This article is based on a pre-release version of Microsoft Visual Studio 2005, formerly code named "Whidbey". All information contained herein is subject to change.
Working with the ObjectDataSource and DateTime Type10/4/2012 9:29:23 AM. This tip will help you to work with the ObjectDataSource, when at least one of the properties of your business object (BO) is type of the DateTime .
Using OUTPUT Clause for Getting Deleting Information from Several Tables.10/4/2012 9:19:49 AM. In this article I will explain how you can use such a T-SQL (SQL Server 2005) feature as OUTPUT clause in order to get information about rows, which were affected, when deleting process is executed for several tables, “connected” by foreign keys. The examples are written using T-SQL and C#.
Applied MS Reporting Services 2005 101 using Smart Client10/4/2012 7:35:23 AM. An applied approach to get you started with MS Reporting Services using Smart Client host.
Building the ListBoxesFT_C ASP.NET Web User Control in Visual Studio 2005: Part I10/3/2012 12:04:06 PM. In multi-part article, I share how you can build your own ASP.NET web user control.
Using Client Callbacks for Building the ListBoxesFTs_C ASP.NET Web User Control: Part II10/3/2012 11:54:45 AM. In this article I share how you can build your own ASP.NET web user control with the help of the Client Callbacks. The examples are written using C# and JavaScript.
.NET SQL Authorization Manager10/3/2012 10:57:50 AM. .NET Sql Authorization Manager (AzMan x .NET 2.0) allows you to set Item-based permissions for Authorization Manager-enabled Microsoft.NET 2.0 applications. Storage reside on a MS Sql Server DataBase and can be administrated by a managed MMC 3.0 Snap-In.
Triggers and Active Databases10/3/2012 9:27:59 AM. This article is intended to illustrate how to use triggers in databases systems to enforce business rules and react to events in database applications thus supporting the Active databases principles.
Searching in User Profile Properties10/3/2012 9:14:10 AM. Enabling search in membership profile properties using SQLSERVER2005 pluggable assembly created by C#.
In-depth Look at WMI and Instrumentation: Part I9/30/2012 4:16:45 AM. WMI provides a consistent programmatic access to management information in the enterprise. It uses the typical provider and consumer concept where you have on one side components providing this management information while on the other side management applications can subscribe and consume it.
Error Opening SSIS Package9/30/2012 3:53:58 AM. I got a weird error when trying to open an SSIS package in VS2005.
Sql Server 2005 features - Part II9/30/2012 2:35:12 AM. In this article i have explained about the features introduced in the sql server 2005 edition.
Email Sending in ASP.net 2.09/30/2012 2:31:08 AM. This article will focus on following concept Simplest way of sending email Writing HTML Email Creating Email with attachment.
How to Start and Stop Database Engine in SQL 20059/29/2012 9:48:32 AM. This article will show how to start, stop and restart the database engine in SQL Server 2005.
Best Practices for Data Transfer in SQL Server 20059/29/2012 9:40:42 AM. This article talks about some best practices and the process of data transfer in SQL Server 2005.
Using DLL files in Visual Studio 2005 using C#9/29/2012 9:39:01 AM. This article explains the procedure of creating DLL files using visual studio 2005. It is very quick and easy to learn.
Save the application settings using VS2005 for subsequent application sessions9/29/2012 9:02:12 AM. It is practical to save some usefuls data that can be kept in a separate file when the application is out of the service.
Building control derived from Windows Forms control in Visual Studio 2005: Part II9/29/2012 8:51:12 AM. Reusability and component oriented development is one of the features of .NET development. This approach may be applied to any project. In this article I share how you can build your own Windows control derived from an Windows Forms control in Visual Studio 2005. The examples are written using C#.
Sample Windows Forms Application in ASP.NET2.0.9/29/2012 6:51:05 AM. This is a step-by-step user guide that explains how to create a simple Windows Forms Application that uses the Coherence for .NET library.
Using a Web User Control inside the GridView control9/27/2012 9:18:42 AM. In this article I will share how a Web User Control can be used in the GridView control. The examples are written using C# .
Use Update Statement in SQL Using Inner Join7/30/2012 12:44:35 PM. In this example, we will see how to use an update statement of SQL using Inner Joins.
Building Reports from XML Documents using ReportViewer6/12/2012 1:24:57 AM. In this step-by-step tutorial, you will learn how to create reports from an XML document using the ReportViewer control and Visual Studio 2005.
Output keyword in Sql Server 20085/31/2012 11:50:11 AM. In a simple word we can say OUTPUT clause used with INSERT, UPDATE, or DELETE to identify the actual rows affected by these statements and also used for the auditing purpose.
Using the System Function fn_listextendedproperty of SQL Server 2005 for .NET Applications: Part II5/20/2012 5:57:16 AM. In this article, divided into two parts, I will compare the system function fn_listextendedproperty of SQL Server 2005 with the similar function of SQL Server 2000 ( Part 1 ), describe using the function for .NET applications ( Part 2 ). The examples are written using Transact-SQL and C#.
Using the System Function fn_listextendedproperty of SQL Server 2005 for .NET Applications: Part II5/20/2012 5:26:25 AM. In this article, divided into two parts, I will compare the system function fn_listextendedproperty of SQL Server 2005 with the similar function of SQL Server 2000, describe using the function for .NET applications. The examples are written using Transact-SQL and C#.
Building Managed Code Using Common Language Runtime (CLR) Integration in SQL Server 20055/20/2012 5:22:24 AM. In this article I am going to talk about a cool new feature of SQL Server 2005 called "CLR Integration", its advantages and how to program database objects using managed code with a simple project in Visual Studio 2005 beta 2.
Migrating from ASP.NET 1.0/SQL Server 2000 to ASP.NET 2.0/SQL Server 20055/20/2012 4:52:53 AM. The article provides details of various steps followed by author in upgrading ASP.Net 1.1 application to ASP.Net 2.0 and SQL Server 2000 to SQL Server 2005
How to Connect Mysql Server with Asp.net 2005 / 2008 (C#)5/20/2012 4:20:09 AM. Here I will discus in the easiest way to connect your asp.net web application with MYSQL Server and also how you can migrate from Microsoft SQL to MYSQL.
Wildcards in SQL Server 20055/20/2012 4:18:31 AM. SQL wildcards are used for searching data’s in a database, which were used with LIKE operator.
Enable and Rename SA account in SQL Server 2005/20085/20/2012 4:08:52 AM. This Article shows How to Enable/Disable sa Account in SQL Server.
Bulk DML With SQL Server 2005 - XML Data Type5/20/2012 3:12:12 AM. This article explains about doing bulk DML on SQL Server 2005 using XML datatype
Import Data from SQL Server 2005 to Excel Sheet and Viceversa5/20/2012 3:04:39 AM. This Article Shows How to Use SQL Server to Export Data from SQL Server to Excel Sheets and Viceversa.

Topics