Generate Auto Request ID and UpdateDate

private void InsertData()

{

for (int i = 0; i < Dt.Rows.Count; i++)

{

DataRow row = Dt.Rows[i];

int columnCount = Dt.Columns.Count;

string[] columns = new string[columnCount];

for (int j = 0; j < columnCount; j++)

{

columns[j] = row[j].ToString();

}

conn.Open();

string sql = "INSERT INTO ParcelInf(RequestID,SubdivisionNo,ParcelNo,Region,City,Zone,CoordinateSystem,CUID,Status,Remarks,UpdateDate)";

sql += "VALUES('" + columns[0] + "','" + columns[1] + "','" + columns[2] + "','" + columns[3] + "','" + columns[4] + "','" + columns[5] + "','" + columns[6] + "','" + columns[7] + "','" + columns[8] + "','" + columns[9] + "','" + columns[10] + "')";

SqlCommand cmd = new SqlCommand(sql, conn);

cmd.ExecuteNonQuery();

conn.Close();

}