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.
  • A Database Access Class with Overloaded SELECT StatementsJan 24, 2001. A useful database access class with overloaded SELECT and other statements.
  • Control Statemenats - Part 1Jun 01, 2001. This lesson shows how to use c# control statements, and the difference between these controls in C++/ JAVA and c#. Sample includes single selection, if-else, and multi case ..
  • Control Statements - Part 2Jun 04, 2001. This lesson shows how to use while,do, for, for..each statements.
  • Working with OleDb Data AdaptersJun 20, 2001. This step by step article guides you to create your database applications using OleDb Data Adapters in VS.NET.
  • Difference Using Directive and StatementJul 26, 2001. This article explains difference between using directive and using statement with sample example.
  • ASP.NET and VB.NET Error HandlingAug 24, 2001. ASP.NET and VB.NET both are providing excellent error handling options when compared with ASP and VB6. In VB.NET we can make use of the structured way of error handling with the Try & Catch statement.
  • Debugging Techniques in C#Dec 04, 2001. Debugging GUI applications for me mostly consists of printing out debug statements in the form of a dialog box with some text.
  • Exception Handling in C#Jan 03, 2002. In C# Exception is a class in the system namespace. An object of an exception is that describe the exceptional conditions occur in a code That means, we are catching an exception, creating an object of it, and then throwing it. C# supports exceptions in a very much the same way as Java and C++.
  • VS.NET Tools Intermediate Language Disassembler (ILDAM)Feb 06, 2002. "The ILDSAM tool parses any .NET Framework EXE/DLL Module and shows the information in a human-readeble format"
  • Create a SQL Server Database dynamically in C#Mar 05, 2002. In this article, I’ll show you how to create a new SQL Server database and its objects such as table, stored procedures, views and add and view data. I’ll also show you how to change database table schema programmatically. You’ll see how SQL statement ALTER TABLE is useful when you need to change a database table schema programmatically.
  • ManifestMaker: Creating your own ManifestMay 31, 2002. When switching over to .NET, I was annoyed at how difficult it was to use Windows XP themes in my applications, so I created this class to ease my life.
  • A Generic Data Access Component using Factory PatternJul 30, 2002. the article A Generic Data Access Component using Factory Pattern provides a very good way of creating ADO.Net data provider independent applications, but there is one problem with it. Different ADO.Net data providers use different approaches in labeling of parameters in SQL statement.
  • The "Using" Statement in C#Dec 11, 2002. The .Net Framework provides resource management for managed objects through the garbage collector - You do not have to explicitly allocate and release memory for managed objects.
  • ADO.NET, COBOL and Stored ProcedureDec 13, 2002. A stored procedure is basically a series of SQL statements that reside on the database. The procedure could create a new table, retrieve data from one or more tables, update one or more tables or perform many other tasks.
  • Using Stored Procedures in Conjuction with DataAdapterJan 09, 2003. A stored procedure is a named collection of SQL statements that are stored in the database. To the client a stored procedure acts similar to a function.
  • Working with Windows TabControl with C#Dec 16, 2003. Windows TabControl is a useful control that allows you display multiple dialogs tabs on a single form by switching between the tabs. In this tutorial, I will explain how to create and use a TabControl in your Windows applications with C#.
  • 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.
  • 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.
  • Implementing Security Access Rights in ASP.NET ButtonMar 24, 2004. In Web based Application, each of the users have different privileges and access rights based on their roles. Each of these roles can have read or write access for different Web pages.
  • TFTP application written in C#Jul 07, 2004. This application is the beginning of a program I want to use to download switch/router configuration files via TFTP and archive them. This application merely asks for an IP address and a filename then it receives the file via TFTP and displays it in a RichTextBox.
  • 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.
  • CopySchemaOct 05, 2004. CopySchema is a utility for copying all the data from one Oracle schema to another. Although similar to the exp/imp and bulk load utilities of Oracle, it has the advantage of offering a simple GUI interface and of handling changes to the schema.
  • Insert Master-Detail Data using Transact-SQLJun 24, 2005. Microsoft SQL Server 2000 SQLXML allows among other things to manage batch operations in a database, which reduces significantly the need of more than one round-trip to a database. OpenXML is a Transact-SQL statement that allows to represent data in XML format and can be used to insert, update, and delete more than one row (represented by an element) in a table or group of tables.
  • Top 10 Reasons to Switch from Java to Visual C#Jun 03, 2006. This article details the major reasons for Java programmers to consider switching from the Java language to Visual C#.
  • System Views and Functions in SQL Server 2005 by Steve on Jul 06, 2006 Jul 06, 2006. I tried to explore some basic TSQL functions and VIEWS in SQL Server 2005. I believe this would be useful when we write DDL-DML Statements.
  • Illustrates the use of the lock in multithreading applicationAug 17, 2006. Any application must have one or more processes. A Process is structural unit with a memory block and using some set of resources. For each executable, the Windows operating system creates some isolated memory block. This article tries to explain the use of lock basics of Multithreading in C# .Net.
  • Enhanced Oracle Explorer in C# and .NET Using Windows FormsApr 27, 2007. This application will allows to do multiple simple activities on oracle database like running select statements and getting selected procedure's definition simultaneously in a thread-based GUI.
  • Generate SQL Statements With Objects, Attributes and ReflectionJun 12, 2007. Create a SQL Command with SQL Statement and Parameters dynamically.
  • Anonymous methods in C#Mar 06, 2008. This article discusses the anonymous methods as a new feature in .NET 2.0, it will show you how to associate a delegate directly to a block of code statements at the time of event registration.
  • 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.
  • Using Statement in C#Feb 09, 2009. This article is about Using statement and how it has been implemented.
  • Search and selection of data using LINQMay 27, 2009. In this article I will explain how you can use LINQ, when we should search and select some data according to parameters, defined by users.
  • Handling the power off button in Pocket PC in C#Aug 18, 2009. In this article we will see How to handle the code if power is being switched off in Pocket PC.
  • SQL Server 2005 features - Part ISep 18, 2009. This article explains about the features in the sql server 2005 with example sql statements.
  • 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.
  • Control Statements in C#Nov 20, 2009. In this article I will explain you about different control statements in c#.
  • Exception Statements in C#Dec 24, 2009. In this article I will explain you about Exception Statements in C#.
  • Try-Finally in C# Dec 28, 2009. In this article I will explain you about Try-Finally in C#.
  • Throw Statement in C# Jan 01, 2010. In this article I will explain you about Throw Statement in C#.
  • 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.
  • The Switch Class in C#Feb 07, 2010. In this article I will explain you about the Switch Class in C#.
  • Programmatically Enumerating, Attaching, and Detaching SQL Server DatabasesApr 14, 2010. This writing is like an encyclopedia for the SQL statements and stored procedures used to enumerate, attach, and detach databases on a SQL Server instance.
  • Goto statement in C#Jul 17, 2010. How to use go to statement in C#.
  • Basics of Data Communication: Part 4Jul 19, 2010. This article will explain about, Transmission Media, Guided Transmission Media, Twisted Pair, Coaxial Cable, Optical fiber, Wireless Transmission media, Multiplexing, Circuit Switching etc.
  • Is it Possible to Use the Select Statement to Access Stored ProceduresSep 07, 2010. In this article you will learn how it possible to use the select statement to access stored procedures.
  • Introduction about Command Design PatternSep 21, 2010. The Command pattern creates distance between the client that requests an operation and the object that can perform it.
  • Performance of If-else if tree vs. Switch (multiple variables) in C#Sep 28, 2010. This article demonstrates multiple ways to implement if-else if tree, when there are multiple values to check, and compares their performance to a switch.
  • AFTER INSERT TRIGGER Example Using the Inserted and Deleted TablesOct 14, 2010. DML trigger statements use two special tables: the deleted table and the inserted tables. SQL Server automatically creates and manages these tables.
  • Using statement in C#Nov 22, 2010. The using statement defines the scope of the object/resource.
  • Named arguments in C# 4.0Dec 02, 2010. This new feature of c# 4.0 allows users to define arguments in the calling statement in any order rather than defined in the parameter list.
  • Rich Internet ApplicationDec 13, 2010. In this article, I am going to cover what makes the people to switch over to Rich Internet Application. Before getting into the picture, first we will see the general architecture of the simple web application.
  • How to: Easily Query a DatabaseFeb 14, 2011. Often there is a need to obtain data from a database and sometimes it becomes hectic to write pieces of code again and again. Like Connection Open statement, Error Message Coding, Connection string etc. This can be optimized by making a class and calling the methods of the class with the appropriate query string.
  • SQL Server: WAITFOR StatementMar 07, 2011. WAITFOR statement used to delay execution of T-SQL command for a specified period of time. This can be used to block the execution of batch statement, stored procedure and T SQL commands for a specified time.
  • Acceptable uses for the goto statement in C#Apr 05, 2011. In those days, he had a point because the 'goto' statement produced a lot of spaghetti code particularly by those using early versions of the BASIC programming language.
  • Show Excel File in ASPX pageApr 08, 2011. In this article I show an Excel file in an aspx page; many times we want to see a large amount of data when running our project, so we switch to Excel file & see the data.
  • How to Use InsertBatch With BSon Serialization in a Mongo database in C#May 17, 2011. In this article I will describe the use of the insert batch statement in a Mongo database for inserting a large amount of data.
  • Case Statement in SQL ServerJun 02, 2011. In this article I will describe the usef of a case statement in SQL Server.
  • SQLCommand Class ConstructorJun 24, 2011. The SqlCommand Class is used for T-SQL, SQL statements and stored procedures to execute against a SQL Server database. This class cannot be inherited because it is a sealed class.
  • Imperative Control Statements in F#Jul 08, 2011. In this article you will learn about F# Imperative control statements which includes if-then, elif, else and looping statements. The people who want to learn F# can have a quick review.
  • How to Save Records at The Time of Adding in LightSwitch Beta 2Jul 12, 2011. Here we will discuss how to save records to the database at the time of adding it.
  • How to Add Custom Control in LightSwitchJul 18, 2011. Today we shall see how to handle custom controls in LightSwitch as a series of articles.
  • Adding Custom Control Dynamically in LightSwitchJul 19, 2011. In this article we shall see about how to add the custom control dynamically to the LightSwitch screen.
  • Application Execution Model in Windows Phone 7Aug 10, 2011. Window Phone 7 (Mango) provides the Fast Application Switching (FAS). With FAS, the user can start a new application and then return to your application without seeing the "resuming…" screen and without a discernable pause.
  • How to handle Property Changed Event in LightSwitch 2011Sep 04, 2011. In this article, we shall discuss about how to handle the Property Changed Event in LightSwitch 2011.
  • How to add Records programmatically into Entity in LightSwitch 2011Sep 05, 2011. In this article we shall discuss about what my colleague has discussed with me for help on his LightSwitch project.
  • Context switching in Windows Phone 7Sep 14, 2011. Very first let us understand what I mean by word “Context Switching“ here? Context switching in context of this post is essentially, navigate back to the page from where the application got deactivated.
  • Format Data on a Screen in a LightSwitch ApplicationOct 23, 2011. Using this article one can format data on a screen in a LightSwitch application.
  • Output keyword in Sql Server 2008Nov 12, 2011. In a simple word we can say OUTPUT clause used with INSERT, UPDATE, or DELETE to identify the actual rows affected by these statements and also used for the auditing purpose.
  • Select, Insert, Update, Delete Using Stored Procedure in SQL Server 2008Nov 16, 2011. Here, we will see how to create select, insert, update, delete statements using stored procedure.
  • How to Export Data from Two Different Entities in LightSwitch Dec 03, 2011. So today I am going to explain how to export data from two different entities [tables] in LightSwitch.
  • Conditional Statements in MySQLDec 07, 2011. In this article we will describe how to use Conditional Statements in MySQL.
  • GROUP BY in MySQLDec 08, 2011. In this article you will see how to use the Group By statement in MySQL.
  • Help and Show Commands in MySQL Dec 12, 2011. This article describes general information about the database and provides help for these commands.
  • How to Work with a ToggleSwitch in Windows Phone 7Dec 14, 2011. In this post I will discuss the Toggle Switch Button.
  • Difference between delete, truncate and drop statements of MySQL Dec 14, 2011. This article explain the difference between the delete, truncate and drop statements in MySQL.
  • How to Check Application Returning from Dormant State in Windows Phone 7Dec 20, 2011. In this article you will see how to check application returning from dormant state in Windows Phone 7.
  • 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.
  • Help Statement in MYSQL ServerJan 02, 2012. This article explains the help statement which provides a list of help categories.
  • DROP in MySQLJan 04, 2012. This article represents how to work the drop statement in MySQL database.
  • 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.
  • Toggle Switch in Windows Phone 7 Messages via WCF ServiceJan 22, 2012. Today, in this article we will dig out on one more interesting implementation in WP7 which whereby gets cross messages from WCF Service based on Toggle Switch Operation.
  • Performing SQL Server Transaction Using ADO.NETJan 31, 2012. A transaction allows you to execute two or more SQL commands in such a way that if any one of the statements fail, then no other statement will change the database.
  • Switch Menu Using JQueryFeb 12, 2012. Switch Menu now supports persistence (so it remembers which menu item was last expanded) whenever you revisit the page. To sweeten the deal, you can choose between "sitewide" and "local" persistence, with the former remembering the menu state across your entire site.
  • Switch Menu II Using JQueryFeb 13, 2012. A Switch Menu is a common UI component in many applications. A number of JavaScript libraries provide a nice and simple Switch Menu.
  • 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.
  • 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.
  • Interlocked Class in c# ThreadingMar 07, 2012. The methods of this class help protect against errors that can occur when the scheduler switches contexts while a thread is updating a variable that can be accessed by other threads, or when two threads are executing concurrently on separate processors.
  • Intersect and Except in SQL Server 2005Mar 11, 2012. This article explains the intersect and except statement in SQL Server.
  • Oracle MERGE Statement - Quick Catch UpMar 14, 2012. In this article we have to describe the Oracle merge statement.
  • Switch Between Metro UI and Desktop in Windows 8Mar 17, 2012. In this article, I explain how to switch between Metro UI and Desktop Mode. Articles also talks about some short cut keys.
  • Use of Applications and Snaps Applications in Windows 8Mar 18, 2012. In this article I will explain how to switch between Application or Snaps Application in Windows 8. If You are using a Metro UI and Desktop, then you are running multiple applications. A Metro application is very simple on the touch screen. You can swipe your finger in the left side or right side in the touch screen.
  • Control Your Remote Control Car With PC KeyboardMar 20, 2012. This is something I have been working with sometime back. Goal is to control my remote control car using my computer's keyboard...Isn’t it cool. I haven’t used any of the complicated circuit’s diagrams etc! Idea is really simple only base theory used is, “a transistor can act as a switch”.
  • Switch Between Windows Accounts and Local Accounts in Windows 8Apr 04, 2012. In this article I will explain how to switch between the Windows Accounts and Local Accounts.
  • Triggers in SQLJun 08, 2012. Triggers are special kind of Stored Procedure that executes automatically when a user tries to modify database.
  • PHP Tutorial 2 - Hello World ProgramJul 16, 2012. This tutorial will guide you to a simple "Hello world" program in PHP; it will also show the use of loop and conditional statements in PHP.
  • Disable Fast User Switching in Windows 8Jul 17, 2012. This article describe how to disable Fast User Switching in Windows 8.

About typescript-switch-statement

NA

SPONSORED BY

File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!
Download Free eBooks