C# Corner

Resources  
  • 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.
  • Get a database table propertiesJan 22, 2001. Get a table properties such as column names, types etc using DataColumn and DataTable.
  • 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 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.
  • 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.
  • 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.
  • 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.
  • 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?
  • 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.
  • 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.
  • .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).
  • 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#.
  • Will Java and .Net Framework Co-exist?May 15, 2001. The article begins by briefly probing what constitutes the Java platform and .NET framework.
  • 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 ..
  • 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.
  • Calling Java Program from C#Jul 18, 2001. This article shows you how to call a Java program from C#.
  • Populating and Editing a DataGrid in ASP.NETAug 17, 2001. I will show here , how to develop DataGrid, which is able to retrieve data from joined tables and editable.
  • 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 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 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.
  • 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.
  • 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.
  • 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++.
  • 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.
  • 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.
  • .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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Editable GridView Control in C# and .NET - Part IV Exporting the GridView to ExcelJun 27, 2002. In this article we will take the contents of our GridView control and spill it into an Excel spreadsheet using this wrapper mechanism.
  • Editable ListBox ControlJul 01, 2002. A ListBox is a read-only list of items. But let us suppose your application needs to edit an item in a listbox at runtime.
  • Editable ListView in C#Jul 01, 2002. Based on the similar technique used my previous article, the Editable Listbox, we can edit columns and rows of a ListView control.
  • 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.
  • 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.
  • Working with COBOL Data Groups in C#Sep 11, 2002. In this article we will begin with a C# console application calling a COBOL DLL file. The C# application will pass it a number of occurrences to create in the table (much like a user requesting a specific number of months to report on).
  • 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.
  • 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.
  • Caution When Using SetParentRow of a DataSetJan 13, 2003. I had a serious performance killer when using SetParentRow in the creation of a DataSet in ADO.NET.
  • 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.
  • 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.
  • 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.
  • How to Display Data Vertically?May 08, 2003. This article explains how to display data vertically rather than typically horizontal rows.
  • Java Like StringTokenizer in C# Jun 11, 2003. The StringTokenizer class is yet another implementation of a java-like StringTokenizer in C#.
  • 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.
  • 2D ChartingAug 11, 2003. I was amazed at what the VS.NET IDE does for a programmer as I was primarily used to Java via the command line.
  • 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: Part IIIJan 13, 2004. Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management. Alas, for the reason that it is first necessary to provide a background of SQL and cover some preliminary concepts that we need to know, the majority of this article is text in paragraph format.
  • Real Life SQL and .NET: Part IJan 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 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.
  • DataSets in Microsoft .NET - Part 2Mar 09, 2004. This article explains sorting, searching and filtering support provided by dataset and data table objects.
  • University Student Registration Application in ASP.NETMay 03, 2004. The aim of this project is to implement a Web application, where students can register for an online course. If the user is an administrator, he can add and remove courses and modify the student information.
  • Dynamic SQL Server Database Creation in .NETMay 03, 2004. This article explains step by step dynamic creation of a SQL Server database, tables and stored procedure using Visual Studio codename Whidbey and VB.NET.
  • Web Services-InteroperabilityAug 04, 2004. In this article, we will see what interoperability is all about, comparison between Java and .NET interoperability, the benefits of and challenges faced in interoperability and the role of WS-I in this overall scenario.
  • Creating a Managed Automated Information Agent(mBot)Aug 16, 2004. mBot manages multiple RTC Client objects and exposes interfaces to them via .Net Remoting and .Net Web Services so that they can be managed and used remotely by other .Net applications or from entirely different platforms such as a Java J2EE/SOAP application like Jabber running on Linux or Windows.
  • Writing unsafe code - pointers in C#Oct 13, 2004. In this article I will give a short description of one of the feature of C# which are pointers and so-called unsafe code. This subject is particularly close for C++ programmers. Moreover, it is a feature that we do not find in Java.
  • Editable ListBox in C#Jun 09, 2005. The attached sample code demonstrates how you can create an editable ListBox control, which will let you edit ListBox items at runtime.
  • 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.
  • DNS QueryAug 18, 2005. This example shows similarity of c# and java and how to implement dns query.
  • ASP.NET Session StateSep 21, 2005. Session state is nothing more than memory in the shape of a dictionary or hash table, e.g. key-value pairs, which can be set and read for the duration of a user's session.
  • Adding and retrieving Images from a SQL Server TableSep 23, 2005. This article describes the process to add and retrieve images from a SQL Server table using ADO.NET.
  • Migrating from Java to C# Oct 03, 2005. Microsoft has created a tool called Java Language Conversion Assistant (JLCA), which automatically converts Java code into C# for developers who want to move existing applications to the .NET Framework.
  • How To Get All Database Tables and TableColumns in Oracle Nov 08, 2005. In this article, I will show how can I fetch all tables and corresponding columns from an Oracle database using C# and Oracle .NET Data Provider.
  • Navigating Data Grid using Client ScriptingNov 10, 2005. It's very common practice to use the Data Grid to present data over web pages. Though the Data Grid is provides the richer UI presentation if not coded and handled effectively it can have great performance issues. This article gives the code sample for navigating the data grid using the Client Scripting (thereby can be used for lots of validation before doing the Post Back to the server) and minimizing the round trip to server
  • Hashtable in C#Nov 14, 2005. Hashtable is useful when you need to store data in a key and value pair. This article shows how to use hashtable in C#.
  • How to Select all Checkbox when Header Checkbox is SelectedDec 30, 2005. Here I have provided the code using javascript to check/uncheck all checkboxes when header checkbox is checked. I recommend JAVA Script because its executed at client side and saves request Round-Trip time.
  • Web Service : Asynchronous call by using Java Script and DHTML behaviourDec 31, 2005. This article shows how to make asynchronous call of web service by using Java Script and DHTML behaviour.
  • Migrating Java RMI to .NET RemotingJan 16, 2006. .Net Remoting and Java RMI are mechanisms that allow the user to invoke method/methods in another address space. The other address space could be on the same machine or a different one. These two mechanisms can be regarded as RPC in an object-oriented fashion. This article describes how to migrate java RMI applications to .NET Remoting applications, with practical examples.
  • An Introduction to C# GenericsFeb 06, 2006. There is a reality; most of the developers confuse about C# Generics. Actually, there is no reason for that. If your background comes from C++ or Java you may understand more easily. What “Templates” tell you from your C++ knowledge or “Generics” from Java.
  • Web Services for .NET and J2EE InteroperabilityFeb 13, 2006. Web services technologies are designed to support the interoperability between many different application development platforms that exist today. This article is focused on the fundamentals of .NET and Java interoperability using Web services technologies.
  • Integrating .NET Web Services with Java and classic ASP Clients for InteroperabilityFeb 13, 2006. The goal of this article is to show to integrate Microsoft's .NET Platform Web service with other platform like Java and ASP. The samples demonstrate basic techniques and principles that are used to cross-platform interoperability via Web services.
  • Displaying Single Table Database Hierarchy with DataSet and DataRelationsMar 03, 2006. Hierarchies can be difficult to store SQL tables and even more difficult to query and display. This Example will show you how you can use DataRelation to convert single table hierarchy in to nested XML and then use XSLT to transform it to nested list.
  • Customized Binding Using CollectionBaseMar 04, 2006. In this article I am trying to explain the use of CollectionBase class. In a simple example I used CollectionBase to bind a DataGrid control with data from Employees table of NorthWind database. So please be sure that your system exists with NorthWind database before using the sample code along with this article.
  • Deploying ASP.Net 2.0 Web site to Production Server: Part IApr 03, 2006. Deploying ASP.NET 2.0 web site is the first issue facing the developer. This part of the article gives you a step by step to how to move membership tables from MS SQL express Edition to your database that you are used on your web site. The second part we will go in details to configure our asp.net web site.
  • 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.
  • Accessing Crystal Report in ASP.NET using C#May 01, 2006. This article is for web-developers who want to access crystal reports in ASP.Net by using multiple tables or views etc. This application might help them and save their development time.
  • Merging data into single table from multiple tables (resultsets)May 15, 2006. This article shows how to reduce the number of trips to improve performance by merging data into single table from multiple tables (resultsets).
  • Nested Repeater : Display Hierarchal Data in Web Form by Using ASP.Net RepeaterJun 02, 2006. This article features how to display hierarchal data from multiple tables using an ASP.Net repeater control in a web form.
  • Top 10 Reasons to Switch from Java to Visual C#Jun 03, 2006. This article details the major reasons for Java programmers to consider switching from the Java language to Visual C#.
  • Six C# features Java developers will kill for...Jun 21, 2006. C# is called Java on steroids, and everyone agrees that it is based on some long-time Java ideas and concepts. But, there are differences, and some of them make C# very powerful compared to Java. Here are six of them.
  • Six Java features C# developers will kill for...Jul 06, 2006. Not everything on the .NET framework is perfect, and Microsoft still has more improvements to implement. This time we will look at six features available to Java developers but unfortunally absent from C#.
  • Introduction to Common Table Expressions – SQL Server 2005Aug 03, 2006. This article delves into the concepts of Common Table Expressions (CTE) in SQL Server 2005 and their usage.
  • Maintaining Transactions in Enterprise applications using ADO.NET Transactions Aug 07, 2006. This article explains usage of System.Transactions to update tables of two different databases with two different data providers (SqlClient and OleDB) in Atomic(ACID) way.

About Editable-table-in-java

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