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.
  • Assemblies : The Ins and Out : Part IApr 13, 2001. In Part 1, I will cover what exactly an assembly is, and what an assembly contains.
  • Assemblies : The Ins and Out : Part IIApr 16, 2001. In this part, I will discuss both Private and Shared assemblies and how to create a "Shared Assembly".
  • Assemblies : The Ins and Out : Part IIIApr 20, 2001. In this part I will discuss in more detail than Part 2, the available utilities for manipulating assemblies.
  • 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.
  • 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.
  • 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.
  • The "ins" and "outs" of Using Stored Procedures in C#Jan 27, 2003. This article reviews the creation of stored procedures with parameters using the Visual Studio IDE.
  • 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.
  • 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.
  • Basics of Extending Your Working Environment in Visual StudioApr 10, 2003. All of us have used Macros in Microsoft Office and Add-ins in Visual Studio 6 and I am very sure all of us have been impressed as well by their power to control their own working environment.
  • 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 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 : 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 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: 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 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.
  • 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.
  • 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.
  • 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.
  • 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
  • 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.
  • 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.
  • 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.
  • .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).
  • 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.
  • Introduction to Building a Plug-In Architecture Using C#Sep 10, 2007. In this article we'll take another look at how we can use the state pattern to build a plug-in architecture that will allow us to change the behavior of our application by placing differnt plug-ins into a folder.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Introduction to Visual Studio Add-insMar 03, 2009. This article explains about Visual Studio 2008 Add-ins.
  • Introduction to Interfacing Win Forms with VS Add-insMar 04, 2009. This article explains about integration of Windows Forms with Visual Studio Add-ins.
  • 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.
  • Paging and Sorting ListViews with ASP.NET MVC and jQueryMar 23, 2009. This article provides a simple example of using jQuery along with the jQuery tablesorter and tablesorter.pager plug-ins to provide sorting and paging support for a listview within the context of an ASP.NET MVC application. JQuery has partnered with Microsoft and is now integrated within the IDE to include the availability of intellisense support.
  • 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.
  • jQuery in Microsoft.NET and Oracle ASApr 14, 2009. jQuery is a lightweight JavaScript library CSS3 compliant to efficiently traverse HTML documents, handle events, perform actions and add interaction to the Web pages. In this article, I will explain how to use jQuery with Microsoft ASP.NET and Oracle Application Server (AS).
  • 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.
  • LINQ FAQ for Newbie's Jul 13, 2009. In this section 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.
  • LINQ FAQ Part 2Jul 14, 2009. This FAQ article is dedicated to LINQ to SQL. In this article we will see a basic example of LINQ to SQL, how to define 1-1 and 1-many relationship using LINQ, how we can optimize LINQ queries, execution of stored procedures using LINQ and finally we will see a simple CRUD example using LINQ to SQL. For past some days I was running small sprint to complete this marathon I hope you will like this article.
  • How to improve your LINQ query performance by 5 X times ?Jul 17, 2009. LINQ has been criticized by many early adopters for its performance issues. Well if you are just going to drag and drop using DBML code generator I am sure you will land up in to mess. Try doing this make a simple LINQ to SQL project using DBML and see your SQL profiler, I am sure you will never like to touch DBML code generator again. In this article we will first look in to how LINQ queries are executed, and then we will touch base on how compiled LINQ queries can help us improve our application performance at least 5 times. My numbers can be 10% up and down as I had come to that figure using my environmental situations.
  • LINQ FAQ Part3Aug 01, 2009. This is the third series in my LINQ FAQ series. In this series we will cover LINQ FAQ’s related to concurrency handling, compiled queries, CRUD implementation and mapping simple .NET classes with XML file configuration. I love to write articles in FAQ format for the only purpose that they are to the point and you can get to know more by reading less.
  • Parameterized Query and SQL Injection AttacksAug 10, 2009. In this article I will explain about Parameterized Query and SQL Injection Attacks.
  • LINQ Deferred ExecutionAug 24, 2009. In this article we will see how LINQ defers the execution of the query till you request the results. Plus, learn how to execute the query immediately.
  • Common Table Expression(CTE) in Sql server 2005Sep 14, 2009. This article explains about Common Table Expression(CTE) in sql server 2005 with sample sql queries.
  • Views in SQL Server 2005Oct 14, 2009. This article explains about the views in sql server 2005 with sample sql queries.
  • Creating Data Adapters with the Data Adapter Configuration Wizard Oct 14, 2009. This article will help you in understanding Creating Data Adapters with the Data Adapter Configuration Wizard.
  • DataReader in ADO.NETDec 29, 2009. In this article I will explain DataReader in ADO.NET.
  • Create a Data Adapter in ADO.NET Jan 28, 2010. In this article I will explain how to Create a Data Adapter in ADO.NET.
  • Binding using LinqDataSource controlJan 31, 2010. In this article, I will explain how to implement data binding techniques in Web applications using Language Integrated Query (Linq) and LinqDataSource control shipped with ASP.NET 3.5.
  • SQL Query Optimization FAQ Part 1 (With video explanation)Feb 02, 2010. In this article we will first try to understand what is a SQL plan, how is it created and then we will move towards understanding how to read the SQL plan. As we read the SQL plan we will try to understand different operators like table scan, index seek scan, clustered scan, RID lookup etc. We will also look in to the best practices associated with clustered and non-clustered indexes and how they function internally. We will practically see how indexed views increase performance and in what scenarios we should use the same.
  • Adding Editor, and Deleting data in Web Forms using ADO.NET Feb 11, 2010. In this article I will explain Adding Editor, and Deleting data in Web Forms using ADO.NET.
  • LINQ to Object Part #4: Querying Non- IEnumerable collectionsMar 15, 2010. In this article, I am going to show, how we could apply LINQ to query non-IEnumerable<T> Collections.
  • Query Through File System Using .Net 4.0 Enumerable CollectionsApr 26, 2010. This article describes a new method introduced in .NET 4.0 using which developers can interact with file systems very quickly, especially for searching files and folders.
  • Linq to SQL Performance Considerations: Part IIApr 29, 2010. This article takes a look at what it takes to convert Linq queries to compiled queries and what performance gains can be obtained.
  • Using LINQ to SQL QueryMay 04, 2010. Here in this article, you will get very basic idea of LINQ to SQL Query using code.
  • Using LINQ to SQL ClassMay 07, 2010. In this article, I am going to show you how we can perform various operations using LINQ to SQL.
  • Simple Explanation for very beginners of Query StringMay 10, 2010. Query String allows you to pass values between the asp.net pages.
  • RIA Services - exposing OData serviceMay 24, 2010. Open Data Protocol (OData) is a web protocol which is used for querying and updating data. In this article we will see how to enable OData service in our RIA services.

About Queries-in-CSS3

NA
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!
VSLive! Anaheim