private void BindPage(Int32 EstNum, Int32 ProjectNumber) { Whitfield_Project _wc = new Whitfield_Project(); try { IDataReader iReader = _wc.GetProjectInfo(Convert.ToInt32(EstNum), Convert.ToInt32(ProjectNumber)); while (iReader.Read()) { BindWinClientinfo(Convert.ToInt32(EstNum), Convert.ToInt32(ProjectNumber)); txtOrigContract.Text = iReader["O_Contract_Value"] == DBNull.Value ? "0" : iReader["O_Contract_Value"].ToString(); txtChangeOrder.Text = iReader["Change_Order_Value"] == DBNull.Value ? "0" : iReader["Change_Order_Value"].ToString(); lblCurrentContract.Text = (Convert.ToDecimal(txtOrigContract.Text) + Convert.ToDecimal(txtChangeOrder.Text)).ToString(); lblPrjHeader.Text = iReader["ProjName"] == DBNull.Value ? "" : iReader["ProjName"].ToString(); txtInitialPaymentDate.Text = iReader["Init_Payment_Date"] == DBNull.Value ? "" : iReader["Init_Payment_Date"].ToString(); txtFinalPaymentDate.Text = iReader["Final_Payment_Date"] == DBNull.Value ? "" : iReader["Final_Payment_Date"].ToString(); //String winclient = iReader["WinClient"] == DBNull.Value ? "" : iReader["WinClient"].ToString(); String winclient = _wc.GetWinningClient(Convert.ToInt32(EstNum)); String Payment_point_of_contact = iReader["Payment_point_of_contact"] == DBNull.Value ? "" : iReader["Payment_point_of_contact"].ToString(); //Response.Write("Wining Client:" + winclient); BindContacts(Convert.ToInt32(winclient)); ddlContacts.SelectedIndex = ddlContacts.Items.IndexOf(ddlContacts.Items.FindByValue(Payment_point_of_contact.ToString())); BindYears(); BindMonths(); BindWeeks(); string strMonth = DateTime.Now.ToString("MMMM"); string strYear = DateTime.Now.ToString("yyyy"); ddlMonth.SelectedIndex = ddlMonth.Items.IndexOf(ddlMonth.Items.FindByValue(strMonth.ToString())); ddlYear.SelectedIndex = ddlYear.Items.IndexOf(ddlYear.Items.FindByValue(strYear.ToString())); } DisplayGrid(); DisplaySOVGrid(); DisplayCOSOVGrid(); DisplayHistoryNotes(); DisplaySchedulingGrid(); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } }