Binding Numeric TextBox to int Field

[Chris T.]

Maybe there's an easy way to do this that I'm missing, but I'm pulling my hair out here.

I have a class that has a field...for example:

protected int? _MNIIdentityID;
public int? MNIIdentityID {
    get { return _MNIIdentityID; }
    set { _MNIIdentityID = value; }
}

When I bind an instance of the class to a FormView, I can't seem to make it work. 

If I bind to Text, I can't get empty strings to work correctly.

If I bind to DbValue, I get an error that it can't convert double? to int?.

Any suggestions, short of using a non-numeric textbox?

[Missing User]

Hi Chris,


We are having some trouble understanding the problem. I have prepared a sample page which demonstrates the correct behavior. Can you please modify it to show us what goes wrong? I am afraid without an example we will not be able to provide much assistance.

Sincerely yours,
Plamen
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Chris T.]

Sorry it took me a bit to get back to this issue.

I've modified and attached the project as requested.  The problem occurs when using an ObjectDataSource to do the binding.  A simple dal and bll are in the one file in App_Code.

Note that as is, binding to DBValue works great if you submit an empty string.  The bll object gets a null in the int? field.  The problem is trying to send in an actual number value.  That's when I get the "can't convert from double? to int?" bit.

Thanks for taking a look!

Modified Example Code

[Missing User]

Hello Chris,

You can use the ItemUpdating event handler. The FormView control raises the ItemUpdating event when an Update button within the control is clicked, but before the FormView control updates the record. Here is an example:

    protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e)
    {
        e.NewValues[0] = Convert.ToInt32(e.NewValues[0]);
    }

Please find attached a sample web application that demonstrates the needed approach. Take a look at it, and do not hesitate to contact me if you have other questions and/or problems.



Sincerely yours,
Plamen
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Chris T.]

Plamen,

Works great!

I'm aware this wasn't a telerik error, but a lack of complete ASP.NET knowledge on my part...thanks for taking the time to help anyway!

-Chris