C# Corner

Resources  
  • Printing in C#Jan 26, 2000. An application show you all Printing, Print Preview functionality using C#.
  • 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.
  • Adding Menu Support to a Windows FormDec 18, 2000. This sample code shows you how to use the MainMenu and MenuItem classes to add a menu and click handler for a Windows Form.
  • GDI+ Tutorial for BeginnersDec 26, 2000. GDI+ is next evolution of GDI. In Visual Studio .NET, Microsoft has taken care of most of the GDI problems and have made it easy to use.
  • ADO.NET Database ExplorerJan 20, 2001. The sample connects to the SQL server database and shows you a tree view like interface of all the tables.
  • Database Explorer : Part 2Jan 22, 2001. Attached is a C# program which is a enhanced version of the previous article on ADO.NET.
  • Creating your own cool Volume Control using GDI+Jan 23, 2001. In this article, I'll give you an example of creating your own control.
  • Handling Mouse Events in C#Jan 25, 2001. This article explains how to handle mouse events in C# or VB. In C#, you write a delegate and then write an event handler.
  • Database Explorer-IVJan 25, 2001. This is version IV of the Database Explorer, which include the support for Access Database with SQL Server.
  • PaintBrush in C# - IIJan 30, 2001. This is a PaintBrush Application. In this Paintbrush user can draw some images and he can save the images in a persistence storage and later time can retrive the images.
  • Tutorial: Working with Toolbars in C#Jan 30, 2001. This tutorial explains you how to add toolbars to a form, load images to the toolbar buttons, and writing event handlers for toolbar buttons.
  • SQL Programming using .NETFeb 01, 2001. This program shows several data objects, some draw backs of each and some interesting things.
  • Schedule Program Using C#Feb 22, 2001. The Scheduling program consists of three main classes. The Form, the DatabaseController used to read and write scheduled events into the database and RowData which corresponds to data extracted from a row in the database.
  • Drag and Drop RevisitedMar 13, 2001. I've had a couple inquiries on how to do drag and drop in .NET again, so I've put together a simple app for dragging text from a TreeView to a TreeView and a TreeView to a ListBox.
  • Developing Web Applications in VS.NET Mar 29, 2001. This tutorial describes about Step-by-step tutorial guides you towards developing your first web application.
  • 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.
  • XML Strengths and Weaknesses with DOM, ASP, and XSLApr 30, 2001. In this article we're going to take a look at some of the terminology that comes with using XML and its related technologies, as well as how to create and transform XML documents with XSL using Microsoft's MSXML parser. To test the code samples shown in this article you should be running Windows NT/2000/XP with IIS installed. You should also have SQL server 2000 installed on the same machine.
  • Reminder ProgramJun 08, 2001. The program allows you to set a running timer to remind you of an upcoming event.
  • Working With OleDb Data Adapters Jun 19, 2001. This step by step tutorial guides you to create your database applications using OleDb Data Adapters in VS.NET.
  • 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.
  • 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.
  • Creating a screen saverJun 21, 2001. Creating a screen saver is an interesting topic. A screen saver is a maximized form that contains no borders and caption.
  • Mobile with Access DatabaseJul 14, 2001. Till now we had done the Programming using SQL Server and XML as Database.
  • Developing Windows Applications Jul 23, 2001. This tutorial explains you step by step how to create your Windows Applications using Visual C#.
  • Events and DelegatesJul 26, 2001. Events in C# are based on delegates, the Originator defining one or more callback functions as delegates and the listening object then implements then.
  • Generating XML from SQL databaseJul 30, 2001. Some Days Back i posted the article dealing XML as a Middle tier but i guess the People didn't get the clear funda.
  • Eater Game in C#Jul 31, 2001. This is a simple game written in C# in which the user moves a packman like player around the form and gobbles up red dots. The object is to get all the dots in as quick a time as you can.
  • Printing out your W2 Form using C# and .NETAug 07, 2001. This article covers a fairly practical aspect of using a computer - dealing with forms.
  • Basic Database Operations in ADO.NETAug 08, 2001. This Article will show the basic database transactions select, insert update and delete.
  • Timer Control Aug 22, 2001. The sample project attached with this article shows how to use the Timer control available in .NET and C#.
  • Simple Windows Forms Events and InterfacesSep 03, 2001. This article contains a c# code which makes use of the concepts of Events and Interfaces together.
  • Mouse and Key EventsSep 11, 2001. This article explains the usage of key and mouse events. The following code shows you how you can read mouse position on mouse move.
  • Visual Inheritance in C#-Part1Sep 24, 2001. We all know that Inheritance means a extending a class with more Features without worrying about the implementation of features of hidden inside the class to be inherited.
  • Visual Inheritance Part 2 Sep 26, 2001. We all know that Inheritance means a extending a class with more Features without worrying about the implementation of features of hidden inside the class to be inherited.
  • WinChat For .NETOct 10, 2001. WinChat For .NET is a simple peer-to-peer chatting program that functions very similarly to the WinChat program provided by Windows 2000. It provides all the functionalities that the original WinChat program provides.
  • Calculator in C# (Windows Application)Oct 19, 2001. This is a simple calculator program that was written using Visual Studio.NET and C#.
  • Extended Euclidean AlgorithmOct 31, 2001. Author explains how to implement Extended Euclidean Algorithm in C#.
  • FlashCards Language Program : How to read and save Images in a Sql Server Database using ADO.NETNov 09, 2001. I thought it would be fun to write a simple program that displayed flashcards from a database and at the same time, show you how to read and write images to the database. This program is a simple flashcard program that talks to a single table in a Sql Server Database.
  • Printing a Ruler using C# and GDI+Nov 12, 2001. If you misplaced your ruler, here's an application that will create one for you on your printer!
  • Adding Controls to Windows Forms at RuntimeNov 13, 2001. In this example I'll show how one can create and add controls to their Windows Forms at runtime.
  • Monitoring File System using FileSystemWatcher Class - Part 2Nov 26, 2001. In Part 1, we have seen how to use FileSystemWatcher class. Today I' m giving an example to monitor your file system.
  • Monitoring File System using FileSystemWatcher Class - Part 1Nov 27, 2001. In this article, I am explaining you how to use FileSystemWatcher class. In part 2, a sample application, which helps you to monitor a specified directory.
  • Using Interfaces in .NET RemotingNov 30, 2001. In this article, we will create a remote object that will return rows from a database table. For the sake of simplicity I have used the NorthWind database that is packed with the installation of the Microsoft SQL Server.
  • Event Handling in C#Dec 10, 2001. This article shows you how to write control, mouse, and keyboard event handlers in C#.
  • Observer and .NET event delegatesDec 17, 2001. The purpose of this article is to try to introduce observer pattern and compare it to .NET event delegate handling of notifications.
  • Space Invaders in C# and .NETDec 23, 2001. Yes, the classic arcade game has returned and is appearing in C# Corner complete with sound and authentic aliens and source code. It's not quite as good as the real game, but with a few adjustments it can get there.
  • Data Transfer from SQL Server to ExcelDec 26, 2001. In this application, we will see how we can transfer data from Microsoft SQL Server into Excel spreadsheet.
  • Graphics Programming in C#Dec 26, 2001. The new improved version of GDI is called GDI+. The .NET framework provides a rich set of classes, methods and events for developing applications with graphical capabilities.
  • SharpHSQL - An SQL engine written in C#Jan 08, 2002. .NET! C#! If you haven't been inundated with the marketing of Microsoft's new initiatives, you've been living in your cube without a web connection for quite a while. Like a lot of developers, I had installed the .NET SDK and the Beta 1 of Visual Studio .NET and played with it. However, since its release was so far out in the future and I had deadlines to meet, I soon went back to working with the things my customers needed now.
  • An Animation Component using C#Feb 08, 2002. Sometimes its desirable to get those graphics moving a bit and this article show the control to implement it.
  • 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.
  • FlashCards Language Program : How to read and save Images in a Sql Server Database using ADO.NETFeb 19, 2002. I thought it would be fun to write a simple program that displayed flashcards from a database and at the same time, show you how to read and write images to the database. This program is a simple flashcard program that talks to a single table in a Sql Server Database.
  • 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.
  • 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.
  • Publication Application Developed in C#Mar 07, 2002. This program retrieves publishers, title and author information from the SQL Server "pubs" Database.
  • Creating a SQL Server Database Programmatically using SQLDMOMar 12, 2002. The attached source code creates a SQL Server database programmatically using SQLDMO.
  • Event Handling in .NET using C#Mar 13, 2002. In this article I discuss the event handling model in .NET using C#. The discussion starts with an introduction to the concept of delegates and then it extends that concept to events and event handling in .NET.
  • SQL Server Database ExplorerMar 20, 2002. This application connects to a running SQL Server 2000 and displays all the available databases in it.
  • Peer-to-peer Chat Program using Asynchronous SocketMar 22, 2002. This is a simple chat program, which uses asynchronous socket to provide connection between two machines.
  • Multithreading Part 3: Thread SynchronizationApr 11, 2002. The .NET framework provides a number of classes and data types that you can use to control the access to shared resources. Thread synchronization refers to the act of shielding against multithreading issues such as data- races, deadlocks and starvation.
  • 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.
  • A Database Component: Inserting Serializable ObjectsApr 23, 2002. The attached zip file contains two projects - a database component (DLL) project and a Windows forms project called Test. Both projects are written and compiled using Visual Studio .NET version 1.0.
  • Ripple.NET: A Windows Forms DemoApr 25, 2002. Finally, in the OnPaint Event Handler I clear the Form and step through the rippleLIst drawing each of the RippleObjs in it that has a location Point that's not Empty.
  • Web Services: Basics and Beyond Part 3Apr 30, 2002. This article series shall attempt an explanation that will go beyond the basics of web services.
  • Nemesis-7rc1 ( Codename Deviate)Jun 13, 2002. Nemesis-7 is a full-screen 2D shoot’em up that makes use of the DirectInput, DirectSound and DirectDraw interfaces from DirectX. The player controls a spaceship which he uses to duel the computer opponent. I implemented some artificial intelligence to make the CPU play more human.
  • Editable GridView Control in C# and .NET - Part-III Printing the GridViewJun 24, 2002. In our last two articles, we talked about how to create an editable GridView and how to make it persistent in XML.
  • Key Logger Application in C#Jun 30, 2002. In this article, I'll explain an easy but an important concept of how to catch user pressed keys and write them into a log file.
  • Intellisense: An Example of How to Make ItJul 01, 2002. Auto completing is one way to offer a productive and programmer friendly user interface to programmers and Intellisense feature of Visual Studio .NET is one of them.
  • Imlememnting Drag and Drop in ListView ControlsJul 08, 2002. Drag and Drop operations in Windows can be achieved using 3 simple events - DragEnter, DragLeave, and DragDrop.
  • Writing a Single Event Handler for Multiple ControlsJul 22, 2002. Writing a Single Event Handler for Multiple Controls by Giuseppe Russo. Jul 22, 2002. I have noticed that in many articles, I read, people use a longer method of clearing many textboxes, as well as handling more than one control at the same time.
  • 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.
  • Sharp HSQL- An SQL Engine Written in C#Aug 01, 2002. .NET! C#! If you haven't been inundated with the marketing of Microsoft's new initiatives, you've been living in your cube without a web connection for quite a while.
  • Master-Detail Display Using Nested Repeater Web Forms ControlAug 05, 2002. In this example, we will create a web page that displays a formatted view of data with a master detail hierarchy using nested Repeater controls. We will use the Northwind sample for our example. There are many different ways to accomplish this task.
  • Using Installer Classes to Ease Deployment in VS.NETAug 07, 2002. In this article I will demonstrate how to incorporate installer classes with your Visual Studio .NET msi's to handle any supporting tasks that your assemblies may need.
  • DataGrid Customization Part-IV:Exchanging a DataGrid Columns using Drag and DropAug 21, 2002. This article covers customized sorting and a DataGrid column hiding programmatically.
  • User Management Utility for Web Form AuthenticationSep 06, 2002. This article deals with the management of user login and password information for a Forms Authentication in ASP.NET.
  • SMTP and POP3 Mail ServerSep 13, 2002. This is simple implementation of SMTP and POP3 server. Two new features are added to the original code.
  • Using SQL in .NET: Part 1Oct 04, 2002. In this article, I will show you how to execute SQL queries from your C# applications.
  • Customize User Interfaces and Pass User Input to Installer ClassesOct 29, 2002. In this article I am going to demonstrate how to customize your MSI install to prompt the user for some information and then pass this information to an installer class. This can be useful when needing to do something during an install based on the user input.
  • The NeFs Application Demo Part 2: Designing Application Oriented Server ControlsOct 31, 2002. This article is part II of a three part demo application dubbed Net-Worked Financial System written in C# and .NET framework.
  • Data Access with ADO.NETNov 04, 2002. This first article will provide a brief history of data access as well as provide the basic flow for using ADO to access data.
  • Drag and Drop using C#Nov 13, 2002. To allow your program to accept files using the drag and drop, you must first pick a control that you wish to be able to accept them.
  • 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.
  • DigitizeAny - A .NET Windows Digitization ToolDec 17, 2002. DigitizeAny uses Win32 API calls to obtain the coordinates of the cursor and then translates to the graph coordinates once set. Since a mouse click would essentially bring to focus the window where it is pointed to, this tool uses the key event to capture the coordinates of the cursor.
  • Using Remoting to Implement Distrubuted LoggingDec 20, 2002. In an earlier article we had discussed how new tracing and debugging techniques in .NET make debugging easier. In this article we will view the event logging API that comes with .NET.
  • Event Logging in .NET: Using Remoting to Implement Distributing LoggingDec 20, 2002. In this article we will view the event logging API that comes with .NET.
  • 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.
  • Events in C# Advanced - Lesson2Jan 02, 2003. In the previous lesson we created an event and consumed it. In doing so you probably noticed that our code would have been a little better if we could have determined whether or not the file actually existed.
  • 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.
  • 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.
  • Recording Sheet Music Using C# and .NETFeb 07, 2003. This is a article that allow you to record and replay the music you performed on the piano.
  • 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.
  • Mask Edit ControlMar 05, 2003. This control is a attempt to emulate the Marked Edit control available in VB 6.0. MaskEdit control extends the TextBox System.Windows.Forms.TextBox control available in Microsoft .NET library.
  • Math Equation Editor in C#Apr 07, 2003. The Equation Editor I created in C# allows you to create a few simple equations using the keyboard. With the editor you can open and save files of your equations.
  • Basics of Extending Your Working Environment in Visual StudioApr 10, 2003. Visual studio.net offers a wide variety of options, which enable the user to create custom and personalized Visual Studio working environments.
  • 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.
  • Using OLEDB in ADO.NET with COBOLApr 16, 2003. The SqlClient class was created by Microsoft and is used primarily to access a SQL Server database.
  • Extending Your Working Environment in Visual Studio - AdvancedApr 24, 2003. In my previous article, you learned about how to create wizards and some simple objects such as DTE, Solutions, Project and Project Item. These objects help us to customize our Visual Studio working environment.

About Extended-Event-in-SQL

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!
techbash 2016