Hi,
Based on the database used you have to give connection string details accordingly. for ex
1. for mysql - https://www.connectionstrings.com/mysql-oledb-mysqlprov/
2. https://www.connectionstrings.com/sql-server-2008/
// MySQL connection string format is below
// Provider=MySQLProv; Data Source=mydb; User Id=myUsername; Password=myPassword
var connectionString = ""; // use above format with your server/db details and assign the string value to this variable
var objConnection = null;
var objRecordSet = null;
var query = "select * from table_1"; // your query on database
objConnection = Sys.OleObject("ADODB.Connection");
objConnection.ConnectionString = connectionString;
objConnection.Open();
objRecordSet = Sys.OleObject("ADODB.RecordSet");
objRecordSet.Source = query;
objRecordSet.ActiveConnection = objConnection;
objRecordSet.Open();
objRecordSet.MoveFirst();
while ( !objRecordSet.EOF ){
intCount++;
objRecordSet.MoveNext();
}
please let me know if it helps. thank you.