when i am read data drom sql then an error occur "System.IndexOutOfRangeException". this error generate in line of insureclaim datafield:
my code is:
SqlDataReader rd;
string sql;
if (Session["Case_Ref"] != null)
{
sql = "SELECT * FROM tbl_FPV WHERE Case_Ref='" + Session["Case_Ref"].ToString() + "'";
rd = c1.SelectRD(sql);
if (rd.Read())
{
drop_claimInsure.SelectedValue = rd["Claimant_insure"].ToString();
drop_alterCompany.SelectedValue = rd["Alternative_Company"].ToString();
...
Go to the complete details ...