Ranorex Forum

Code: Select all

 public class MSSQLConnector : ITestModule
    {
    	
    	private string server, database, uid, password, connectionString;

        	//construct	
        public MSSQLConnector(string _server, string _database, string _username, string _password)
        {
         	this.server = _server;
			this.database = _database;
			this.uid = _username;
			this.password = _password;
			this.connectionString = "user id="+this.uid+";"+"password="+this.password+";"+@"server="+this.server+";"+"database="+this.database+";"+"connection timeout=30";

        	
        }


		public DataTable RunQuery(string SQL)
		{

			SqlConnection connection = new SqlConnection(connectionString);
			SqlDataReader reader = null;
			DataTable dt = new DataTable();
			try{
				SqlCommand command = connection.CreateCommand();
				command.CommandText = SQL;
				connection.Open();
				reader = command.ExecuteReader();
				dt.Load(reader);
				}
			catch(Exception e){
				Console.WriteLine("Exception is MSSQLConnector::RunQuery – " + e.ToString());
				}
			finally{
				reader.Close();
				connection.Close();
				}
				return dt;
		}
  void ITestModule.Run()
        {
            Mouse.DefaultMoveTime = 300;
            Keyboard.DefaultKeyPressTime = 100;
            Delay.SpeedFactor = 1.0;            
      //connector object
     MSSQLConnector db = new MSSQLConnector("NQ08\\NQ08", "QA", "generic", "password");
		
		
			//validate middle name 			
DataTable dt= db.RunQuery("Select * from candidate where firstname='Sam'");
			foreach(DataRow row in dt.Rows)
			{
				Ranorex.Validate.IsTrue(row["middlename"].ToString() == "S", "Validating Sam middle name S.");


		}
    }
}
}