Learn Visual Studio .Net

Selenium Browser Automation

2018-02-11T19:51:00.002+05:30

Selenium is for automating web applications.
Selenium has the support of some of the multiple browser vendors.

You can download the Selenium library from http://www.seleniumhq.org/download/.

Sample Code:

using OpenQA.Selenium;

using OpenQA.Selenium.Support.UI;

FirefoxOptions options = new FirefoxOptions();
options.BrowserExecutableLocation = "Fire Fox Directory Path";

IWebDriver driverOne = new FirefoxDriver(service, options, TimeSpan.FromMinutes(1));

driverOne.Navigate().GoToUrl("URL");

//You can find the Elements by ID, Tag Name, Class Name etc.

IWebElement TagElement= driverOne.FindElement(By.Id("CtrlID"));

String Value = TagElement.Text;

WatiN : Automate Web Application Testing

2017-03-08T08:32:00.000+05:30

WatiN aims to bring you an easy way to automate Web Application Testing in .Net. Watin offers automation of Internet Explorer and Firefox.

It has Open source library and is known for very easy to read syntax.

You can download the Watin library from https://sourceforge.net/projects/watin/files/WatiN%202.x/.

WatiN interacts with the Internet Explorer using its COM (Component Object Model) interface. The Firefox interaction is done using the JSSh (JavaScript Shell Server) extension for Mozilla Firefox, present in WatiN.Core.dll file.

JSSH is a plug-in that exposes a telnet server that allows automation commands to be pushed to Firefox. When WatiN is downloaded, then it contains archive which have WatiN.Core.dll file.

Following are the features of WatiN:

Automate all the HTML elements
Find elements by multiple attributes
Support Ajax Website Testing
Syntax of WatiN is more Object Oriented and intuitive for developers
Supports creating screenshot of WebPages
Easy to integrate with your favorite Unit Testing Tool
Can be used with any .NET language
Since it is open source, you can download and add new features yourself

Sample Code:

BrowserIE.cs :

using WatiN.Core;

public sealed class BrowserIE

