- Details
- Written by: Stanko Milosev
- Category: Code snippets
- Hits: 4423
Selenium tests in java, I already explained here. Since I am not Java expert I need them to run also in .NET environment, idea is to create console application to parse few web pages, by automatizing Chrome. I am using this web site.
Download Selenium Client & WebDriver Language Bindings, in my case I downloaded this one. You will also need ChromeDriver, in my case I downloaded this one.
Start new project:
Choose console:
Add references to previously downloaded Selenium Client & WebDriver Language Bindings (in solution explorer right mouse button on References):
Browse:
In my case I decided to go on net40:
Add dll's:
In my case I decided to add also ChromeDriver to project, then I will not have explicitly to write path. Right click on the project and click add existing item:
Choose chrome driver:
Select chrome driver, choose properties:
In part Copy To Output Directory, choose Copy always. You can also choose copy if newer, but to avoid possible problems I decided to go like this:
Now I added following name spaces:
using OpenQA.Selenium; using OpenQA.Selenium.Chrome; using OpenQA.Selenium.Support.UI;
Then in Main method add code like:
IWebDriver driver = new ChromeDriver(); driver.Navigate().GoToUrl("http://www.milosev.com");
In line:
IWebDriver driver = new ChromeDriver();
You can also write something like:
IWebDriver driver = new ChromeDriver(@"C:\Users\myUserName\Downloads\chromedriver_win32");
Then you wouldn't need to add chrome driver into the project...
So, this is all you need to start parsing pages with Selenium. Example project download from here.
- Details
- Written by: Stanko Milosev
- Category: Code snippets
- Hits: 5068
using System; using System.Data.SqlClient; using System.IO; using Microsoft.SqlServer.Management.Common; using Microsoft.SqlServer.Management.Smo; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { string[] filePaths = Directory.GetFiles(@"c:\myListOfScripts\", "*.sql"); Array.Sort(filePaths); string connectionString = "server=myServer\\myInstance;database=myDatabase;uid=sa;pwd=mySaPwd"; SqlConnection cn = new SqlConnection(connectionString); Console.WriteLine("Last how many scripts you want to execute?"); var lastNoScript = Convert.ToInt16(Console.ReadLine()); FileStream ostrm; StreamWriter writer; TextWriter oldOut = Console.Out; try { ostrm = new FileStream("./log.txt", FileMode.OpenOrCreate, FileAccess.Write); writer = new StreamWriter(ostrm); } catch (Exception e) { Console.WriteLine("Cannot open log.txt for writing"); Console.WriteLine(e.Message); return; } Console.SetOut(writer); cn.Open(); for (int i = filePaths.Length - lastNoScript; i < filePaths.Length; i++) { Console.WriteLine("Executing script: "); Console.WriteLine(filePaths[i]); Console.WriteLine(); FileInfo file = new FileInfo(@filePaths[i]); string script = file.OpenText().ReadToEnd(); ServerConnection svrConnection = new ServerConnection(cn); Server server = new Server(svrConnection); try { server.ConnectionContext.ExecuteNonQuery(script); } catch (Exception e) { Console.WriteLine(script + " : Message: " + e.Message + " Inner exception: " + e.InnerException.Message); } } Console.SetOut(oldOut); writer.Close(); ostrm.Close(); Console.WriteLine("Press any key..."); Console.ReadKey(true); } } }
For:
using Microsoft.SqlServer.Management.Common; using Microsoft.SqlServer.Management.Smo;
you will need to add reference to files:
C:\Program Files\Microsoft SQL Server\110\SDK\Assemblies\Microsoft.SqlServer.ConnectionInfo.dll
and
C:\Program Files\Microsoft SQL Server\110\SDK\Assemblies\Microsoft.SqlServer.Management.Sdk.Sfc.dll
C:\Program Files\Microsoft SQL Server\110\SDK\Assemblies\Microsoft.SqlServer.Smo.dll
Your app.config file must to look like:
<?xml version="1.0"?> <configuration> <!--<startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/></startup>--> <startup useLegacyV2RuntimeActivationPolicy="true"> <requiredRuntime version='v4.0.20506' safemode='true'/> <supportedRuntime version='v4.0'/> </startup> </configuration>
To add app.config file do next:
1. On the Project menu, click Add New Item.
2. The Add New Item dialog box appears.
Select the Application Configuration File template and then click Add.
A file named app.config is added to your project.
- Details
- Written by: Stanko Milosev
- Category: Code snippets
- Hits: 5532
OCR - optical character recognition, with MODI - microsoft office document imaging.
Microsoft has developed tool for OCR, which we can use it as a COM object.
First you need to install MODI on your computer, then, you can use it like this:
Document md = new Document(); String ocrText = String.Empty; md.Create(openFileDialog1.FileName); const bool ocrOrientImage = false; const bool ocrStraightenImage = false; md.OCR(MiLANGUAGES.miLANG_ENGLISH, ocrOrientImage, ocrStraightenImage); var image = (MODI.Image)md.Images[0]; var layout = image.Layout; foreach (Word word in layout.Words) { if (ocrText.Length > 0) { ocrText += " "; } ocrText += word.Text; } textBox1.Text = ocrText;
Only problem is if you want to really release the object md, then you ave to use SaveAs method something like:
string path = Path.GetDirectoryName(openFileDialog1.FileName); md.SaveAs(path + "\\deleteMe.tif", MODI.MiFILE_FORMAT.miFILE_FORMAT_DEFAULTVALUE,
MODI.MiCOMP_LEVEL.miCOMP_LEVEL_MEDIUM);
Taken from here, and from this source code.
My source you can download from here, and exe file can be found here.
- Details
- Written by: Stanko Milosev
- Category: Code snippets
- Hits: 4212
Open new form in "modal" style:
Form2 frmTest = new Form2(); frmTest.ShowDialog();
To get path from file name:
using System.IO; ... string path = Path.GetDirectoryName(openFileDialog1.FileName);