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.
  • Alternative Simplified C# Property Syntax Dec 19, 2002. When I first read about properties in C#, I was a bit excited and a bit confused. I was glad to see so many inventions, including properties, designed to help programmers be more productive.
  • 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.
  • Regular Expression ValidatorMar 14, 2003. This tool is useful when you are creating Regular Expression. This tool will help you in checking syntax of the regular expression typed in.
  • Syntax Highlighting in RichTextBox Control - Part 2Jun 12, 2003. This article shows how to perform interactive syntax highlighting within the RichTextBox control.
  • Syntax Highlighting in Rich TextBox Control - Part 1Jun 12, 2003. This article shows how to perform basic syntax highlighting using the RichTextBox control and C#.
  • Part I: Simple Color Syntax Code Editor for PHP written in C# and .NETJun 18, 2003. The Application is a simple Windows Form program that allows you to open and save the text files edited in the rich edit control, as well as print them out. The program takes advantage of a “syntax” text file for PHP which lists the functions and keywords contained in the PHP language.
  • Part I: Simple Color Syntax Code Editor for PHP written in C# and .NETJun 18, 2003. The second part of this article shows how to print out the contents of a RichTextBox control.
  • 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?
  • Code Generator for Basic Stamp II MicrocontrollerOct 15, 2003. The Basic II Stamp is programmed by the language its named after, Basic. The language is a combination of Basic syntax and built in key words that control the Basic Stamp II chip.
  • 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 :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 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: 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.
  • Build a .NET Solution or Project from the Command Line Sep 27, 2004. Devenv allows you to set various options for the integrated development environment (IDE) as well as compile, build, and debug projects from the command line.
  • Introduction to ASP.NETNov 17, 2004. I have seen many tutorials on ASP.NET but most of them starts with coding and writing your first ASP.NET program. But here I have written this tutorial for explaining why there is a need for ASP.NET when classy ASP is working fine, what are the underlying technology behind ASP.NET, and what programming model ASP.NET provides to programmers.
  • 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.
  • Sending Mail from ASP.NET Webpage using VB.NetJan 06, 2006. This article shows how easy it is to send an email from an ASP.NET Web page. While sending email from an ASP.NET Web page the syntax differs slightly from sending an email from an ASP page, the overall approaches are similar.
  • 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.
  • Building applications with DLinq DesignerJul 01, 2006. DLinq designer is the visual design surface to create the entity objects and bound the controls to the dlinq objects with relationships. We can easily create the windows form using the designer. The developer need not take more time to design the User Interface. The designer itself suggests you the controls suitable for the selected fields.
  • 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.
  • Regular ExpressionsJul 05, 2006. The purpose of this article is to build upon the existing pool of regular expression articles by providing an overview of the new regular expression features found in .NET and to offer some guidelines as to when and how to use them.
  • .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.
  • Reading and Writing XML using XLinqJun 21, 2007. XLinq is a new API to work with XML using LINQ. XLinq is more flexible, simple, and faster programming model to read, write, manipulate, and traverse XML documents.
  • Select Items with Where in LINQ and C#Jun 21, 2007. This article shows how to select exact match and in between items from a collection using LINQ and C#.
  • Think in LINQ: Yahtzee Score Calculator Using LINQ TechnologyJul 23, 2007. This article revisits the yahtzee program I wrote in 2002 and reimplements scoring using LINQ technology. It compares the old way of scoring with LINQ and shows you the advantages of using LINQ.
  • Data Binding using LINQ to SQL in C#Aug 09, 2007. LINQ to SQL allows developers to work with databases using LINQ. This article discusses how to get, add, update, and delete data in a DataGridView control using LINQ to SQL.
  • Color Syntax Editor Part II - Exporting a RichTextBox to a Microsoft Word DocumentAug 14, 2007. This article is part II of a color syntax editor created back in 2003. It describes how to export the contents of the RichTextBox to Word and Open the Word Document Programmatically.
  • Free Book: C# Programming for BeginnersAug 21, 2007. In this book, you will learn how to write and compile C# programs, understand C# syntaxes, data types, control flow, classes and their members, interfaces, arrays, and exception handling. After completing this book, you should have a clear understanding of the purpose of C# language, it’s usages, and how to write C# programs.
  • 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.
  • Chapter 1: Introducing ASP.NetJan 07, 2008. This article tells the features and frills of Asp.Net 3.5 and .Net framework.
  • 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.
  • Functional Programming in C#: CurryingJan 13, 2008. Currying is a way to re-write a function with multiple arguments in such a way as it can be called as a chain of functions each with a single argument. This article covers using a few simple utility methods you can use to curry your methods.
  • Introduction to Functional Programming in C#Jan 13, 2008. With the release of the 3.5 framework, we have a completely different coding style available (functional programming). We could actually do functional programming in the 2.0 framework, but the resulting code was ugly and hard to understand at a glance and thus hard to maintain. Now, with lambda method syntax and extension methods, we can produce very human-readable code written in a functional style.
  • Functional Programming with C#: Lazy CalculationJan 20, 2008. I ran across Mike Gold’s nice algorithm for finding primes using LINQ syntax and thought I’d use his idea as a base from which to demonstrate one of the more subtle features in functional programming: lazy calculation.
  • 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.
  • Methods, Delegates, Anonymous Delegates, and Lambda Expressions... Oh My!Mar 22, 2008. This article covers different syntax we can use for declaring and executing methods.
  • 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.
  • Cascading Deletes in LINQ to SQLJul 03, 2008. 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.
  • Generic Data Access using LINQ to SQL and C#Jul 22, 2008. This article discusses the construction of a generic data access layer built on top of a LINQ to SQL implementation.
  • 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.
  • Difference between C++ and C#Aug 27, 2008. This article gives you complete information about the different syntax used in c++ and C# language.
  • 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.
  • SQL Server Stored procedures and UDF within LINQ context-PartIISep 03, 2008. In the first article, SQL Server Stored procedures and UDF within LINQ context-Part I, I exposed 2 scenarios of how to deal with stored procedures using LINQ, in this second part, I will accomplish the task by demonstrating how to call a user defined function UDF using the same way adopted in the first part.
  • SQL Server Stored procedures and UDF within a LINQ context-Part ISep 04, 2008. In this two parts particle, I will give techniques of how to deal with stored procedures and user defined functions UDF from within a LINQ context rather than ADO.Net.
  • Silverlight Tutorial: Creating a data centric Web Application with DataGrid, LINQ, and WCF Web ServiceSep 15, 2008. This step-by-step tutorial is a guide for creating a silverlight Web application capable of submitting and retreiving data from a database.
  • 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.
  • Secrets of Extension Methods: Part IIDec 23, 2008. This article explains how Extension Methods are used in LINQ.
  • Caching FAQ's: Part IJan 22, 2009. In this section we will touch base on one of important concepts in .NET Caching.
  • JSON FundamentalsFeb 02, 2009. A new data format which is built on JavaScript is called JavaScript Object Notation[JSON]. It is a lightweight data format based on JavaScript syntax. JSON definitions can be included within JavaScript files. This post speaks about basic syntax of JSON.
  • Using Data in Silverlight 2 Applications - IFeb 05, 2009. In this Article you will learn how to create a data connection, a LINQtoSQL class and a WCF service.
  • SQL Server Compact and LINQFeb 13, 2009. In this article, I will cover how to access data in SQL Server Compact databases (.sdf file) using new development technologies such as LINQ.
  • 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.
  • Easy LINQ to SQL Based Master-Detail Editor C#Feb 22, 2009. This article describes a simple approach to creating a LINQ to SQL based master-detail view with the ability to save changes made to the data. With practically no coding involved, the application below will allow the user to edit the master record as well as the detail records.
  • 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.

About LINQ-Query-Syntax

NA

SPONSORED BY

Spire.Doc - Free .NET Word API
Use Spire.Doc to create, read, write, print, and convert word documents to OpenXML, RTF, TXT, XPS, EPUB, EMF, HTML, Image and PDF.
European SharePoint Conference