Do you have any difficulty to edit XML files? You can use this cool application to feel better when you are working with XML !! good luck 🙂
Downlod here
Do you have any difficulty to edit XML files? You can use this cool application to feel better when you are working with XML !! good luck 🙂
Downlod here
Here I will teach you how can merge two datatables :
You can whatch the video here
Private Sub MergeDatatable() Dim dt1 As New DataTable Dim dt2 As New DataTable dt1.Columns.Add("Id") dt1.Columns.Add("Name") Dim dtrow1 As DataRow dtrow1 = dt1.NewRow dtrow1("Id") = 12 dtrow1("Name") = "Mehran" dt1.Rows.Add(dtrow1) dt2.Columns.Add("Id") dt2.Columns.Add("Name") Dim dtrow2 As DataRow dtrow2 = dt2.NewRow dtrow2("Id") = 12 dtrow2("Name") = "Nush" dt2.Rows.Add(dtrow2) dt1.Merge(dt2) End Sub
Click here to convert this Vb.net code to C#
If you have a scheduled job interview for .Net Developer position, please take a look at these questions
JSON (JavaScript Object Notation) is a lightweight data-structure format for data interchange, JSON could be read by human and it is easy for machine to generate and pars it.
When should we use JSON?
Assume you want create a service that retrieve data from DataBase and send them to the client. What will happen if your client use different type of machines and platform same as Smart phone, PHP website, ASP.net Website, different type of operating system. There are two solutions:
I am sure you are agree with me that the second solution is more logical.
In my opinion WebAPI could be a good choice for our scenario because, it can produce JSON output that is readable by all machines and platform and also it uses HTTP to transfer data that, also this protocol is well known for all.
Today I am just going to show you how you can create a simple JSON data structure but, In the future I will show you how create a WebAPI and call it by JQuery.
This is simple JSON sample, I declare an employee array that can carry different employees’ data.
{ "employees": [ { "firstName":"Mehran" , "lastName":"JN" }, { "firstName":"Arman" , "lastName":"Nas" }, { "firstName":"Farzam" , "lastName":"ABS" } ] }
I am going to do it in a JavaScript code:
<!DOCTYPE html> <html> <body> <h2>JSON Object Creation in JavaScript</h2> <p> Name: <span id="Name"></span><br> Family: <span id="Family"></span><br> </p> <script> var JSONObject = { "Name":"Mehran", "Family":"Jan"}; document.getElementById("Name").innerHTML=JSONObject.Name document.getElementById("Family").innerHTML=JSONObject.Family </script> </body> </html>
If you have been a ASP.Net programmer and now you decided to move to MVC this post can help you to find out how populate a Dropdownlist and how use selected value when the form is posted to the controller.
What is scenario?
I have this table in the database, as you see here, this table contains student’s information, I need a Dropdownlist in the form for list of available programs that user can select for each students.
Id | int |
Name | nvarchar(50) |
Family | nvarchar(50) |
Tel | nvarchar(50) |
Address | nvarchar(50) |
ProgramId | int |
In this function I created a list that contains program information (value, text), then I wanted to assign it to the DropDownlist:
public ActionResult Create() { IEnumerable<SelectListItem> ProgramList= new[] { new SelectListItem { Value = "1", Text = "bachelor" }, new SelectListItem { Value = "2", Text = "Master" }, new SelectListItem { Value = "3", Text = "PHD" }, }; ViewBag.List = ProgramList; return View(); }
After that you need to make a view base on Student class, because we need to use ProgramId to post back a selected program’s Id and other student information to the controller that want to save data.
Here I just show you how to create a DropDownlist and I ignore other student’s fields:
<form method="post" action="students/create"> @Html.DropDownListFor(model => model.ProgramId, new SelectList(ViewBag.List, "Value", "Text")) <input type="submit" /> </form>
I am sure that this post it is not clear for those programmer that are new in MVC , therefore if you need more help , just leave comment here then I will help you to improve your knowledge in MVC and also I can help you to find good reference to learn MVC 🙂
What is Dictionaries ?
Dictionaries are collections that are meant to store lists of key/value pairs to allow lookup of values based on a key.
For example, assume that you needed to map student code to the full name of some students. For this purpose you can use the Hashtable.
[VB.Net]
Private Sub CreateHashTable() Dim StudentCodes As New Hashtable() 'The first method. StudentCodes.Add("MN145098", "Mehran,Jn") 'The second method. StudentCodes("MN18454") = "Arman,Nas" End Sub
[C#]
private void CreateHashTable() { Hashtable StudentCodes = new Hashtable(); //The first method. StudentCodes.Add("MN145098", "Mehran,Jn"); //The second method. StudentCodes["MN18454"] = "Arman,Nas"; }
In this way you can read HashTable
[VB.Net]
For Each Item As DictionaryEntry In StudentCodes Console.WriteLine(Item.Value) Next
[C#]
foreach (DictionaryEntry Item in StudentCodes) { Console.WriteLine(Item.Value); }
As you know there are different types of machines and OS in the world that they have to connect to each other and transfer data but each system has own structure and may cannot understand the data that are coming from other system(s), but technology has solved it for them! One of the solutions is XML
What is XML?
XML (Extensible Markup Language) is a format that was designed to transport and store data.Both machine and human can understand XML.
If you want to learn more about the XML I suggest you to go this link.
Before start you must import these classes:
[VB.Net]
Imports System.IO Imports System.Xml.Serialization
[C#]
using System.IO; using System.Xml.Serialization;
[VB.Net]
Private Sub CreateXML() Dim OFileStream As FileStream = _ New FileStream("C:/CodingTips.XML", _ FileMode.Create) Dim Oxmlsr As XmlSerializer = _ New XmlSerializer(GetType(DateTime)) Oxmlsr.Serialize(OFileStream, System.DateTime.Now.ToString) OFileStream.Close() End Sub
[C#]
private void CreateXML() { FileStream OFileStream = new FileStream("C:/CodingTips.XML",_ FileMode.Create); XmlSerializer Oxmlsr = new XmlSerializer(typeof(DateTime)); Oxmlsr.Serialize(OFileStream, System.DateTime.Now.ToString()); OFileStream.Close(); }
What is SHA1?
This part has been copied directly form Wikipedia
SHA-1 is a cryptographic hash function designed by the United States National Security Agency and published by the United States NIST as a U.S. Federal Information Processing Standard. SHA stands for “secure hash algorithm”. For further information click here
Why you need SHA1?
If you want to make your sensitive information secure, one of the best way, is that make them encrypt. There are different ways which you can use them to make your information encrypt but in most of cases the encrypted information can be decrypted easily , So these methods cannot be good choice for encrypting data same as Base64, But SHA1 is a one way street , it means after encrypt nobody can decrypt it . Awesome!
If there is no way to decrypt SHA1, how we can use it?
It is common question about SHA1! Somebody still looking for a way to decrypt the SHA1 but I suggest them to stop searching because they cannot find anything.
Now I will explain you how SHA1 can work for you. For example you make a SAH1 from the password that you want to save on the database, when user wants to login to the system you have to make another SHA1 form the string that user has entered, then compare it with SHA1 that you have been saved before on the database if they are same user is eligible to login to the system.
To make a SAH1 you need to pass 3 steps:
I have mention these three steps in the code below:
[VB.Net]
Private Sub EncryptData() Dim strToHash As String = "Please Encrypt me !" Dim Result As String = "" Dim OSha1 As New _ System.Security.Cryptography.SHA1CryptoServiceProvider 'Step 1 Dim bytesToHash() As Byte _ = System.Text.Encoding.ASCII.GetBytes(strToHash) 'Step 2 bytesToHash = OSha1.ComputeHash(bytesToHash) 'Step 3 For Each item As Byte In bytesToHash Result += item.ToString("x2") Next End Sub
[C#]
private void EncryptData() { string strToHash = "Please Encrypt me !"; string Result = ""; System.Security.Cryptography.SHA1CryptoServiceProvider OSha1 = _ new System.Security.Cryptography.SHA1CryptoServiceProvider(); //Step 1 byte[] bytesToHash = _ System.Text.Encoding.ASCII.GetBytes(strToHash); //Step 2 bytesToHash =_ OSha1.ComputeHash(bytesToHash); //Step 3 foreach (byte item in bytesToHash) { Result += item.ToString("x2"); } }
As I have promised ,today I am going to show you how to create a file, you can write (create) file in different ways same as reading file.
Before you start, have to import System.IO.
[VB.Net]
Imports System.IO
[C#]
using System.IO;
Writing File
Let met to start with the easiest way,
1.WriteAllText
With this function you can create and write file at the same time!
[VB.Net]
File.WriteAllText("c:\CodingTips.txt", "coding is easy !")
[C#]
File.WriteAllText("c:\\CodingTips.txt", "coding is easy !")
2.StreamWriter:
This Pattern is much like reading file.
[VB.Net]
Dim writer As StreamWriter =File.CreateText("c:\CodingTips.txt") writer.WriteLine("coding is easy") writer.Close()
[C#]
StreamWriter writer = File.CreateText("c:\\CodingTips.txt"); writer.WriteLine("coding is easy"); writer.Close();
3.MemoryStream:
Sometimes you will need to create a stream (the string that you want to write to the file) before you really need to store it somewhere (like in a file). for example you have 5 functions in your code, and each function has a specific result and you want to store the results of these functions in one file, you cannot use the methods that I explained above, in this case, first you need to prepare the stream and then write it to the file, for this purpose MemoryStream would be a good choice,
[VB.Net]
Dim memoryStrm As New MemoryStream() Dim writer As New StreamWriter(memoryStrm) 'This part can to be repeated anywhere in your code that you want to you want to append text to the memoryStream. writer.WriteLine("Function1") writer.WriteLine("Result1")
[C#]
MemoryStream memoryStrm= new MemoryStream(); StreamWriter writer = new StreamWriter(memoryStrm); //This part can to be repeated anywhere in your code that you want to you want to append text to the memoryStream. writer.WriteLine("Function1"); writer.WriteLine("Result1");
After you prepared your MemoryStream you can write it to the file:
[VB.Net]
' Here you must ask the writer to push the data into the ' underlying stream writer.Flush() ' the create a file stream Dim MyFile As FileStream = File.Create("c:\CodingTips.txt") ' now Write the MemoryStream to the file memoryStrm .WriteTo(theFile) ' the you have to Clean up the objects writer.Close() theFile.Close() memoryStrm .Close()
[C#]
// Here you must ask the writer to push the data into the // underlying stream { writer.Flush(); // the create a file stream FileStream MyFile = File.Create("c:\\CodingTips.txt"); // now Write the MemoryStream to the file memoryStrm.WriteTo(theFile); // the you have to Clean up the objects writer.Close(); theFile.Close(); memoryStrm.Close(); }
Reading and writing files are two of the most common tasks in the world of development. As a .NET developer, .NET Framework makes it easy to perform these tasks.
Before you start, have to import System.IO.
[VB.Net]
Imports System.IO
[C#]
using System.IO;
1.Reading File
There are different ways that you can use them for reading file,
if you want to read a whole file as string, this ways could be fine for you:
[VB.Net]
Dim Result As String = File.ReadAllText("C:\CodingTips.txt")
[C#]
string Result = File.ReadAllText("C:\\CodingTips.txt");
if you need more properties and futures ,
same as searching specific text in the file, I suppose this ways is more efficient:
[VB.Net]
Private Sub Readfile() Dim strReader As StreamReader = File.OpenText("C:\CodingTips.txt") ' We will Search the stream until we reach the end or find the specific string. While Not strReader.EndOfStream Dim line As String = strReader.ReadLine() If line.Contains("Code") Then 'If we find the specific string, we will inform the user and finish the while loop. Console.WriteLine("Found Code:") Console.WriteLine(line) Exit While End If End While ' Here we have to clean the memory. strReader.Close() End Sub
[C#]
private void Readfile() { StreamReader strReader = File.OpenText("C:\\CodingTips.txt"); // We will Search the stream until we reach the end or find the specific string. while (!strReader.EndOfStream) { string line = strReader.ReadLine(); if (line.Contains("Code")) { //If we find the specific string, we will inform the user and finish the while loop. Console.WriteLine("Found Code:"); Console.WriteLine(line); break; // TODO: might not be correct. Was : Exit While } } // Here we have to clean the memory. strReader.Close(); }
In the next post I will teach you , How to write a file 🙂