how to set Integer/double textbox controls to DBNull

Is there any way to set integer/double textbox to DBNull? Integer/Double textbox controls assumes that the value 0 is NullString. But in reality a numeric column can contain NULL value. There is also another issue with these controls related to the above mentioned problem. These controls are always intialized to have a value 0. Is there a way to override this behaviour (ie not to have any value on screen if it is null)?

Hi Rajeev, Presently the DoubleTextBox and IntegerTextBox controls cannot handle DBNull value and they assume 0 to be the Null value. However, we have considered this as a feature request for implementation in a future release of Essential Suite. Please open an incident in DirectTrac regarding this issue and I will update you when this is accomplished. In order to set the values of the DoubleTextBox and IntegerTextBox to a null value you could set the Text property values to null as shown below : this.doubleTextBox1.Text = null; this.integerTextBox1.Text = null; In order to prevent 0 being displayed when the values are set to null, please set the following properties : this.doubleTextBox1.NullString = ""; this.doubleTextBox1.UseNullString = true; this.integerTextBox1.NullString = ""; this.integerTextBox1.UseNullString = true; I have also attached a sample application here which shows how this can be done. Thanks for your patience and cooperation. Regards, Guru Patwal Syncfusion, Inc.

Thanks. The controls now doesn't display 0 by default. But I still find a problem with this. It doesn't allow me to enter 0 (or show )in to these fields. As you know 0 is a valid value. How could I force these controls to display 0 when user enters it. Thanks > Hi Rajeev, > > Presently the DoubleTextBox and IntegerTextBox controls cannot handle DBNull value and they assume 0 to be the Null value. However, we have considered this as a feature request for implementation in a future release of Essential Suite. Please open an incident in DirectTrac regarding this issue and I will update you when this is accomplished. > > In order to set the values of the DoubleTextBox and IntegerTextBox to a null value you could set the Text property values to null as shown below : > this.doubleTextBox1.Text = null; > this.integerTextBox1.Text = null; > > In order to prevent 0 being displayed when the values are set to null, please set the following properties : > this.doubleTextBox1.NullString = ""; > this.doubleTextBox1.UseNullString = true; > > this.integerTextBox1.NullString = ""; > this.integerTextBox1.UseNullString = true; > > I have also attached a sample application here which shows how this can be done. Thanks for your patience and cooperation. > > Regards, > Guru Patwal > Syncfusion, Inc.

Thanks. The controls now doesn't display 0 by default. But I still find a problem with this. It doesn't allow me to enter 0 (or show )in to these fields. As you know 0 is a valid value. How could I force these controls to display 0 when user enters it. Thanks > Hi Rajeev, > > Presently the DoubleTextBox and IntegerTextBox controls cannot handle DBNull value and they assume 0 to be the Null value. However, we have considered this as a feature request for implementation in a future release of Essential Suite. Please open an incident in DirectTrac regarding this issue and I will update you when this is accomplished. > > In order to set the values of the DoubleTextBox and IntegerTextBox to a null value you could set the Text property values to null as shown below : > this.doubleTextBox1.Text = null; > this.integerTextBox1.Text = null; > > In order to prevent 0 being displayed when the values are set to null, please set the following properties : > this.doubleTextBox1.NullString = ""; > this.doubleTextBox1.UseNullString = true; > > this.integerTextBox1.NullString = ""; > this.integerTextBox1.UseNullString = true; > > I have also attached a sample application here which shows how this can be done. Thanks for your patience and cooperation. > > Regards, > Guru Patwal > Syncfusion, Inc.

Hi Rajeev, Thanks for bringing this to our notice. I could observe the above mentioned behavior here. I have contacted the Essential Development Team for their inputs on this issue, and will update you as soon as I hear from them. Thanks for your patience. Regards, Guru Patwal Syncfusion, Inc.