Loading

Why??

7450821

22y3.7k.NET

public DataSet GetClass() { SqlConnection myConnection=new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]); SqlDataAdapter countCmd=new SqlDataAdapter("select *,(select count(*) from Class where ParentId=g.SubId) as nCount from Class g",myConnection); DataSet dstClass=new DataSet(); countCmd.Fill(dstClass); return dstClass; } DataBinder.Eval: 'System.Data.DataRowView' does not contain a property with the name nCount. why? Is anybody could help me?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

ashug21y ago
I tried the same thing and its working fine. string connectionString="connectionString"; SqlConnection myConnection=new SqlConnection(connectionString); SqlDataAdapter countCmd=new SqlDataAdapter("select o.*,(select count(*) from [order details] where OrderID=o.OrderID) as nCount from orders o",myConnection); DataSet dstClass=new DataSet(); countCmd.Fill(dstClass); rturn dstClass;
0
jinwolf21y ago
Try using: int nCount = dstClass.Tables[0].Rows.Count;
0
prasannav281021y ago
ya there is... u can use dataview.count or dataview.row.count
0