I am working with ASP.NET and StoredProcedure. I change the stored procedure so now it returns 10 field rather than 9. I have added corresponding textbox in asp.net which gets the 10th field.

```
<asp:TextBox ID="ID" runat="server" Text='<%# Eval("ID") %>' Width="80px" ReadOnly="true"></asp:TextBox>

```

But it fails, saying 

> 
> DataBinding: 'System.Data.DataRowView' does not contain a property
>  with the name 'ID'.
> 
> 
> 

I run the stored procedure in SQL Management studio and indeed it does not return the newly modified field. I stop and start the SQL engine and now it does spits out the new value but in my ASP.net application, it still does not recognized the new value. What is the best way to troubleshoot this? It happened to me before as well.

Adding the code where SP is called:

```
SqlConnection aConn = new 
SqlConnection(ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString);
SqlCommand aCommand = new SqlCommand("GetCustomer", aConn);
aCommand.CommandType = CommandType.StoredProcedure;
aCommand.Parameters.Add("@ID", SqlDbType.Int).Value = aID;
SqlDataAdapter adapter = new SqlDataAdapter(aCommand);
DataSet aCustomerDS = new DataSet();
adapter.Fill(aCustomerDS);

```

My Stored Procedure is(there is nothing strange here):

```
CREATE PROCEDURE [dbo].[GetCustomer]
    @ID int
AS
BEGIN
    SET NOCOUNT ON;

IF @ID = 0
BEGIN    
SELECT  ID,
    [this field] as thisfield,
       [that field] as thatfield,
       [new field] as newfield
FROM MyDB.dbo.customers
ORDER BY ID DESC
END
ELSE
BEGIN
SELECT  ID,
    [this field] as thisfield,
       [that field] as thatfield,
       [new field] as newfield
FROM MyDB.dbo.Customers
WHERE ID = @ID
ORDER BY ID DESC
END
END

```

FormView is used to bind data to sdsCustomer

```
<asp:FormView ID="fvCustomer" runat="server" AllowPaging="True" DataSourceID="sdsCustomer"
            DataKeyNames="ID" OnPreRender="OnfvCustomer_PreRender">

```