System.IndexOutOfRangeException on a webfarm

re: System.IndexOutOfRangeException on a webfarm

Ramendra Kumar — Wed, 27 Aug 2008 10:09:40 GMT

It gives An Exception for System.IndexOutOfRangeException:

Sql Field IS int also. Could You Help ME

totalsponsoe = Convert.ToInt32(sdr["AppMstSponsorTotal"]);

re: System.IndexOutOfRangeException on a webfarm

Rob Awe — Tue, 16 Sep 2008 21:19:53 GMT

There's probably a typo in your field name.

re: System.IndexOutOfRangeException on a webfarm

Tom — Tue, 16 Sep 2008 21:56:15 GMT

Good point Rob, remember that the SQL field names are case sensative.

re: System.IndexOutOfRangeException on a webfarm

Ariady Putra — Tue, 14 Oct 2008 07:35:45 GMT

my problem is similar to Ramendra Kumar, but i only get the System.IndexOutOfRangeException if i try to call char or text data type from SQL. other fields using int or varchar no problem. i've checked over and over the field name.

bceData.Answer = sqlDataReader["AnswerField"].ToString();

the "AnswerField" is text datatype in SQL. can you help me please?

i have no permission to alter the database.

re: System.IndexOutOfRangeException on a webfarm

Ariady Putra — Thu, 16 Oct 2008 09:51:14 GMT

alright, please forget my previous comment :D the problem was in the stored procedure :D now everything is solved :D i'm still learning anyway :D

re: System.IndexOutOfRangeException on a webfarm

swapneel — Tue, 28 Jul 2009 14:16:40 GMT

sql = "select Rlens_code,Llens_code from Spects where " & oprator & " = '" & Search & "'"

CM = New SqlCommand(sqlstr, frmMasterObj.cn)

Dim dr1 As SqlDataReader = CM.ExecuteReader

If dr1.HasRows = True Then

While (dr1.Read)

If dr1("Llens_code") = "" Then

lblRtLensRef.Text = ""

Else

lblLtLensRef.Text = dr1("Llns_code").ToString()

End If

If dr1("Rlens_code") = "" Then

lblLtLensRef.Text = ""

Else

lblRtLensRef.Text = dr1("Rlens_code").ToString()

End If

End While

dr1.Close()

End If

in this code if some value is null so how can we catch that null value