C# Corner

Resources  
  • 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.
  • 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.
  • Creating a User Control: .NET Toggle ControlNov 16, 2001. This is a C# User Control which re-creates the toggle used by XML, HTML, etc. files in the .NET Developer Studio. Just compile the control and drag it onto a form from the Windows Form Toolbox.
  • How to create a "ComboBox button" in a toolbar in .NETNov 20, 2001. You can actually put a ComboBox in your toolbar by just dragging a ComboBox from the toolbox onto the toolbar but if you want the ComboBox to be one of the toolbar buttons, you are out of luck using the regular old ComboBox. One way around this is to use the DropDownMenu style of a ToolbarButton to create a pseudo-ComboBox.
  • Saving and Restoring Location, Size, and Window State of a FormMar 01, 2002. This article presents a simple C# class that may be added to a form to automatically do this. When I designed this class I wanted to be able to add it to a form using the least amount of code and also be able to add it to a form from the toolbox.
  • 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.
  • Creating Graphics with XMLApr 09, 2002. This article shows how to create images on the fly and uses XML to specify the properties of the images.
  • XML Schema ValidatorApr 16, 2002. The XML Schema Validator checks if a given XML document is well formed and has a valid schema model.
  • 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.
  • ADODB Services in .NET Applications Using C#Dec 31, 2002. With the advent of ADO.NET, the .NET Framework lets you work with your data in a paradigm shift.
  • FTP Client ComponentJun 12, 2003. An FTP Connection component that you can add to the toolbox of your IDE.
  • DataSets in Microsoft .NETFeb 20, 2004. ADO.NET was designed to meet the needs of this new programming model: disconnected data architecture, tight integration with XML, common data representation with the ability to combine data from multiple and varied data sources, and optimized facilities for interacting with a database, all native to the .NET Framework.
  • SOAP Client in Windows XPMay 06, 2004. This article covers the basics of using the SOAP Client software included with Microsoft Windows XP Professional to access Web Services using SOAP.
  • Validating Input Xml Data FilesJun 28, 2004. In this article we'll discus two strategies for validating input XML data files. The validation of an XML input file could occur at various instances of processing.
  • Retrieving Schema Information Using ADO.NET and C#Jul 06, 2004. In this article, I will describe the ways to retrieve the database schema information using System.Data.SqlClient class and the System.Data.OleDb class.
  • In-depth Look at WMI and Instrumentation: Part ISep 14, 2004. WMI provides a consistent programmatic access to management information in the enterprise. It uses the typical provider and consumer concept where you have on one side components providing this management information while on the other side management applications can subscribe and consume it.
  • 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.
  • CopySchema - Part 2Oct 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.
  • 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.
  • Leveraging on XML feature of Microsoft Office Word 2003Nov 24, 2004. Word 2003 came up with a new feature of saving the conventional word document (.doc) files in the XML format. You can retrieve the information inside the Word 2003 documents by using the XPath queries and some logic.
  • Data Access Layer to execute Stored ProceduresJan 18, 2005. This article explains about executing a single stored procedure or batch of stored procedures from the application layer. As Data access layer completely decoupled from Application layer we just need to change the Application layer in case of any change in underlying database schema.
  • Best Approach for Designing Interoperable Web ServiceMar 15, 2005. This article will clarify and explain in detail the different Web Service Design Methodologies as defined by the Web Services Standardization Groups, clarify the terms, highlight their differences.
  • Using Snippets in Visual Studio 2005Nov 10, 2005. Visual Studio contains several built-in intellisense code snippets. Snippets are like templates and can be described completely in XML. If you understand the snippet xml schema, you can easily begin to create your own snippets.
  • How to Execute Oracle Stored Procedures Dynamically in C# Nov 10, 2005. In this article, I wiil show how we can store schema of stored procedures in an XML file and load and run the stored procedure from UI application using C# and Oracle.
  • Using XML and XSLTJan 18, 2006. XML Stylesheet Transformation(XSLT) is defined as a language for converting XML documents to other document formats. This article shows how to perform the transformation using classes of .NET Framework.
  • Mimic the Appearance of Outlook's Sidebar with the Multi-view ControlDec 14, 2006. This article describes a simple way to mimic the appearance of Microsoft’s Outlook sidebar within an ASP.NET 2.0 web application. The approach is based upon the use of the existing Multi-View control contained in the standard ASP.NET 2.0 toolbox and does not require much time or effort to implement. This article includes a sample web application that presents an example of the approach in use.
  • Build Your Own Visual Studio: An Application Framework for Editing Objects at Run TimeDec 22, 2006. This article describes a generic application framework that may be of some use in projects that would need an interface similar to Visual Studio. The application demonstrates approaches to providing a toolbox, a workspace, an object treeview, and an object editor.
  • 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.
  • Docking Controls - Standard and CustomMar 16, 2007. This article addresses the user of the standard 2005 toolstrip container control used in conjunction with toolstrips and discusses an approach to building a custom dockable tool palette.
  • View database structure using C#Jan 16, 2008. This article describes an easy approach for examining all of the tables, views, and columns in a database.
  • Biztalk Messaging Services: Flat File SchemaJan 21, 2008. This article is intended to consolidate the principles of messaging in Biztalk Server 2006.
  • Biztalk Messaging ServicesMar 27, 2008. This article is intended to illustrate the concepts of mapping in Biztalk Server 2006.
  • Best Practices for Data Transfer in SQL Server 2005Jun 23, 2008. This article talks about some best practices and the process of data transfer in SQL Server 2005.
  • Invalid FORMATETC structure ErrorSep 12, 2008. This tip shows how to fix Invalid FORMATETC structure error when you drag and drop a control from Toolbox to a XAML file.
  • Working with Silverlight Toolkit: Part IINov 25, 2008. The Silverlight Toolkit provides a variety of rich controls to supplement the existing Silverlight controls. This article describes how to add the Toolkit controls to your Toolbox and make use of the AutoCompleteBox control.
  • 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.
  • Hello WorldMar 16, 2009. The goal of this article is to teach and explain C# in such a way so that when you have finished it you will be able to program in C#.
  • Promoting Schemas Properties in BizTalk ServerMar 18, 2009. A common scenario in a BizTalk solution is to subscribe to a message based on its content or context and make decisions based on the underlying values. This is known as content-based routing. In this article, I will cover the principles and techniques to expose this sort of metadata in BizTalk Server.
  • Parsing BizTalk Messages in .NET Components Through OrchestrationApr 30, 2009. This article discusses how to parse BizTalk messages in .NET Components through Orchestration.
  • Receiving Messages With Multiple Schemas in a Single OrchestrationSep 18, 2009. In this article, I will cover how to receive two messages with different schemas in a single orchestration in order to process them instead of creating separate orchestrations for each message with identical business logic. For the solution, I will use the Listen shape along with two Receive shapes each of them listening for different messages.
  • XML NamespacesNov 18, 2009. In this article I will explain you about XML namespace, DTD and schemas and Extensible Hyper Text Markup Language.
  • Standardizing Incoming Messages Using Inbound Maps Tab on Receive Port Properties in BizTalk ServerNov 25, 2009. In this article we will see how to develop integration applications which receive documents with different schemas arriving from external entities, and it’s required to transform each format to a common (canonical) internal schema using port maps on the receive ports in BizTalk Server.
  • Visual Studio .NET and XML SupportDec 02, 2009. In this article I will explain you about Visual Studio .NET and XML support.
  • Working with DataSetsDec 04, 2009. In this article I will explain about working with DataSets.
  • Adding Typed DataSets in ADO.NET Dec 13, 2009. In this article I will explain about Adding Typed DataSets in ADO.NET.
  • Using the Data Form Wizard in ADO.NETDec 17, 2009. In this article I will explain about using the Data Form Wizard in ADO.NET.
  • Creating a Guest Book in ASP.NET Jan 29, 2010. In this article I will explain Creating a Guest Book in ASP.NET.
  • Getting a Database Schema Mar 11, 2010. In this article I will explain getting a Database Schema.
  • Compare Two XML Files Using .NetMar 23, 2010. In this tool, we Validate the schema and compare the data's of two XML files.
  • Validation in Linq to SQL and ASP.NETMay 19, 2010. In this article, I will show how to add business rules to Linq to SQL data model default set of schemas.
  • Toolbar in C#Jul 18, 2010. Toolbar control is not available in Toolbox of Visual Studio 2010. ToolStrip control replaces Toolbar in Visual Studio 2010. But for backward compatibility support, Toolbar class is available in Windows Forms. In this article, I will discuss how to create and use a Toolbar using Toolbar class in a Windows Forms application.
  • Model-First Design using ADO.NET Entity Framework 4.0 Jul 19, 2010. In this article we are going to see the second most importment part of the ADO.NET entity framework 4.0.
  • Using Tools and Windows in Expression Blend 2.0Sep 14, 2010. This article is a basic introduction of Expression Blend 2 and how to use various tools in Expression Blend. I am using Expression Blend version 2.0.
  • Schemas in SQL ServerOct 18, 2010. Schemas are nothing but logical grouping of objects either it may be a table or view or stored procedure or function or any other DB objects.
  • Chapter 3: Data-Tier ApplicationsNov 30, 2010. With the release of Microsoft SQL Server 2008 R2, the SQL Server Manageability team addressed these struggles by introducing support for data-tier applications to help streamline the deployment, management, and upgrade of database applications. A data tier application, also referred to as a DAC, is a single unit of deployment that contains all the elements used by an application, such as the database application schema, instance level objects, associated database objects, files and scripts, and even a manifest defining the organization’s deployment requirements.
  • How to add reusable codes in Visual Studio Toolbox Feb 26, 2011. This article shows how to use the Visual Studio Toolbox to make reusable code available to any project.
  • SQL Server Schema Comparison in Visual Studio 2010Mar 05, 2011. This article explains the new tool in visual studio 2010 which most of the users require seeing the comparison report of the 2 different database schema (say a development and a production db) in order to get the object that has been changed for the current releases.
  • Create a Strongly Typed DataSet Using The XML Schema Definition Tool (XSD.exe)Jun 27, 2011. In this article we are going to see how to create a strongly typed DataSet from a XSD schema file using the XML Schema Definition Tool (XSD.exe).
  • Progress bar custom ControlOct 13, 2011. Create a Progress Bar custom control and add it into the Toolbox and drag and drop this custom control into another application.
  • XML SchemaValidatorDec 01, 2011. This article shows how to validate an XML document against a schema using C#. For demonstration of this, I have created a GUI application using Visual Studio 2005 Express Edition.
  • Creating a Model Class to "LINQ to SQL" using ASP.NET MVC Dec 06, 2011. This is a simple application that show how to create model class to Link to Sql in MVC ASP.NET. In this application we first create the database after that create the schema and insert the data.
  • Entity Framework: Part 1Jan 18, 2012. The Entity Framework facilitates the development and conceptual use of application models for development instead of directly using relational storage schema.
  • Merge the Content of DataSets in ASP.NETJun 17, 2012. This article shows the use of the Merge() method in C# to merge two or more DataSet objects that have largely similar schemas to exist in the same Data Container.
  • Architecture of Search Schema in SharePoint 2013Oct 23, 2012. In this article we can see some very good information about the Search Schema of SharePoint 2013. The search index is one of the most important elements in search architecture. What is in our search index determines what people will find when they look for information by entering search queries or by interacting with internet or intranet pages.
  • An Application Framework for Editing Objects at Run Time in VB.NETNov 09, 2012. This article describes a generic application framework that may be of some use in projects that would need an interface similar to Visual Studio. The application demonstrates approaches to providing a toolbox, a workspace, an object treeview, and an object editor.
  • Secure WS in VB.NETNov 09, 2012. This code covers the .NET (VB) implementation of the security of webservices using the Microsoft “The Favorites Service” security modified schema.
  • ASP.Net Toolbox (Standard Controls): Part 1 in VB.NETNov 10, 2012. In this article we will discuss, ASP.Net Toolbox controls and its uses.
  • ASP.Net Toolbox (Data Controls): Part 2 in VB.NETNov 10, 2012. In this article we will discuss, ASP.Net Toolbox controls and its uses. In this article I am only writing some lines on each and every control available in Data Control section.
  • ASP.Net Toolbox (Validation Control): Part 3 in VB.NETNov 10, 2012. In this article we will discuss, ASP.Net Toolbox controls and its uses. In this article I am only writing some lines on each and every control available in Validation Control section.
  • XML TreeView in VB.NETNov 10, 2012. The application shown here was my first adventure into Xml in the .Net platform. My goal was to be able to reflect any Xml file into the Windows Forms TreeView control. I found various examples online, but none I found were suited for opening all Xml files, rather they were suited to one schema or another.
  • ASP.Net Toolbox (Navigation Control): Part 4 in VB.NETNov 10, 2012. In this article we will discuss, ASP.Net Toolbox controls and its uses. In this article I am only writing some lines on each and every control available in Navigation Control section.
  • XML Schema Validator in VB.NETNov 10, 2012. The XML Schema Validator checks if a given XML document is well formed and has a valid schema model. If it finds the document is not a valid XML schema, it generates the error telling the problem in the schema.
  • ASP.Net Toolbox (Login Control): Part 5 in VB.NETNov 10, 2012. In this article we will discuss, ASP.Net Toolbox controls and its uses. In this article I am only writing some lines on each and every control available in Login Control section.
  • Generating XML from SQL Database in VB.NETNov 10, 2012. This sample shows how you can obtain a Dataset from (in this case) a SQL Server database, and then write it out to an XML Document. As an "Extra Added Bonus(tm)", it can show you how to write the schema as well.
  • ASP.Net Toolbox (AJAX Extensions Control): Part 7 in VB.NETNov 10, 2012. In this article we will discuss, ASP.Net Toolbox controls and its uses. In this article I am only writing some lines on each and every control available in AJAX Extensions Control section.
  • ASP.Net Toolbox (WebParts Control): Part 6 in VB.NETNov 10, 2012. In this article we will discuss, ASP.Net Toolbox controls and its uses. In this article I am only writing some lines on each and every control available in WebParts Control section.
  • ASP.Net Toolbox (Dynamic Data Controls): Part 8 in VB.NETNov 10, 2012. In this article we will discuss, ASP.Net Toolbox controls and its uses. In this article I am only writing some lines on each and every control available in Dynamic Data Control section
  • ASP.Net Toolbox (Reporting Controls): Part 9 in VB.NETNov 10, 2012. In this article we will discuss, ASP.Net Toolbox controls and its uses. In this article I am only writing some lines on each and every control available in Reporting Control section. In coming day you will find separate article on each control
  • Secure WS in VB.NETNov 10, 2012. This code covers the .NET (VB) implementation of the security of web services using the Microsoft “The Favorites Service” security modified schema.
  • Schema in SQL Server 2012Dec 03, 2012. In this article I describe schemas in SQL Server 2012.
  • Visual Studio 2012 SQL Schema ComparisonJan 30, 2013. Visual Studio 2012 is very much a developer friendly and robust IDE. This article covers the enhanced schema comparison tool in terms of friendliness using self explanatory pictures/images.
  • Using Windows Control in WPFFeb 04, 2013. In this section we are going to learn how to use Windows Forms Controls in WPF.
  • The Database Principal Owns a Schema in the Database, and Cannot be DroppedMay 06, 2013. I encountered a problem today and thought to share with all of you so that in the future, if you confront such an issue then this article may help you.
  • Schema Compare Using Visual StudioMay 25, 2013. Consider a situation where we need to compare multiple databases and update one of those with latest changes. This can be easily achieved by using Schema Comparison Utility available in VS 2013/2012/2010/2008/2005, almost all versions.
  • How to Disable Mouse Scroll in DevExpress LookupEdit ControlJun 28, 2013. LookupEdit is another one of the most commonly used controls in the DevExpress WinForms library since it resembles the default ComoboBox control provided in the default .Net Toolbox.
  • Drag and Drop Code Into Toolbox in Visual StudioAug 03, 2013. In this article you will learn how to drag and drop code into/from the Toolbox in Visual Studio.
  • Validating an XML Document ProgrammaticallyAug 18, 2013. This article provides an example of validating a XML document using the XmlReader and XMLScema class of System.Xml and System.Xml.Schema.
  • Let’s Understand the Levels of Document Object Model (DOM)Sep 27, 2013. This article describes the levels of the Document Object Model (DOM).
  • Copy Table Schema and Data From One Database to Another Database in SQL ServerOct 03, 2013. This article is all about how to copy table and its data in SQL Server using Query as well as graphically.
  • Oracle SQL Commands : Part 3 Oct 29, 2013. In Oracle we can create our own procedure. A procedure is a collection of SQL statement that can be called by any valid object name and create a user-defined procedure we use the command create Procedure.
  • Creating a Simple User Control and Adding it to the ToolboxOct 30, 2013. In this article we will spend some time to learn how to create a simple User Control in C# and add it to the Toolbox.
  • Modifying InfoPath Form Based on XSD Schema Using Resource FilesDec 16, 2013. I came across a scenario where an InfoPath form was created based on an XSD schema. This schema changed frequently and the corresponding changes had to be made to the UI (InfoPath form template) accordingly.
  • Playing Audio and Video File in Windows Form ApplicationJan 23, 2014. Here, I will explain how to store audio and video files in, and how to restore them from, a local database then how to play them in the Windows Media Player.
  • Query to Find All About Database SchemaJan 26, 2014. In this short tip you will learn how to find information about a database schema in SQL Server.
  • Using Entity Framework to Work With DatabaseFeb 11, 2014. This article describes the database creation with the Entity Framework. You can also learn to apply the Data Annotation attributes in the database schema creation.
  • Memory-Optimized Tables in SQL Server 2014Mar 03, 2014. In this article you will learn about memory-optimized tables in SQL Server 2014.
  • Implementing the ListPicker Control in Windows Phone Application Using C#Mar 13, 2014. In this article we will implement a ListPicker Control that is not actually imbedded in the toolbox but it is very useful.
  • SPCurrentContext Activities in Visual Studio 2013 Toolbox For SharePoint 2013 WorkflowsJul 09, 2014. This article explains how to use the SPCurrentContext toolbox activities in SharePoint 2013 workflows.
  • Create, Update, Delete and Copy Item Activity in SharePoint 2010 WorkflowJul 09, 2014. This article explains how to use create, update, delete and copy an Item activity that is available in the Workflow Toolbox to create and update an existing item or to delete and copy an item from one document to another in the Document Library in a SharePoint List using Visual Studio 2010.
  • Create, Update and Delete List Item Using Builtin Activity in SharePoint 2013 WorkflowsJul 10, 2014. This article explains how to Create, Update and Delete a List Item using a builtin activity available in the workflow toolbox for SharePoint 2013 in Visual Studio 2013.

About schema-toolbox

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