With my below code, I am getting error as
Error : Index was outside the bounds of the array.
protected void SaveChanges(object sender, EventArgs e)
{
OleDbConnection myComm = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=dev;Persist Security Info=False;");
conn.Open();
string excelData = Grid1ExcelData.Value;
string excelDeletedIds = Grid1ExcelDeletedIds.Value;
string[] rowSeparator = new string[] { "|*row*|" };
string[] cellSeparator = new string[] { "|*cell*|" };
string[] dataRows = excelData.Split(rowSeparator, StringSplitOptions.None);
for (int i = 0; i < dataRows.Length; i++)
{
string[] dataCells = dataRows[i].Split(cellSeparator, StringSplitOptions.None);
string PROJECT_ID = dataCells[0]; Go to the complete details ...