anatar02
13 years agoContributor
Unable to fetching data from SQL server by using C#
Hi All,
I have written the set of below code to fectching the data from sql server by using C#. Its executed successfully without any error but unfortunately its not fetching any data from db.
Some one please have a look and let me know that where i am missing.
function doGetTestSuiteRunId()
{
var mConnection, RecSet, Cmd, sql,Prm;
mConnection=Sys["OleObject"]("ADODB.Connection");
mConnection["Open"]("Driver={SQL Native Client};"+"Server=BLRWIN7VM01;"+"Database=execution_log;"+ "Uid=sa;"+"Pwd=test");
Prm=mConnection["Execute"]("SELECT top 1 TestSuiteRunId FROM TestSuiteRunId where data='test' ORDER BY TestSuiteRunId DESC");
Log["Message"](Prm)
mConnection["Close"]()
}
I have written the set of below code to fectching the data from sql server by using C#. Its executed successfully without any error but unfortunately its not fetching any data from db.
Some one please have a look and let me know that where i am missing.
function doGetTestSuiteRunId()
{
var mConnection, RecSet, Cmd, sql,Prm;
mConnection=Sys["OleObject"]("ADODB.Connection");
mConnection["Open"]("Driver={SQL Native Client};"+"Server=BLRWIN7VM01;"+"Database=execution_log;"+ "Uid=sa;"+"Pwd=test");
Prm=mConnection["Execute"]("SELECT top 1 TestSuiteRunId FROM TestSuiteRunId where data='test' ORDER BY TestSuiteRunId DESC");
Log["Message"](Prm)
mConnection["Close"]()
}