C# Corner

Resources  
  • Read Microsoft Access Database in C#Jan 01, 2000. How to connect and read data from a Microsoft Access (.mdb) database using ADO.NET and C#.
  • CSDownloadURL : Download Contents of a Web PageDec 03, 2000. CSDownloadURL is a class which has two functions - SetURL and DownloadURL. The set URL sets the current URL and GetDownload downloads the URL contents and returns its contents in a string.
  • 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.
  • Add, Edit, Delete, View data using ADO+Jan 04, 2001. Free to use Tutorials on using ADO+ on Microsoft's .NET Platform in C# as programming language.
  • 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.
  • Get a database table propertiesJan 22, 2001. Get a table properties such as column names, types etc using DataColumn and DataTable.
  • 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.
  • A Database Access Class with Overloaded SELECT StatementsJan 24, 2001. A useful database access class with overloaded SELECT and other statements.
  • Database Explorer-IVJan 25, 2001. This is version IV of the Database Explorer, which include the support for Access Database with SQL Server.
  • Timer in C#Jan 26, 2001. An article with sample project explains how to work with the Timer control in C# and .NET to write to a text file after few seconds.
  • Implementing Delegates in C#Feb 04, 2001. The Zip file contains two projects. One is VB.Net and the other is C#. Each project is an example of the same use of a delegate. A base class is derived and the delegate calls a method on several classes derived from the base class.
  • Implementing Delegates in C# : Part 2Feb 13, 2001. This is second part of Timothy's Delegates in C# series...
  • 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.
  • Effective C#: Working with StringsMar 12, 2001. Using string might degrade the performance of your application. This article explains about what precautions you should take when you are going to use strings in your application.
  • Write Relational Data to an XML FileMar 15, 2001. This article shows you how you can write data from a database to an XML file using DataSet.
  • View Relational Data in a DataGridMar 15, 2001. This article explains you how easy is reading a database and displaying in a grid using DataSet.
  • Programming in ADO.NETMar 19, 2001. A simple example shows you how to read a database table in a dataset and display in a list view control.
  • ADO.NET DataSet ProgrammingMar 20, 2001. A sample project shows you how to add, edit, delete, navigate, save records in a database using DataSet.
  • Mail Merge Program - Part 2Mar 21, 2001. This is a simple mail merge program (Part 2). This program reads from the access database (by default) from a specified table.
  • Text to HTML ParserApr 05, 2001. If you have been into developing Web Applications then you might have at many times experienced that when you display multiple lines of data from a database you loose the spacing or formatting between multiple lines of data.
  • Connect to an Oracle DatabaseMay 03, 2001. This sample code shows you how to connect to an Oracle database using C#.
  • SQLDataReader Vs. DataSetMay 11, 2001. To compare and contrast SQLDataReader and SQLDataSetCommand.
  • Transaction Web SiteMay 16, 2001. When I started working with this technology I faced a problem dealing with session as in any transaction or Database oriented portal this is a must requirement to deal with.
  • Flames for FunMay 31, 2001. This is my second application using C#. In this Application I used GDI+.
  • Validation Contol in Mobile FormJun 04, 2001. In this article i'll be showing the power of Valiation Control which u can use with Mobile Application.There are total six Valiation Control as provided. Here i am showing four of them in this example and the rest two are Valiationsummary and CustomValidator.
  • 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.
  • Snooping on C#.NET Regular ExpressionsJun 26, 2001. I present here two micro test utils, which will let you play with regular expressions. Regular expression( System.Text.RegularExpressions.Regex ) is a powerful class very useful for parsing, splitting or replacing texts.
  • XML as Middle TierJul 12, 2001. There is always been a need that there will be an intelligent middle Layer between Database Server and the UI Code. There are many ways but one fantastic approach came in picture with the XML.
  • Mobile with Access DatabaseJul 14, 2001. Till now we had done the Programming using SQL Server and XML as Database.
  • 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.
  • strnicmp equivalent in C#Aug 07, 2001. C# equivalent strnicmp function in C language. It accepts two input strings along with the number of positions of chars to compare.
  • Basic Database Operations in ADO.NETAug 08, 2001. This Article will show the basic database transactions select, insert update and delete.
  • CDataService: A Generic Database Access ClassAug 09, 2001. Using a generic database access component in data-aware applications can simply development and separate data tier from business tier.
  • Creating Dynamic Web Quizzes using C# and ASP.NETAug 15, 2001. This article describes how to create a web quiz from the information in a database.
  • Basic Database operations using ADO.NETAug 21, 2001. I found very interesting database features incorporated into the .NET as ADO.NET.
  • Web Services between .NET, Java and MS SOAP Toolkit: Part 2Aug 24, 2001. This second article in this series dedicated to Web services comes as a sequel to the first one in which I started to tell you how you could build different kind of clients and services using MS SOAP Toolkit, Apache SOAP for Java and .NET Framework.
  • Web Service Between .NET, Java and MS SOAP Toolkit - Part IIAug 24, 2001. Second article in this series dedicated to Web services comes as a sequel to the first one in which I started to tell you how you could build different kind of clients and services using MS SOAP Toolkit, Apache SOAP for Java and .NET Framework.
  • Validation Controls in Web Forms: Part IAug 24, 2001. Validation is one of the less talked about areas – often taken for granted.
  • 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.
  • Passing Const Parameter to Functions in C#/C++/VB ComparedAug 30, 2001. Parameter passing to a function is extremely important in all programming languages. The desire to keep the passed parameter intact forced the compiler designers to add various keywords to the programming languages.
  • Accessing Oracle DatabaseSep 21, 2001. This source code shows you how to connect to an oracle database and do operations such as select, insert, update and delete.
  • A Simple Multi-threaded TCP/UDP Server and Client V2.Sep 24, 2001. This is the second version of my client/server program. The server and the client can be run on the same machine or on different machines. The following is the brief description of the server and the client programs specifically.
  • Oracle Database ConnectivitySep 26, 2001. This is a GUI based data entry application which shows how to add, modify and delete records using Oracle Database.
  • File Uploading using XMLOct 09, 2001. This application is in ASP.NET which will allow you to upload images to an XML file which serves as the database for the uploaded files.
  • Query BuilderOct 17, 2001. This application is that of a QueryBuilder in CSharp.This application is for Beta2 SDK version of DotNetFramework.
  • Oracle Database ViewerOct 17, 2001. This is a GUI based application which connects to an Oracle database depending upon the DSN, username and password that you provide. It then shows the list of tables on the left hand side in the form of a treeview.
  • Mapping Objects to Relational DatabasesNov 01, 2001. The application generates C# Class files for each table in a relational database. I have used Mysql and ODBC.NET for this project. The application only supports MySQL right now.
  • 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.
  • Network Programming in C# - Part 1Nov 12, 2001. The .NET framework provides two namespaces, System.Net and System.Net.Sockets for network programming
  • Network Programming in C# - Part 2Nov 12, 2001. This is the second part of the series of articles about the network programming with C#.
  • Exceptions and Exception StackNov 16, 2001. The purpose of this tutorial is to explain firstly how you would go about creating your own set of exceptions to trap error conditions that could occur in your code or library, for your own benefit or for the benefit of another developer using your library. The second lesson is on how the C# exception stack works, and how you can use it to catch all types of exceptions.
  • 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.
  • Debug Troelsen's .NET books (1): IEnumeratorDec 10, 2001. This article examines code problem in chapter 4 (for C#)/chapter 5(for VB.Net) of the two .Net books.
  • 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.
  • Developing a Record Navigation Form with Unbound ControlsDec 26, 2001. Developing a record navigation form with unbound controls. The form enables you to navigate through the records one at a time. In this application we have used a combo box, two text boxes and various command buttons.
  • Deevloping a Banking System using VS.NET and Windows FormsDec 26, 2001. This article also focuses on deploying multiple windows forms and shows how to navigate between them.
  • Adapter Pattern in C#Jan 03, 2002. The Gang Of Four (GoF) defined the Adaptor pattern as follows in their most famous book "Design Patterns" Gamma et al. Adapter lets classes work together that couldn't otherwise because of incompatible interfaces."
  • Overview of Automated TranscationsJan 04, 2002. Two or more .NET Framework objects can participate in the same transaction. One or more .NET Framework objects can participate in the same transaction as one or more COM+ objects. All objects must be hosted in Microsoft Windows 2K Component Services so as to receive services such as transaction processing.
  • Bridge Patterns in C# Jan 17, 2002. Bridge Pattern is commonly known as Handle/Body idiom in C++ community. This pattern is used for decoupling an abstraction from its implementation so that the two can vary independently.
  • C# Discussion Forum from Harrison LogicJan 29, 2002. Threaded Discussion Forum that utilizes the .NET framework, with C# as the ASP.NET server side language. Uses MS Access Database for data.
  • Data Binding in DataGrid Control - Part 1Feb 05, 2002. When it comes to data-bound controls and database programming, DataGrid control is the most versatile , powerful and flexible control available in Visual Studio .NET.
  • Working with Strings in VB.NETFeb 05, 2002. This article is VB.NET version of Working with Strings in .NET using C#.
  • 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.
  • xBase Engine for C# and VB.NETFeb 25, 2002. This library is written to handle DBF files from C# or VB.NET applications.
  • Transcations in Web Services - Part 1Feb 26, 2002. I believe most of the database developers are familiar with transactions. Transactions are one of the common activities a database developer has to deal with. Transactions are also used in Web Services.
  • Sorting Object Using IComparer and IComparable Interfaces Mar 01, 2002. The System.Collections namespace contains interfaces and classes that define various...
  • Authenticate Web ServiceMar 04, 2002. In this example we will build a web service that authenticates userid and password from an a very simple MS Access database. This web service exposes only one method to the client.
  • 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.
  • JIT CodingMar 11, 2002. One not so well known feature of .NET platform is possibility to invoke compiler and practically create code and assembly from running instance of application. It is possible to do that in two ways. First one is a bit simpler and involves namespaces System.CodeDom and System.CodeDom.Compiler, second one is more efficient and utilizes namespace System.Reflection.Emit. Since there are very few examples about how to use System.CodeDom.Compiler I will start with it.
  • A Shaped Windows Forms Application with Variable OpacityMar 11, 2002. This application demonstrates two simple techniques that beginners might find useful in developing creative new looks for Windows applications.
  • Creating a SQL Server Database Programmatically using SQLDMOMar 12, 2002. The attached source code creates a SQL Server database programmatically using SQLDMO.
  • Boxing and Performance of CollectionsMar 14, 2002. In this article, I will compare some performance issues of values and references types during boxing and unboxing operations.
  • Sending Windows Message in C#Mar 14, 2002. This sample code shows how to send Window messages between two forms using C#.
  • 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.
  • Saving and Reading Object to/from a DatabaseMar 25, 2002. An object is a memory stream, which is hard to write using the normal methods. In this article, I show how you can save objects in a database and read back from the database.
  • .NET Remoting: The Interface ApproachMar 26, 2002. In this article, we will create a remote object, and access this object using the Interface. The object returns rows from a database table.
  • Reflecting Data in .NET Classes - Part IV: From Database TableApr 08, 2002. In this article, we will be looking at how to "reflect" data from the most common data source - Database tables.
  • Creating Graphics with XMLApr 09, 2002. This article shows how to create images on the fly and uses XML to specify the properties of the images.
  • XML Schema ValidatorApr 16, 2002. The XML Schema Validator checks if a given XML document is well formed and has a valid schema model.
  • Outlook Bar ControlApr 18, 2002. This is a simple control similar to the OutlookBar. The attached zip file contains two Visual Studio .NET projects.
  • Drawing B-Spline CurvesApr 22, 2002. The attached source code project draws spline curves between two points.
  • 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.
  • ADO.NET From Windows DNA's PerspectiveJun 12, 2002. Windows DNA is a framework to build multi-tier, high performance, scalable distributed applications over the network. This article takes a Windows DNA perspective and compares how ADO.NET fits in Windows DNA.
  • Understanding Destructors in C#Jun 18, 2002. This article is about understanding the working concept of destructor in C#. As you read this article you will understand how different is C# destructor are when compared to C++ destructors.
  • An Editable GridView Control in C# and .NET - Part IIJun 19, 2002. In this article we will take advantage of the XML classes available to us to persist the GridView control that we talked about in our first article in this series. The two classes we utilize in our code are XmlTextWriter and XmlTextReader.
  • An Editable GridView Control in C# and .NET - Part II Persisting in XMLJun 19, 2002. In this article we will take advantage of the XML classes available to us to persist the GridView control that we talked about in our first article in this series. The two classes we utilize in our code are XmlTextWriter and XmlTextReader.
  • Communication Between Two FormsJun 24, 2002. The aim of the program is to send a message between different forms.
  • 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.
  • Communication Between Two Forms: Part-IIJun 24, 2002. Last time I wrote about the possibility of sending a string from a textbox in one form to another.
  • Deploying a COM Component from C#Jul 08, 2002. Here is some code to help you to deploy a COM component from C#. I needed to programmatically deploy a project that would be registered as COM object (not COM+) and be installed into GAC. The following two classes will help in this objective.
  • Writing a Generic Data Access ComponentJul 17, 2002. OK, I've received couple of emails people asking me how can they use a common data provider to access various types of data sources without loosing the power and flexibility of native data provider libraries.
  • Validation Server Controls in Web FormsAug 05, 2002. When working with Web applications, developers need to write two separate codes using Java Script and VB Script to validate user inputs.In this article we are going to see, how we can reduce the programmers effort on coding, reducing the execution process time and simplify the code handling and less number of lines in the coding.
  • 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.
  • RSS Feed Project in .NETAug 19, 2002. The RSS Feed project is aimed as demonstrating writing C# code to consume RSS feeds from the internet and putting the data from these RSS feeds into a database for you to use in your own applications.
  • DataGrid Customiztion Part-III:Implementing Search Feature in a DataBound GridAug 21, 2002. In this article, I will show you how to exchange two DataGrid columns by dragging and dropping.

About Compare-the-Schemas-of-two-Databases

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