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.
  • 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.
  • 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.
  • 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: 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 : 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 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.
  • Crystal report with Dynamic ColumnNov 03, 2006. The objective of this article is to provide a process which can be followed to develop a crystal report with dynamic columns using parameterized column fields and formula fields. Before going for this the developer has to decide the maximum number of columns he/she has to display and as per the no. of columns the size of the paper. The developer can define the size of the paper by selecting Printer Setup in File menu.
  • 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.
  • 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.
  • 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.
  • Constructors in C#May 18, 2009. In this article, I will explain the constructor concept in C# along with practical demonstration which will help you to understand it in a simple way.
  • 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.
  • Configuring Parameters and Parameter Data Types-ADO.NETAug 12, 2009. In this article I will explain you about command object, benefits of parameterized command, DbParameter Object, ParameterDirection Property and Parameter Data Types in ADO.NET
  • 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.
  • Visual Studio 2010 Application Lifecycle Management - Manage Work ItemsJun 15, 2010. In this article, I am going to show step by step process of creating work items (user stories/tasks), create queries to view the work items and managing same work items using Microsoft Office Excel.
  • Select and SelectMany: LINQ projection operatorAug 16, 2010. Projection transforms the query result into the form defined by the developer. There are two projection operators in LINQ
  • Performance Tuning High Level- SQL SERVERAug 26, 2010. You can view the query execution plan while executing the query in your query analyzer. Through that you can tune your query. It will show you whether the appropriate tables are using the proper index or not.
  • Working with LINQ in SharePoint 2010Oct 05, 2010. In this article I am showing how to use LINQ in SharePoint 2010 web part. SharePoint 2010 has the ability to use LINQ syntax to fetch data from lists instead of using the CAML queries.
  • Cross Site List Query using SPSiteDataQuery in SharePoint 2010Oct 29, 2010. In this article I am giving you an introduction on SPSiteDataQuery class.
  • Linq queries for beginnersDec 02, 2010. Following are some of the basic Linq command/samples for those who just want to start learning Linq.
  • How to Get Database Information's - Oracle, Sql ServerDec 07, 2010. Article helps to show basic queries to retrieve database related information’s.

About Parameterized-Query

NA

SPONSORED BY

C# Corner Chandigarh DevCon16
Chandigarh DevCon16 is a one-day Developer Conference where programmers, technologists, authors, and members meet, demonstrate, plan, and hang out.
Download Free eBooks