public string[] ReturnItem(string prefixText) { string str1 = 'select Item from SCM_BalPo where Item LIKE ' + prefixText + '%'; ds1 = objDl.returnDataSet(str1, 'Item'); items1 = new string[ds1.Tables['Item'].Rows.Count]; for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { items1[i] = ds1.Tables[0].Rows[i].ItemArray[0].ToString(); } return items1; } [WebMethod] public string[] ReturnSiteId(string prefixText1) { string str = 'select SiteId from SA_Client where SiteId LIKE ' + prefixText1 +'%'; ds = objDl.returnDataSet(str, 'SiteID'); items = new string[ds.Tables['SiteID'].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { items[i] = ds.Tables[0].Rows[i].ItemArray[0].ToString(); } return items; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)