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#.
  • 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.
  • A Database Access Class with Overloaded SELECT StatementsJan 24, 2001. A useful database access class with overloaded SELECT and other statements.
  • 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.
  • Database Explorer-IVJan 25, 2001. This is version IV of the Database Explorer, which include the support for Access Database with SQL Server.
  • New Modifiers in C#Jan 26, 2001. If you come from a C++ or Java background to C# then you will of course notice some strange keywords introduced to this new language, especially the "new" and "override" modifiers.
  • Chat Server and Client in C# Using Remoting TechnolgyFeb 16, 2001. The application is a simple Chat server and Client, which is conversion of Java RMI chat server and client. The Java client was a Applet and present application client in WinForm.
  • Chat Server and Client in C# Using Remoting TechnologyFeb 16, 2001. This application is a simple Chat server and Client, which is conversion of Java RMI chat server and client. The Java client was a Applet and present application client in Windows Forms.
  • 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.
  • Sticky NotepadMar 05, 2001. I wanted to experiment with writing a program that would run from the "System Tray" of window (that's where you have the date displayed...) since that's not possible with pure Java.
  • 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.
  • 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.
  • 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.
  • Introduction to SOAPMar 22, 2001. Since the release I have been fascinated with this thing called SOAP, This bubbly new protocol backed by the power of XML is certainly going to make waves in the world of distributed computing. The first thing which comes into our mind is “Why the heck we didn’t think of this before?
  • 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#.
  • Line numbering utility in C# and JavaMay 08, 2001. After reading this article Java programmers should be able to decipher and de-jargonize the .NET architecture and relate it with the proposed ECMA standard.
  • Line Numbering Utility in C# and JavaMay 08, 2001. This is the first of the series of programs I wish to write to help myself get a handle on C#.
  • .NET framework comparison with Java ArchitectureMay 08, 2001. This article outlines Microsoft's proposed standardization of .NET framework in ECMA forum as CLI (Common Language Infrastructure), but the Microsoft documentation refer this as CLR (Common Language Runtime).
  • SQLDataReader Vs. DataSetMay 11, 2001. To compare and contrast SQLDataReader and SQLDataSetCommand.
  • Will Java and .Net Framework Co-exist?May 15, 2001. The article begins by briefly probing what constitutes the Java platform and .NET framework.
  • 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.
  • 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 ..
  • 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.
  • Net DDE to DOTNET RemotingJul 02, 2001. This article travel through time to trace the genesis of Dot Net Remoting right from RPC to RMI till SOAP.
  • 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.
  • Calling Java Program from C#Jul 18, 2001. This article shows you how to call a Java program from C#.
  • 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.
  • 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.
  • Web Services between .NET, Java and MS SOAP Toolkit: Part IAug 24, 2001. WinGhost 2.0 application allows you to show and hide applications running on your machine. I find this program useful at my work as I do lot of programming at any given time I can have a bunch windows open. I use it normally to hide just my windows I don't access that often.
  • Web Services Between .NET, Java, and MS SOAP toolkitAug 24, 2001. This article will try to explain the how you can build web services and/or clients with any of the three languages: .NET, MS SOAP Toolkit and Java. But the real point of the article is to show you how you can build clients for web services from any of above-mentioned 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.
  • 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.
  • 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.
  • 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.
  • 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++.
  • 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."
  • 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.
  • 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.
  • Creating a SQL Server Database Programmatically using SQLDMOMar 12, 2002. The attached source code creates a SQL Server database programmatically using SQLDMO.
  • SQL Server Database ExplorerMar 20, 2002. This application connects to a running SQL Server 2000 and displays all the available databases in it.
  • Function Overriding and Its Impact During Object InitializationMar 25, 2002. Different languages have different ways to initialize an object. C# and Java both have almost similar ways to initialize an object with few subtle differences.
  • 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.
  • .NET Remoting: The Interface ApproachMar 26, 2002. .NET Remoting provides a powerful and high performance way of working with remote objects. Architecturally, .NET Remote objects are a perfect fit for accessing resources across the network without the overhead posed by SOAP based Web services. .NET Remoting is easier to use than Java's RMI, but definitely more difficult than creating a WebService. In this article, we will create a remote object, and access this object using the Interface.
  • 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.
  • 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.
  • Comparison of C# with Java: A Developer PerspectiveMay 29, 2002. The .NET is a language and operating system (on Windows as of now) independent platform pretty similar to Java.
  • 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.
  • 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.
  • TWINXBASE ServiceSep 09, 2002. This service scans in a directory by using FileWatcher component and when a file arrives, then the service will check the extension of the file, if the file has the extension .DBX then it will read the contents of the file and communicate with the database (C:\FILESERVICE\DB\MyDB.mdb) and insert / update / delete the records in the database -table.
  • Access MySQL Server Database using ODBC data providerOct 14, 2002. In this article, I will show you how to access MySQL server database using ODBC data provider.
  • Database Vendor Independent Code with Improved Connection PoolingOct 17, 2002. This article covers how to create a database application that allows you to specify different databases without writing code for different data providers.
  • Accessing Text Files using ODBC Data ProviderNov 12, 2002. In this article, I will show you how to access Access database files using ODBC data provider.
  • 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.
  • Singleton Patterns in C# RevisedDec 16, 2002. I am coming from the Java world, where synchronizing the Singleton creation is common practice.
  • 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.
  • C# Versions of Java's StringTokernizerJan 13, 2003. Here is another C# version of the Java StringTokenizer Class from the version posted August last year on your site. Given a string and a set of delimiters, the class return an enumeration of substrings based on the delimeters passed in.
  • From DAO to ADO.NETJan 14, 2003. This article will briefly discuss and show a summary of the evolution of the Microsoft ActiveX Data Objects, it will also explain some database concepts and finally provide some code examples.
  • 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.
  • PERST: A Simple, Fast, Convenient Object Oriented DatabaseMar 05, 2003. PERST is a simple Object-Oriented Database implemented with pure C-Sharp and Java implementations.
  • J2EE to .NET Migration: Quick TipsMar 26, 2003. Here are some Quick tips to get you started, in case you need to migrate a J2EE based application to a .NET based application.
  • Making Thumbnails of Transparent Images in .NET and C#Mar 28, 2003. When I started writing web applications using .NET, I found myself in need to dynamically create thumbnails of images that could be uploaded by the user or pulled from a database.
  • 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.
  • Add Column Dynamically to DataGrid to Display CalculationMay 08, 2003. In this article we'll see how to create a DataGrid column which displays the calculation of more than one field in the database table. The calculation could be addition, multiplication or even filtering rows.
  • Dynamically Setting Properties of a Class from a DatabaseMay 12, 2003. This example demonstrates a powerful feature of Reflection that will allow you to dynamically set the values of a class.
  • How to Detect a Dialup Connection?May 15, 2003. In the article we'll see how to check connectivity with internet using VB.NET.
  • Java Like StringTokenizer in C# Jun 11, 2003. The StringTokenizer class is yet another implementation of a java-like StringTokenizer in C#.
  • DataGrid and CheckBox ControlsJun 17, 2003. How to have checkbox that is checked or unchecked depending on a field value stored in the Database, and then allow the user to click on it and record the new checkbox state in the database.
  • Kuti.DataJul 02, 2003. The attached source code file has two parts - DataObject directory and Automatic SQL Generator.
  • Data Access Component for SQL Server in C#Jul 07, 2003. The attached source code a data access component for SQL Server that contains methods to get a DataSet.
  • Creating ASP.NET Controls DynamicallyJul 10, 2003. This article shows you how create ASP.NET controls dynamically and fill data from a database.
  • Deleting a DataGrid Data Based on a Column ValueJul 24, 2003. In this article we'll see how to delete the records of a DataGrid based on a column value in the database table.

About Java-Database-Connectivity

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