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.
  • ColorDialog in C#Dec 21, 2000. A ColorDialog control is used to select a color from available colors and also define custom colors. This article demonstrates how to use a ColorDialog in Windows Forms and C#.
  • Using ListViews in C#Jan 18, 2001. As a Visual C++ user for 10 years I can say that Microsoft deserves praise for their new ListView class. The MFC ListView class was, well, unpleasant to use. C# makes life a bit easier with a richer property and method set for ListViews. Also, you can now, set the ListView to select an entire row in report mode, something that in Visual C++ you had to write a whole custom ListView control to do. Note also the nice grid lines.
  • A Database Access Class with Overloaded SELECT StatementsJan 24, 2001. A useful database access class with overloaded SELECT and other statements.
  • Directory Picker in C#Feb 07, 2001. A directory tree control let you select files or directories from any file structure on your computer system.
  • 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.
  • 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.
  • 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.
  • 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++.
  • 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#.
  • 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.
  • Assembly Browser: Browsing a .NET AssemblyMay 17, 2002. This program lets you browse an assembly and lists the methods and the parameter name and parameter type for each assembly.
  • 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.
  • 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).
  • MWControls v1.0.3.0May 05, 2003. This latest version includes Multi Select TreeView Control which lets you choose between a few different ways of selecting TreeNodes.
  • 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.
  • Installing a Service ProgrammaticallySep 04, 2003. With the arrival of .NET, creation of a windows service has become a piece of cake by just selecting Windows Service as project type in the New Project Dialog Box.
  • 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 VIJan 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 : 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.
  • Setting Ink Overlay Properties in Tablet PCJun 02, 2004. In this article, I will write an application that allows us to set the Ink Overlay properties dynamically based on the values selected by the user.
  • Tablet PC Ink Editing Modes - Select and Delete InkJun 25, 2004. In my previous articles, I discussed how to use Ink and set its properties to draw on a Windows Forms and Windows controls. In this article, I will discuss some more features of Tablet PC Ink including selecting and deleting ink, Ink collection, and Ink object.
  • Moving to ASP.NET: Part 1Aug 24, 2004. The attached white paper, Moving to ASP.NET, examines trends in the adoption of ASP.NET, and provides guidelines for selecting the migration approach that best meets specific business needs.
  • 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.
  • 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.
  • Selecting and Highlighting Multiple Columns in a Data GridJul 21, 2005. This article shows how to select multiple columns in a DataGrid and highlight the columns selected.
  • Multi Selection of DataGrid Rows without Ctrl ClickJul 31, 2005. This article shows how to select multiple rows in a DataGrid without using CRTL.
  • Learning Visual Studio 2005 IDE - Document Outline in Windows Forms 2.0Aug 02, 2005. We all have seen Document Outline feature in Visual Studio 2003, which allows ASP.NET developers to select a control on a Web Form and in code editor, it would select the code respective to that control.
  • 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.
  • Select/Deselect all Checkboxes at Server side in ASP.NET using C#Jan 11, 2006. In this article we will see that how to select/deselect all checkboxes using C#.net server side code inspite of simple Javascript code.
  • 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.
  • 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.
  • Client-Side XML Data Islands Jun 17, 2006. This article demonstrates how to send xml data to the web client, filter records from xml at client side by using XPath expression and populate all products of selected category into product drop-down.
  • Building applications with DLinq DesignerJul 01, 2006. DLinq designer is the visual design surface to create the entity objects and bound the controls to the dlinq objects with relationships. We can easily create the windows form using the designer. The developer need not take more time to design the User Interface. The designer itself suggests you the controls suitable for the selected fields.
  • 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.
  • Crystal report with Dynamic ColumnNov 03, 2006. The objective of this article is to provide a process which can be followed to develop a crystal report with dynamic columns using parameterized column fields and formula fields. Before going for this the developer has to decide the maximum number of columns he/she has to display and as per the no. of columns the size of the paper. The developer can define the size of the paper by selecting Printer Setup in File menu.
  • Strategy for querying Microsoft Access as an In-Memory Database using DataSets and ADO.NETJan 09, 2007. This article describes how you can read tables in from MSAccess up front in your application and then query the tables in-memory using some powerful features of the DataSet and ADO.NET
  • Simple Web and RGB Color Picker UtilityFeb 08, 2007. The article addresses the construction of a simple utility application useful for selecting an RGB or web color.
  • 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.
  • Bulk Uploader in ASP.NET 2.0Mar 28, 2007. The FileUpLoad control enables you to upload file to the server. It displays a text box control and a browse button that allow users to select a file to upload to the server.
  • 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.
  • Manage Ads with AdRotator Control in ASP.NET 2.0Jun 15, 2007. The AdRotator control available in ASP.NET 2.0 allows you to manage and run ads on a website. The AdRotator control selects and displays an ad randomly each time a page is refreshed.
  • Select Items with Where in LINQ and C#Jun 21, 2007. This article shows how to select exact match and in between items from a collection using LINQ and C#.
  • 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.
  • Selecting multiple Checkboxes inside multiple GridViewsOct 04, 2007. Ths article describes how to check/ uncheck multiple Checkboxes inside two or more GridViews on same page with Masterpage and usercontrols.
  • Find the First and Last Days of the Month with C#Oct 31, 2007. This article shall describe a very simple approach to finding out the first and last day of the month based upon either a selected date or selected month.
  • ASP.NET Multiple File UploaderJan 04, 2008. This article tells you how to allow users to upload more than one file at a time.
  • SQL Server backup utility using VB.Net and SQL-DMOFeb 05, 2008. This article allows you to take backup of any SQL Server database using SQL-DMO library. It allows you to take backup of selected tables, views or stored procedure.
  • Selecting Checkboxes inside the GridView ControlFeb 27, 2008. This article explains about how to select checkboxes inside the GridView control using javascript.
  • 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.
  • Killing Processes From a Windows Form Application in C#May 01, 2008. This article provides you a simple example of how to use the System.Diagnostics.Process library to display a list of running processes, and to select and kill processes by their process name and ID.
  • 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.
  • 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#.
  • OpenFileDialog in SilverlightNov 30, 2008. The OpenFileDialog allows users to select one or more files on the local computer or on a networked computer. This article demonstrates how to create and use an OpenFileDialog control in Silverlight using XAML and C#.
  • Silverlight Date Picker ControlDec 08, 2008. The DatePicker control in Silverlight 2 enables you to select a date by either typing it into a text field or by using a drop-down Calendar control.
  • Reading Text Files using OpenFileDialog in SilverlightFeb 04, 2009. In this article, you will learn how to select and read files using OpenFileDialog in Silverlight 2.
  • Using Statement in C#Feb 09, 2009. This article is about Using statement and how it has been implemented.
  • 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.
  • Recruiting the right candidateMar 07, 2009. Every team member either contributes to or erodes the team’s success. No matter how experienced you are, the art of selecting the right person is more art than science.
  • Introduction to Windows PowerShell ScriptingMar 16, 2009. This article explains about scripting in Widnows PowerShell.
  • Using a Combobox to Select ColorsMar 19, 2009. This is a short article on how to use a combo box control to display and select all the named colors.
  • 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.
  • Master-detail data-binding using two Web pages in ASP.NET 2.0Apr 29, 2009. This article is intended to illustrate how to implement the master-detail presentation pattern using the ObjectDataSource components and two Web pages in ASP.NET 2.0. Master-detail presentation pattern is one of the techniques most used in enterprise applications intended to visualize one-to-many relationships, for example, let’s suppose the following a common business scenario where we want to display a list of subcategories of products, and allow the user select a particular subcategory in order to display the list of associated products.
  • 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.
  • Tip: How to Highlight Rows in a DataGrid Using a CheckBoxJun 25, 2009. This code snippet shows how to select or highlight selected rows in a DataGrid based on a CheckBox column similar to yahoo or hotmail emails.
  • Selecting TreeView Nodes in Silverlight 3Aug 05, 2009. We will see in this article about selecting TreeView nodes in Silverlight 3.

About Select-Statement-with-PHP-script

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.
European SharePoint Conference