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#.
  • Ping Utility in C#Feb 16, 2001. Ping is a very useful utility used to determine the speed of a Network Connection. It establishes a socket connection with the given hostname and sends a Data Packet using ICMP Protocol.
  • 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.
  • 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.
  • Connect to an Oracle DatabaseMay 03, 2001. This sample code shows you how to connect to an Oracle database using C#.
  • FTP Explorer in C#May 21, 2001. I have developed a GUI based FTP client application. This takes connection information and populates folder and files in treeview and listview respectively.
  • 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.
  • TCP/IPLib SampleJun 22, 2001. This compopnent contains both a TCP/IP server and client. TcpIpClient inherits from System.Net.Sockets.TCPClient and is very straight forward. After construction, specifying the host and port, a network connection is established by calling Connect(). Internally, upon a successful connection, the client receives a TcpIpPacket, which contains a unique cookie that is used in any subsequent transactions.
  • 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.
  • WhoIs Sample CodeAug 27, 2001. Sample example shows you how to implement WhoIs...
  • Socket Programming in C#Sep 03, 2001. This program is useful for a starter who wants to write C# code using .Net Sockets.
  • 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.
  • Console Based ChatOct 01, 2001. This is a article on how to create a simple console based chat application using socket connections.
  • Real Time ApplicationOct 02, 2001. The Real time Application is a sample that shows the communication techniques between a client (TcpClient) and a server (TcpServer) application using Socket class on each side. The project also demonstrates how to using listview control in the real time project.
  • 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.
  • C# IRC BotNov 19, 2001. This is a very simple program that establishes a connection to irc server, joins a channel and greets every nick that joins.
  • 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.
  • FTP Explorer in C#: Beta 2Jan 10, 2002. FTP Explorer is a MDI application that can explore FTP server. This application takes FTP connection information and populates folder and files in treeview and listview respectively.
  • FTP Explorer in C#(Beta 2)Jan 10, 2002. FTP Explorer is a MDI application that can explore FTP server. This application takes FTP connection information and populates folder and files in treeview and listview respectively.
  • Web/WAP Calender form Harrison LogicFeb 11, 2002. This application provides an updateable web-based calendar that can be viewed from both the Web and through a Mobile device, such as a cellular phone.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Using Generic Algorithms to Layout Circuit BoardsApr 07, 2003. This article tells you how to use a Genetic Algorithm to optimally layout parts on a circuit board so they have the shortest connections between them.
  • 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.
  • How to Detect a Dialup Connection?May 15, 2003. In the article we'll see how to check connectivity with internet using VB.NET.
  • FTP Client ComponentJun 12, 2003. An FTP Connection component that you can add to the toolbox of your IDE.
  • Part I: Simple Color Syntax Code Editor for PHP written in C# and .NETJun 18, 2003. The Application is a simple Windows Form program that allows you to open and save the text files edited in the rich edit control, as well as print them out. The program takes advantage of a “syntax” text file for PHP which lists the functions and keywords contained in the PHP language.
  • Part I: Simple Color Syntax Code Editor for PHP written in C# and .NETJun 18, 2003. The second part of this article shows how to print out the contents of a RichTextBox control.
  • 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.
  • Check Internet ConnectionAug 25, 2003. How to check if your computer is connected to the internet with C#. It's much more easier that other tutorials I've seen in other sites.
  • Oracle Data Provider for .NET : Part IIFeb 20, 2004. Oracle Data Provider for .NET (ODP.NET) is an implementation of a data provider for the Oracle database. ODP.NET uses Oracle native APIs to offer fast and reliable access to Oracle data and features from any .NET application.
  • Remote Data Access LayerAug 24, 2004. The attached source project is a data access layer library and the main idea of developing such a DAL is to separate the database execution from the client/end user and maintain it on the server side, there by reducing the number of direct simultaneous connection to the SQL Server.
  • Microsoft Application Center TestOct 13, 2004. Application Center Test (ACT) stress tests Web servers and analyze performance and scalability problems of Web applications. ACT simulates a large group of users by opening multiple connections to the server and rapidly sending HTTP requests. It also supports several other authentication schemes and the SSL protocol, making it ideal for testing personalized and secure sites.
  • Storing Images into a DatabaseOct 18, 2004. In order to provide your application with cool pictures you can employ two techniques (at least). One of them is that you can save the pictures in a folder and store the path to each one in a database or configuration file. The other one is to store the entire file into a database, along with its file name.
  • 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.
  • Generic 'T, K' Database ComponentDec 17, 2005. I have written a C# 2.0 (Visual Studio 2005), Generic <T, K> Database component, The component has simplified the architecture and the implementation by allowing me to keep the number of overloaded methods to a minimum.
  • Revised Generic 'T, K' Database ComponentDec 20, 2005. This is the code behind the Generic 'T, K' Database Component.
  • Authorization and Programmatic ImpersonationFeb 03, 2006. By default, ASP.NET applications usually do not impersonate the original caller for design, implementation, and scalability reasons. For example, impersonating prevents effective middle-tier connection pooling, which can have a severe impact on application scalability.
  • ASP.NET Security With SQL Server 2005Jul 11, 2006. This article focuses on security concerm when using SQL Server 2005 in ASP.NET application.
  • Understanding Connection PoolingJul 27, 2006. This article is to go in deep in dome key features in the ADO.NET 2 which was shipped with VS 2005. In this article I will go trough one of the key features which is the Connection Pooling.
  • Accessing Data using Object Data Source in ASP.Net 2.0 and C# Aug 23, 2006. This tutorial demonstrates how to bind data against Objects using Visual Studio 2005.
  • Creating SQL Server Database Dynamically in .NET Using SQL DMOOct 05, 2006. It is a sample ASP.NET and Visual Studio 2005 application for creating a SQL Server database at runtime. I have used SQL-DMO dll. This article will show you how to create a database in SQL Server 2005 and 2000.
  • Encrypting Connection Strings in ASP.Net 2.0Oct 05, 2006. This article describes how to encrypt the connection strings section in ASP.Net 2.0 web.config files and demonstrates the transperancy of using encrypted connection strings in your web application.
  • Database connection object with application-wide scopeJan 02, 2007. This article describes a class that can be placed in a Visual Studio C# project that makes a connection object available to any of the other classes in the project.
  • Monitor Internet Connection StateFeb 09, 2007. This article describes an easy approach to building two controls used to monitor the status of an internet connection and provide the user with some indication of that status.
  • Add a Quick Map to a Windows ApplicationMar 15, 2007. This project demonstrates a quick and easy way to add mapping to a windows desktop application (with an available internet connection) using Google Maps as the basis and source for the map.
  • Connection PoolingAug 11, 2007. While performing any database activity it is necessary that every single connection need to be closed, but in case your application throws some exception in that case our connection wont’ get closed. And you will get error “Cannot open connection, it is already open” In this article I will be discussing what is connection pooling? Why connection polling & how we can enable connection pooling etc.
  • Generic Data Layer - One time creationSep 06, 2007. This article will explain how to create a generic data layer that can be used with very less amount of coding. It is a known fact that, most of the time we create applications for Create , Select , Update, Delete. And every time, we end up with writing similar set of code for every execution of our stored procedures.
  • Introduction to Building a Plug-In Architecture Using C#Sep 10, 2007. In this article we'll take another look at how we can use the state pattern to build a plug-in architecture that will allow us to change the behavior of our application by placing differnt plug-ins into a folder.
  • Add and handle application settings in the configuration file: Part IIApr 16, 2008. This article tells you how to add connection string using the configuration file itself.
  • Add and handle connection strings in an application configuration file: Part IApr 17, 2008. There are two ways to save data and parameters. In this case we save application parameters like information entered by the user during the installation process.
  • Multiple Active Result Sets (MARS)May 12, 2008. This article gives you information about the Mars a feature supported by MSSqlServer 2005 and .Net 2.0/3.x, which is a feature to execute more than one query with one single connection to database.
  • Developing a PHP Website using Visual Studio 2005Jun 03, 2008. Yes it’s possible to use PHP under Visual Studio 2005 and even Visual Studio 2008 IDE. In this tutorial, I will show a walkthrogh how it is possible to develop a classic PHP web application.
  • Encrypt and Decrypt Sensitive Metadata Within Your Config file Jun 18, 2008. In a certain cases, metadata embedded within your configuration file is sensitive. In fact, imagine that you develop an application that uses a data base as data source; all information about this data base is located in the configuration file. What if a hacker success to log into your configuration files and obtains the connection string and other metadata about your data base??
  • How to Enable Remote Connections in SQL Server 2005Jul 17, 2008. By default, SQL Server 2005 doesn’t allow remote connection so you have to enable it manually. This article shows you how to enable remote connection in your SQL Server 2005.
  • Auto create database connection string using INI by C# Jul 22, 2008. This article shows how to auto create database connection string using INI by C# .
  • Attaching a Digital Certificate (Public Key) to an HTTPS RequestAug 10, 2008. This article will guide you on how to post data to an HTTPS (i.e., secure connection) URL from a Windows application (.NET) by attaching a digital certificate from a certificate file and getting the response back.
  • Connect to MySQL database - via ODBC without using DSN: Part IIAug 11, 2008. In order to connect to on MySQL method, I propose this more flexible solution, thus, it enables us to customize the connection parameters in one hand, moreover, it enables us to choose which mode should we use. I mean, ADO connected mode using data reader or disconnected mode using data adapter and data set.
  • Storing and Retrieving Connection Strings in ASP.NET 2.0/3.5 Nov 04, 2008. This article demonstrates how to store database connection strings in Web.config in ASP.NET 2.0/3.5 and retrieve it for creating connection objects.
  • Check Internet ConnectionJan 29, 2009. To check for an Internet connection in .NET, we can use GetIsNetworkAvailable method defined in the System.Net.Network-Information namespace.
  • Using Data in Silverlight 2 Applications - IFeb 05, 2009. In this Article you will learn how to create a data connection, a LINQtoSQL class and a WCF service.
  • ADO.NET FAQ's: Part IIFeb 13, 2009. This is the Part 2 of ADO.NET. In this section also we will touch base on one of important concepts in ADO.NET.
  • Introduction to Visual Studio Add-insMar 03, 2009. This article explains about Visual Studio 2008 Add-ins.
  • Introduction to Interfacing Win Forms with VS Add-insMar 04, 2009. This article explains about integration of Windows Forms with Visual Studio Add-ins.
  • Paging and Sorting ListViews with ASP.NET MVC and jQueryMar 23, 2009. This article provides a simple example of using jQuery along with the jQuery tablesorter and tablesorter.pager plug-ins to provide sorting and paging support for a listview within the context of an ASP.NET MVC application. JQuery has partnered with Microsoft and is now integrated within the IDE to include the availability of intellisense support.
  • XSD XML Based Crystal Report Data Source Apr 01, 2009. This article is intended to illustrate the benefits of using disconnected connection in crystal reports.
  • ADO.NET using C#Jul 22, 2009. In this article I will explain you how to make a SQL database connection and show information in data grid.
  • ADO.NET Objects: Part IJul 23, 2009. In this article I will explain about ADO.NET objects. This will help you in understanding them in an easy manner.
  • Rows.Count, Column.Count and IEnumerator using ADO.NET with C# and Database ServerJul 29, 2009. In this article I will explain you how to make a SQL database connection and show information in data grid. Count the number of rows and columns in the table and show the records in text boxes using IEnumerator interface.
  • Connection Object in ADO.NETOct 07, 2009. In this article I will explain you about Connection Object in ADO.NET.
  • Simple ADO.NET program with Visual Studio .NET IDEOct 12, 2009. In this article I will explain about a simple ADO.NET program with VS using windows forms.
  • Data Components in Visual Studio .NET: Part IOct 13, 2009. In this article, I will help you in understanding using the Server Explorer for Adding a new Connection.
  • Data Components in Visual Studio .NET Part4Oct 13, 2009. This article will help you in understanding Data Connections in Visual Studio .NET
  • Monitoring Database Connections using Performance CountersOct 14, 2009. ADO.NET performance counters can be used to monitor the status the connection resources that the application uses. This article concentrates mainly on monitoring database connections.
  • Creating Data Adapters with the Data Adapter Configuration Wizard Oct 14, 2009. This article will help you in understanding Creating Data Adapters with the Data Adapter Configuration Wizard.
  • ASP.NET Web Configuration FileNov 11, 2009. In this article I will explain you about ASP.NET Web Configuration File.
  • Configuring connection string using SPPersistedObjectNov 13, 2009. In this article, I am going to show how to use SPPersistedObject to save connection string in config database of web application. I will also show how to configure connection string using ADMIN UI. We really do not need to go and configure the web.config manually.
  • Using the Data Form Wizard in ADO.NETDec 17, 2009. In this article I will explain about using the Data Form Wizard in ADO.NET.
  • Connecting to the Database in ADO.NETDec 23, 2009. In this article I will explain about Connecting to the Database in ADO.NET
  • Understanding Connection Pooling in ADO .NETDec 31, 2009. In this article I will explain Understanding Connection Pooling in ADO .NET
  • Handling ADO .NET Events & Connection Events Feb 18, 2010. In this article I will explain handling ADO .NET Events & Connection Events.
  • Developing SOAP Web Services with PHPMay 28, 2010. In this article you will learn how to Develop SOAP Web Services with PHP.
  • Connecting to SQL Server in ASP.NetJun 11, 2010. In this article, I will explain the process of establishing the connection to SQL Server Database.
  • Connection String Placement in ASP.NetJul 15, 2010. This Article will explain you about placing the connection string in web pages.
  • Step by Step walkthrough on CRUD Operation on Azure table: Part IIJul 21, 2010. This article is going to explain , how we can use AZURE table. This article will explain how to create a stroage account and then modify the connection string in exsiting azure application using local development storage.
  • Add a Data Connection to SharePoint List or Library in InfoPath Form TemplateSep 07, 2010. This article will help you bind the SP list or library in InfoPath. Below article contains only few basic steps which will help you to display the sp fields in InfoPath Form template.
  • Abstract Factory PatternSep 21, 2010. In this walkthrough I'll try to explain GOF (Gang of Four) Abstract Design pattern. This article is about managing multiple connection strings of different data providers (SQL, Oracle, OleDB etc.).

About Connection-in-PHP

NA

SPONSORED BY

Spire.Doc - Free .NET Word API
Use Spire.Doc to create, read, write, print, and convert word documents to OpenXML, RTF, TXT, XPS, EPUB, EMF, HTML, Image and PDF.
Download Free eBooks