private void FetchSehedule() { txtSchhours.Text = ""; txtWeeklyComments.Text = ""; Whitfieldcore wc = new Whitfieldcore(); DataSet ds = new DataSet(); ds = wc.GetScheduleData(Convert.ToInt32(ViewState["twc_project_number"].ToString()), ddlYear.SelectedItem.Value.ToString(), ddlMonth.SelectedItem.Value.ToString() + "(" + ddlYear.SelectedItem.Value.ToString() + ")", ddlWeek.SelectedItem.Value.ToString()); Int32 resultCount = 0; if (ds.Tables.Count > 0) resultCount = ds.Tables[0].Rows.Count; DataTable myControls; myControls = ds.Tables[0]; if (myControls.Rows.Count > 0) { try { foreach (DataRow dRow in myControls.Rows) { String _hr = dRow["Hours"] != DBNull.Value ? dRow["Hours"].ToString() : ""; String _comments = dRow["weeklyNotes"] != DBNull.Value ? dRow["weeklyNotes"].ToString() : ""; //String project_amount = dRow["project_amount"] != DBNull.Value ? dRow["project_amount"].ToString() : ""; txtSchhours.Text = _hr; txtWeeklyComments.Text = _comments; //txtProjectedAmt.Text = project_amount; } } catch (Exception ex) { Response.Write(ex.Message); } DisplaySchedulingGrid(); } else { txtSchhours.Text = "0"; txtWeeklyComments.Text = ""; } }