There is no row at position 0

[uday1302]

Hi Friends,
There is no row at position 0 Error
here it is my code..

string q="select * from Masters where deptno="+deptno;
dataset ds=new datset();
sqldataadapter da=new sqldatadapter(q, conn);
da.fill(ds,"fill");
listviewitem list=null;
foreach(datarow dr in ds.tables["fill"].rows)
{
list=new lisviewitem(dr.rows["empno"].tostring());
listview.items.add(list);
list.subitems.add(dr.rows["empname"].tostring())
}

In masters tables row values r ther.
deptno, empno emname
1 100 u
2 200 k
3 null null
4 null op
if i select deptno 1 values r retrived...if i select deptno 3 then tht error exists
Please me how to solve the problem. I think everbody understood

[uday1302]

Plz reply me Guys i am in very urgent

[r035198x]

Plz reply me Guys i am in very urgent

You posted that in the wrong forum.
This is certainly not a programming challenge.
You get responses faster if you post in the correct forum.

[Frinavale]

Hi Friends,
There is no row at position 0 Error
here it is my code..

string q="select * from Masters where deptno="+deptno;
dataset ds=new datset();
sqldataadapter da=new sqldatadapter(q, conn);
da.fill(ds,"fill");
listviewitem list=null;
foreach(datarow dr in ds.tables["fill"].rows)
{
list=new lisviewitem(dr.rows["empno"].tostring());
listview.items.add(list);
list.subitems.add(dr.rows["empname"].tostring())
}

In masters tables row values r ther.
deptno, empno emname
1 100 u
2 200 k
3 null null
4 null op
if i select deptno 1 values r retrived...if i select deptno 3 then tht error exists
Please me how to solve the problem. I think everbody understood

I'm not sure what you are doing in the Selected Index Changed event for your ListView....maybe you're not properly referencing the correct index?

Could you please post your code for this method so that we can better understand your problem. Remember to use [code] tags when posting code.

-Frinny

[GayathriP]

Hi Uday,

The line

list=new lisviewitem(dr.rows["empno"].tostring());
 

should be

list=new lisviewitem(dr["empno"].tostring());
 

<B>The Datarow object doesn't have the rows collection</B>

Hope now it will work.