 <p>Try this</p> <p>Error Says that Your are accessing a row which is Not present so,</p> <p>Always Check For whether Row exists in <code>DataSet/DataTable</code> using <code>RowCount</code></p> <pre><code>protected void Page_Load(object sender, EventArgs e) { if(!Page.IsPostBack) { Label1_pl.Text = Session["UserID"].ToString(); string sqlstr = "select zzfname from sap_empmst where pernr = '" + Label1_pl.Text + "'"; DataSet ds = new DataSet(); OracleDataAdapter adp = new OracleDataAdapter(sqlstr, con1); adp.Fill(ds); if(ds!=null) if(ds.Tables[0].Rows.Count&gt;0) { string zzfname = ds.Tables[0].Rows[0]["zzfname"].ToString(); Label2_name.Text = zzfname; } } } </code></pre>