{

static readonly IE _Instance = new IE();

static BrowserIE()

{

}

BrowserIE()

{

}

public static IE Instance

{

get { return _Instance; }

}

internal static void WaitForComplete()

{

throw new NotImplementedException();

}

internal static object SelectList(WatiN.Core.Constraints.AttributeConstraint attributeConstraint)

{

throw new NotImplementedException();

}

Watin Code:

using WatiN.Core;

public partial class form1 : System.Windows.Forms.Form

{

public form1 ()

{

InitializeComponent();

}

private void btnSearch_Click(object sender, EventArgs e)

{

BrowserIE.Instance.GoTo("WebURL");

Span Span_ID = Tbl.Span(Find.ById("spanID"));

String Text= Span_ID .Text;

}

Get Geo Location with Google Map

2015-12-13T16:28:00.001+05:30

Sample code to show how to use the Google Map API for Geo location details.
Code to get your current location (Latitude & Longitude) and how to add the marker on the Google Map.

if (navigator.geolocation) {
navigator.geolocation.getCurrentPosition(function (p) {
var LatLng = new google.maps.LatLng(p.coords.latitude, p.coords.longitude);
var mapOptions = {
center: LatLng,
zoom: 13,
mapTypeId: google.maps.MapTypeId.ROADMAP
};
var map = new google.maps.Map(document.getElementById("dvMap"), mapOptions);
var marker = new google.maps.Marker({
position: LatLng,
map: map,
title: "Your location: Latitude: " + p.coords.latitude + "Longitude: " + p.coords.longitude
});

google.maps.event.addListener(marker, "click", function (e) {
var infoWindow = new google.maps.InfoWindow();
infoWindow.setContent(marker.title);
infoWindow.open(map, marker);
});
});
}
else
{
alert('Geo Location feature is not supported in this browser.');
}

OCR with Microsoft Office Document Imaging

2015-11-29T10:34:00.001+05:30

This article will show how to integrate the Office 2007 OCR engine. This will perform the OCR on the scanned image and convert it to the text.

It's necessary that you have installed the Microsoft Office Document Imaging 12.0 Type Library. MS office setup doesn't install this component by default, being necessary to install it later. To do this:

Run the Office 2007 installation setup
Click on the button Add or Remove Features
Make sure that the component is installed

Add reference of Microsoft Office Document Imaging DLL in project by clicking on Add Reference from solution explorer. At the COM tab, select Microsoft Office Document Imaging 12.0 Type Library.

Code:

MODI.Document md = new MODI.Document();
md.Create("FileName.TIF");
md.OCR(MODI.MiLANGUAGES.miLANG_ENGLISH, true, true);
MODI.Image image = (MODI.Image)md.Images[0];

MODI.Layout layout = image.Layout;

//create text file with the same Image file name
FileStream createFile = new FileStream("fileName.txt",FileMode.CreateNew);

//save the image text in the text file
StreamWriter writeFile = new StreamWriter(createFile);
writeFile.Write(image.Layout.Text);

writeFile.Close();

if you want to read text word by word then use below,

for (int i = 0; i < layout.Words.Count; i++)
{
MODI.Word word = (MODI.Word)layout.Words[i];
string strText = word.Text;

}

Launch Application exe with Javascript.

2015-07-03T14:37:00.006+05:30

Sample code to launch the application exe from the Javascript.

Code:

var ws = new ActiveXObject("WScript.Shell");

ws.Exec("C:\\TestApp.exe");

Read & Write a File with JavaScript

2015-07-03T14:36:00.000+05:30

Sample code to do the File manipulation in JavaScript.
This code illustrate, how to Create, Read & Write the text in file using the Java Script.

Code:

// Reading text file.

var fso = new ActiveXObject("Scripting.FileSystemObject");
var fhRead = fso.OpenTextFile("C:\\Test.txt",1);
var Fltext = fhRead.ReadAll();
fhRead.Close();

// Creating text file.

var fh = fso.CreateTextFile("C:\\Test.txt", true);
fh.WriteLine("Sample");
fh.Close();

Dynamically Compile C# Code

2015-06-29T14:02:00.002+05:30

Sample code to dynamically compile the C# source code and generate the Exe/DLL. You can write the code at runtime and execute or make a DLL.

Namespace :

using System.CodeDom.Compiler;

Code:

CodeDomProvider codeProvider = CodeDomProvider.CreateProvider("CSharp");
string Output = "Out.exe";

System.CodeDom.Compiler.CompilerParameters parameters = new CompilerParameters();
//Make sure we generate an EXE, not a DLL
//parameters.GenerateExecutable = true; // set to false to generate DLL.
parameters.OutputAssembly = Output;
CompilerResults results = codeProvider.CompileAssemblyFromSource(parameters, txtSource.Text);

if (results.Errors.Count > 0)
{
txtStatus.ForeColor = Color.Red;
foreach (CompilerError CompErr in results.Errors)
{
  txtStatus.Text = txtStatus.Text +
"Line number " + CompErr.Line +
", Error Number: " + CompErr.ErrorNumber +
", '" + CompErr.ErrorText + ";" +
Environment.NewLine + Environment.NewLine;
}
}
else
{
//Successful Compile
  txtStatus.ForeColor = Color.Blue;
  txtStatus.Text = "Success";
//Launch our EXE
Process.Start(Output);
}

CSV to DataGridView

2015-06-29T13:09:00.000+05:30

Sample code to show the content of the CSV (Comma Separated File) in DataGrid View with the filter & sorting in C#.

Namespace :

using System.Data.OleDb;

Code:

OleDbConnection conn = new OleDbConnection
("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " +
Path.GetDirectoryName(@"D:\TEST\test.txt") +
"; Extended Properties = 'Text;FMT=Delimited'");

conn.Open();

OleDbDataAdapter adapter = new OleDbDataAdapter
("SELECT * FROM " + Path.GetFileName(@"D:\TEST\test.txt"), conn);

DataSet ds = new DataSet("Temp");
adapter.Fill(ds);

conn.Close();

dataGridView1.DataSource = ds.Tables[0] ;

You can add the filter condition on dataset as below,
First create the Default view from the DatagridView datasource.

string rowFilter = string.Format("column1 LIKE '%{0}%' AND column2 = 1",
"test");
(dataGridView1.DataSource as DataTable).DefaultView.RowFilter = rowFilter;

If you want to sort the DatagridView, set the sort column to the Default view.
.

(dataGridView1.DataSource as DataTable).DefaultView.Sort = "column1";

Launching Application .EXE from C#

2015-06-16T17:51:00.002+05:30

Sample code to Launch the application exe from c#.

Namespace :

using System.Diagnostics;

Code:

// Prepare the process to run
ProcessStartInfo start = new ProcessStartInfo();

// Enter in the command line arguments, everything you would enter after the executable name itself
start.Arguments = arguments;

// Enter the executable to run, including the complete path
start.FileName = ExeName;

// Do you want to show a console window?
start.WindowStyle = ProcessWindowStyle.Hidden;
start.CreateNoWindow = true;
int exitCode;

// Run the external process & wait for it to finish
using (Process proc = Process.Start(start))
{
proc.WaitForExit();

// Retrieve the app's exit code
exitCode = proc.ExitCode;
}

Or

Simply write below,

System.Diagnostics.Process.Start( @"C:\Windows\System32\Notepad.exe" );

Delete Files & Folders

2015-01-10T14:11:00.002+05:30

Sample code to delete the Files and the Directories.

Namespace :

using System.IO;

Code:

Delete Directory:

Directory.Delete("C:\test\")

If Directory have the sub directories then,

Directory.Delete("C:\test\", True)

Delete Files:

File.Delete("C:\test\text.txt")

To delete multiple files from Directory,

string[] Files= Directory.GetFiles(@"c:\test\");

           foreach (string filePath in Files)
                  File.Delete(filePath);

Get Files from Directory using C#

2015-01-10T14:05:00.000+05:30

Sample code to get the list of files from the source Directory. You can also add filter to search the specific file type only.

Namespace :

using System.IO;

Code:

Directory.GetFiles returns string array with files names.

string[] files = Directory.GetFiles(@"c:\Test\");

You can also search the files with specific pattern.

string[] files = Directory.GetFiles(@"c:\Test\", "*.txt");

To get the list of files from directory including the sub directories,

string[] filePaths = Directory.GetFiles(@"c:\Test\", "*.txt",SearchOption.AllDirectories);

Selecting data from two Different SQL Servers

2013-10-20T22:24:00.000+05:30

For selecting the data from two databases of two different servers, first we have to link the two servers.

sp_addlinkedserver('servername')

Then you can run the query like,

select * from Table1
unionall
select * from [server2].[database].[dbo].[Table1]

Read Text File using C#

2013-10-20T20:26:00.001+05:30

Article about reading the Text file line by line using the StreamReader in C#

Namespace :

using System.IO;

Code:

string line;

// Read the file and display it line by line.
StreamReader file = new StreamReader(@"c:\test.txt");
while((line = file.ReadLine()) != null)
{
Console.WriteLine (line);
counter++;
}

file.Close();

Get Serial Number of Hard Drive using C#

2013-06-21T22:23:00.000+05:30

To get the Serial # of HDD using C#

Namespace :

Imports System.Management

Code:

Dim devid As String = ""
Dim driveser As String = ""

Try
Dim searcher As New ManagementObjectSearcher( _
"root\CIMV2", "SELECT * FROM Win32_DiskDrive")

For Each queryObj As ManagementObject In searcher.Get()
If queryObj("SerialNumber") <> "" Then driveser = queryObj("SerialNumber")
Debug.Print(queryObj("Model") + ":" + driveser)
Next

Catch err As ManagementException
Debug.Print("An error occurred while querying for WMI data: " & err.Message)
End Try

Accept Only Numeric Textbox

2013-04-13T17:04:00.003+05:30

Simple code to accept only numeric in Textbox. You have to handle the key press event of textbox and have to check the key character is numeric or not.

Code:

private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
    if (!char.IsControl(e.KeyChar) && !char.IsDigit(e.KeyChar) && e.KeyChar != '.')
    {
        e.Handled = true;
    }
}

Replace/Mask Images of PDF file using Itextsharp

2013-03-29T11:07:00.000+05:30

Article is about masking or replacing the images from PDF documents using iTextSharp.

iTextSharp is a free .NET component, you can download the DLL from http://sourceforge.net/projects/itextsharp/.

After downloading the DLL, add reference of DLL in project by clicking on Add Reference from solution explorer.

Namespace :

using iTextSharp.text;
using iTextSharp.text.pdf;

Code:

   PdfReader pdf = new PdfReader("Test.pdf");
            PdfStamper stp = new PdfStamper(pdf, new FileStream("output.pdf",
FileMode.Create));


PdfWriter writer = stp.Writer;
             for (int pageNumber = 1; pageNumber <= pdf.NumberOfPages; pageNumber++)
            {

                Image img = Image.GetInstance("Img.jpg");
            PdfDictionary pg = pdf.GetPageN(pageNumber);
            PdfDictionary res =
              (PdfDictionary)PdfReader.GetPdfObject(pg.Get(PdfName.RESOURCES));
            PdfDictionary xobj =
              (PdfDictionary)PdfReader.GetPdfObject(res.Get(PdfName.XOBJECT));
            if (xobj != null)
            {
                foreach (PdfName name in xobj.Keys)
                {
                    PdfObject obj = xobj.Get(name);
                    if (obj.IsIndirect())
                    {
                        PdfDictionary tg = (PdfDictionary)PdfReader.GetPdfObject(obj);
                        PdfName type =
                          (PdfName)PdfReader.GetPdfObject(tg.Get(PdfName.SUBTYPE));
                        if (PdfName.IMAGE.Equals(type))
                        {
                            PdfReader.KillIndirect(obj);
                            Image maskImage = img.ImageMask;
                            if (maskImage != null)
                                writer.AddDirectImageSimple(maskImage);
                            writer.AddDirectImageSimple(img, (PRIndirectReference)obj);
                            break;
                        }
                    }
                }
            }
        }
            stp.Close();

Reading WebResponse in C#

2013-03-23T15:42:00.002+05:30

Namespace:

using System.Net;

Code:

         try
        {
            String Result, URL;
            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(URL);
            ICredentials credentials = new NetworkCredential("username", "Password", "Domain");
            IWebProxy webProxy = new WebProxy("proxy URL", 8080);
            webProxy.Credentials = credentials;
            request.Proxy = webProxy;

            WebResponse myResponse = request.GetResponse();
            StreamReader sr = new StreamReader(myResponse.GetResponseStream(), System.Text.Encoding.UTF8);
            Result = sr.ReadToEnd();
            sr.Close();
            myResponse.Close();
        }
        catch {    }

Use Crystal Report in C#

2013-03-21T16:57:00.000+05:30

Code to view the Crystal Report using C#.

Namespace:

using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

Code:

            CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
             CrystalDecisions.Shared.IConnectionInfo conn;

             ConnectionInfo CInfo = new ConnectionInfo();
             CInfo.ServerName = "server";
             CInfo.UserID = "ID";
             CInfo.Password = "Password";

             TableLogOnInfo tableInfo = new TableLogOnInfo();
             tableInfo.ConnectionInfo = CInfo;

             TableLogOnInfos tablelog = new TableLogOnInfos();
             tablelog.Add(tableInfo);

             crystalReportViewer1.ReportSource = Application.StartupPath + "\\Report.rpt";
             crystalReportViewer1.LogOnInfo = tablelog;

             ReportDocument obj = new ReportDocument();
             obj.Load(Application.StartupPath + "\\Report.rpt");

              obj.SetParameterValue("Para1","Value");
             obj.SetParameterValue("Para2", "Value");

             crystalReportViewer1.ReportSource = obj;

Start or Stop Services on Remote Machine

2013-03-20T14:43:00.002+05:30

Sample code to control the remote machine/system services. Below code shows how to Start or Stop the remote computer service.

Note : To run this code user must have the rights to Start/Stop the service of the remote computer.

Namespace:
       using System.Management;

Code:

Start service of the Remote Machine:

              try
                {

                    #region Code to start the service

                    string serviceName = "Service1";
                    string IP="Remote machine IP";
                    string username ="UserID";
                    string password ="Pass";

                    ConnectionOptions connectoptions = new ConnectionOptions();
                    //connectoptions.Impersonation = ImpersonationLevel.Impersonate;
                    connectoptions.Username = username;
                    connectoptions.Password = pass;

                    //IP Address of the remote machine

                    ManagementScope scope = new ManagementScope(@"\\" + IP + @"\root\cimv2");
                    scope.Options = connectoptions;

                    //WMI query to be executed on the remote machine
                    SelectQuery query = new SelectQuery("select * from Win32_Service where name = '" + serviceName + "'");

                    using (ManagementObjectSearcher searcher = new
                                ManagementObjectSearcher(scope, query))
                    {
                        ManagementObjectCollection collection = searcher.Get();
                        foreach (ManagementObject service in collection)
                        {
                            if (service["Started"].Equals(false))
                            {
                                //Start the service
                                service.InvokeMethod("StartService", null);
                            }

                        }
                    }

           #endregion

                }
                catch ()
                {

                }

Similar way you can stop the service of Remote Machine:

                       if (service["Started"].Equals(true))
                        {
                            //Stop the service
                            service.InvokeMethod("StopService", null);
                        }

Generate PDF From images using itextsharp

2013-03-19T12:13:00.000+05:30

Article is about creating PDF documents using iTextSharp.

iTextSharp is a free .NET component, you can download the DLL from http://sourceforge.net/projects/itextsharp/.

After downloading the DLL, add reference of DLL in project by clicking on Add Reference from solution explorer.

Namespace :

using iTextSharp.text;
using iTextSharp.text.pdf;
using System.IO;

Code:

            DirectoryInfo dir = new System.IO.DirectoryInfo("Image Path");
            FileInfo[] file;
            file = dir.GetFiles("*.jpg");
            String[] Fname;
            String Path;

using (FileStream fs = new FileStream(Path+ "Test.pdf", FileMode.Create, FileAccess.Write, FileShare.None))
            {

                using (Document doc = new Document())
                {
                    using (PdfWriter writer = PdfWriter.GetInstance(doc, fs))
                    {
                        doc.Open();
                        doc.SetMargins(0, 0, 0, 0);

                        iTextSharp.text.Image importImage;

                        for (int j = 0; j <= file.Length - 1; j++)
                        {

                                Chapter chapter1 = new Chapter("", j);
                                chapter1.NumberDepth = 0;
                                chapter1.TriggerNewPage = true;
                                importImage = iTextSharp.text.Image.GetInstance(file[j].FullName);
                                doc.SetPageSize(new iTextSharp.text.Rectangle(0, 0, importImage.Width, importImage.Height));
                                doc.SetPageSize(new iTextSharp.text.Rectangle(importImage.Width, importImage.Height));
                                chapter1.Add(importImage);
                                doc.Add(chapter1);

                        }

                        doc.Close();
                    }
                }
            }

Fill SQL data in Dataset

2013-03-17T13:17:00.001+05:30

Add Namespace :

using System.Data.SqlClient;

Code:

SqlConnection con;
SqlCommand cmd ;
SqlDataAdapter adp = new SqlDataAdapter();
DataSet ds = new DataSet();

con = new SqlConnection( "Data Source=ServerName;Initial Catalog=DatabaseName;UserID=UserName;Password=Password" );

try
{
con .Open();
cmd = new SqlCommand("Select * from Tablename", con);
adp.SelectCommand = cmd;
adp.Fill(ds, "Tablename");
adp.Dispose();
cmd.Dispose();
con.Close();
}
catch (Exception ex)
{

}

Send email using C#

2013-03-16T12:45:00.001+05:30

Simple code to send the email gmail SMTP.

Add Namespaces :

using System.Net.Mail;

Code :

MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com"); //Enter your SMTP address

mail.From = new MailAddress("your_emailID@gmail.com");
mail.To.Add("to_address");
mail.Subject = "Test EMail";
mail.Body = "Test SMTP mail from GMAIL";

SmtpServer.Port = 25;
SmtpServer.Credentials = new System.Net.NetworkCredential("username", "password");
SmtpServer.EnableSsl = true;
SmtpServer.Send(mail);

Triple DES Encryption Algorithm using Visual Basic.Net

2010-07-16T00:57:00.000+05:30

Triple DES (3DES) is the common name for the Triple Data Encryption Algorithm (TDEA or Triple DEA) symmetric-key block cipher, which applies the Data Encryption Standard (DES) cipher algorithm three times to each data block.

Namespace:

Imports System.IO
Imports System.Text
Imports System.Security.Cryptography

Code:

Friend Class cTripleDES

' Triple DES provider
Private Obj_Des As New TripleDESCryptoServiceProvider

' String handler
Private Obj_Utf8 As New UTF8Encoding

Private Key() As Byte
Private Init_Vec() As Byte

Public Sub New(ByVal key() As Byte, ByVal iv() As Byte)
Me.Key = key
Me.Init_Vec = iv
End Sub

Public Function Encrypt(ByVal input() As Byte) As Byte()
Return ConvertTO(input, Obj_Des.CreateEncryptor(Key, Init_Vec))
End Function

Public Function Decrypt(ByVal input() As Byte) As Byte()
Return ConvertTO(input, Obj_Des.CreateDecryptor(Key, Init_Vec))
End Function

Public Function Encrypt(ByVal text As String) As String

Dim input() As Byte = Obj_Utf8.GetBytes(text)
Dim output() As Byte = ConvertTO(input, _
Obj_Des.CreateEncryptor(Key, Init_Vec))
Return Convert.ToBase64String(output)

End Function

Public Function Decrypt(ByVal text As String) As String

Dim input() As Byte = Convert.FromBase64String(text)
Dim output() As Byte = ConvertTO(input, _
Obj_Des.CreateDecryptor(Key, Init_Vec))
Return Obj_Utf8.GetString(output)

End Function

Private Function ConvertTO(ByVal input() As Byte, _
ByVal CryptoTransform As ICryptoTransform) As Byte()
' create the necessary streams
Dim memStream As MemoryStream = New MemoryStream
Dim cryptStream As CryptoStream = New _
CryptoStream(memStream, CryptoTransform, _
CryptoStreamMode.Write)

cryptStream.Write(input, 0, input.Length)
cryptStream.FlushFinalBlock()

memStream.Position = 0
Dim result(CType(memStream.Length - 1, System.Int32)) As Byte
memStream.Read(result, 0, CType(result.Length, System.Int32))

memStream.Close()
cryptStream.Close()

Return result

End Function

End Class

Sending tasks using Microsoft Outlook 11.0

2010-07-16T00:47:00.000+05:30

This is the simplest way for creating and sending a task

First add Reference to Microsoft 11.0 object library from Add Reference and click on COM tab.

code :
using Outlook = Microsoft.Office.Interop.Outlook;

'Create objects of ApplicationClass and TaskItem as follows :
Outlook.ApplicationClass app = new Outlook.ApplicationClass();
Outlook.TaskItem task = (Outlook.TaskItem)
app.CreateItem(Outlook.OlItemType.olTaskItem);

'Set task property :
task.StartDate = DateTime.Now;
task.DueDate = DateTime.Now;
task.Subject = "Test";
task.Body = "Testing";
task.Recipients.Add(xyz@xyz.com);
task.Assign();
task.Send();