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..
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • FTP Server in C#Mar 26, 2001. The application is a simple implementation of FTP Protocol RFC 959.
  • Inserting Data to an XML DocumentMar 28, 2001. The XmlNode and the XmlDocument classes can be used to insert XML data to an existing document or to a new document.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Stock TrackerJul 18, 2001. This program is a utility to track stock quotes for multiple symbols.
  • 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.
  • Automatic Generated DataGrid CommandsAug 15, 2001. This article illustrates how to update, insert, and delete in the windows DataGrid control by using automatic generated commands.
  • 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 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.
  • Multiple Inheritance in C#Aug 29, 2001. Can you inherit from multiple classes in C#? Simply put, this cannot be done. However there are ways around it. From a design perspective you must ask yourself, will a Class fully represent an object?
  • 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)
  • 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.
  • 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.
  • Customizable Generic Form Validation ControlOct 01, 2001. This control performs form validations at the client-side irrespective of the web 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.
  • 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.
  • Exception Handling in C#Oct 17, 2001. Exception handling is a builtin mechanism in .NET framework to detect and handle run time errors.
  • 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.
  • 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.
  • 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.
  • 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.
  • Microscopic Discussion in ClassesJan 02, 2002. This article is going to take a microscopic view of classes, in terms of Inheritance(I) , Multiple Inheritance(MI) and Circular Base Classes (CBC).
  • 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.
  • Using MS Agent in C# - Part-IIIJan 09, 2002. In this article, I will show you how to write a program which lists all the animations of the loaded characters which speak to us using synthesized speech, recorded audio, or text in a cartoon word balloon.
  • 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.
  • Developing MDI Applications in C#Jan 16, 2002. In this article, I'll explain how to write MDI applications using C# and Windows Forms.
  • 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.
  • SQL Server Database ExplorerMar 20, 2002. This application connects to a running SQL Server 2000 and displays all the available databases in it.
  • .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.
  • Multicasting using UDP in C#Apr 04, 2002. The attached source code shows you how to use multi casting in a LAN environment.
  • 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.
  • DNS Resolver using DNSAPI.DLLApr 15, 2002. This is a DNS resolver using the dnsapi.dll, it can do all sorts of DNS lookups and not just simple a record lookup like the Dns class in the .NET framework.
  • Loading XML File in a TreeView Control using MultithreadingApr 19, 2002. There are many occasions when programmers need to develop multithreading applications, which can load big files in the background and let the user do data entry or other jobs without any interruption. In this article, I'll show you how to create multiple threads to load multiple files.
  • 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.
  • Viewing Multiple ImagesMay 08, 2002. I'm writing this article in response to a question on discussion forums, How do I view multiple images on top of each other?
  • Remoting in C#May 13, 2002. This simple article shows you how to write simple server and client to access the server remotely.
  • Windows Services Admin: Control Your Windows ServicesMay 20, 2002. In this article, we will create an application to control Windows services on our local computer as well as on remote computers. You can simultaneously Stop or Start multiple Services on the local computer or on the specified remote computer.
  • Use CurrencyManager and MemoryStream to Display ImagesJul 01, 2002. This article and attached sample code demonstrates you how to use the CurrencyManager and MemoryStream to display images. The current demonstration displays all the records of the employees with their company and the personal Information.
  • 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.
  • 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.
  • Writing a Single Event Handler for Multiple ControlsJul 22, 2002. Writing a Single Event Handler for Multiple Controls by Giuseppe Russo. Jul 22, 2002. I have noticed that in many articles, I read, people use a longer method of clearing many textboxes, as well as handling more than one control at the same time.
  • 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.

About insert-multiple-record-in-sql-server-table

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