Hi Sir,
i am fetching data from QB and insert in the XML file on page and gridview binded from XML
but sometime if QB is Closed on server it's giving some big error "related with connection"
below code for fetching data from QB
public DataTable SupplierBind(String AutoCompleter)
{
try
{
// Set QueryType to qtVendorSearch
oObjsearch.QBConnectionString = QBConnectionString;
oObjsearch.OpenQBConnection();
oObjsearch.QueryType = InQB.ObjsearchQueryTypes.qtVendorSearch;
oObjsearch.SearchCriteria.NameContains = AutoCompleter;
oObjsearch.Search();
//oObjsearch.CloseQBConnection();
Int32 Cnt = Convert.ToInt32(oObjsearch.Results.Count);
String[] supplierId = new String[Cnt];
String[] names = new String[Cnt];
String[] UpperName = new String[Cnt];
...
Go to the complete details ...