protected void fv_ItemInserting(object sender, FormViewInsertEventArgs e) { int?i = null; int iCode = 0; DropDownList ddlYear = fv.FindControl("ddlYear") as DropDownList; DropDownList ddlSource = fv.FindControl("ddlSource") as DropDownList; TextBox tbAmt = fv.FindControl("tbAmt") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { try { short?shYear = null; if (!string.IsNullOrEmpty(ddlYear.SelectedValue)) { shYear = Convert.ToInt16(ddlYear.SelectedValue); } else { sb.Append("Year is required. "); } string sSource = null; if (!string.IsNullOrEmpty(ddlSource.SelectedValue)) { sSource = ddlSource.SelectedValue; } else { sb.Append("Source is required. "); } decimal?dAmt = null; if (!string.IsNullOrEmpty(tbAmt.Text)) { try { dAmt = Convert.ToDecimal(tbAmt.Text); } catch { sb.Append("Amount must be a number (Decimal). "); } } else { sb.Append("Amount is required. "); } if (string.IsNullOrEmpty(sb.ToString())) { iCode = wac.agWorkloadFunding_add(shYear, sSource, dAmt, Session["userName"].ToString(), ref i); if (iCode == 0) { fv.ChangeMode(FormViewMode.ReadOnly); BindWorkloadFunding(Convert.ToInt32(i)); } else { WACAlert.Show("Error Returned from Database.", iCode); } } else { sb.Insert(0, "The Insert Failed: "); WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }