Binary Serialization in C#

Binary Serialization Binary serialization uses binary encoding to produce compact serialization for uses such as storage or socket-based network streams. It is also known as deep serialization. Because it serialize every thing of an object. Example In this example we take an employee class. It has two attribute EmpId and EmpName.   using...

Continue reading

SOAP Serialization in C#

SOAP serialization uses SOAP encoding to produce compact serialization for uses such as web service. Example In this example we take an employee class. It has two attribute EmpId and EmpName.   using System; using System.Runtime.Serialization; namespace Example_Serialization { [Serializable] public class Employee : ISerializable { public...

Continue reading

Execute SSIS package from ASP.NET

Execute SSIS package from ASP.NET web forms. Let’s take a scenario, we will create a table in SQL server and insert data into that table using SSIS package and call the package from Web forms. Step 1 Create a table in SQL server named “stud”. Step 2 Prepare a parameterize insert SQL query. Step 3 Create a SSIS package. Open SQL Server...

Continue reading

Export to excel in ZIP format

Problem Exporting large file from Asp.Net pages cause huge bandwidth consumption, slow response and time-out problem. In most of application there are couple of pages where we export large data file in to excel. And the most common problems are response time-out and  slow UI response. Solution There are two solutions for this problem. Enable...

Continue reading

SSIS – connection string from XML

SSIS – getting connection string from XML file. Step 1 Go to SSIS and select Package Configurations.  Step 2 Add new configuration. Step 3 Select Configuration type as XML Configuration file. Then select Specify configuration setting directly radio button and select the configuration file. Step 4 Select the property which you want to...

Continue reading