Hi, Rohit
The think am looking for is custom connector in visual studio for SQL DB.
I can't find information how to pass table name and select statement and then read response.
Here is code sample i am working on:
namespace QvSQLConnector
{
internal class QvSQLConnection : QvxConnection
{
public override void Init()
{
var SQLFields = new QvxField[]
{
new QvxField("n17_kodas_ps", QvxFieldType.QVX_TEXT,
QvxNullRepresentation.QVX_NULL_FLAG_SUPPRESS_DATA, FieldAttrType.ASCII),
new QvxField("n17_tipas", QvxFieldType.QVX_TEXT,
QvxNullRepresentation.QVX_NULL_FLAG_SUPPRESS_DATA, FieldAttrType.ASCII),
new QvxField("n17_pav", QvxFieldType.QVX_TEXT,
QvxNullRepresentation.QVX_NULL_FLAG_SUPPRESS_DATA, FieldAttrType.ASCII),
};
MTables = new List<QvxTable>
{
new QvxTable
{
TableName = "SQL SELECT n17_kodas_ps, n17_tipas, n17_pav FROM SQL.dbo.N17_PROD",
GetRows = GetProducstFromSQL,
Fields = SQLFields
}
};
}
private IEnumerable<QvxDataRow> GetProducstFromSQL()
{
QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Notice, "GetDataFromSQL()");
string itemCode = "";
string tipe = "";
string name = "";
QvxTable table= FindTable("SQL SELECT n17_kodas_ps, n17_tipas, n17_pav FROM SQL.dbo.N17_PROD", MTables);
if (table == null) yield return null;
itemCode = table.Fields[0].ToString();
tipe = table.Fields[1].ToString();
name = table.Fields[2].ToString();
var row = new QvxDataRow();
row[MTables[1].Fields[0]] = itemCode;
row[MTables[1].Fields[1]] = tipe;
row[MTables[1].Fields[2]] = name;
yield return row;
}
}
public override QvxDataTable ExtractQuery(string query, List<QvxTable> qvxTables)
{
return base.ExtractQuery(query, qvxTables);
}
}
}
