Selenium with C# SQL Server connection with

Question

I'm running into an issue when I try to run a simple Selenium script which has field (SSN), and on every new run of the script SSN need to has bigger value (+1). Is it possible Selenium to connect with SQL Server database and check the SSN value from there, and what is the code to connect Selenium with SQL Server database? I am using Selenium with C#. Many Thanks.

Selenium automates browsers. It do not connect with Database, C# will do that part. — Manu
– Manu, Commented Aug 13, 2015 at 12:40

Raviteja · Accepted Answer · 2016-01-18 05:04:57Z

2

public static int SSN_DB(IWebDriver session, string connString) {
  //creating a db connection connection
  var DBConnection = new SqlConnection(connString);
  DBConnection.Open();
  // Can execute a query or store procedure 
  var MemTable = new SqlCommand();
  MemTable.CommandText = "Select top 1 SSN from dbo.member order by EMPL desc";
  MemTable.Connection = DBConnection;
  var dr = MemTable.ExecuteReader();
  var Memberid = 0;

  while (dr.Read()) {
    Memberid = dr.GetInt32(0);
    Console.WriteLine(Memberid);
  }
  return Memberid;
}

}

edited Jan 18, 2016 at 5:04

Raviteja

3,48723 gold badges46 silver badges74 bronze badges

answered Jan 18, 2016 at 4:21

banu s

506 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Maris Over a year ago

SqlConnection have to used in scope of using, otherwise you will endup with memory leak!!!

Collectives™ on Stack Overflow

Selenium with C# SQL Server connection with

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related