Senorita

Senorita

  • NA
  • 123
  • 8.8k

Google.GoogleApiException: Google.Apis.Requests.RequestErro

Nov 6 2019 1:25 AM
Hi,
 
i am working on "Create And Update Google SpreadSheet Via Google API.NET Library" .
 
i follow all instrection in "https://www.c-sharpcorner.com/article/create-and-update-google-spreadsheet-via-google-api-net-library/" tutorial.
 
but when i upload more then 50 record it showing error . error in attached with screen short.
 
i only made below changes:-
  1. private static IList<IList<Object>> GenerateData()  
  2. {  
  3. string connstr;  
  4. connstr = ConfigurationManager.AppSettings["DSN_RMS"];  
  5. SqlConnection conn = new SqlConnection(connstr);  
  6. conn.Open();  
  7. System.Data.DataTable table = new System.Data.DataTable();  
  8. SqlDataAdapter adapter = new SqlDataAdapter();  
  9. SqlCommand cmd = new SqlCommand("SELECT * from employee", conn);  
  10. adapter.SelectCommand = cmd;  
  11. adapter.Fill(table);  
  12. List<IList<Object>> objNewRecords = new List<IList<Object>>();  
  13. IList<Object> obj = new List<Object>();  
  14. IList<Object> obj1 = new List<Object>();  
  15. foreach (System.Data.DataColumn row in table.Columns)  
  16. {  
  17. obj1.Add(row.ColumnName);  
  18. }  
  19. objNewRecords.Add(obj1);  
  20. foreach (System.Data.DataRow row in table.Rows)  
  21. {  
  22. foreach (System.Data.DataColumn dc in table.Columns)  
  23. {  
  24. obj.Add(row[dc].ToString());  
  25. }  
  26. objNewRecords.Add(obj);  
  27. }  
  28. return objNewRecords;  
  29. }  
Please help me as soon as possible