Server Error in '/' Application.

There is no row at position 0.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: There is no row at position 0.

Source Error:


Line 38:         string sql = "select *,tenl,link_lxt,tenlc,linklc,Loaibenthung.idlbt,tenLBT,LBT_tit,lbt_link,linktt,tentt from sp left join loai on sp.idl=loai.idl left join taitrong on sp.idtt=taitrong.idtt left join Loaibenthung on sp.idlbt=Loaibenthung.idlbt left join loaicau on sp.idlc=loaicau.idlc where idsp=" + Request.QueryString["code"].ToString();
Line 39:         DataTable dt = XLDL.Docbang(sql);
Line 40:         Page.Title = "" + dt.Rows[0]["ten_xt"].ToString();
Line 41:         og_site_name = "" + dt.Rows[0]["ten_xt"].ToString();
Line 42:         og_alt = "" + dt.Rows[0]["ten_xt"].ToString();

Source File: c:\inetpub\vhosts\hdvn.vn\xetaihoamai.vn\san-pham-chi-tiet.aspx.cs    Line: 40

Stack Trace:


[IndexOutOfRangeException: There is no row at position 0.]
   System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +2441533
   System.Data.DataRowCollection.get_Item(Int32 index) +19
   san_pham_chi_tiet.pge() in c:\inetpub\vhosts\hdvn.vn\xetaihoamai.vn\san-pham-chi-tiet.aspx.cs:40
   san_pham_chi_tiet.Page_Load(Object sender, EventArgs e) in c:\inetpub\vhosts\hdvn.vn\xetaihoamai.vn\san-pham-chi-tiet.aspx.cs:32
   System.Web.UI.Control.OnLoad(EventArgs e) +106
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.4057.0