I have this code, but it does not insert the data in the database, but it does not mark any error.
foreach (DataRow r in datasetexcelcont.Tables[0].Rows) {
DataRow dr = cobranzaDataSet3.Cartera.NewRow();
dr[0] = r[0];
dr[1] = r[1];
dr[2] = r[2];
dr[3] = r[3];
dr[4] = r[4];
dr[5] = r[5];
dr[6] = r[6];
dr[7] = r[7];
dr[8] = r[8];
dr[9] = r[9];
dr[10] = r[10];
dr[11] = r[11];
dr[12] = r[12];
dr[13] = r[13];
dr[14] = r[14];
dr[15] = r[15];
dr[16] = r[16];
dr[17] = r[17];
cobranzaDataSet3.Cartera.Rows.Add(dr);
}
this.carteraTableAdapter.Update(this.cobranzaDataSet3.Cartera);
If you need more code to understand tell me and put everything. Thanks for helping, I can not find anything. by the way I'm using access database.