IndexOutofRangeException :There is no row at position 0

Ameya Deshpande

9y6.7kLearn iOS Programming

I am getting the following error when I click on the login button:

There is no row at position 0

Specifically from the Image3.ImageUrl = HDT.Rows[0]["image"].ToString(); line.

DS_HOUSE.HOUSE_SELECTDataTable HDT = new DS_HOUSE.HOUSE_SELECTDataTable();

DS_HOUSETableAdapters.HOUSE_SELECTTableAdapter HAdapter = new DS_HOUSETableAdapters.HOUSE_SELECTTableAdapter();

DS_USER.USERMST_SELECTDataTable UDT = new DS_USER.USERMST_SELECTDataTable();

DS_USERTableAdapters.USERMST_SELECTTableAdapter UAdapter = new DS_USERTableAdapters.USERMST_SELECTTableAdapter();

protected void Page_Load(object sender, EventArgs e)

{

lblsell.Text = "";

UDT = UAdapter.Select_By_UID(Convert.ToInt32(Session["uid"].ToString()));

HDT = HAdapter.Select_By_SNAME_BLOCKNO(UDT.Rows[0]["societyname"].ToString(), Convert.ToInt32(UDT.Rows[0]["Houseid"].ToString()));

Image3.ImageUrl = HDT.Rows[0]["image"].ToString();

lblsname.Text = HDT.Rows[0]["sname"].ToString();

lblbno.Text = HDT.Rows[0]["blockno"].ToString();

lbltype.Text = HDT.Rows[0]["type"].ToString();

ViewState["HID"] = HDT.Rows[0]["HID"].ToString();

}

The table is not empty and yet this error is coming.Please help.

The full project source code and database backup has been attached.

It would be great help if you run and help solving this error which is bugging me since long time now.

8 Replies

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

Midhun Tp9y ago
Accepted answer
Hi,

Just try altering the procedure "USERMST_SELECT_by_uid" as below -
ALTER PROCEDURE [dbo].[USERMST_SELECT_by_uid]
    -- Add the parameters for the stored procedure here
    @uid int
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT u.*,h.SName as societyname from dbo.UserMst u inner join HouseMst h on u.HouseID=h.HID where UID = @uid
END
+1
Midhun Tp9y ago
Hi Ameya,

You have to look the procedures and check what logic you are using. The suggestion I gave you was purely based on the data I found in your database. I still suggest you that you have to check the mapping of datas in your tables. Be clear about the master tables.

In the procedure "HOUSE_SELECT_BY_SNAME_and_BLOCKNO", you are selecting data based on column Sname & Blockno.

Please check what values are you passing to that parameters in your code.

You are getting those values from "USERMST_SELECT_by_uid" procedure. Check that procedure too.

Happy coding :)
0
Ameya Deshpande9y ago
Midhun i am getting 1 more error :When i enter 3 values into table the same error comes (No row at position 0) and error is pointed at HDT = HAdapter.Select_By_SNAME_BLOCKNO(UDT.Rows[0]["societyname"].ToString(),

Please can you suggest what changes should i make to stored procedure dbo.HOUSE_SELECT_BY_SNAME_ AND BLOCKNO ?
0
Ameya Deshpande9y ago
Thank you so much for trying on your system .It worked beautifully. @Midhun
0
Midhun Tp9y ago
Hi,

This issue is happening because the method "HAdapter.Select_By_SNAME_BLOCKNO" is not returning any rows.

This is because the parameter "UDT.Rows[0]["societyname"].ToString()" you passing to that method is empty.
You have to check your database and tables once again. Datas are not matching properly.

Also check whether dataset is empty before binding the values.

if (HDT.Rows.Count > 0)
{
//Your code
}
0
Ameya Deshpande9y ago
Can you please run the code on your side and help in resolving the error ? I have been stuck on it for the past 2 days.
0
Ameya Deshpande9y ago
I have read those links but am yet to arrive at a solution .
Can you please try the attached source on your end as well please? Because i posted this on 3 forums and havent got any answer.
+1
Thiruppathi R9y ago
Try this way

https://stackoverflow.com/questions/20940979/what-is-an-indexoutofrangeexception-argumentoutofrangeexception-and-how-do-i-f
0