Wednesday 23 November 2011

Data Driven using Excel Data with oledb connection in selenium webdriver with CSharp

string connectionstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "d:\\Userdata.xlsx" + ";Extended Properties=\"Excel 12.0;HDR=YES;\"";
 string selectusername = "SELECT *from [Sheet1$] ";
OleDbConnection con = new OleDbConnection(connectionstring);
OleDbCommand cmd = new OleDbCommand(selectusername, con);
con.Open();
OleDbDataReader thedata = cmd.ExecuteReader();
while (thedata.Read())
{
username = thedata[0].ToString();
password = thedata[1].ToString();
driver.Navigate().GoToUrl(baseURL);
driver.FindElement(By.LinkText("REGISTER")).Click();
driver.FindElement(By.Name("email")).SendKeys(username);
driver.FindElement(By.Name("password")).SendKeys(password);
driver.FindElement(By.Name("confirmPassword")).SendKeys(password);
}


No comments:

Post a Comment