C# Corner

Resources  
  • 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.
  • Populating and Editing a DataGrid in ASP.NETAug 17, 2001. I will show here , how to develop DataGrid, which is able to retrieve data from joined tables and editable.
  • C# IRC BotNov 19, 2001. This is a very simple program that establishes a connection to irc server, joins a channel and greets every nick that joins.
  • Multithreading Part 2: Understanding the System.Threading.Thread ClassApr 08, 2002. In this article we will study the .NET threading API, how to create threads in C#, start and stop them, define their priorities and states.
  • 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.
  • 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.
  • Developing Secure Web Site with ASP.NET and IIS - PartIIMay 07, 2003. Authentication is a very important element of developing secure sites. It is the starting point of a secure environment for the protected resources. I have discussed several authentication mechanisms available in ASP.NET and how they join with IIS to provide a secure platform to develop sites in Part I of this article.
  • Developing Secure Web Site with ASP.NET and IIS: PartIIMay 07, 2003. Authentication is a very important element of developing secure sites. It is the starting point of a secure environment for the protected resources. I have discussed several authentication mechanisms available in ASP.NET and how they join with IIS to provide a secure platform to develop sites in Part I of this article. I will be looking at Form Authentication and how to implement it in several sample web applications.
  • 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.
  • Real Life SQL and .NET : SQL Subqueries: Part VIIJan 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 XJan 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.
  • Understanding Threading in .NET FrameworkApr 21, 2005. This article describes how to use threading model in .NET Framework including creating, joining, suspending, killing, and interlocking threads.
  • 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.
  • Developing a PHP Website using Visual Studio 2005Jun 03, 2008. Yes it’s possible to use PHP under Visual Studio 2005 and even Visual Studio 2008 IDE. In this tutorial, I will show a walkthrogh how it is possible to develop a classic PHP web application.
  • Joins in SQL Server 2005Oct 02, 2008. This article discusses how to use Joins in SQL Server 2005.
  • 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.
  • 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.
  • Customizing Line Caps and Line joins in GDI+ Mar 18, 2010. In this article I will explain about Customizing Line Caps and Line joins in GDI+.
  • Developing SOAP Web Services with PHPMay 28, 2010. In this article you will learn how to Develop SOAP Web Services with PHP.
  • Introduction to Joins in Sql ServerMar 22, 2011. Ann introduction to Joins in SQL Server.
  • Full Outer join and Cross Join in SQL Server 2008Apr 08, 2011. In this article I describe the purpose of full outer join and cross join.
  • SQL Server Integration Services (SSIS) - Merge Join Transformation in SSISApr 25, 2011. In this article we are going to see how to use the Merge Join Transformation in SSIS packaging. This is part 52 of the series of articles on SSIS.
  • Lookup Transformation in SSISMay 19, 2011. The Lookup transformation performs lookups by joining data in input columns with columns in a reference dataset.
  • Left and Right Join in SQL Server 2008Jun 01, 2011. In this article I will describe how to perform a left and right outer join between more than one tables in SQL Server 2008.
  • Ins Tag in HTML5Aug 02, 2011. The ins tag defines text that has been inserted into a document.
  • Difference Between On Clause And Where Clause When Used With Left Join in SQL ServerAug 04, 2011. The purpose of this article is to show the difference between the On clause and Where clause when used with a left join in SQL Server.
  • Joins in MySQLNov 21, 2011. In this article we will discuss about joining in MySQL.
  • Audio tag in HTML5Nov 22, 2011. This new element allows you to deliver audio files directly through the browser, without the need for any plug-ins. embedding the audio file into a web page via the src attribute.
  • Join, Sleep and Abort methods in C# ThreadingNov 24, 2011. A thread class consists of a number of methods. the join() and sleep() methods are two of them.
  • Introduction to PHPNov 26, 2011. PHP Stand for "Hypertext Preprocessor". PHP is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML.
  • Installation of XAMPP Server to run PHP programNov 28, 2011. XAMPP Server is a free and open source cross-platform web server solution stack package, consisting mainly of the Apache HTTP Server, MySQL database, and interpreters for scripts written in the PHP programming languages.
  • Simple HTML embedded application in PHP Nov 29, 2011. PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded in HTML.
  • Working with database in PHPNov 30, 2011. In this section we are going to know that how to work with a database with the XAMPP server of PHP where MySQL is in the back-end.
  • Login Page in PHPDec 01, 2011. In this article we will know how to do a simple login page using PHP.
  • Display data from a database through PHPDec 03, 2011. In this article we will learn how to display the records from the database using PHP. Before going forward we should know about WAMP Server. This is an environment where we can run your php scripts and create databases.
  • Create Login page using PHP Dec 04, 2011. The login page is the most important web page in web-development, the login page provides secure access to websites for registered users only.
  • Work with Strings in PHP Dec 05, 2011. PHP is a hypertext-preprocessor. In PHP, a string can be used directly in a function or it can be stored in a variable. With a string variable we can store and manipulate text.
  • Registration page in PHPDec 05, 2011. In this article we will learn how to create a simple registration page using PHP.
  • Working with PHP functions with XAMPP Dec 06, 2011. In this section we are going to understand with php functions. PHP is very well known in the world of web-development & is a powerful tool for making dynamic and interactive Web Pages.
  • Working with PHP Include()Dec 07, 2011. Here you will learn how to insert the content of one PHP file into another PHP file using the include() or require() functions before the server executes it.
  • Populate a Dropdown and Display a Related Record in PHPDec 09, 2011. In this article we will learn how to populate a Dropdown with records from the database and display the related record when dropdown value is selected.
  • Working with files in PHP Dec 10, 2011. In this article we are going to understand the handling of files with a practical approach. File handling functions in PHP are extremely useful and user-friendly.
  • Sorting in PHPDec 10, 2011. In this article we will learn how to do sorting in PHP using AJAX.
  • Display Related Records in PHPDec 10, 2011. In this article we will learn how to display related records from the database when we click a show all link using PHP.
  • File uploading in PHP using XAMPPDec 11, 2011. In this article we are going to understand how to upload a file with the help of PHP. For this purpose you must install a XAMPP server.
  • Working with cookies in PHPDec 12, 2011. Today I will discuss about cookies in PHP which, in short "cookies are small strings of data created by a Web server but stored on the client".
  • Paging in PHPDec 12, 2011. In this article we will learn how to do paging in PHP using Ajax.
  • Working with PHP SessionsDec 13, 2011. Hi guys, In this article we are going to learn the concept of a session in PHP. The PHP session variable is used to store information about, or change settings for a user session.
  • Joins Using LINQ in C#Dec 13, 2011. Today, in this article we will see how to perform join operation using LINQ queries. I have created two tables in database named ‘Candidate’. The first table name is Employee. the second table name is Student. I have used LINQ to SQL to communicate with database.
  • Send mail on local host via Mercury with XamppDec 17, 2011. In this article we are going to have some interesting things with PHP; we are going to send mail via mercury with XAMPP.
  • Work with Static Methods and Variables in PHPDec 19, 2011. In this article we are going to understand the concept of static methods and variables. Methods and variables can also be used and accessed if they are defined as static in a class.
  • Exception handling in PHP: Part 1Dec 20, 2011. In this article we are going to understand the concept of exception handling. An exception is the abnormal termination of the program and here you learn how to handle this exceptions.
  • Exception handling in PHP: Part 2Dec 21, 2011. In this article we going to understand the next four error handling methods. An exception is the abnormal termination of the program. It is known as run time errors.To avoid the abnormal termination of program we use exception handling.
  • Work with a Filter in PHP Dec 24, 2011. In this article we are going to understand the concept of the PHP filter. First of all we need to understand the concept thoroughly. You must have installed the Xampp server.
  • Insert Statement With PHP ScriptDec 27, 2011. In this article we are going to have a glance at the insert into statement through PHP. The INSERT INTO statement is used to insert new records in a table. Here we are going to explore the concept thoroughly.
  • Approximate Joins in MySQL ServerDec 28, 2011. Here we have to show Approximate joins on two tables in MySQL server.
  • Working With PHP XML Expat Parser And XML DOMDec 31, 2011. In this article we are going to understand the concept of PHP Expat parser & XML DOM. First of all we need to know about XML. XML is used to describe data and to focus on what data is. An XML file describes the structure of the data. There are only user defined tags in XML.
  • Creation of Database & Table Through PHPJan 08, 2012. In this article we are going to understand the MySQL database with PHP. A database is an organized collection of data for one or more purposes, usually in digital form. A database holds one or multiple tables.
  • Select Statement With PHP ScriptJan 08, 2012. In this article we are going to understand the database select statement using PHP. The SELECT statement is used to select data from a database.
  • Join Operation Through JSPJan 10, 2012. In this article, I am going to develop an application that joins two database tables.
  • Variables in PHPFeb 12, 2012. In this article you will see the types of variables and how to use variables in PHP.
  • Operators in PHPFeb 13, 2012. In this article you will see the types of operators available and how to use them in PHP.
  • Conditional Statemets (if...else) in PHPFeb 14, 2012. Using this article one can easily understand conditional statements or decision statements in PHP.
  • Looping in PHPFeb 15, 2012. In this article you will see types of loops and how to use of loops in PHP.
  • Working With Threads in JavaFeb 15, 2012. In this article you will learn how to set the priority of a thread and use the og join(), isAlive() methods in Java
  • Arrays in PHPFeb 18, 2012. Using this article one can easily understand the concept of arrays in PHP .
  • Functions in PHPFeb 19, 2012. Using this article one can easily understand the concept of functions in PHP.
  • $_GET and $_POST in PHPFeb 20, 2012. Using this article one can easily understand the difference between the GET and POST methods in PHP.
  • Include() and Require() Function in PHPFeb 21, 2012. Using this article one can easily understand the include() and require() functions in PHP.
  • Date() Function in PHPFeb 22, 2012. Using this article one can easily understand , how to format a date and time in PHP and related functions.
  • Mathematical Functions in PHPFeb 26, 2012. In this article you will see how to use mathematical functions in PHP.
  • Database Connectivity (Insert and Select) With MySQL in PHPFeb 28, 2012. This article explains how to insert and select data from database into a HTML table in PHP.
  • Update Statement in PHPFeb 29, 2012. In this article you will see how to update data in the database through HTML table.
  • Delete Statement in PHPMar 01, 2012. Using this article one can easily understand how to delete data from a database in PHP.
  • Sorting Arrays in PHPMar 02, 2012. Using this article one can easily understand sorting arrays in PHP.
  • Dropdown List in PHPMar 03, 2012. In this article you will see how to create a static and dynamic drop down list in PHP.
  • SQL Limit in PHPMar 05, 2012. In this article you will see, how to execute a LIMIT operator of mysql in PHP. 
  • Dynamic Navigation Menu in PHPMar 05, 2012. Using this article one can easily understand the concept of a dynamic navigation menu in PHP.
  • Browser Information in PHPMar 12, 2012. Using this article one can easily understand, how to determine browser name and IP address in PHP.
  • Concept of Join in SQL ServerMar 13, 2012. In this article we are show different types of joins in SQL Server. A Join in SQL is used to combine two or more tables. We use the Join operator to gather the data in a single query.
  • Validation in PHPMar 13, 2012. Using this article one can easily understand how to apply validation in a PHP form.
  • Implode() and Explode() Function in PHPMar 14, 2012. In this article you will see how to use the implode and explode functions in PHP.
  • Image Uploading in PHPMar 17, 2012. In this article you will see how to upload an image and how to see an uploaded image using PHP.
  • Types of Errors in PHPMar 18, 2012. Using this article one can easily understand errors in PHP.
  • Insert Value From Radio Button in MySQL in PHPMar 21, 2012. Using this article one can easily understand how to insert a value from a radio button into a MySQL database in PHP.
  • MVC in PHPMar 25, 2012. This article is an introduction to the use of Model, View, Controller (MVC) in PHP.
  • Introducing CodeIgniter Framework in PHPMar 26, 2012. In this article you will see how to use the MVC architecture in PHP through the CodeIgniter framework.
  • Fetch Data From Database With CodeIgniter Framework in PHPMar 27, 2012. In this article I will explain how to fetch data from a database using the CodeIgniter framework in PHP.
  • Types of Print Function in PHPMar 28, 2012. Using this article you can get more knowledge of many types of print functions.
  • Canvas Line Join Using HTML 5Apr 10, 2012. This article is very useful to understand the concept of canvas line joining in various shapes.
  • Insert Value From CheckBox in Database (MySQL) in PHPApr 15, 2012. In this article you will see how to insert a value from a checkbox in the MySQL database.
  • Login Page With CodeIgniter Framework in PHPApr 16, 2012. In this article you will see how to build a Login page with the CodeIgniter framework in PHP.
  • Turn Affiliate RSS Feeds Into a Website Using DrupalMay 02, 2012. Convert your affiliate RSS feeds into a website in a few steps using Drupal.
  • Joins in SQL ServerMay 07, 2012. By this article I am trying to show you the joins in a different way i.e. in math terms by the sets as well as the query which will give you the return in one single click of Execute in Management Studio.
  • Creating a Search Page in PHPMay 21, 2012. In this article we will learn how to make a search page in PHP.
  • Display Records From One ComboBox to Another in PHPMay 21, 2012. In this article we will learn how to get the related records from a ComboBox by selecting any items of another ComboBox.

About joins-in-PHP

NA

SPONSORED BY

Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.
European SharePoint Conference