int cellRowIndex = 2; int cellColumnIndex; for (int i = 0; i < dataGridView1.Rows.Count - 1; i++, cellRowIndex++) { cellColumnIndex = 1; for (int j = 0; j < dataGridView1.Columns.Count - 1; j++, cellColumnIndex++) { worksheet.Cells[cellRowIndex, cellColumnIndex] = dataGridView1.Rows[i].Cells[j].Value.ToString(); } } cellColumnIndex = 1; for (int j = 0; j < dataGridView1.Columns.Count - 1; j++, cellColumnIndex++) { worksheet.Cells[1, cellColumnIndex] = dataGridView1.Columns[j].HeaderText; }
if (txt_Adults.Text.Length != 0) { int32 tempValue; if (int32.TryParse(txt_Adults.Text, tempValue) == true) { // // tempValue now contains the integer value of the text // if (tempValue > Max_NoAdults) { txt_Adults.Text = ""; txt_Adults.Focus(); } else if(tempValue <= Max_NoAdults) { NoAdults = tempValue; } } else { txt_Adults.Focus(); } }