C# Corner

Resources  
  • 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.
  • A Database Access Class with Overloaded SELECT StatementsJan 24, 2001. A useful database access class with overloaded SELECT and other statements.
  • 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.
  • Regular Expressions ExampleMay 14, 2001. The following example shows the use of Regular Expressions in C#.This program has basic validation scripts for validation easily useable in all programs.
  • 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 ..
  • Control Statements - Part 2Jun 04, 2001. This lesson shows how to use while,do, for, for..each statements.
  • 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.
  • Difference Using Directive and StatementJul 26, 2001. This article explains difference between using directive and using statement with sample example.
  • 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.
  • ASP.NET and VB.NET Error HandlingAug 24, 2001. ASP.NET and VB.NET both are providing excellent error handling options when compared with ASP and VB6. In VB.NET we can make use of the structured way of error handling with the Try & Catch statement.
  • 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.
  • Share Information between C# and VBScript with RegistryOct 06, 2001. VBScript is widely used to write automation and system scripts. It is more powerful within Windows Script Host (WSH).
  • Debugging Techniques in C#Dec 04, 2001. Debugging GUI applications for me mostly consists of printing out debug statements in the form of a dialog box with some text.
  • Multilingual Support in C#Jan 03, 2002. Many major languages of the world like Arabic, Hindi and Chinese are not written in Roman Script, so special features are provided for dealing with these languages. This article will tell how to implement multilingual application using C#.
  • 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.
  • 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.
  • Calling Managed Code from Unmanaged CodeMar 11, 2002. One significant part of developers (including myself) are doing some kind of automation of Microsoft Office. So I will concentrate on opposing side of problem, how to use managed assembly from MS Office or VB script. In this article, I will discuss how to call managed code from unmanaged code.
  • XbWrapper - Xbase InterpreterMar 15, 2002. XbWrapper-Xbase script inter XbWrapper is a simple scripting language. It is intended to use as an embedded language in other C# programs.
  • Poorman's Installation program in C# and .NETApr 08, 2002. Installation programs can be quite expensive these days. Although programs such as Wise and InstallShield have fantastic features and are fairly comprehensive, sometimes you just want to do the easy installation of copying and pasting files into a directory and perhaps placing a shortcut in the start menu.
  • 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.
  • 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.
  • 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.
  • The "Using" Statement in C#Dec 11, 2002. The .Net Framework provides resource management for managed objects through the garbage collector - You do not have to explicitly allocate and release memory for managed objects.
  • 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.
  • Using Stored Procedures in Conjuction with DataAdapterJan 09, 2003. A stored procedure is a named collection of SQL statements that are stored in the database. To the client a stored procedure acts similar to a function.
  • Telnet Scripting in C#Jan 28, 2003. This library, written in C#, expands on some telnet code from various other sources, presenting the caller with a number of functions handy for scripting telnet sessions (i.e. SendMessage, SendAndWait, WaitAndSend, WaitFor).
  • 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.
  • Enter Null Values for DateTime Column of SQL ServerSep 26, 2003. Inserting a null value to the DateTime Field in SQL Server is one of the most common issues giving various errors. Even if one enters null values the value in the database is some default value as 1/1/1900 12:00:00 AM.
  • Real Life SQL and .NET : using SQL with C#: Part XJan 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 IIJan 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 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.
  • Refactoring in Visual Studio 2005Jun 11, 2004. Refactoring allows developers to use the built-in feature of Visual Studio to rename and convert and change the signatures and definitions of a class members. In this article, I will show you how refactoring feature provided by Visual Studio 2005 can be a handy tool when you are reorganizing or optimizing your existing projects.
  • CopySchemaOct 05, 2004. CopySchema is a utility for copying all the data from one Oracle schema to another. Although similar to the exp/imp and bulk load utilities of Oracle, it has the advantage of offering a simple GUI interface and of handling changes to the schema.
  • TranslateSQLOct 05, 2004. TranslateSQL is a utility for generating SQL-Server SQL scripts based on an existing Oracle schema, in essence 'translating' Oracle schemas into SQL-Server databases.
  • How to Insert a Date Into DateTime Column Using ADO.NET & C#Feb 04, 2005. In this article, we will show how to insert a date into a date column using ADO.NET and C#.
  • ValidationScriptGeneratorMar 16, 2005. This article gives you a solution for generating a client side validation script in a component model that you can reuse in an ASP.NET project.
  • How to Call a .NET Assembly From a SQL Server Scheduled JobApr 27, 2005. This article shows you a step-by-step implementation of a COM client (a SQL Server scheduled Job) using .NET and C#.
  • Active Directory and .NETJun 22, 2005. Microsoft Technet offers a script repository to work with AD User Accounts; however, I needed to work with .NET and I could not find samples for all the tasks I needed to program. I promised to myself that one day I would publish the code samples I found and created to help other developers who are working with Directory Services.
  • 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.
  • 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
  • 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.
  • Introduction to the MagicAjax.NET - The Magic Ajax Engine for .NETFeb 11, 2006. MagicAjax.NET is a free open-source framework, designed to make it easier and more intuitive for developers to integrate AJAX technology into their web pages, without replacing the ASP.NET controls and/or writing tons of JavaScript code.
  • Insert /Retrieve an Image Into/ From a Blob Field in Oracle Database using C#.NetMar 17, 2006. This article helps you to insert an image to a blob field of an oracle database and to retrieve the image from the blob field of an oracle database.
  • Debug Client Side Script in Visual Studio 2005May 18, 2006. This article is for web developers, because it's target is one of the new feature in Visual Studio 2005 which is debug client side script.
  • System Views and Functions in SQL Server 2005 by Steve on Jul 06, 2006 Jul 06, 2006. I tried to explore some basic TSQL functions and VIEWS in SQL Server 2005. I believe this would be useful when we write DDL-DML Statements.
  • Calling the Server-Side method asynchronously from Client ScriptJul 19, 2006. This article describes how to call the server-side method asynchronously from JavaScript with the use of Client Callbacks that is built in ASP.NET 2 so that the client browser receives the data dynamically without page postback.
  • Illustrates the use of the lock in multithreading applicationAug 17, 2006. Any application must have one or more processes. A Process is structural unit with a memory block and using some set of resources. For each executable, the Windows operating system creates some isolated memory block. This article tries to explain the use of lock basics of Multithreading in C# .Net.
  • Inserting new row in GridView in ASP.NET 2.0Sep 04, 2006. The GridView was not designed to insert new rows, but there is a way to accomplish this with very little code. This article shows how to do that.
  • Tip related to sub containers and SqlDataSourceDec 06, 2006. This article provides some tips when working With Master page or SqlDataSource insert function In VS 2005.
  • Extending ASPX Panel Control to produce Rounded CornersMar 05, 2007. This article shows how to create a custom control which encapsulates scripts. Also shows how to add method attributes to interact with VS Designer and ToolBox as well as providing intellisense dropdowns.
  • Animating your XAML AppsApr 05, 2007. This article will describe how to do 2D Animation using XAML Scripts. In the article we will describe how to implement transforms on XAML shapes and then how to move them around in your form.
  • Enhanced Oracle Explorer in C# and .NET Using Windows FormsApr 27, 2007. This application will allows to do multiple simple activities on oracle database like running select statements and getting selected procedure's definition simultaneously in a thread-based GUI.
  • Generate SQL Statements With Objects, Attributes and ReflectionJun 12, 2007. Create a SQL Command with SQL Statement and Parameters dynamically.
  • ASP.NET Multiple File UploaderJan 04, 2008. This article tells you how to allow users to upload more than one file at a time.
  • Comaprission of dates for a year in JavaScriptFeb 29, 2008. This article and code snippet shows how to use JavaScript to validate dates in a method for a year.
  • Anonymous methods in C#Mar 06, 2008. This article discusses the anonymous methods as a new feature in .NET 2.0, it will show you how to associate a delegate directly to a block of code statements at the time of event registration.
  • Google Maps Control for ASP.Net - Part IMar 27, 2008. This is a user control for ASP.Net. You can use this control to insert google map in your aspx pages.
  • Using LINQ to Objects in C#May 26, 2008. This article provides an introduction to employing LINQ to Objects queries to support a simple win forms application; the article addresses the construction of LINQ to Objects statements and then goes on to describe how one might use LINQ to Objects within the context of an actual application.
  • 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.
  • Generic Data Access using LINQ to SQL and C#Jul 22, 2008. This article discusses the construction of a generic data access layer built on top of a LINQ to SQL implementation.
  • Insert, Update and Delete in Silverlight DataGrid using ADO.NETJul 22, 2008. In this article will show how to perform CRUD (Create, Retrieve, Update, Delete) operations in Silverlight 2 using ADO.NET Data Services.
  • LinqDataSource Control in ASP.NET 3.5Sep 16, 2008. This article shows that how to use LindDataSource Control in ASP.NET 3.5.
  • Bulk DML With SQL Server 2005 - XML Data TypeOct 15, 2008. This article explains about doing bulk DML on SQL Server 2005 using XML datatype
  • Debug Javascript in Visual Studio 2005Nov 06, 2008. This article explains you how to debug script in VS2005 by using practical Google map example.
  • Using Lightbox in an ASP.NET Application (C#)Nov 17, 2008. The article describes Lightbox as, "... a simple, unobtrusive script used to overlay images on the current page." It delivers a nice, professional looking method for displaying images as overlays through the use of hyperlinks.
  • Select, Add, Update, and Delete Data in a ASP.NET GridView ControlNov 23, 2008. This articles describes you how to view, add, update, and delete data using an ASP.NET 2.0 GridView Control in SQL Server database and C#.
  • Using Statement in C#Feb 09, 2009. This article is about Using statement and how it has been implemented.
  • Simple & Complete GridView Functionality in .Net 2.0Feb 18, 2009. This article provides a single GridView which is capable of Displaying Data from database, Updateing it if required, Deleting the existing records from database based on a Confirmation Message and Inserting a new record(which is beyond the implicit usage of GridView).
  • WCF Service using ASP.NET and Client ScriptFeb 25, 2009. WCF Service using ASP.NET and Client Script
  • Create a SQL Server CE Database From SQL Schema FileMar 04, 2009. In this article, I will explain how to create a SQL Server CE .sdf database file from a database schema defined in .sql scripts.
  • Introduction to Windows PowerShell ScriptingMar 16, 2009. This article explains about scripting in Widnows PowerShell.
  • Building your own Java Script EditorMar 23, 2009. A step by step guide for implementing your Java Script editor.
  • Handling complex data types returned by Web services using JSON and jQuery in Microsoft.NET and Oracle ASApr 17, 2009. In this article, I will illustrate how to invoke an Ajax-enabled Web service which returns a complex data type (an array of products) from a Web service in Visual Studio.NET and JDeveloper.
  • Search and selection of data using LINQMay 27, 2009. In this article I will explain how you can use LINQ, when we should search and select some data according to parameters, defined by users.
  • Insertion at the begining of a Linklist in C#Jul 11, 2009. This code snippet shows how to insert data to a Linklist at the beginning.
  • Example of DataGrid in ASP.NETAug 11, 2009. The basic operations of DataGrid Like Edit, delete, Update, Insert record and show the data at the same page.
  • Inserting records in a database using stored procedure and ADO.NET technology.Aug 13, 2009. In this article I will explain you how to use CommandType stored procedure to insert records in a database in a disconnected manner.
  • Zero Server Controls technique in ASP.Net, C# (XML Insertion, JavaScript tricks using AJAX deletion and XSLT record display using JavaScript)Sep 07, 2009. Insert a record using XML, Delete a Record using Ajax and Display Results using XML and XSLT through JavaScript. No Server Side Controls have been used.
  • Client execution from server controlsSep 09, 2009. In this article I will expalin how to execute client script from server controls.
  • SQL Server 2005 features - Part ISep 18, 2009. This article explains about the features in the sql server 2005 with example sql statements.
  • Multiple user insertion in Sharepoint listSep 23, 2009. In this article, I am going to explain, how to insert multi user or more than one user in Sharepoint list.
  • Start using JQuery in Web ApplicationOct 11, 2009. In this article we will see how we can use jQuery compatible script in a simple web application. jQuery is a buzzword today for writing script behind in mark up.
  • 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.
  • Inserting Text in TextBox using Silverlight 3Nov 09, 2009. In this article we will see how can we insert text in any TextBox Caret position.
  • Control Statements in C#Nov 20, 2009. In this article I will explain you about different control statements in c#.
  • Exception Statements in C#Dec 24, 2009. In this article I will explain you about Exception Statements in C#.
  • Try-Finally in C# Dec 28, 2009. In this article I will explain you about Try-Finally in C#.
  • How to Return Value from Javascript to Server Side Dec 30, 2009. This article will teach you how to retrieve JavaScript functions Return Value to Code Behind
  • Throw Statement in C# Jan 01, 2010. In this article I will explain you about Throw Statement in C#.
  • Getting friendly with jQuery (A beginners guide + added auto TOC generation + text entry limit)Jan 09, 2010. jQuery is a javascript library with rich API to manipulate DOM, event handling, animation and ajax interactions. The following are the essential features of jQuery that makes it so appealing for client side scripting.
  • 9 simple steps to run your first Azure Table ProgramJan 11, 2010. Azure has provided 4 kinds of data storages blobs, tables, queues and SQL azure. In this section we will see how to insert a simple customer record with code and name property in Azure tables.
  • Updating the Database Using the Update Method in ADO.NETJan 11, 2010. In this article I will explain about Updating the Database Using the Update Method in ADO.NET.
  • Running the SQL Script File By Using The System.Diagnostics.Process ClassJan 20, 2010. Process Class Provides access to local and remote processes and enables you to start and stop local system processes.
  • Create a Data Adapter in ADO.NET Jan 28, 2010. In this article I will explain how to Create a Data Adapter in ADO.NET.

About Insert-Statement-with-PHP-script

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.
Download Free eBooks