Learn .Net with Free Lessons & Tips

How can insert bulk records in Salesforce from WPF application to Salesforce by clicking button? I am new to this.

Hi Tarun,

Firstly, suppose you are using a SQL Server or any DB as Source, and you want to post the data to Salesforce. In that case, you need to create a DB connection to SQL server or any DB, then pull the data, store it in WPF objects, and connect to Salesforce using "Salesforce toolkit for .Net" connect to Salesforce and post the data.

Secondly, if you have any file that you want to post to Salesforce, Read the data from the file into WPF objects(like excel, txt, CSV or any), Connect to Salesforce using "Salesforce toolkit for .Net".

This way, you can post the data to Salesforce.

NOTE: For bulk upload, you need to check the documentation provided by Salesforce.

In web.config: <connectionStrings> <add name="ConnectionString" connectionString="Data Source=192.168.1.25;Initial Catalog=Login;Persist Security Info=True;User ID=sa;Password=example.com" providerName="System.Data.SqlClient" /> </connectionStrings>In Class.cs public static string ConnectionString{ get{ return ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;} set{}

 public ActionResult Export()  
   {  
     StringBuilder sb = new StringBuilder();  
     //static file name, can be changes as per requirement  
     string sFileName = "filename.xls";  
     //Bind data list from edmx  
     var Data = objEntities.citymaster.Take(10).ToList();  
     if (Data != null && Data.Any())  
     {  
       sb.Append("<table style='1px solid black; font-size:12px;'>");  
       sb.Append("<tr>");  
       sb.Append("<td style='width:120px;'><b>City Name</b></td>");  
       sb.Append("<td style='width:300px;'><b>City Code</b></td>");  
       sb.Append("</tr>");  
       foreach (var result in Data)  
       {  
         sb.Append("<tr>");  
         sb.Append("<td>" + result.sCityName + "</td>");  
         sb.Append("<td>" + result.sCityCode + "</td>");  
         sb.Append("</tr>");  
       }  
     }  
     HttpContext.Response.AddHeader("content-disposition", "attachment; filename=" + sFileName);  
     this.Response.ContentType = "application/vnd.ms-excel";  
     byte[] buffer = System.Text.Encoding.UTF8.GetBytes(sb.ToString());  
     return File(buffer, "application/vnd.ms-excel");  
   }  

ASP.Net is known as a development platform for the web, which in turn is known to help create robust web applications. It is known to contain innumerous libraries which have a wide range of functionality. It is a comprehensive web framework that supports accordingly with MS IIS  and has a bunch load of technologies added to it.

VB.NET in layman’s terms is a programming language. VB, which is short for Visual Basics, is actually similar to excel as in syntactically. However, it is to known that the version of excel, which is called VBA is some ways different from the excel we use. The great thing about VB.NET is the assembly written in VB.Net is compatible with an assembly written in another programming language.

Hope this helps