C# Corner

Resources  
  • A Database Access Class with Overloaded SELECT StatementsJan 24, 2001. A useful database access class with overloaded SELECT and other statements.
  • Copying and Pasting on Clipboard using C#Feb 23, 2001. If you use CTRL+C, some data or files are copied to a system clipboard and stored in system memory and when you use CTRL+V, the data is copied back to wherever you paste it. The Clipboard class provides functionality to place and retrieve data from the system clipboard. Usually
  • Serializing Objects in C#May 14, 2001. In simple words serialization is a process of storing the object instance to a disk file. Serialization stores state of the object i.e. member variable values to disk. Deserialization is reverse of serialization.
  • Mobile Fun with XMLMay 24, 2001. Here is something really wonderful in Mobile field .This example is for authenticating the Mobile Users against his settings stored in XML file. This is really good where all the ease of XML is applied. Function open the XML file and particular node data validate it against user inputs and do the specified.
  • Working with OleDb Data AdaptersJun 20, 2001. This step by step article guides you to create your database applications using OleDb Data Adapters in VS.NET.
  • Mobile Page Unit of Mobile SiteSep 19, 2001. This is something like creating WAP Pages it is still as usual my basic starting So here i will be storing only some info but What it exactly is the same as if people heard of WAP Pages and many sites offer you to create your own WAP Pages similar to WebPages but limit it to the device size and strength.
  • GUI Based Opinion PollSep 26, 2001. This is a article on how to create a opinion poll in C#. It creates a Text file on your c drive storing the voting parameters in it.
  • Yahtzee Program Using C#: Part IIJan 31, 2002. This is an update of the Yahtzee program for VS 2005. Included in this version is a Game Reset and a High Score Tracker. The Top Ten High Scores are tracked using an Array with sortable components. In this article we will talk about the IComparable interface used to make an object stored in an array sortable.
  • 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.
  • .NET Static Variables : Better than Application!Feb 22, 2002. In traditional ASP, we always had the Application object to store application-wide variables in.
  • 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.
  • Daleks in .NETDec 11, 2002. The other night my girlfriend dragged me down to the NYC Public Library claiming that they had a huge Science Fiction movie section. Admittedly my taste in movies and my wife's taste in movies can vary slightly, however, I was willing to take a chance, given that rentals at the library are free as opposed to $4 at the local video store.
  • 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.
  • The "ins" and "outs" of Using Stored Procedures in C#Jan 27, 2003. This article reviews the creation of stored procedures with parameters using the Visual Studio IDE.
  • Accessing Sharepoint Portal Server 2001 in .NETFeb 19, 2003. Sharepoint portal server provides a set of COM API that can be used to access its functionality from .NET applications via COM Interoperability. In this article, I will show you how to import SPP functionality in your .NET application.
  • Use Thread Local Storage to Pass Thread Specific DataMar 18, 2003. The specific thread level storage is known as thread local storage or TLS for short. The .NET threading namespace allows .NET developers to use TLS from within their multi-threaded applications to store data that is unique to each thread.
  • Sorted List and Web Server ControlJun 09, 2003. This article shows you to take advantage of SortedList in data binding with Web Server controls.
  • DataGrid and CheckBox ControlsJun 17, 2003. How to have checkbox that is checked or unchecked depending on a field value stored in the Database, and then allow the user to click on it and record the new checkbox state in the database.
  • Data Access Layer based on dataSetsJul 01, 2003. This article aims to introduce the reader to several conceptual problems encountered in the development of a generic Data Access Layer (from now on referred to as DAL).
  • Data Access Component for SQL Server in C#Jul 07, 2003. The attached source code a data access component for SQL Server that contains methods to get a DataSet.
  • Storing Data in C#Sep 17, 2003. In this article, we will talk about C# data types and how data storage works with different types of data types.
  • Using Web.Config in ASP.NET and ASPJan 09, 2004. Web.config acts as a central location for storing the information to be accessed by web pages.
  • 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 VJan 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 : SQL Subqueries: Part VIIJan 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.
  • Real Life SQL and .NET: Part XIIJan 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.
  • Typed DataSets in .NETFeb 03, 2004. As all of we know, we can specify the data type when we create a DataColumn for a DataTable. This is to enforce the runtime type-safety for the column so that only data of specified data type can be stored in the column.
  • Directory Services Vs RDBMSFeb 06, 2004. When storing user information, developers can have two choices to choose from - Active directory and a relational database. This article sheds lights on usefulness of each of these and when to use one over the other and vice versa.
  • DataView in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataTable Events in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • Constructing a DataTable using C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataAdapter in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataReader in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataSet in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • Data Binding in DataGrid Control using C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • DataTable in C#Feb 17, 2004. The ADO.NET DataSet is a data construct that can contain several relational rowsets, the relations that link those rowsets, and the metadata for each rowset. The DataSet also tracks which fields have changed, their new values and their original values, and can store custom information in its Extended Properties collection. The DataSet can be exported to XML or created from an XML document, thus enabling increased interoperability between applications.
  • Transporting and Displaying Images using DIME and HTTP HandlersApr 28, 2004. This article shows an example of how to display images stored in a database in a virtual fashion using a Web Service in conjunction with an HTTP Handler.
  • Dynamic SQL Server Database Creation in .NETMay 03, 2004. This article explains step by step dynamic creation of a SQL Server database, tables and stored procedure using Visual Studio codename Whidbey and VB.NET.
  • Accessing Excel Spreadsheet in C#Jun 01, 2004. Most of the time you will use SQL, Oracle, Access or some other database to store data. But it is possible to use Excel spreadsheet much like a database to stored data. This article and code will explain how to do this in C#.
  • Evolving Numeric Series using Genetic Algorithms in C#Jul 27, 2004. If you ever browsed around the book store, you'll notice these puzzle books or IQ test books and some of the books contain questions asking you to complete a series of numbers.
  • Bulk Data Transactions using OpenXMLOct 13, 2004. OPENXML is a new function added to SQL Server 2000 that provides a rowset view over an XML document. Since a rowset is simply a set of rows that contain columns of data, OPENXML is the function that allows an XML document to be treated in the familiar relational database format. It allows for the passing of an XML document to a T-SQL stored procedure for updating the data.
  • Storing Images into a DatabaseOct 18, 2004. In order to provide your application with cool pictures you can employ two techniques (at least). One of them is that you can save the pictures in a folder and store the path to each one in a database or configuration file. The other one is to store the entire file into a database, along with its file name.
  • A Comprehensive View of SharePoint Portal Server 2003: Part INov 05, 2004. There are many portal solutions on the market, for example from IBM, Microsoft, Plumtree, Vignette, etc. Microsoft's latest portal solution is "Windows SharePoint Services" and "SharePoint Portal Server 2003". This article will not evaluate different portal solutions but rather explain how to use and develop for "Windows SharePoint Services" and "SharePoint Portal Server 2003" from Microsoft.
  • A comprehensive view of SharePoint: Part IINov 19, 2004. Enterprise portals are an important part of today's enterprise IT infrastructure. Portals are used as an entry point for a specific topic, organization, project or team. Many enterprises have an enterprise portal, opened by default when an employee opens up a browser, which shows general information about the enterprise, its strategy, its departments, etc.
  • How to generate unique integer IDs across multiple systemsNov 30, 2004. This article show to generate unique integers across environments. Generally repeating IDs in different environments are not a problem, but once in a while you need to migrate something from dev to staging, or from staging to production.
  • Talk to SharePoint through its web servicesDec 09, 2004. Microsoft Office 2003 is very tightly integrated with SharePoint by utilizing its web services. Windows SharePoint Services comes with sixteen different web services. SharePoint Portal Server 2003 supports an additional five web services. The web services provided by SharePoint do provide a vast array of features.
  • 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.
  • Performance Improvement in ASP.NET Using CachingFeb 01, 2005. ASP.NET provides caching at several levels for you to leverage and improve the responsiveness of your application by storing the page output or application data across HTTP requests and reuse it. This allows the web server to take advantage of processing the request without recreating the information and thus saving time and resources.
  • Starting With SharepointFeb 11, 2005. Microsoft came up with an idea of "Sharepoint Server", and now it's only a matter of few clicks to build an enterprise-portal. This article shows you how.
  • Session State Management in Application having ASP and ASP. Net PagesFeb 15, 2005. If we are developing a web application in which both ASP and ASP.NET pages resides, then passing session information from ASP to ASP.NET page or vice versa becomes a critical issue. To share session state between ASP and ASP.NET pages, session state need to be stored in some common format like in database.
  • Integration of InfoPath with SharePointApr 28, 2005. InfoPath is based on industry-standard Extensible Markup Language (XML). Extensible Markup Language (XML) is a condensed form of Standard Generalized Markup Language (SGML) that enables developers to create customized tags that offer flexibility in organizing and presenting information.
  • 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.
  • Programming with .NET Compact Framework 1.0 and SQL CE 2.0 : Part IJul 26, 2005. This article covers various major components for developing application for PDA .Before developing application targets to PDA device its very important to understand .NET compact framework, supported/unsupported features for smart device development, Difference between .NET compact framework and .NET framework and of course SQL CE if you want to store application data in SQL database.
  • SQLCLR DebuggingAug 09, 2005. In SQL Server 2005, CLR integration allows you to write stored procedures, triggers, user-defined types, and user-defined functions using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#. In this article, I will explain how to debug SQLCLR stored procedure or SQLCLR user-defined function.
  • SQLCLR DebuggingNov 10, 2005. In SQL Server 2005, CLR integration allows you to write stored procedures, triggers, user-defined types, and user-defined functions using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#. In this article, I will explain how to debug SQLCLR stored procedure or SQLCLR user-defined function.
  • 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.
  • Hashtable in C#Nov 14, 2005. Hashtable is useful when you need to store data in a key and value pair. This article shows how to use hashtable in C#.
  • How do I Pass the Required Parameters of a Stored Procedure in Crystal Reports?Dec 30, 2005. This small tip shows how to pass the required parameters of a Stored Procedure in Crystal Reports.
  • Using Crystal Reports 9 in Windows ApplicationJan 18, 2006. This article shows an application for storing the data using Microsoft Access and generating report using Crystal reports.
  • Creating Custom Templates in SharePointJan 29, 2006. This article is all about creating custom templates in SharePoint.
  • How to Read and Write System Registry Keys using C# (VS.Net 2005)Feb 09, 2006. Most of the time while working with the Enterprise Application will need to store the user preferences inside the windows system registry. In a general term Windows Registry is the database that holds all the settings Windows needs to function.
  • Displaying Single Table Database Hierarchy with DataSet and DataRelationsMar 03, 2006. Hierarchies can be difficult to store SQL tables and even more difficult to query and display. This Example will show you how you can use DataRelation to convert single table hierarchy in to nested XML and then use XSLT to transform it to nested list.
  • DataReader And DataSetMar 20, 2006. ADO.NET is part of Microsoft.NET which comprises a set of tools and object model for accessing a data source. The objects definition appears under the System.Data namespace. It allows applications to store, manipulate and retrieve data. In this article I’m going to talk about the two different objects for accessing data sources in two common contexts of your application: the connected and disconnected environment.
  • Dynamic Document ID's without Maintaining Counters!Apr 04, 2006. An article to demonstrate the creation of business document ids without using stored counters.
  • Deploying ASP.NET 2 Web Site to Production Server: Part IIApr 10, 2006. On the first part we discussed in detail how to move our database which contains the membership tables from the default aspnetdb Database to our database. On this part we will show how to change the default settings of asp.net membership and role providers to read from tables which stored on our database.
  • Merging data into single table from multiple tables (resultsets)May 15, 2006. This article shows how to reduce the number of trips to improve performance by merging data into single table from multiple tables (resultsets).
  • A Brief Overview of Sharepoint Portal Server 2003May 16, 2006. This article is a brief introduction of Sharepoint Portal Server 2003.
  • Application Scheduler Service Using C#.Net And XMLMay 29, 2006. This is an application scheduler that is implemented as a Windows Service, similar to the Windows Task Scheduler - but simple, as it has fewer configuration options and it uses XML to store and retrieve data.
  • Enabling CLR integration in SQL Server 2005Jul 31, 2006. One of the new features in SQL Server 2005 is the feature to write your own stored procedures using any language supported in .NET. This feature gives you more flexibility to implement any complex logic in your business scenario.
  • PDF Search in SharePointSep 11, 2006. This is a small article that tells users about the PDF search in SharePoint. I have not included the exact steps that need to be taken because that has already been published before on many sites including Microsoft's. My objective is tell users where to start looking for resources if they want to search PDF documents in SharePoint.
  • Creating a Workflow solution in SharePoint 2003Sep 18, 2006. There has always been a great demand for workflows in SharePoint. If you are a programmer, you can create a workflow solution of yourself and integrate it into SharePoint. In this article, I will give you some tips on how to create a workflow solution of your own.
  • Pull a column value from another list in your site in Sharepoint Portal ServerSep 21, 2006. In document and form libraries, you can create custom columns or metadata properties and interestingly, you can autopopulate these columns with data that can be hardcoded or extracted from other lists that are part of the same site where your document library is located.
  • SQL Server Backup file in standard Zip formatOct 12, 2006. This is SQL Server Backup and restore tool, the system will store the backup files in standard Zip format ,the user-friendly screen let you backup and restore SQL Server database to local harddisk or remote network driver easily and quickly.The program can restore database easily.
  • Book Store Application using ASP.NET 2.0Oct 13, 2006. This project is done using ASP.NET 2.0 and SQL Server 2005. This application covers all the basic aspects a developer needs.
  • Working with HashTable in C# 2.0Nov 13, 2006. We often need to store more than one dimension data in a list and data may not be an integer or string. This article shows how to use the HashTable class to store object type data.
  • Using ADO.NET concurrent model in Oracle databaseDec 07, 2006. The most popular instrument to access database data for .NET applications is ADO.NET. This set of components contains three main classes those are used to manipulate and store data: DataReader, DataSet and DataAdapter.
  • Access Sharepoint Portal Server using Web Services in .NETFeb 05, 2007. This article discusses how we can leverage Sharepoint Portal Web Services to work with WSS in Microsoft .NET. The sample code used in this article shows how to access Lists Web Service to get the available lists in WSS. The sample code also shows how to add and update list items.
  • Writing Managed Stored Procedures using C#Feb 19, 2007. This article is trying to explain the simple and required steps that are require starting the creation of Manage Stored Procedure using C# and using them.
  • Image Mapping UtilityFeb 23, 2007. This article describes an easy approach to building a simple image mapping utility that may be used to mark and store points as pixel based coordinates from an image file or directly from a web page.
  • Concurrency violation: the UpdateCommand affected 0 records. Mar 27, 2007. When you use a DataAdapter object to write changes back to a database by means of a stored procedure, you may receive the following error message: Additional information: Concurrency violation: the UpdateCommand affected 0 records.
  • Encrypted .NET Serialization to SQLite DatabaseJun 25, 2007. Sometimes, non-enterprise applications need the ability to store encrypted data locally. We'll explore 3 ways to serialize and encrypt data to a SQLite database file with C#.
  • .NET Serialization to SQLite Database Jun 25, 2007. Most non-enterprise applications need the ability to store data locally. We'll explore 3 ways to serialize data to a SQLite database file with C#.
  • Calling Oracle stored procedures from Microsoft.NETJun 29, 2007. This article is intended to illustrate how to illustrate how to call Oracle stored procedures and functions from Microsoft.NET through the Microsoft.NET Oracle provider and its object model residing in the namespace System.Data.OracleClient. I will cover several possible scenarios with advanced examples.
  • Using SQL Server 2005 system SP to change extended property values of database objectsAug 01, 2007. In this article, that is the logical continuation of the earlier published articles, I will show how you can update the value of an existing extended property or add a new extended property to a database object with the help of the system stored procedures of SQL 2005. The examples are written using T-SQL.
  • 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.
  • Share Point Portal Nov 08, 2007. This article explains brief description on share point portal server.
  • Programmatically uploading multiple files to Custom sharepoint list in 2007Nov 08, 2007. This article describes step by step processes to create a webpart in share point server 2007, and using the same how to programmatically upload Multiple files to Custom Share Point List in Share Point Server 2007.
  • Using Stored Procedures with ASP.NETDec 12, 2007. This article helps you to create a stored procedure on SQL Server and tells you how to use them in your asp.net applications.
  • Caching in ASP.NET 2.0Jan 08, 2008. Caching is a technique of storing a copy of data in memory. You could cache a page or the results of a query. The advantage of caching is to build better performance into your application.
  • Sharepoint Workflow Custom Activity for Active Directory & Deployment on Moss 2007Jan 16, 2008. This article tells you how to create your own custom workflow activities as components using Windows Workflow Foundation.
  • Developing a Web Part for Moss 2007Jan 17, 2008. This article describes the step by step process to develop a web part for Moss 2007.
  • Call any stored procedure which take input parameters and return output parametersFeb 01, 2008. This one generic function can call any Stored Prodedure which take input parameters and return output parameters with the help of two-dimensions array. This is very helpful specially when you designing n-tier application.
  • 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.
  • Understanding Connected World of MOSS 2007Feb 27, 2008. This article tells you the conceptual and real world industrial usage of MOSS 2007.
  • Features of WSS 3.0 and MOSS 2007Mar 04, 2008. This Article describes features of windows SharePoint services (WSS 3.0) and MOSS 2007. It describes basic difference between WSS 3.0 and Moss 2007.
  • Executing multiple stored procedures within a single transaction context from ADO.NetMar 20, 2008. This article discusses how we can execute multiple stored procedures in ADO.NET with different parameter values in a single Transaction context.
  • Manage Data in a Win Forms Application (without the Database)May 12, 2008. This article provides an approach to building an application that may be used to collect, store, and retrieve data without relying upon a database to get there.
  • Using Symmetric Algorithms to Encrypt DataMay 20, 2008. In this article, I will propose a method of how to encrypt data and store it using symmetric algorithms whose are, in fact, four integrated classes within the .Net framework, namely DES,RC2,Rijndael and TripleDES but I will perform the task using the two last ones as they are the mostly used in real time cases.

About SharePoint-store

NA

SPONSORED BY

Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.
European SharePoint Conference