DataTable Error: There is no row at position 0 VB.Net

baijuep

SOLVED CLOSED ACTIVE ANSWERED
User: baijuep
Posted: on Mar 29, 2013 01:39 AM
Forum: .Net Basics
Answer: 1
Views: 9028

in my asp.net+vb+sql database web there is a edit page in which data is displayed from two different tables and it works fine

when there is no persnumber(common id in both tables) is not there in table2 then the following error comes. how can i rectify this

There is no row at position 0

the table2 is a table in which all the pernumber is not fed as a person goes for leave then onlt the pernumber gets fed into it

If lvety.Text = dt1.Tables("lve").Rows(0).Item("type") Is DBNull.Value Then
                lvety.Text = ""
            Else
                lvety.Text = dt1.Tables("lve").Rows(0).Item("type")

the code which i used is as above

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Mar 29, 2013 01:41 AM
Report

Try

If dt1.Tables("lve").Rows.Count = 0 And dt1.Tables("lve").Rows(0).Item("type") Is DBNull.Value Then
    lvety.Text = ""
Else
   vety.Text = dt1.Tables("lve").Rows(0).Item("type")

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

DataTable Error: There is no row at position 0 VB.Net

There is no row at position 0

Company

Explore

Follow us

Contact Us