vanillaET wrote: There are two databases with the same data structure. One database is ok to insert that record, but another is not ok for data type conversion. I've checked all the data fields.Please give me any suggestion to solve it. Check the data-fields again. You're inserting something that cannot be converted, might be a text in a bit or a datetime field. Try logging all values that are going to be inserted, and have the app mail the offending values using a try-catch block. Next, simply try the offending values using your original insert-statement trough the Sql Management Studio. Bastard Programmer from Hell :suss:

Hi, I suggest to you a javascript client solution: add this javascript function somewhere in your project function selectChoice(ddl, textboxID) { var chosenoption = ddl.options[ddl.selectedIndex]; if (chosenoption.value != 'nothing') { document.getElementById(textboxID).value = chosenoption.value; } } add onrowdatabound event for your grid with this code: protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { DropDownList ddlChoice = e.Row.FindControl("ddlChoice") as DropDownList; TextBox txtSelectedValue = e.Row.FindControl("txtSelectedValue") as TextBox; string jScript = "selectChoice(this, '{0}');"; ddlChoice.Attributes.Add("onchange", string.Format(jScript, txtSelectedValue.ClientID)); } } ____________________ Web Programmer http://glucolo.wordpress.com modified on Monday, July 4, 2011 6:10 AM

Strictly speaking, this question should be in the ASP.NET forum, and no - a required field validator validates that a field is required, not that one of two fields is required. You'll need to write a custom validator. "WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes. My blog | My articles | MoXAML PowerToys | Onyx

Thanks for your help. I'm now trying to write my program according to your psudo code. At first, I thought this program in a very confused way. Thanks a lot! :)