Posts

Showing posts from March, 2018

How to Convert DataTable into List in C# ?

In this article, we are going to convert DataTable into a List in C#. There are three ways to do it. We will see in following simple program how to do it. The program is self-explanatory in the form of code comments. Code Snippet:- using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Reflection; using System.Text; using System.Threading.Tasks; namespace BlogsProgram { public class Program { // Creating an Entity class for Employee public class Employee { public int EmpID { get; set; } public string EmpName { get; set; } public string City { get; set; } } public static void Main(string[] args) { // Creating Object of Program class to access its Members Program _obj_Program = new Program(); // Defined Tabble as "Employee". DataTable dt = new DataTable("Employee"); // ...

How to Transpose DataTable in C# ?

In this article we are going to see, How to transpose DataTable in C#? It means we are going to convert DataRow into DataColumn and DataColumn intoDataRow.Following is the simple and self-explanatory example in the form of code comment. Code Snippet:- using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; using System.Threading.Tasks; namespace BlogsProgram { public class TansposeDataTableClass { public void TransposeDataTable() { // Defined Table as "Employee". DataTable dt = new DataTable("Employee"); // Defined "EmpID" column as Integer Datatype. dt.Columns.Add("EmpID", typeof(Int32)); // Defined "EmpName" column as String Datatype. dt.Columns.Add("EmpName", typeof(string)); // Defined "EmpRank" column as String Datatype. dt.Columns.Add(...

Importing and Indexing .CSV file in solr

1) Download the latest version of Apache Solr from the following location: http://lucene.apache.org/solr/downloads.html 2) Once the Solr zip file is downloaded unzip it into "C:\\Program Files" folder. The extracted folder will contain few subfolders such as bin, Contrib , dust, docs, example, license, server etc. 3) Now open command prompt in administrative mode and goto bin directory of solr to start it.Ex:- C:\Program Files\solr-6.0.0\bin > solr start And to stop solr C:\Program Files\solr-6.0.0\bin > solr stop -all 4) Now its time to create Core-Admin to import, index, and search data. For that we have to use the following commands. Ex:- C:\Program Files\solr-6.0.0\bin >solr create -c jcg -d basic_configs 5) We can see the following output in the command window.Creating new core 'jcg' using command: http://localhost:8983/solr/admin/cores?action=CREATE&name=jcg&instanceDir=jcg { "responseHeader":{ "status":0, ...

Encapsulation in C#

In this article we are going to see, Encapsulation in C#. So, What is an Encapsulation in C#? The answer is very simple, Encapsulation is nothing but wrapping up of data or members in order to protect them or secure them. Following is a simple program to understand it. Code Snippet:- using System; public class Class1 { public void Method1() {  Console.WriteLine("Calling this Method1 by using Object of Class1.Becauseit is non static."); } } public static class Class2 { public static void Method2() { Console.WriteLine("Calling this Method2 by using name of Class2. Because it is static."); } } public class Encapsulation { public static void Main(string[] args) { // Creating object of Class1 Class1 object1 = new Class1(); // Calling Method/Data Member of Class1 using its object. object1.Method1(); // Calling Method2 using Class2 name because it is static.It means, it is sharable. Class2.Method2(); Console.ReadLine(); } } In the abo...