private void saveval() { try { int i = 0; DataTable dt = new DataTable(); dt.Columns.Add("Trading_Range_Id"); dt.Columns.Add("Trading_Date"); dt.Columns.Add("Trading_Range"); dt.Columns.Add("Trading_Period"); dt.Columns.Add("Min_Ext_Unit"); dt.Columns.Add("Min_Ext_Value"); dt.Columns.Add("Max_Ext_Unit"); dt.Columns.Add("Max_Ext_Value"); int inc = 1; string WEF = ""; foreach (GridDataItem dataItem in rgdItems.MasterTableView.Items) { DropDownList ddlLTGMTP = (DropDownList)(dataItem.FindControl("ddlLTGMTP")); DropDownList ddlHoursWEFP = (DropDownList)(dataItem.FindControl("ddlHoursWEFP")); DropDownList ddlMinsWEFP = (DropDownList)(dataItem.FindControl("ddlMinsWEFP")); TextBox txtPWFF = (TextBox)(dataItem.FindControl("txtPWFF")); DropDownList ddlminUnit = (DropDownList)(dataItem.FindControl("ddlminUnit")); DropDownList ddlmaxUnit = (DropDownList)(dataItem.FindControl("ddlmaxUnit")); TextBox txtTradingRange = (TextBox)(dataItem.FindControl("txtTradingRange")); TextBox txtTradingPeriod = (TextBox)(dataItem.FindControl("txtTradingPeriod")); TextBox Min_Ext_Value = (TextBox)(dataItem.FindControl("Min_Ext_Value")); TextBox Max_Ext_Value = (TextBox)(dataItem.FindControl("Max_Ext_Value")); HiddenField hdnTPId = (HiddenField)(dataItem.FindControl("hdnTPId")); if (txtPWFF.Text != "") { WEF = AddHourMin(txtPWFF.Text, ddlHoursWEFP.SelectedValue, ddlMinsWEFP.SelectedValue); } if (txtTradingRange.Text.Length > 0 && txtTradingPeriod.Text.Length > 0) { DataRow dritem = dt.NewRow(); if (hdnTPId.Value == null || hdnTPId.Value == "") { dritem["Trading_Range_Id"] = "0"; } else { dritem["Trading_Range_Id"] = hdnTPId.Value; } if (WEF != "") { WEF = Convert.ToDateTime(WEF).ToString("yyyy-MM-dd hh:mm"); dritem["Trading_Date"] = WEF; } else { dritem["Trading_Date"] = WEF; } dritem["Trading_Range"] = txtTradingRange.Text; dritem["Trading_Period"] = txtTradingPeriod.Text; dritem["Min_Ext_Unit"] = ddlminUnit.SelectedValue; dritem["Min_Ext_Value"] = Min_Ext_Value.Text == "" ? Convert.DBNull : Convert.ToInt32(Min_Ext_Value.Text); dritem["Max_Ext_Unit"] = ddlmaxUnit.SelectedValue; dritem["Max_Ext_Value"] = Max_Ext_Value.Text == "" ? Convert.DBNull : Convert.ToDecimal(Max_Ext_Value.Text); dt.Rows.Add(dritem); inc++; } } int retval = 0; if (dt.Rows.Count > 0) { retval = objCP.INS_UPD_Trading_Range(UDFLib.ConvertIntegerToNull(ViewState["CPID"]), dt, UDFLib.ConvertIntegerToNull(Session["USERID"].ToString())); if (retval == 0) { lblError.Text = "With effect from cannot be duplicate! "; } else { BindItems(); } } else { lblError.Text = "Please provide Item description."; } } catch (Exception ex) { string err = ex.ToString(); } }