C# using ACCESS data Base .accdb

See more:

C#

I'm trying to use an access database (long stroy) and I've successfully pulled data from the data set to populate cbo's tb's ect.. but every time I try and update a new record it will not populate the dataset or database. Plz. help. Thx

MedRecordsDBDataSet1TableAdapters.ProvidersTableAdapter pta = new
                MedRecordsDBDataSet1TableAdapters.ProvidersTableAdapter();

            MedRecordsDBDataSet1 ds = new MedRecordsDBDataSet1();
            MedRecordsDBDataSet1.RecordsRow newRecord = ds.Records.NewRecordsRow();

            newRecord.ProviderID = cboProvider.Text;
            newRecord.MonthofRecord = cboMonth.Text;
            newRecord.DayofRecord = cboDay.Text;
            newRecord.YearofRecord = cboYear.Text;
            newRecord.PatientID = tbPatientID.Text;
            if (radioButton1.IsChecked == true) { newRecord.Q1 = "`Yes`"; }
            if (radioButton2.IsChecked == true) {newRecord.Q1 = "No";}
            if (radioButton3.IsChecked == true) { newRecord.Q1 = "N/A";}
            if (radioButton4.IsChecked == true) {newRecord.Q2 = "Yes";}
            if (radioButton5.IsChecked == true) {newRecord.Q2 = "No";}
            if (radioButton6.IsChecked == true) {newRecord.Q2 = "N/A";}
            if (radioButton7.IsChecked == true) {newRecord.Q3 = "Yes";}
            if (radioButton8.IsChecked == true) {newRecord.Q3 = "No";}
            if (radioButton9.IsChecked == true) {newRecord.Q3 = "N/A";}
            if (radioButton10.IsChecked == true) {newRecord.Q4 = "Yes";}
            if (radioButton11.IsChecked == true) {newRecord.Q4 = "No";}
            if (radioButton12.IsChecked == true) {newRecord.Q4 = "N/A";}
            if (radioButton13.IsChecked == true) {newRecord.Q5 = "Yes";}
            if (radioButton14.IsChecked == true) {newRecord.Q5 = "No";}
            if (radioButton15.IsChecked == true) {newRecord.Q5 = "N/A";}
            if (radioButton16.IsChecked == true) {newRecord.Q6 = "Yes";}
            if (radioButton17.IsChecked == true) {newRecord.Q6 = "No";}
            if (radioButton18.IsChecked == true) {newRecord.Q6 = "N/A";}
            if (radioButton19.IsChecked == true) {newRecord.Q7 = "Yes";}
            if (radioButton20.IsChecked == true) {newRecord.Q7 = "No";}
            if (radioButton21.IsChecked == true) {newRecord.Q7 = "N/A";}
            if (radioButton22.IsChecked == true) {newRecord.Q8 = "Yes";}
            if (radioButton23.IsChecked == true) {newRecord.Q8 = "No";}
            if (radioButton24.IsChecked == true) {newRecord.Q8 = "N/A";}
            if (radioButton25.IsChecked == true) {newRecord.Q9 = "Yes";}
            if (radioButton26.IsChecked == true) {newRecord.Q9 = "No";}
            if (radioButton27.IsChecked == true) {newRecord.Q9 = "N/A";}
            if (radioButton28.IsChecked == true) {newRecord.Q10 = "Yes";}
            if (radioButton29.IsChecked == true) {newRecord.Q10 = "No";}
            if (radioButton30.IsChecked == true) {newRecord.Q10 = "N/A";}
            if (radioButton31.IsChecked == true) {newRecord.Q11 = "Yes";}
            if (radioButton32.IsChecked == true) {newRecord.Q11 = "No";}
            if (radioButton33.IsChecked == true) {newRecord.Q11 = "N/A";}
            if (radioButton34.IsChecked == true) {newRecord.Q12 = "Yes";}
            if (radioButton35.IsChecked == true) {newRecord.Q12 = "No";}
            if (radioButton36.IsChecked == true) {newRecord.Q12 = "N/A";}
            if (radioButton37.IsChecked == true) {newRecord.Q13 = "Yes";}
            if (radioButton38.IsChecked == true) {newRecord.Q13 = "No";}
            if (radioButton39.IsChecked == true) {newRecord.Q13 = "N/A";}
            if (radioButton40.IsChecked == true) {newRecord.Q14 = "Yes";}
            if (radioButton41.IsChecked == true) {newRecord.Q14 = "No";}
            if (radioButton42.IsChecked == true) {newRecord.Q14 = "N/A";}
            if (radioButton43.IsChecked == true) {newRecord.Q15 = "Yes";}
            if (radioButton44.IsChecked == true) {newRecord.Q15 = "No";}
            if (radioButton45.IsChecked == true) {newRecord.Q15 = "N/A";}
            if (radioButton46.IsChecked == true) {newRecord.Q16 = "Yes";}
            if (radioButton47.IsChecked == true) {newRecord.Q16 = "No";}
            if (radioButton48.IsChecked == true) {newRecord.Q16 = "N/A";}
            if (radioButton49.IsChecked == true) {newRecord.Q17 = "Yes";}
            if (radioButton50.IsChecked == true) {newRecord.Q17 = "No";}
            if (radioButton51.IsChecked == true) {newRecord.Q17 = "N/A";}
            if (radioButton52.IsChecked == true) {newRecord.Q18 = "Yes";}
            if (radioButton53.IsChecked == true) {newRecord.Q18 = "No";}
            if (radioButton54.IsChecked == true) {newRecord.Q18 = "N/A";}
            if (radioButton55.IsChecked == true) {newRecord.Q19 = "Yes";}
            if (radioButton56.IsChecked == true) {newRecord.Q19 = "No";}
            if (radioButton57.IsChecked == true) {newRecord.Q19 = "N/A";}
            if (radioButton58.IsChecked == true) {newRecord.Q20 = "Yes";}
            if (radioButton59.IsChecked == true) {newRecord.Q20 = "No";}
            if (radioButton60.IsChecked == true) {newRecord.Q20 = "N/A";}
            if (radioButton61.IsChecked == true) {newRecord.Q21 = "Yes";}
            if (radioButton62.IsChecked == true) {newRecord.Q21 = "No";}
            if (radioButton63.IsChecked == true) {newRecord.Q21 = "N/A";}

            ds.Records.AddRecordsRow(newRecord);

            pta.Update(ds);