C# Corner

Resources  
  • TCP Date Client/ServerJan 03, 2000. Free to use Tutorials on Communicating using TCP Sockets on Microsoft's .NET Platform using C#...
  • Chat Server with Client Implemented with C#Jan 19, 2000. The Main Heart of the program is taken from the sample program of Gopalan Suresh Raj modified as per requirement & presented in front of you..
  • Creating a Class and Call it from Main ProgramSep 30, 2000. This article explains how to create your class, add some functions and call it from Main function.
  • A Simple Calculator ClassNov 28, 2000. Code sample shows how to create a simple calculator class and call it from Main C# program.
  • 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.
  • 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.
  • Database Explorer-IVJan 25, 2001. This is version IV of the Database Explorer, which include the support for Access Database with SQL Server.
  • FileSharing Server in C# and .NETFeb 01, 2001. The server acts as a File Sharing Server, it listens for multiple clients to connect to it. The Clients have a option to either Download any of the Files available with the server for download.
  • SQL Programming using .NETFeb 01, 2001. This program shows several data objects, some draw backs of each and some interesting things.
  • Web ProxyServer in C# and VBFeb 06, 2001. Web Proxy Server is HTTP proxy server written in C#.It is Multithreaded so many clients can access the web through this WebProxy Server.
  • Implementing Delegates in C# : Part 2Feb 13, 2001. This is second part of Timothy's Delegates in C# series...
  • 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.
  • FTP Server in C#Mar 26, 2001. The application is a simple implementation of FTP Protocol RFC 959.
  • 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.
  • POP3 AccessMar 29, 2001. This is a follow up to my SMTP example that shows how to access your POP3 server.
  • Using Delegates to Choose Right FunctionApr 01, 2001. The need to call different class method based on some string passed to class is an old problem.
  • 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.
  • Wireless Model : How Does It Work?May 09, 2001. The browser sends an HTTP request to the Web server, which interprets the request and determines which resources to retrieve or execute. If the URL specifies a file, then the server sends it back.
  • 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.
  • Mobile Fun with XMLMay 24, 2001. Here is something really wonderful in Mobile field .This example is for authenticating the Mobile Users against his settings stored in XML file. This is really good where all the ease of XML is applied. Function open the XML file and particular node data validate it against user inputs and do the specified.
  • 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.
  • 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.
  • 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.
  • FTP Explorer in C# Version 2.0Jul 10, 2001. FTP Explorer is a GUI - FTP client application developed in C# using Visual Studio.NET Beta 1.
  • 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.
  • 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.
  • 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.
  • Super String in C#Aug 20, 2001. Today I realized that I miss those Visual Basic/Visual C++ type operators. You know the ones: Left, Mid, Right.
  • 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.
  • 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.
  • String Jargon in C#Sep 05, 2001. The following article shows some String functions which are not currently available directly in C#.
  • Playing with StringsSep 18, 2001. This program explores the String class and its various methods. With this you will be able to initialize strings using different constructors and use them. To see how the methods of the 'String' class work, see the following code.
  • TCP Client and ServerSep 20, 2001. You need to compile the server and the client programs separately. Before compiling, change the IP address in both programs to match that of your machine (NOTE: You can get IP address of your machine if you run 'ipconfig' from the command prompt in Windows NT/2000 m/c's)
  • 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.
  • Customizable Generic Form Validation ControlOct 01, 2001. This control performs form validations at the client-side irrespective of the web server.
  • Console Based ChatOct 01, 2001. This is a article on how to create a simple console based chat application using socket connections.
  • Socket ProgrammingOct 01, 2001. This is a simple Client/Server program showing the communication taking place between the client and the server.
  • 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.
  • 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.
  • Encapsulation in C#Oct 12, 2001. In Object Oriented programming Encapsulation is the first pace. Encapsulation is the procedure of covering up of data and functions into a single unit (called class).
  • Creating your own Web Server using C#Oct 15, 2001. This article explains how to write a simple web server application using C#.
  • Creating your own Web Server using C#Oct 15, 2001. This article explains how to write a simple web server application using C#.
  • C# PagerOct 16, 2001. C# Pager is a simple client/server application that implements functions of a pager.
  • Exploring delegates in C#Oct 30, 2001. Delegates are a kind of type safe function pointers which are actually declared as class derived from System.MulticastDelegate.
  • 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.
  • Email Notifier with Microsoft Agent--- GENIENov 16, 2001. Email notifier with Microsoft Agent is a TCP/IP application that notifies the user if there is email in the user's email server.
  • 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.
  • 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.
  • Simple Sniffer in C#Dec 03, 2001. This program shows you how to retrieve data from a packet using Sockets.
  • C# and ActiveX DLLDec 14, 2001. As you know with Visual Basic 6.0, it is possible develop a COM server and implement them in a Visual Basic client program. But this is being done by using Visual Basic. You may wonder about the idea of calling this DLL in a C# Application. Well, C# language provides us a way to call this COM server in a program. When we compile a C# program an Intermediate Language is generated and it is called as Managed Code.
  • 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.
  • Web Enabled C# ApplicationJan 02, 2002. C# is a sharp-edged weapon for Microsoft Visual Studio Programmers. My article beneath presents a brief eye-catching vivid view of programming internet web-browser using C#(C Sharp), and solves today's need with tomorrow's software!
  • 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.
  • 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 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.
  • 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.
  • Using MS Agent in C#-Part-I(Text To Speech)Jan 15, 2002. This article explains how to use MS Agent to write text-to-speech applications using C# and .NET.
  • Chat Server with Client Implemented with C#Jan 19, 2002. This client/server application let you chat ....
  • 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.
  • Rebooting a Remote Server using WMIFeb 04, 2002. Windows Management Instrumentation or WMI holds many surprises and features but when my colleagues machine rebooted even I was surprised.
  • Rebooting a Remote Server using WMIFeb 04, 2002. Windows Management Instrumentation or WMI holds many surprises and features but when my colleagues machine rebooted even I was surprised.
  • 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.
  • Tutorial: Capturing and Running IE Instances in a Windows controlMar 15, 2002. In this article we are going to study how to find the running instances of Internet Explorer on your machine.
  • 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.
  • Xite EncryptionMar 25, 2002. This class contains methods/functions for easily decrypting and encrypting data.
  • .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.
  • Real-time Message Logging Utility - Part 1Apr 01, 2002. A message logger is a utility that helps in logging the messages thrown from functions/programs. It is useful in critical applications as it helps to know the time taken by a function to execute, the time that the function remained idle and any messages that the function wants to be logged for further analysis.
  • .NET COM Interoperability - Part 1: Using COM Components from .NET FrameworkApr 02, 2002. The DotNet framework exposes COM objects through a proxy called the runtime callable wrapper (RCW). The primary function of RCW is to marshal call between a managed client (.Net) and unmanaged COM object. The runtime maintains a single RCW for each COM object.
  • Multicasting using UDP in C#Apr 04, 2002. The attached source code shows you how to use multi casting in a LAN environment.
  • Multithreading Part 4: The ThreadPool, Timer Classes and Asynchronous ProgrammingApr 16, 2002. In this article, I would discuss few more .NET classes and how and what role do they play a role in building multithreading applications.
  • 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.
  • 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.
  • Expression EvaluatorApr 30, 2002. This program uses the transformation from infix notation to postfix notation to evaluate most of the mathematical expressions.
  • Remoting in C#May 13, 2002. This simple article shows you how to write simple server and client to access the server remotely.
  • 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.
  • Shell Commands within C#Jul 10, 2002. In this article we will examine a few examples for executing shell commands outside of our program using C#.
  • Programming Template in Web Server ControlsJul 15, 2002. Templates play a major role in managing the layout and format of the data being displayed in ASP.NET data bound controls.
  • dotMSN: .NET Messenger LibraryJul 25, 2002. dotMSN is a class library to make use of the MSN Messenger Service. The library is built in C# and can therefore be used by all languages the .NET environment supports.
  • 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.
  • 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.
  • Double Buffer Drawing with DirectDraw: Part1Aug 15, 2002. Because we will be primary focusing on 2D game programming in the first articles, we will use the DirectX7 API which is perfect for its DirectDraw class and simplicity. Don’t worry for not having the right DLL because DirectX8 has full backward compatibility to DirectX7 and the COM object should already be available on your computer if you have DirectX 8 installed.

About Round-function-in-SQL-Server

NA

SPONSORED BY

C# Corner Chandigarh DevCon16
Chandigarh DevCon16 is a one-day Developer Conference where programmers, technologists, authors, and members meet, demonstrate, plan, and hang out.
Visual Studio Live - Redmond 2016