C# Corner

Resources  
  • FileDownloader : Download files using HTTPJan 10, 2000. This application contains a Form and a Class module . From Form we create a thread which execute the procedure to handle the NET download. This application can be enhance to do more down load as in Download manager by creating more threads.
  • A Database Access Class with Overloaded SELECT StatementsJan 24, 2001. A useful database access class with overloaded SELECT and other statements.
  • Protecting IL Code from unauthorised DisassemblingApr 09, 2001. Microsoft .NET proved a mechanism where the code written in VB.NET, C# or any CLS compliant languages to generate MSIL (Microsoft Intermediate Language)code which targets the CLR and executes. This is an excellent mechanism to abstract the high level code from the underlying hardware.
  • Assemblies : The Ins and Out : Part IApr 13, 2001. In Part 1, I will cover what exactly an assembly is, and what an assembly contains.
  • Assemblies : The Ins and Out : Part IIApr 16, 2001. In this part, I will discuss both Private and Shared assemblies and how to create a "Shared Assembly".
  • Assemblies : The Ins and Out : Part IIIApr 20, 2001. In this part I will discuss in more detail than Part 2, the available utilities for manipulating assemblies.
  • Defining Custom Entry PointsApr 30, 2001. In this article i am going to demonstrate how we can manipulate the IL code to change the behaviour of how the .NET programme executes.
  • Wireless Model : How Does It Work?May 09, 2001. The browser sends an HTTP request to the Web server, which interprets the request and determines which resources to retrieve or execute. If the URL specifies a file, then the server sends it back.
  • Synchronization in Parallel threadsJul 02, 2001. The Threads makes us able to run multitasks at a time. In fact Computers (John von Neumann Architecture) don't execute the tasks parallel .The OS gives threads permission (depend on thread priority) to work on CPU. The sufficient degree of parallelism keeps the CPU busy and it is efficient.
  • Working with ReflectionJul 05, 2001. This article is about the use of reflection package in Csharp. Through Reflection we can get Information about the class.
  • XML GeneratorAug 17, 2001. This article is about advance use of reflection package in Csharp.
  • Real-time Message Logging Utility - Part 1Apr 01, 2002. A message logger is a utility that helps in logging the messages thrown from functions/programs. It is useful in critical applications as it helps to know the time taken by a function to execute, the time that the function remained idle and any messages that the function wants to be logged for further analysis.
  • 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.
  • Shell Commands within C#Jul 10, 2002. In this article we will examine a few examples for executing shell commands outside of our program using C#.
  • Using DTS from C#Sep 16, 2002. In this article I will concentrate on enumerating, executing and changing properties or global variables of DTS package.
  • Using SQL in .NET: Part 1Oct 04, 2002. In this article, I will show you how to execute SQL queries from your C# applications.
  • 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.
  • DTS Custom Task in C#Jan 28, 2003. During last year I wrote an article about DTS and how to use it in C#. In that article I stated that I didn’t manage to solve the problem related to CustomTask. Today I finally forced myself to tackle that problem again and here is the result. Writing simple CustomTask in C# is the easiest part.
  • An XML-RPC Package for .NETFeb 06, 2003. This package provides a simple XML-RPC client and server for C# applications. It's pure C#, using .Net for networking and XML functionality.
  • Run Time CompilerFeb 07, 2003. In this article, I am going to discuss how to take a string then compile it and then how you execute it.
  • Basics of Extending Your Working Environment in Visual StudioApr 10, 2003. All of us have used Macros in Microsoft Office and Add-ins in Visual Studio 6 and I am very sure all of us have been impressed as well by their power to control their own working environment.
  • 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.
  • Distributed Computing Using .NET RemotingJan 05, 2004. AppDomain is an isolated environment for executing Managed code. Objects within same AppDomain are considered as local whereas object in a different AppDomain is called Remote object.
  • Code Access SecurityFeb 06, 2004. Code Access Security represents a fundamentally different way of controlling access rights to protected resources. Traditionally, permissions such as access to the file system, databases or network were allocated based on characteristics of the user. All processes executed by the user would assume an equivalent set of permissions.
  • Transforming Visual Studio .NET Projects into NANT files using XSLT and .NETApr 16, 2004. I was looking for a solution on how to execute an XSL transform on a C# project file and convert it to a Nant build file. Nant provides the xsl file to do the conversion under the open source license agreement, but Nant does not provide away of producing the transformation.
  • 3D Real-Time Stock Exchange Quote Stream Ticker in GDI+ and C#Oct 04, 2004. This article represents 3D Real-Time Stock Exchange Quote Stream Ticker version 1.0. The big option here is internal email-alert control with built in POP3 and SMTP protocols. This control starts when some condition is execute. You can save current quote in some graphics format and print it.
  • 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.
  • Asynchronous Data Access using Callback ModelAug 17, 2005. The problem with the ADO.Net 1.x is that one thread has to wait for the other thread to complete. So to overcome this problem Microsoft has introduced Asynchronous data access, through which one can execute multiple threads at a time.
  • Top 10 New Features in ADO.NET 2.0Aug 19, 2005. This article summarizes the new and updated features of ADO.NET 2.0, which ships with .NET Framework 2.0. In my following articles I will discuss these features in more details with sample examples.
  • RegisterWaitForSingleObject in ThreadPoolNov 04, 2005. In this article, we are going to describe how to use Threadpool to execute a thread at specified time interval or instant by using Threading AutoResetEvent.
  • 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.
  • 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.
  • System Date Time Check FormatOct 18, 2006. This program executes the system date time format. Is it in dd/mmm/yyyy or other format and the which cultuerInfo is the system running on.
  • How to Execute an Application in a Remote Application DomainJan 18, 2007. This article explains executing an application in a remote application domain
  • OleHelper for Microsoft Access (.MDB) in ASP.NET 2.0Apr 18, 2007. This article is very much similar to the Microsoft Data Access Application Block, provides static methods in a "sealed class OleHelper" where I have Execute Dataset, ExecuteNonQuery & PrepareCommand to work with Microsoft Access database.
  • Error Opening SSIS PackageMay 30, 2007. I got a weird error when trying to open an SSIS package in VS2005.
  • Using the BackgroundWorker Component in .NET 2 ApplicationsJul 03, 2007. In this article I will show (step-by-step) how you can use the BackgroundWorker Component in .NET 2 applications to execute time-consuming operations.
  • Multi-threaded Asynchronous Programming in C#... Through The Web Page. Part VIJul 27, 2007. Async web pages which are primarily used as a server performance enhancement. There are two main methods we will be looking at that are used to execute operations asynchronously from web pages: Page.AddOnPreRenderCompleteAsync() and Page.AddOnPreRenderCompleteAsync().
  • Introduction to Building a Plug-In Architecture Using C#Sep 10, 2007. In this article we'll take another look at how we can use the state pattern to build a plug-in architecture that will allow us to change the behavior of our application by placing differnt plug-ins into a folder.
  • Functional Programming with C#: Asynchronous Method CallsJan 20, 2008. With the functional programming style and extension methods it is extremely easy to execute methods asynchronously. This article cover some simple extension methods that will allow you to easily execute your methods asynchronously with threads from the thread pool.
  • Dynamic Building and Execution of Assembly Using CodeDome & ReflectionFeb 01, 2008. This article shows how to enter code, compile it , execute it and apart from that access code and data member from the main or other referenced assembly during runtime.
  • Using the BackgroundWorker componentMar 12, 2008. This article discusses the BackgroundWorker component in .NET 2.0, it will show you how to use it to execute tasks in the background of your application
  • 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.
  • Methods, Delegates, Anonymous Delegates, and Lambda Expressions... Oh My!Mar 22, 2008. This article covers different syntax we can use for declaring and executing methods.
  • Using OUTPUT Clause for Getting Deleting Information from Several Tables.Apr 01, 2008. In this article I will explain how you can use such a T-SQL (SQL Server 2005) feature as OUTPUT clause in order to get information about rows, which were affected, when deleting process is executed for several tables, “connected” by foreign keys. The examples are written using T-SQL and C#.
  • High Performance Abstraction Layer for Non-Blocking Asynchronous Thread Safe SqlServer CallsApr 25, 2008. One of the things I find myself doing frequently is writing (and re-writing) plumbing code to execute database CRUD operations. I wrote an abstraction layer over asynchronous SqlServer calls that allows developers to correctly make async calls agains SqlServer without having to deal with any of the complex plumbing normally required. All source code is included with this article.
  • Multiple Active Result Sets (MARS)May 12, 2008. This article gives you information about the Mars a feature supported by MSSqlServer 2005 and .Net 2.0/3.x, which is a feature to execute more than one query with one single connection to database.
  • Model View Presenter (MVP)Dec 31, 2008. In this article we will understand MVP, execute a sample project with MVP, implement the same using windows UI and then finally we will discuss about the differences between MVP and MVC.
  • Unified Modeling Language (UML): Part IIFeb 27, 2009. This is second part of the series of articles on Unified Modeling Language (UML).
  • Introduction to Visual Studio Add-insMar 03, 2009. This article explains about Visual Studio 2008 Add-ins.
  • Introduction to Interfacing Win Forms with VS Add-insMar 04, 2009. This article explains about integration of Windows Forms with Visual Studio Add-ins.
  • Include Files in Application Package in Silverlight 2.0Mar 13, 2009. This article describes how to include files in application .xap package and read them.
  • State Machine Work flow DiscussionMar 14, 2009. This is a nice talk between Mr. RC and Mr. Shiv about state machine work flow. RC starts talking about an order project and they end up in a nice discussion which gives us step by step approach of how to execute a state machine work flow.
  • Paging and Sorting ListViews with ASP.NET MVC and jQueryMar 23, 2009. This article provides a simple example of using jQuery along with the jQuery tablesorter and tablesorter.pager plug-ins to provide sorting and paging support for a listview within the context of an ASP.NET MVC application. JQuery has partnered with Microsoft and is now integrated within the IDE to include the availability of intellisense support.
  • Simple 6 steps to use stored procedure in LINQJul 08, 2009. This is an extremely small article which describes how to flourish LINQ objects using stored procedure. What provoked me to write this article is the ‘ExecuteMethodCall’ function which helps to execute stored procedures in LINQ. As this is a protected function it changes the way you architect the DAL using ‘DataContext’ class and probably you would like to tweak and consider some options here. You can see more details of it when you read through the steps below. I am writing a huge series of LINQ FAQ and these small articles form small sprints to complete the huge FAQ series. I hope you enjoy it.
  • How to improve your LINQ query performance by 5 X times ?Jul 17, 2009. LINQ has been criticized by many early adopters for its performance issues. Well if you are just going to drag and drop using DBML code generator I am sure you will land up in to mess. Try doing this make a simple LINQ to SQL project using DBML and see your SQL profiler, I am sure you will never like to touch DBML code generator again. In this article we will first look in to how LINQ queries are executed, and then we will touch base on how compiled LINQ queries can help us improve our application performance at least 5 times. My numbers can be 10% up and down as I had come to that figure using my environmental situations.
  • Stored ProceduresAug 13, 2009. In this article I will explain you about stored procedure. How to create, execute and alter stored procedure. Why to use stored procedures and advantages of stored procedures.
  • LINQ Deferred ExecutionAug 24, 2009. In this article we will see how LINQ defers the execution of the query till you request the results. Plus, learn how to execute the query immediately.
  • Client execution from server controlsSep 09, 2009. In this article I will expalin how to execute client script from server controls.
  • The Architecture of Visual SourceSafe 2005Sep 11, 2009. In this article, I want to take a look at the architecture of Visual SourceSafe 2005; an important package which can be used in software development projects as a source control system.
  • Working with COBOL Data GroupsOct 19, 2009. COBOL programmers have used data groups to package data together for a long time. How though does a non-COBOL user access the data being used by the COBOL programs?
  • 5 simple steps to execute unit testing using NUNIT Nov 22, 2009. Unit testing is validation and verification methodology where the developers test the individual units of source code. In this tutorial we will try to understand how we can do unit testing using NUNIT framework. This tutorial we will try to understand the 5 important steps to do unit testing using NUNIT.
  • The CommandType Enumeration in ADO.NETJan 05, 2010. In this article I will explain the CommandType Enumeration in ADO.NET.
  • Simple 6 steps to run your first Azure Worker Role ProgramJan 07, 2010. In this article we will try to understand 6 basic steps to create worker role project and as we run through the article we will try to understand the various fundamental methods which are executed in worker role projects.
  • Adding Editor, and Deleting data in Web Forms using ADO.NET Feb 11, 2010. In this article I will explain Adding Editor, and Deleting data in Web Forms using ADO.NET.
  • Executing Asynchronous Web Services Feb 16, 2010. In this article I will explain Executing Asynchronous Web Services.
  • System.Windows.Xps.Packaging Reference MissingMar 01, 2010. If you need to use XpsDocument class in your WPF project, you must add reference to System.Windows.Xps.Packaging namespace.
  • Executing a Stored Procedure Programmatically Mar 04, 2010. In this article I will explain executing a Stored Procedure Programmatically.
  • Deployment and Packaging in .NET May 07, 2010. In this article I will explain you about Deployment and Packaging in .NET.
  • Multithreading in WPF Part IMay 27, 2010. Multithreading means executing more than one code block at a time .
  • How to: Deploy or Retract WSP Package in Sharepoint 2007Jun 17, 2010. In this article I will show you how to deploy and retract a WSP in a Sharepoint web application.
  • Working with Entity Data Model and Executing Stored ProceduresJun 21, 2010. In this article we are going to work with the following concepts that EDM support.
  • LINQ to SQL in C#Jul 24, 2010. This article provides an introduction to employing LINQ to SQL within a Windows Forms application; the article will address the incorporation of LINQ to SQL into a win forms project, how to use LINQ to SQL to select, insert, update, and delete data, and how to use LINQ to SQL to execute stored procedures.
  • BackgroundWorker in C#Aug 20, 2010. A BackgroundWorker component executes code in a separate dedicated secondary thread. In this article, I will demonstrate how to use the BackgroundWorker component to execute a time consuming process while main thread is still available to the user interface.
  • VS 2010 Deployment (Package, One click deploy and Web.config transformation)Aug 24, 2010. In this article we will discuss about 3 important features provided by VS 2010 to ease our deployment task on production and other environment. We will first start with understanding problems with deployment and then move ahead by creating packages , one click deploy and web.config transformation.
  • Performance Tuning High Level- SQL SERVERAug 26, 2010. You can view the query execution plan while executing the query in your query analyzer. Through that you can tune your query. It will show you whether the appropriate tables are using the proper index or not.
  • Connect to an SSIS package and consume its data from .Net applicationSep 01, 2010. In this article, I will show how to connect to a Data reader destination component within a given SQL Server Integration Services package.
  • How to: Execute only one instance of application concurrentlySep 07, 2010. There was a requirement that the application can’t run more than one instance, and if already running then show the message to the user and set that window as active. Here we will see how to do that.
  • SQL Profiler InputBuffer Events in SQL ServerSep 10, 2010. In this article we will see how to find the last execution command of your user in SQL Server.
  • Scheduling SSIS Package Using SQL Server AgentOct 08, 2010. This article shows how to schedule a SSIS package using SQL Server Agent.
  • How to Run a Power Shell Script in SharePoint 2010Oct 27, 2010. In this article I am showing you how to execute power shell scripts.
  • Incremental Cube Refresh using SSISNov 03, 2010. This article shows how to incrementally refresh cube using SSIS.
  • How to Send Email Using Send Mail Task of SSISNov 03, 2010. In this article we will see how to send email using Send Mail Task of SSIS
  • Chapter 3: From 2003 to 2010: Debugging an ApplicationNov 24, 2010. After reading this chapter on debugging, you will be able to Use the new debugger features of Microsoft Visual Studio 2010. Create unit tests and execute them in Visual Studio 2010.Compare what was available to you or see what was different for you as a developer in Visual Studio 2003
  • Chapter 4: From 2003 to 2010: Deploying an ApplicationNov 25, 2010. After reading this chapter on deployment techniques, you will be able to Deploy a Web application and an SQL database using Web Deployment Packages. Deploy a Web application using One-Click Publish.
  • How Create Excel File Through Open XML Package (OOXML)Dec 14, 2010. In this article I will explain how we can create Excel File through OOXML.
  • Deploy and run your Cloud Application project - Create Service Package OnlyDec 25, 2010. This article demonstrates how to deploy and run your first Cloud Application on Windows Azure.
  • Deferred Execution and Immediate Execution in LINQDec 31, 2010. Deferred Execution executes a query only when a loop starts. What I mean here is that, we iterate through the query variable to get the result.
  • Compiled Queries in LINQJan 07, 2011. There might be a scenario where we need to execute a particular query many times and repeatedly. LINQ allows us to make this task very easy by enabling us to create a query and make it compiled always. We call this type of query a compiled query.
  • Web Solution Packages Jan 11, 2011. Managed code assemblies can be deployed to a SharePoint server using a new capability called Solution Deployment.
  • Chapter 7: From 2005 to 2010: Debugging an ApplicationJan 19, 2011. After reading this chapter, you will be able to use the new debugger features of Microsoft Visual Studio 2010, create unit tests and execute them in Visual Studio 2010, compare what was available to you as a developer in Visual Studio 2005.
  • JavaScript and CSS MinifierJan 31, 2011. The CombineAndMinify package discussed here automatically speeds up the loading of JavaScript files, CSS files and or images (loaded from image tags or from CSS files). The result can be a dramatic improvement in ASP.NET performance.
  • Understanding C# Constructors and it's typeMar 03, 2011. In other words a constructor is a class default method that gets automatically executed whenever a class's object is created or whenever the class is initialized.
  • SQL Server Integration Services (SSIS) - Transforming SQL Data to Excel SheetMar 14, 2011. In this article we will see how data can be transferred from SQL Server DB to Excel sheet.
  • Basics of SQL Server Integration ServicesMar 14, 2011. In this article we will see what a SQL Server Integration Services (SSIS) is; basic on why SSIS is used for, how to create a SSIS Package and how to debug the same.
  • SQL Server Integration Services (SSIS) -Import Data using WizardMar 15, 2011. In this article we will see how to import data from SQL Server using the wizard which is provided with SSMS (SQL server Management Studio).
  • SQL Server Integration Services (SSIS)- Export Data using WizardMar 15, 2011. In this article we will see how to export data from SQL Server using the wizard which is provided with SSMS (SQL server Management Studio).
  • JIT (Just-In-Time) CompilerMar 16, 2011. JIT is the just in time compiler, it is quite different with other compilers. It compiles the source code just in time, and it does not compiles hole code, only the code is to be executed is compiled.
  • SQL Server Integration Services (SSIS) - Breakpoints in SSIS PackagesMar 17, 2011. In this article we are going to look into the options to debug the SSIS package, mainly on the Break point options available with SSIS.
  • SQL Server Integration Services (SSIS) - Scripting in SSIS PackagesMar 17, 2011. This article describes the scripting option available with SSIS, which is nothing but the Script Task component in SSIS.

About Execute-Package-in-SSIS

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.
techbash 2016