Note that you have comment the item adding code of your service
if (rdr.HasRows)
{
}
if this is actual code of service you will not get any results.
it should be soemthing like below
if (rdr.HasRows)
{
while (rdr.Read())
data.Add(new dataclass7(rdr.GetString(0), rdr.GetString(1), rdr.GetString(2), "", "", "", ""));
}
otherwise your service code and WcfTestClient application working fine. As per WcfTestClient response, there is no matching records found for
'001'
go to sql server and run below statement
Select Compcode,Acct_sub0,Acct_Desc from GI_sub0 where Compcode='001'
you will not get any records for sure.