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:-
- private static IList<IList<Object>> GenerateData()
- {
- string connstr;
- connstr = ConfigurationManager.AppSettings["DSN_RMS"];
- SqlConnection conn = new SqlConnection(connstr);
- conn.Open();
- System.Data.DataTable table = new System.Data.DataTable();
- SqlDataAdapter adapter = new SqlDataAdapter();
- SqlCommand cmd = new SqlCommand("SELECT * from employee", conn);
- adapter.SelectCommand = cmd;
- adapter.Fill(table);
- List<IList<Object>> objNewRecords = new List<IList<Object>>();
- IList<Object> obj = new List<Object>();
- IList<Object> obj1 = new List<Object>();
- foreach (System.Data.DataColumn row in table.Columns)
- {
- obj1.Add(row.ColumnName);
- }
- objNewRecords.Add(obj1);
- foreach (System.Data.DataRow row in table.Rows)
- {
- foreach (System.Data.DataColumn dc in table.Columns)
- {
- obj.Add(row[dc].ToString());
- }
- objNewRecords.Add(obj);
- }
- return objNewRecords;
- }
Please help me as soon as possible