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.
  • ColorDialog : How to use?Dec 21, 2000. Changing color of your Window and its controls is a piece of cake in C# using ColorDialog class.
  • A Database Access Class with Overloaded SELECT StatementsJan 24, 2001. A useful database access class with overloaded SELECT and other statements.
  • Using the ref ParameterMar 06, 2001. The ref keyword on a method parameter causes a method to refer to the same variable that was passed as an input parameter for the same method. If you do any changes to the variable, they will be reflected in the variable.
  • Testing .Net Components Using NUnitMar 08, 2001. Write unit tests before starting development". Writing test allows me to see immediate results of every code change.
  • Defining Custom Entry PointsApr 30, 2001. In this article i am going to demonstrate how we can manipulate the IL code to change the behaviour of how the .NET programme executes.
  • 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.
  • ADO.NET: What's changed in .NET Beta 2?Jun 20, 2001. ADO.NET API is one of the changed APIs. In this article, I've covered some of ADO.NET changes in Beta 2.
  • 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.
  • Using ref and out ParameterJun 20, 2001. When we pass a parameter as ref to a method, the method refers to the same variable and changes made will affect the actual variable.
  • C# Language changes from .NET Beta 1 to .NET Beta 2 Jun 22, 2001. This article contains C# language changes from Beta 1 to Beta 2.
  • Time Ticker2Jul 04, 2001. Microsoft had made lot of Changes for Beta2, some of the changes are old Namespace such as System.WinForms modified to System.Windows.Forms. In addition no. of new Namespaces like Microsoft.CSharp, Microsoft.JScript, Microsoft.Vsa etc...
  • PDF File GeneratorJul 26, 2001. PDF documents are the now a days is standard in Documents Exchange over the internet,as these documents are more or less platform independent and can be viewed on virtually any platform without any formatting or changes in the file structure.
  • Difference Using Directive and StatementJul 26, 2001. This article explains difference between using directive and using statement with sample example.
  • Messaging between Threads using Message LoopAug 20, 2001. MessageLoopLib is a stripped down version of a complete, threading communication subsystem Ive written. This implementation is a single thread created in the GUI constructor. Ive dropped all thread management and have had to change some of the message code to accommodate this.
  • Scribble in C#Aug 24, 2001. Here is a simple scribble C# program you can change the color and the pen width.
  • 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.
  • TCP Client and ServerSep 20, 2001. You need to compile the server and the client programs separately. Before compiling, change the IP address in both programs to match that of your machine (NOTE: You can get IP address of your machine if you run 'ipconfig' from the command prompt in Windows NT/2000 m/c's)
  • 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++.
  • A Wheel Control in C#Feb 15, 2002. This article describes a simple Windows control written in C# that simulates a wheel knob like that on your walkman used to change volume.
  • 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.
  • .NET Beta 2 and Navigation in XML DocumentsMar 13, 2002. .NET Beta 2 was released yesterday at tech-ed, 2001, Atlanta. Many things have been changed in Beta 2 since Beta 1. In this article, I'll cover changes in XmlNavigator class replaced with XPathNavigator.
  • Using XML Based Configuration File in Windows Form ApplicationsApr 15, 2002. Often when building an application, a programmer wants to be able to change application settings without having to recompile the application.
  • Tracking Time in a Window ApplicationApr 15, 2002. The program reads from an XML file to get the data about names and birth dates, so it is easy to add or remove names without changing the code in case my son decides the program should include his pet dog or turtle.
  • An Editable GridView Control in C# and .NET - Part 1May 28, 2002. I've gotten a lot of e-mail about my GridView control Article, so I've decided to write a follow up article on a more powerful control that allows you to edit the cells within the control and change the colors of the cells.
  • Developing XP Style ApplicationsJun 26, 2002. Since Windows 95, Microsoft has always changed the styles of its GUI, but with Windows XP, the changes are very profound.
  • 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.
  • Changing User Information using Active DirectoryAug 14, 2002. If your company is one of the lucky? Ones to implement Windows 2000 Active Directory you may have been looking for a way to populate it with data. Perhaps adding people’s details from a file directly into the active directory.
  • Using DTS from C#Sep 16, 2002. In this article I will concentrate on enumerating, executing and changing properties or global variables of DTS package.
  • Customizing Default Project SettingSep 26, 2002. "How do I change the default exe name of my project?". I received this question in an email.
  • Platform Invoke Sample - Changing the Desktop WallpaperSep 27, 2002. In this example we will see how to change the Desktop wallpaper by invoking a Windows API function from C#. The Platform Invoke mechanism allows you to access unmanaged functions implemented in dlls.
  • Drawing Shapes using ThreadingOct 25, 2002. This is simple multi-threading program that draws circles and rectangles. Each shape is handle by individual thread that created every time you press start button. Using sleep method on each thread we can change the speed of each shape.
  • Function to Change a Block of Text to Title CaseNov 20, 2002. Function to change a block of text to Title Case.
  • 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.
  • Events in C# Made Easy - Lesson1Jan 02, 2003. Events are useful for updating a user interface with changed data, or causing a piece of code to run after another piece of code has completed. .NET has brought us a powerful model for programming events.
  • 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.
  • .NET Framework Version 1.1 - Side-By-Side ExecutionApr 11, 2003. Microsoft has announced the release of the new version of the .Net Framework 1.1. As with almost everything in life, the only constant is change.
  • Change Color of a Column Based on Column ValuesMay 15, 2003. In this article we'll see how to change the color of column based on the column value.
  • Formatting ASP.NET DataGrid's DataJun 17, 2003. This article shows you how to change the color of a DataGrid row and format of date.
  • Changing the default limit of 25 threads of ThreadPool ClassJun 19, 2003. The Threadpool is useful for managing threads that are usually in a wait state and that take only a short amount of time to do their work. If still you would like to change the default limit of 25 threads then here you go.
  • How to Change DataGrid Header Text?Jun 30, 2003. This article shows you how to change the header text of a DataGrid programmatically.
  • 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.
  • 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.
  • DataTable in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataView in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataTable Events in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • Constructing a DataTable using C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataSet in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • Data Binding in DataGrid Control using C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataAdapter in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataReader in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • Introduction to GDI+ Transformations Apr 01, 2004. A transformation is a process that changes graphics objects from one state to another. Rotation, scaling, reflection, translation, and shearing are some examples of transformation. Transformations can be applied not only to graphics shapes, curves, and images, but even to image colors.
  • Advanced Notepad in C#Apr 13, 2004. This is an advanced version of Notepad that allows you to search, replace, change background and foreground text color. It also provides registry editing options.
  • Using the Tablet PC as a Flashing Restaurant Menu in C# and .NETJun 08, 2004. This is a simple application written for a restaurant using Tablet PC that allows you to list such things as lunch specials and have the colors on the board change randomly to produce an interesting flashing sign effect.
  • Refactoring in Visual Studio 2005Jun 11, 2004. Refactoring allows developers to use the built-in feature of Visual Studio to rename and convert and change the signatures and definitions of a class members. In this article, I will show you how refactoring feature provided by Visual Studio 2005 can be a handy tool when you are reorganizing or optimizing your existing projects.
  • Difference between passing reference types by ref and by valueSep 02, 2004. We all know the difference between passing value types byval and byref, if the variable is passed byval any change to the variable value in the called function is not reflected back in the callee.
  • CopySchema - Part 2Oct 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.
  • 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.
  • Coloring the Console in C# Oct 25, 2004. When working with console applications in C#, you always see a black and white screen. What if we want to change the background color of the console? We can change the foreground and background color of our console application by using win32 API SetConsoleTextAttribute().
  • How to Populate a DropDownList insides a DataGrid through an XML FileNov 16, 2004. In this article, we will show how to fill a DropDownList inside a DataGrid through an XML file. We will also show how the contents of one DropDownList changes dynamically as we change the index of second DropDownList (both inside the grid).
  • Data Access Layer to execute Stored ProceduresJan 18, 2005. This article explains about executing a single stored procedure or batch of stored procedures from the application layer. As Data access layer completely decoupled from Application layer we just need to change the Application layer in case of any change in underlying database 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.
  • Building WebParts in ASP .Net 2.0Aug 08, 2005. Web Parts is a framework built into ASP.NET 2.0 for building highly customizable portal-style pages. End users can customize Web Parts pages by changing the page layout, adding and removing Web Parts, editing Web Parts properties, establishing connections between Web Parts, and more. I would like to share how to build web parts in ASP .Net 2.0. I am providing the source code of application as well.
  • New Dataset features in ADO.Net 2.0Aug 22, 2005. ADO.NET class libraries are used for accessing data from a wide range of data sources. One of the best features in ADO.Net is DataSet.Even though it was an exciting feature, performance was a concern with DataSet. Lets look some changes made to DataSet in ADO.Net in this article.
  • Working with Drawing ClassOct 27, 2005. This article gives an overview to work with drawing and printing class. It explains how to use various methods in the drawing and printing class.
  • New IDE Features in Visual Studio 2005Nov 10, 2005. Visual Studio 2005 aims to simplify the development process thereby adding many new features to simplify the overall development experience. This article aims to discuss all major IDE related changes in Visual Studio 2005.
  • Utilize the Full Functionality of the Whidbey File ManagementNov 15, 2005. This article is based on a pre-release version of Microsoft Visual Studio 2005, formerly code named "Whidbey". All information contained herein is subject to change.
  • ColorReliefButtonDec 14, 2005. My idea was to create a button that can be used as a colourful decoration for any application. The look of the ColorReliefButton can be determined by changing property values. The main attraction should be a cool look (Relief) of the controls text. Like this almost any font (TrueTyp) can be used to decorate a button and there is no need to use bitmaps.
  • ADO.NET Enhancements in .NET Framework 2.0 for SQL Server Data Provider: Part IIJan 05, 2006. ADO.NET 2.0 includes enhancements for SQL Server client application developers. Understanding these enhancements will help you design and implement effective client applications on the .NET Framework 2.0 platform
  • Wrapper Patterns in C#: Part IFeb 13, 2006. Did you ever wish for a superhuman power to be impervious to bullets or travel outside your body? How about the superpower to be able to breathe underwater or fly? Or how about a changing the way you look so you can disguise yourself as anyone, or anything? In this series of four articles, we will travel down the C# wrapper rabbit hole and see how it is all possible with some patterns: Proxy, Decorator, and Adapter.
  • Wrapper Patterns in C#, Part II: The Proxy PatternFeb 14, 2006. Did you ever wish for a superhuman power to be impervious to bullets or travel outside your body? How about the superpower to be able to breathe underwater or fly? Or how about a changing the way you look so you can disguise yourself as anyone, or anything? In this series of four articles, we will travel down the C# wrapper rabbit hole and see how it is all possible with some patterns: Proxy, Decorator, and Adapter.
  • Wrapper Patterns in C#, Part III: The Decorator PatternFeb 15, 2006. Did you ever wish for a superhuman power to be impervious to bullets or travel outside your body? How about the superpower to be able to breathe underwater or fly? Or how about a changing the way you look so you can disguise yourself as anyone, or anything? In this series of four articles, we will travel down the C# rabbit hole and see how it is all possible with some wrapper patterns: Proxy, Decorator, and Adapter.
  • Controlling behavior of existing services in systemFeb 23, 2006. This article shows how to access the windows services in your system and change the behavior of the services from your application.
  • Custom Drawing Cursors in C#Mar 14, 2006. Some time ago I have decided to try to make something like a "Photoshop" in C#. The first problem has appeared was custom cursors. If you are familiar with "Photoshop" you know that when you change brush size the cursor size also changes. This is solution to make this possible in C# .
  • How to Upload or Change an image in the Crystal Report at runtimeMar 20, 2006. This article will demonstrate how a user can customize the crystal report by uploading an image from the local computer.
  • Deploying ASP.NET 2 Web Site to Production Server: Part IIApr 10, 2006. On the first part we discussed in detail how to move our database which contains the membership tables from the default aspnetdb Database to our database. On this part we will show how to change the default settings of asp.net membership and role providers to read from tables which stored on our database.
  • OnChanged Event for User ControlsMay 09, 2006. In this article I will show some ways how to create user controls with OnChanged event . The examples are written using C# for Windows applications.
  • Email notification of FileSystem changes in C#Jun 16, 2006. This article tells us how to create a windows service to get notifiactions of filesystem changes remotely.
  • 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.
  • Tip: How to format a column value of a Report programmatically?Jul 21, 2006. In one of my reports, I had to change the format of a column programmatically depending on the value of the column.
  • The .NET 2.0 Framework Provider PatternAug 11, 2006. The Provider Model Design Pattern was first introduced with the .NET 1.1 framework, specifically in the ASP.NET starter kits and was formalized in ASP.NET Whidbey as a membership management provider API (Application Program Interface). It's primary purpose is to separate the definition for an API from the implementation. This keeps the API flexible by enabling the core functionality to be flexible and easily changed.
  • 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.
  • Changing XSL StyleSheets on the FLY in C# and ASP.NETSep 26, 2006. This article shows you how you can use alter XSL in memory to transform XML data into HTML with different results.
  • How to change screen resolution in C#Oct 13, 2006. All programmers are facing common problem is how to change screen Resolution dynamically. In .Net 2005 it's very easy to change the screen resolution. Here I will explain you how can we get the Screen resolution and how we will change the resolution at dynamically and while unloading the page it will come as it was before. In dot net we can access the values of user's screen resolution through the Resolution class. It also affects all running (and minimized) programs.
  • Tip: How to change the text of Legends in Crystal Reports?Oct 17, 2006. This tip shows you how to change the text of Legends in Crystal Reports?
  • Tip: How to conditionally change the color of a Chart in Crystal Reports?Oct 18, 2006. This tip shows how to change the color of a Chart in Crystal Reports based on some conditions.
  • Tip: How to change the color of Chart Bars in Crystal Reports?Oct 20, 2006. This tip shows you how to change the color of a chart bars in Crystal Reports.
  • A guide to ObjectDataSource controlNov 17, 2006. One of the best new features of the forthcoming ASP.NET 2.0 will be the ObjectDataSource control. However, as I found out in my experimentation what seems like a simple control has some complex behaviours to master to get it working properly. If (like me) you have an existing data access layer you may have to make changes to be able to use ObjectDataSource.
  • Detecting File Changes using FileSystemWatcherMar 20, 2007. This article is about detecting file changes like file renaming, file creation, deletion and changes in a folder using FileSystemWatcher class.
  • Change SQL Server 2005 SA PasswordMar 22, 2007. This Article shows how to change the password of any account in SQL Server.
  • Concurrency violation: the UpdateCommand affected 0 records. Mar 27, 2007. When you use a DataAdapter object to write changes back to a database by means of a stored procedure, you may receive the following error message: Additional information: Concurrency violation: the UpdateCommand affected 0 records.
  • Validating the Date in a Date Time Picker ControlMar 27, 2007. This is another short article on the date time picker control. This article will address an approach that may be used to require the user to confirm changing a date.
  • How to Swap Two Rows of listview in Upward/Downward DirectionMar 29, 2007. This article describe how two data rows of a listview are changed.
  • 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.
  • A Scrollable MessageBox in C#Jul 30, 2007. This article demonstrates how to create a message box that contains messages that scroll. This message box also allows you to read the message in from a file as well as change fonts and color properties.
  • Using SQL Server 2005 system SP to change extended property values of database objectsAug 01, 2007. In this article, that is the logical continuation of the earlier published articles, I will show how you can update the value of an existing extended property or add a new extended property to a database object with the help of the system stored procedures of SQL 2005. The examples are written using T-SQL.

About change-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