newbie question

[Rafael Chemtob]

hi,
i'm new to .net. i'm getting this error in my app.
Line 21: NameValueCollection nvc = new NameValueCollection();
Line 22: nvc.Add("@MerchantCouponID", merchantCouponID);
Line 23: context.Response.Redirect("http://" +
DAL.RetrieveData("sp_AddClick", nvc).Tables[0].Rows[0]["CreativeUrl"]);
Line 24:
Line 25: }
Source File: g:\CouponsTest\website\Coupons\thank_you.ashx Line: 23

Stack Trace:

[IndexOutOfRangeException: There is no row at position 0.]
System.Data.DataRowCollection.get_Item(Int32 index) +98
thank_you.ProcessRequest(HttpContext context) in
g:\CouponsTest\website\Coupons\thank_you.ashx:23

System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionSte
p.Execute() +152
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +64



the error is in line 23.
i'm not really sure what the problem is? how do i find out the value of
merchantCouponID.
please help
rafael

 

[Marina]

Your datatable has no rows. You can't get the value of the first row, if
there is no first row to begin with.

Make sure you have data before you try to access it.