C# Corner

Resources  
  • Write data to an access database using SQL Query and ADO.NETDec 06, 2000. See how to use SQL Statements to write data to an access database.
  • Database Explorer : Part 2Jan 22, 2001. Attached is a C# program which is a enhanced version of the previous article on ADO.NET.
  • ADO.NET Database Explorer with Query Analyzer : Part 3Jan 24, 2001. This is the part three of the Article Database Explorer. This parts adds some more and valuable functionality.
  • Using Delegates to Choose Right FunctionApr 01, 2001. The need to call different class method based on some string passed to class is an old problem.
  • XML Strengths and Weaknesses with DOM, ASP, and XSLApr 30, 2001. In this article we're going to take a look at some of the terminology that comes with using XML and its related technologies, as well as how to create and transform XML documents with XSL using Microsoft's MSXML parser. To test the code samples shown in this article you should be running Windows NT/2000/XP with IIS installed. You should also have SQL server 2000 installed on the same machine.
  • Line numbering utility in C# and JavaMay 08, 2001. After reading this article Java programmers should be able to decipher and de-jargonize the .NET architecture and relate it with the proposed ECMA standard.
  • Will Java and .Net Framework Co-exist?May 15, 2001. The article begins by briefly probing what constitutes the Java platform and .NET framework.
  • Using Attributes in C#Sep 14, 2001. This article shows how to create custom attribute classes, use them in code, and query them.
  • Query BuilderOct 17, 2001. This application is that of a QueryBuilder in CSharp.This application is for Beta2 SDK version of DotNetFramework.
  • Abstract Factory Patterns in C#Dec 10, 2001. The ABSTRACT FACTORY PATTERN comes under the classification of Creational Patterns. The Abstract Factory provides an interface to create and return one of several families of related objects.
  • Creational Pattern - Abstract FactoryFeb 11, 2002. An abstract factory provides an interface for creating families of related objects without specifying their concrete classes. Sometimes one wants to construct an instance of one of a suite of classes, deciding between the classes at the time of instantiation.
  • Data Access through Web Services, Stored Procedures and SQL QueriesFeb 12, 2002. Web Services has been the most revolutionary aspect of the .NET framework developed by Microsoft. This article presents the three different modes through which data can be accessed viz. through Web services, stored procedures and SQL query using the power of ADO.NET and XML.
  • A Database Web ServiceFeb 22, 2002. This program is a Web service, which contains Web methods that return a dataset after querying a database (any database) given the connection string, the password, the database, the table, the user ID and the SQL commands.
  • SQL Server Database ExplorerMar 20, 2002. This application connects to a running SQL Server 2000 and displays all the available databases in it.
  • WhoIs in ASP.NETApr 15, 2002. Quite often you want to know who owns a particular domain. To obtain the registry information, you go to the respective registry and start a so called WHOIS query (lookup).
  • Interrogating Your Printer Queues with WMIMay 20, 2002. In response to a newsgroup query here is the code needed to view the printer queues on your system.
  • Windows Service Information ComponentSep 11, 2002. This article is on a reusable Windows service information component, which queries and retrieves the Windows service information.
  • Using SQL in .NET: Part 1Oct 04, 2002. In this article, I will show you how to execute SQL queries from your C# applications.
  • Understanding and Using the LinkLabel ControlOct 07, 2002. In this article, I will discuss some functionality related to the LinkLabel control and how to use it.
  • MDX Query BuliderNov 11, 2002. In this article we will be developing a MDX Query Builder.This is similar to the MDX sample application operations, which carry out the transfer of blocks from the secondary memory to the main memory and vice versa.
  • Abstract Factory - Creational Design PatternJan 03, 2003. Abstract Factory simplifies the creation of different families of related or dependent objects. It provides interfaces for this purpose and does not specify the concrete classes.
  • DTS Custom Task in C#Jan 28, 2003. During last year I wrote an article about DTS and how to use it in C#. In that article I stated that I didn’t manage to solve the problem related to CustomTask. Today I finally forced myself to tackle that problem again and here is the result. Writing simple CustomTask in C# is the easiest part.
  • SQL Demo Login in C#Feb 23, 2003. This sample code contains a reusable control that allows you to build a dialog box that queries for SQL-Server connection parameters.
  • Possible Usage of Visitor and Type CastsFeb 25, 2003. In this article I will try to introduce Visitor pattern and one possible variation on it. It treats problems related to projects projects where high level of adaptability is needed.
  • Querying COM+ through Web ServicesMar 12, 2003. The most COM+ common administrative tasks (creating a COM+ application, installing/deleting a component, setting a component attribute) can be accomplished manually with the Component Services administrative tool from Management Console.
  • HTTP Handlers for Images in ASP.NETJun 23, 2003. Have you ever thought of streaming thumbnails just by passing query string indicating width or height of thumbnail you need, and most importantly passing those to image itself?
  • Real Life SQL and .NET: Part IIJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET: Part VJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET: Part IJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET :Using SQL with C#: Part VIIIJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET : using SQL with C#: Part XIJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET: Part IVJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • State Management in Web FormsFeb 18, 2004. This white paper discusses the ways in which the state management can be handled in web forms. State management can be done either on client side or server side as explained below.
  • Downloading Data as a File from a MemoryStreamMar 29, 2004. This article will show you how to buffer data into a MemoryStream from a query and output the buffered data back to the browser as a text file.
  • The Graphics Class and TransformationsApr 01, 2004. The Graphics class defined the transformation related functionality. This article discussed the Graphics class and its members that participate in transformation process.
  • Tablet PC - Frequently Asked QuestionsApr 01, 2004. This article answers some of the frequently asked questions related to Tablet PC and Tablet PC application development.
  • An in-depth look at WMI and Instrumentation: Part IISep 18, 2004. In this second part of the series, you will learn how to work with WMI classes and class instances, and then demonstrates the wealth of information available through the Win32 and IIS WMI providers.
  • Leveraging on XML feature of Microsoft Office Word 2003Nov 24, 2004. Word 2003 came up with a new feature of saving the conventional word document (.doc) files in the XML format. You can retrieve the information inside the Word 2003 documents by using the XPath queries and some logic.
  • Talk to SharePoint through its web servicesDec 09, 2004. Microsoft Office 2003 is very tightly integrated with SharePoint by utilizing its web services. Windows SharePoint Services comes with sixteen different web services. SharePoint Portal Server 2003 supports an additional five web services. The web services provided by SharePoint do provide a vast array of features.
  • Query Tool to Excel using C# and .NETFeb 03, 2005. This article show how to use .NET's interoperability feature to pull the data directly into the spreadsheet.
  • DNS QueryAug 18, 2005. This example shows similarity of c# and java and how to implement dns query.
  • New IDE Features in Visual Studio 2005Nov 10, 2005. Visual Studio 2005 aims to simplify the development process thereby adding many new features to simplify the overall development experience. This article aims to discuss all major IDE related changes in Visual Studio 2005.
  • Service-Oriented Architecture and Microsoft .NETJan 21, 2006. This article is intended to provide an overview how Microsoft .NET and related technologies support the goals and principles of Service-Oriented Architecture. The main approach of Microsoft .NET is explained along with the concepts of Service-Oriented Architecture and it fits into this strategy.
  • C# using the Proxy Pattern to Define RelationshipsJan 23, 2006. I was recently working on a 2.0 Framework project where we had many types of related objects. However, we needed to ensure that there were not multiple instances of the same object in memory. Usually the GOF Proxy pattern is used to hide or control access to an object, but we can also use it to define relationships between objects.
  • Fetching Data from a Database in XML FormatJan 28, 2006. In this article we will see how to fetch data from database in XML format.
  • ASP.NET Caching: SQL Cache Dependency With SQL Server 2000Jan 30, 2006. SQL cache dependencies are one of the most wonderful new features in ASP.NET 2.0, the ability to automatically invalidate a cached data object (such as a DataSet or Custom Data Type) when the related data is modified in the database. This feature is supported in both SQL Server 2005 and in SQL Server 2000, although the underlying plumbing is quite different.
  • Displaying Single Table Database Hierarchy with DataSet and DataRelationsMar 03, 2006. Hierarchies can be difficult to store SQL tables and even more difficult to query and display. This Example will show you how you can use DataRelation to convert single table hierarchy in to nested XML and then use XSLT to transform it to nested list.
  • DataSource controls in .NET 2.0Mar 04, 2006. In this article, we're going to learn how to connect a database for querying data and binding the result set to ASP.NET controls in a very easy way with no looping or control manipulation required, thus avoiding writing any data source code.
  • Server.Transfer : Passing Values from One Page to Another PageJun 19, 2006. Some times, we want to pass values from one page to another page. There are many ways by which we can do this like: by using query string, or session variable, or Server.Transer etc. This article shows you, how to pass values from one page to another page by using Server.Transfer method.
  • Using LINQ in Visual Studio 2005Jul 03, 2006. LINQ (.Net Language Integrated Query) is the general-purpose standard query operators that allow traversal, filter and projection operations to be expressed in a direct yet declarative way in any .Net programming language.
  • .NET Language Integrated Query for XMLJul 17, 2006. This is the overview of .NET Integrated Language Query for XML. This Article explains some of the features of XLINQ with example.
  • The Realization of WS-Security Related Specifications by WSE 3.0.Sep 18, 2006. In this article, we are going to learn the basic concepts of WS-Security related specifications and how they are implemented by Microsoft Web Service Enhancements 3.0 technology.
  • Tip related to sub containers and SqlDataSourceDec 06, 2006. This article provides some tips when working With Master page or SqlDataSource insert function In VS 2005.
  • Text to Speech in Visual C# 2005Dec 20, 2006. 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. This article does not address the newer speech server related libraries nor does it address web based deployments of speech related technologies.
  • ASP.Net State Management TechniquesJan 02, 2007. This article gives brief introduction to various state management techniques in ASP.NET.
  • Strategy for querying Microsoft Access as an In-Memory Database using DataSets and ADO.NETJan 09, 2007. This article describes how you can read tables in from MSAccess up front in your application and then query the tables in-memory using some powerful features of the DataSet and ADO.NET
  • Power Management From a Windows Forms ApplicationJan 17, 2007. This article describes how to place the computer into a power management suspend state, and how to put the computer into a power management related hibernate state.
  • Strategy for querying Microsoft Access as an In-Memory Database using DataSets and ADO.NETJan 19, 2007. DataSets are powerful data structures with the capability of allowing the programmer to treat them as in-memory databases.
  • Capturing Screen Resolution InformationJan 22, 2007. This article describes a simple approach to capturing and displaying screen related information.
  • Interoperability between WCF and Oracle Application Server : Part IJan 24, 2007. This article is part of series intended to show how to use Web Services related technologies to interoperate applications running in different platforms, in this case, the most common scenario between Microsoft.NET and Oracle AS platforms.
  • Add a Quick Map to a Windows ApplicationMar 15, 2007. This project demonstrates a quick and easy way to add mapping to a windows desktop application (with an available internet connection) using Google Maps as the basis and source for the map.
  • ASP.Net 2.0 AJAX Extension 1.0 ApplicationMar 21, 2007. This article will explain you in dept of creating AspNet Ajax-Enabled Application I have explained with the help of product management example, where you can add new product, edit, update & cancel the product related activity.
  • .NET and Active DirectoryApr 19, 2007. This article outlines connecting to AD from .Net using ADO and System.DirectoryServices and also forming a unique ID from AD, moving entries from AD to a database and forming AD queries (also date formatting for AD).
  • Accessing the Active Directory From Microsoft .NETApr 19, 2007. This article is intended to explain the architectural design of an application querying the Microsoft Active Directory. Microsoft Active Directory is a directory service that provides the foundation for distributed networks built on Windows.
  • ASP.Net : AutoListMay 09, 2007. This small web application will demonstrate some useful functionality like AutoList, XML data is land to populate list at client side using xml and xpath query, transform xml data using XSLT at client side etc.
  • Online Web Quiz II: Using the AccessDataSource to Query Microsoft Access in ASP.NET 2.0May 31, 2007. This Article demonstrates an online multiple-choice web quiz that builds itself dynamically from an Access Database.
  • Distributed Transaction Coordinator/Control in asp.net (DTC)Jul 31, 2007. A transaction is a series of work perform as a single unit of work consistency and reliability of the system, can be achieved by binding a set of related operations together in a transaction. Here I will be discussing how we can run distributed application in a application.
  • Extracting the Country from IP AddressSep 25, 2007. Sometimes we want to get visitors details who visit our web site or using client connecting our server. This sample descirbes how to translate IP address and query countrie and city from IP address.
  • C# Asynchronous Multi-Threaded Active Directory User/Group BrowserOct 01, 2007. I was working on a win forms project that queries Active Directory information for user and group information and thought the approach may be of interest to some c-sharpcorner readers as a simple example of a asynchronous multi-threaded win forms application.
  • Distributed Databases in SQL Server 2005.Nov 20, 2007. An increasing number of applications require access to multiple databases located at different sites. A distributed database system allows applications to access database locally and remote transparently.
  • Query Optimization in SQL Server 2005Dec 19, 2007. This article offers suggestions on how to optimize query performance in SQL Server 2005.
  • A Brief Introduction to Expressions in SQL Server 2005 Reporting ServicesJan 07, 2008. This article shows how you can use expressions in SSRS reports to generate dynamic content based on the data within your report queries.
  • Caching in ASP.NET 2.0Jan 08, 2008. Caching is a technique of storing a copy of data in memory. You could cache a page or the results of a query. The advantage of caching is to build better performance into your application.
  • XML Pathfinder - Sample C# Utility to Study XML Paths and XPath QueriesFeb 05, 2008. This article discusses the construction of a simple utility that may be used to locate and evaluate paths within an XML document, and to test queries against those paths.
  • Chapter 1: Hello LINQFeb 06, 2008. This is an exert from Joseph C. Rattz, Jr.'s book Pro LINQ. Here you learn how to use Linq in your application and also depicts the benefits of using Linq.
  • Multiple Active Result Sets (MARS)May 12, 2008. 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.
  • Using LINQ to Objects in C#May 26, 2008. This article provides an introduction to employing LINQ to Objects queries to support a simple win forms application; the article addresses the construction of LINQ to Objects statements and then goes on to describe how one might use LINQ to Objects within the context of an actual application.
  • The third pillar of object-oriented programming - polymorphism:May 29, 2008. In the last part of this series you will see the third pillar of object-oriented programming (polymorphism); you will see how the polymorphism gives you the ability to treat related objects in the same way.
  • Convert a LINQ Query Resultset to a DataTableJun 24, 2008. After a long struggle I find out the way to convert a Linq Query resultset to DataTable object. The attached source code shows how to do it.
  • Animated Banners in XAMLJul 02, 2008. This article shows how to use animation related controls in XAML to create an animated banner with animations such as gradient colors, text rotation, and resize the banner text.
  • How to pass SQL Query Parameters to Crystal Reports using OracleAug 06, 2008. This article shows how to pass SQL query parameters to Crystal Reports using Oracle.
  • Building and consuming parameterized queries from ADO.Net to DLINQAug 29, 2008. In this article, I will represent different techniques to build and make use of parameterized queries. The first way is the classical one, and I mean by that the ADO.Net technique. Then I’ll expose the second one using the new technology, namely DLINQ.
  • Use CompiledQuery.Compile method to build parameterized DLINQ queriesAug 29, 2008. In this article, I will make use of the CompiledQuery.Compile generated method which receives a Lambda expression as parameter, and then it generates a delegate that returns a generic IQueryable object that one can enumerate it through a foreach loop.
  • How to convert a simple DLINQ Query to a data set objectSep 01, 2008. In this article I will represent a trick of how to convert a given DLINQ query to a data set object in order to make use of it as a data source for several controls such as grid view, data grid view and so forth.
  • LinqDataSource Control in ASP.NET 3.5Sep 16, 2008. This article shows that how to use LindDataSource Control in ASP.NET 3.5.
  • ASP.NET 3.5 URL Routing in MVC FrameworkOct 07, 2008. This post speaks about basics of URL Routing and how URL Routing related to building a ASP.NET MVC Application. This post specifically speaks about how URL Routing is used in ASP.NET MVC Application.
  • Getting started with ADO.NET Entity Framework in .NET 3.5 - Part IIIOct 13, 2008. This article show us how to do conditional query and paging in ADO.NET Entity Framework.
  • Performance Tuning in Database SystemsNov 08, 2008. In this article, we’re going to learn the principles and techniques you can use to help troubleshoot and evaluate query performance by illustrating examples in Microsoft SQL Server and Oracle database.
  • Caching FAQ's: Part IJan 22, 2009. In this section we will touch base on one of important concepts in .NET Caching.
  • Test-driven development approach in Microsoft.NET using NUnitFeb 19, 2009. This is the first article of series of articles related to Test-driven development (TDD) approach in Microsoft.NET. My intention is to illustrate this approach with several real-world examples, and this article is an introduction to the approach and the testing framework NUnit.
  • Weird thing with inner queries in SQL SERVER 2005Feb 19, 2009. This articles helps you in understand that how inner queries works with relation to outer queries and what problems it can create if not used in proper manner.
  • Weird Thing With Inner Queries in Sql Server 2005Feb 24, 2009. This articles helps you in understand that how inner queries works with relation to outer queries and what problems it can create if not used in proper manner.
  • LINQ FAQ for Newbie's Mar 05, 2009. In this article we will run through basics of LINQ and then see 5 basic LINQ queries which you will always need in your project for queries. While looking at the basics we will also try to learn what problem LINQ solves from the perspective of middle tier business objects.
  • Query Analyzer for OracleMar 23, 2009. Query Analyzer allows you to connect to an Oracle database and create any query, see the results, and import results to text or excel files.
  • Test-driven development approach for a class library in Microsoft.NETApr 09, 2009. This is the second article of series of articles related to Test-driven development (TDD) approach in Microsoft.NET. My intention is to illustrate this approach with several real-world examples. In this article, I will show how programmers can use the test-driven development approach to implement and test a class library.
  • Custom TimerJob in SharepointMay 11, 2009. This article shows how to create a new entry automatically in your task list in the Sharepoint related to timer which you set.
  • Type Conversions in C#Jun 04, 2009. In this article I will explain about one of the main topics in C# - Data Types. You will also learn about the value and reference types, type conversions and other features related to data types.
  • An Introduction to LINQJun 06, 2009. LINQ stands for Language INtegrated Query. Means query language integrated with Microsoft .NET supporting languages i.e. C#.NET, VB.NET, J#.NET etc. Need not to write\ use explicit Data Access Layer.
  • Custom Overload for ExecuteNonQuery MethodJun 18, 2009. Custom Overload for ExecuteNonQuery Method.
  • WCF FAQ Part 3 - 10 Security Related FAQJun 23, 2009. In this article we will start with transport and message security understanding. We will then see simple code samples of how to implement transport and message security using WsHTTP bindings. We will also see what is the difference between ‘BasicHttpBinding’ and ‘WsHttpBinding’ with the help of a simple source code. WCF security is a huge topic by itself, but we are sure with this article you will get a quick start of how to go about WCF security.

About Co-related-Queries

NA

SPONSORED BY

File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!
Visual Studio Live - Redmond 2016