Unable to call method on varchar error

Question

I get the error "Can't call the method on varchar" on "adapter.Fill (dtROI)". Could you help me? I am trying to populate a data table with adapter results from sql statement.

protected void LoadData() { DateTime StartDate = dpStartDate.Date; DateTime EndDate = dpEndDate.Date; string sql = string.Empty; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = ConfigurationManager.ConnectionStrings["VTC"].ConnectionString; conn.Open(); sql = "select RESERVATION.MEETING_PURPOSE, RESERVATION.PROGRAM_AREA, RESERVATION.START_DATE, RESERVATION.END_DATE, " + "ROI_TRACKING.ENTRY_LOCATION, ROI_TRACKING.SALARY_SAVINGS, ROI_TRACKING.TRANSPORTATION_SAVINGS, ROI_TRACKING.TOTAL_SAVINGS. " + "ROI_TRACKING.TOTAL_DISTANCE, ROI_TRACKING.TOTAL_FUEL, ROI_TRACKING.TOTAL_GSA, ROI_TRACKING.TOTAL_AIRFARE, ROI_TRACKING.TOTAL_INSPECTOR_SALARY, " + "ROI_TRACKING.TOTAL_MGR_SALARY, ROI_TRACKING.TOTAL_SUPERVISOR_SALARY " + "from RESERVATION, ROI_TRACKING WHERE ROI_TRACKING.MEETING_ID = RESERVATION.MEETING_ID"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; DataTable dtROI = new DataTable(); adapter.Fill(dtROI); gridReports.DataSource = dtROI; gridReports.DataBind(); } if (chkDate.Checked == true) { FilterDataGridByDate(StartDate, EndDate); } } } 

Answer 1

I noticed what you have. instead of ',' after ROI_TRACKING.TOTAL_SAVINGS. It must be ROI_TRACKING.TOTAL_SAVINGS,

Hope this helps.