Click here to Skip to main content
16,018,802 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
XML
public List<datalist7> getdata(string id)
       {
           SqlConnection con = new SqlConnection(@"Data Source=saba-PC;Initial Catalog=bcounts;Integrated Security=True");
           con.Open();
           SqlCommand cmd = new SqlCommand("Select Compcode,Acct_sub0,Acct_Desc from GI_sub0 where Compcode='" + id + "'", con);
           SqlDataReader rdr = cmd.ExecuteReader();
           List<datalist7> data = new List<datalist7>();
           if (rdr.HasRows)
           {
               while (rdr.Read())
                 data.Add(new datalist7(rdr.GetString(0), rdr.GetString(1), rdr.GetString(2),"","","",""));
           }
           con.Close();
           return data;
       }


C#
[DataContract]

   public class datalist7
   {
       [DataMember]
       public string val1 { get; set; }
       [DataMember]
       public string val2 { get; set; }
       [DataMember]
       public string val3 { get; set; }
       [DataMember]
       public string val4 { get; set; }
       [DataMember]
       public string val5 { get; set; }
       [DataMember]
       public string val6 { get; set; }
       [DataMember]
       public string val7 { get; set; }
       public datalist7(string v1, string v2, string v3, string v4, string v5, string v6,string v7)
       {
           val1 = v1;
           val2 = v2;
           val3 = v3;
           val4 = v4;
           val5 = v5;
           val6 = v6;
           val7 = v7;
       }

   }


but when i am runnig this method on browser it shows :

{"getdataResult":[]}
what was the matter>> is it woking fine??
and my wcf client test application does not show this method ar any other method of my service?
Posted
Updated 17-May-14 22:21pm
v2
Comments
Kornfeld Eliyahu Peter 18-May-14 4:12am    
Check the SQL! It seems you got no records from your query...
Member 10690757 18-May-14 4:15am    
in sql records are showing
Kornfeld Eliyahu Peter 18-May-14 6:45am    
The line
data.Add(new datalist7(rdr.GetString(0), rdr.GetString(1), rdr.GetString(2),"","","",""));
got hit, while debugging?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900